SELECT distinct b.*, a.sortID
FROM `busi_in_cat_uf` a LEFT JOIN v_BusiUser b
on a.busi_id = b.busi_id
where a.cat_id = '32' and b.Exp_Date >= '2021-08-05' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02')
union all
SELECT distinct b.*, a.sortID
FROM `busi_in_cat` a LEFT JOIN v_BusiUser b
on a.busi_id = b.busi_id
where a.cat_id = '32' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02') ORDER BY sortID DESC , member DESC, busi_name
Bay Area Equestrian Network - Show business listings
Help update BAEN's Directory and earn FREE Photo Ads.
If you find a listing that needs flagging, let us know. Examples: wrong category, broken web links, duplicate, business no longer exists, etc.. Email bayequest@gmail.com and include the ID number of the listing along with your comments. We'll say thanks for your help with a FREE photo ad (maximum value $22).
Fly Free Naturally Eliminate flies from your barn using Natural Pyrethrin solution! We service over 250 barns here in the Bay Area and Northern California. Ask your horse friends about us, they're probably our friends too. Complete sales and service. Jim Norem 415-285-9665 Cell Phone: 415-238-2130 PO Box 31142 Oakland, CA 94604 Bus. ID: 9474 Send E-mailView Map
Innovative Equine Systems Innovative Equine Systems offers a complete line of equestrian facility products: barns/arenas, horse stalls, fencing, rubber flooring, stall/paddock surfacing, insect control and barn accessories. Dennis Marion 800-888-9921 Fax: 775-267-6857 2559 Precision Drive Suite 4 Minden, NV 89423 Bus. ID: 708 Send E-mailView Map
TNT-Tick Natural Terminator A new powder applied to your horse weekly to repel and KILL ticks. It is also safe for dogs, cats, other mammals and humans. Additionally it can be spread around run in sheds and barns, as well as on hay, to control ticks and other crawling pests. Jan Lyon 1588 West Bloomfield Road Honeoye Falls, NY 14472-9212 Bus. ID: 9150 Send E-mailView Map
Ecovet Tim John 800-208-9192 Snohomish, WA 98290 Bus. ID: 8673 Send E-mail
Search the Directory for:
