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 = '64' and b.Exp_Date >= '2019-08-19' and a.subcat_id='94' and (b.admin_appr = 'T' or b.submit_date > '2019-08-16')
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 = '64' and a.subcat_id='94' and (b.admin_appr = 'T' or b.submit_date > '2019-08-16') 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).
Browns Ranch & Supply We offer a full line of horse equipment, supplies, corral panels, animal feed, dog runs, water tanks, buckets, etc. Special orders accepted. We deliver long distance. Open 9-5. (408) 268-4980 Don Brown 408-268-4980 20300 Almaden Road San Jose, CA 95120 Bus. ID: 3218 View Map
Advanced Equine Saddle Fit Independent Saddle Fitting Consultations for English & Western riders. English saddle flocking. Western saddle/ pad assessments. Equine massage. Saddle consignment. Serving the Bay Area, the Central Valley from Redding to Fresno, and the foothills beyond. Please email for quickest response. Robyn Dorius Cell Phone: 209-585-6582 Hughson, CA 95326 Bus. ID: 7978 Send E-mailView Map
Browns Ranch & Supply We offer a full line of horse equipment, supplies, corral panels, animal feed, dog runs, water tanks, buckets, etc. Special orders accepted. We deliver long distance. Open 9-5. (408) 268-4980 Don Brown 408-268-4980 20300 Almaden Road San Jose, CA 95120 Bus. ID: 3218 View Map
Custom Horsehair Jewelry We make beautiful horsehair necklaces, bracelets and earrings! We can custom make one for you out of your own horse's tail or from our stock of horsehair. We are extremely reasonable in price ranging from $10-$75. Check us out on Facebook by searching Equine Tails Western Design! Ann Simon 707-732-1347 Petaluma, CA 94954 Bus. ID: 8986 Send E-mailView Map
DQ's Corner - Fine European Riding Apparel and Tack Catering to the dressage community. Mobile store that goes to dressage shows, online store and now local show room that's open by appointment for all your shopping needs. Bettina Treyer 925-784 4902 401 Glen Falls Ct Hollister, CA 95023 Bus. ID: 9160 Send E-mailView Map
Equestrienne Riding Apparel for Women and Girl equestrian athletes. Proud to design and manufacture in the USA - most of our manufacturing is done in the SF Bay Area! www.stickyseat.com San Anderson 415-595-9042 Fax: 415-460-1228 24 Moody Court San Rafael, CA 94901 Bus. ID: 5436 Send E-mailView Map
Nicker Bait Cookies For Horses We take pride in offering unique cookies, treats and gift items using premium ingredients your horse will flip over. We use San Francisco's own "Giusto's" ground flax, oat flour and barley (human grade) and Organic carrots, sweet potato, and banana. We top each cookie off with a special yummy treat! 510-733- 2126 castro valley, CA 94552 Bus. ID: 5859 Send E-mailView Map
Schleese Saddlery Service Ltd. Member of the Saddlefit4Life global network of equine professionals dedicated to comfort, protection and performance of the horse. Using diagnostics, our saddlefitters will find you the best solutions on-site. Sabine Schleese 905-898-8335 Fax: 905-898-8399 34 Centennial Avenue Holland Landing, Ont, Canada, L9N 1H2 Bus. ID: 5407 Send E-mailView Map
Tully Hole Saddlery Fine custom horse gear in the Californio tradition. Inspired by the classic gear of yesterday, built for the working cowboys of today. Bryan Kunic 831-524-5278 PO Box 301 Tres Pinos, CA 95075 Bus. ID: 6215 Send E-mailView Map
Whole Equine Healthy Horses, Naturally! The Bay Area's online resource for natural care products for horses from supplements and first aid products to premier brushes and hoof boots. Montara, CA 94037 Bus. ID: 8719 Send E-mailView Map
eSaddlery & Tack LLC Richard Cripps 408-842-6255 Fax: 408-904-5659 750 Babbs Creek Dr Gilroy, CA 95020 Bus. ID: 580 Send E-mail
Express Hay & Tack Supply Edie Atkins 408-779-6621 Fax: 779-8657 Cell Phone: 594-1148 14905 Olive Avenue Morgan Hill, CA 95037 Bus. ID: 5076 Send E-mail
Fayters Equine Emporium A Full Service Store Cher Fayter 831-385-8515 Cell Phone: 805 610 9368 69400 Jolon Road Bradley, CA 93426 Bus. ID: 4825 Send E-mail
Search the Directory for:
