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 = '21' and b.Exp_Date >= '2019-12-09' and (b.admin_appr = 'T' or b.submit_date > '2019-12-06')
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 = '21' and (b.admin_appr = 'T' or b.submit_date > '2019-12-06') 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).
A Robinsons Equestrian Services/Who Rescues Who Located in the beautiful east bay hills, R.E.S. Offers the best in Training-Riding Lessons-Rehabs-Sales-Summer Camps
We guarantee personal attention, we welcome horses & Riders at all stages no drama Lisa Braden-Robinson 510-760-8909 Cell Phone: 510-760-8909 6667 Johnston Road Pleasanton, Calif 94588 Bus. ID: 9124 Send E-mailView Map
Thomas Ranch All welcome! Horses started, finished, or reschooled. Lessons, training, sales of REINING, CUTTING, REINED COW & DRESSAGE horses. Indoor/outdoor facilities, 10 minutes from Orinda. Over 30 years national and international experience. Patient, professional help for you and your horse. Eric Thomas 925-229-2299 Fax: 925-229-2292 Cell Phone: 925-528-9356 Briones, CA 94553 Bus. ID: 6133 Send E-mailView Map
A Robinsons Equestrian Services/Who Rescues Who Located in the beautiful east bay hills, R.E.S. Offers the best in Training-Riding Lessons-Rehabs-Sales-Summer Camps
We guarantee personal attention, we welcome horses & Riders at all stages no drama Lisa Braden-Robinson 510-760-8909 Cell Phone: 510-760-8909 6667 Johnston Road Pleasanton, Calif 94588 Bus. ID: 9124 Send E-mailView Map
Christiane Noelting Dressage Center The Dressage Center is a 40stall,40ac. facility with 3outdoor+ 2indoor arenas,irrigated pastures offering boarding,training,lessons,sell+breed horses,hosting clinics+3 three star Dressage Shows Christiane Noelting 707-454-0565 Fax: 707-454-0566 6954 Lewis Rd Vacaville, CA 95687 Bus. ID: 1290 Send E-mailView Map
HJ Sporthorses, LLC. We provide top quality horses for sale in the U.S., direct purchasing of German horses with or without visits overseas, and equine appraising services. Heather Hurwitt 813-928-9140 22603 Rodeo Avenue Gerber, CA 96035 Bus. ID: 9356 Send E-mailView Map
Sterling Equine Appraisals The nation's leading horse valuation experts. ASEA certified horse appraisals for insurance, litigation, and donations. Lifetime certified equine appraisers and specialists in Dressage, Hunter / Jumpers, Miniature and Western Pleasure & Performance. Nationwide, rush service available. IRS vendor. Jennifer Barbee 559-217-8533 PO Box 5 1623 N. Del Rey Ave Sanger, CA 93657 Bus. ID: 329 Send E-mail
Sunnybrook Equine Appraisals Professional appraisal service for all breeds & disciplines, fair and impartial values for every horse in all types of situations.
Also have overnight stabling and pastures for horse retirement. Lori Mote 209-274-2680 Fax: 209-274-0392 Cell Phone: 209-304-4858 9401 Brook Ranch Rd. W. Ione, CA 95640 Bus. ID: 584 Send E-mailView Map
Thomas Ranch All welcome! Horses started, finished, or reschooled. Lessons, training, sales of REINING, CUTTING, REINED COW & DRESSAGE horses. Indoor/outdoor facilities, 10 minutes from Orinda. Over 30 years national and international experience. Patient, professional help for you and your horse. Eric Thomas 925-229-2299 Fax: 925-229-2292 Cell Phone: 925-528-9356 Briones, CA 94553 Bus. ID: 6133 Send E-mailView Map
2R Appraisal Dan Capik 530-517-1000 Orland, CA 95963 Bus. ID: 6985 Send E-mail
Search the Directory for:
