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 = '59' and b.Exp_Date >= '2023-02-04' and a.subcat_id='87' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01')
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 = '59' and a.subcat_id='87' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01') 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).
Fox Equestrian ARE YOU READY TO TAKE YOUR RIDING TO THE NEXT LEVEL? Our team offers a fun and safe environment for riders of all levels to grow, learn and become a well- round equestrian. Rachel Fox 510-861-7946 Castro Valley, CA 94552 Bus. ID: 9481 Send E-mailView Map
Thomas Ranch All riders and goals welcome! Horses started, finished, or reschooled. Lessons, coaching, training, sales of REINING, CUTTING, REINED COW & DRESSAGE horses. Indoor/outdoor facilities, 10 minutes from Orinda. Over 35 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
Ann Simon Horsemanship LLC Western training from starting colts and problem solving to finishing/showing. Specializing in reining, cow horses, ranch riding and barrel racing. Lessons from beginner to advanced on your horse or one of ours. Huge 140'x 300' covered arena and trails.
Ann Simon Cell Phone: 7077321347 7680 Pleasants Valley Rd Vacaville, 95688 Bus. ID: 8706 Send E-mailView Map
All The Kings Horses USDF Certified Instructor offering Dressage training AND KIDS lesson program. Quality school horses! Custom training and lesson packages located at our own facility in Sonoma Co., east of Santa Rosa. Erin King Jackson 415-385-8354 Calistoga, CA 94515 Bus. ID: 4015 Send E-mailView Map
Ann Simon Horsemanship Lessons, training and sales located at Pleasants Valley Arena in Vacaville. Beautiful facility with a large covered arena,round pens and trails. All ages and abilities welcome. Specializing in all around horsemanship with a focus in reining/cowhorse, barrel racing/gymkhana. Lesson horses available! Ann Simon Cell Phone: 707-732-1347 7680 Pleasants Valley Rd Vacaville, 95688 Bus. ID: 8896 Send E-mailView Map
CANTER California Canter California assists in transitioning retired thoroughbred race horses into second careers and provides free sale listings for owners and trainers. Alison Dacher 408-313-1965 Los Gatos, CA Bus. ID: 5205 Send E-mailView Map
Fox Equestrian ARE YOU READY TO TAKE YOUR RIDING TO THE NEXT LEVEL? Our team offers a fun and safe environment for riders of all levels to grow, learn and become a well- round equestrian. Rachel Fox 510-861-7946 Castro Valley, CA 94552 Bus. ID: 9481 Send E-mailView Map
GaitedPleasureHorses.com For over 40 years Gaited Pleasure Horses ranch has specialized in providing gentle gaited trail horses best matched to your personal riding level. Our horses are fairly priced and comes with a limited purchase guarantee. Other services: transport, custom gaited horse saddles, and new & used tack. Terry Zygalinski Cell Phone: 831-818-5932 110 Paddon Road Royal Oaks, CA 95076 Bus. ID: 3012 Send E-mailView Map
Graceland Equestrian Center Gated entry, 2 covered arenas 1 huge outdoor arena. XC course with water jump miles of groomed trails.Top trainers Diane Yeager,James Alliston and Kat Drake. Fox Chase Pony Club. Beginners through advanced riders welcome Pristine barns,3 lrg pastures 5 xtra lrg turnouts,breeding barn,on site vet
Peggy Moore 510-538-5555 Fax: 510-538-5444 Cell Phone: 925-286-1954 10970 Crow Canyon Rd Castro Valley, CA 94552 Bus. ID: 5110 Send E-mailView Map
Thomas Ranch All riders and goals welcome! Horses started, finished, or reschooled. Lessons, coaching, training, sales of REINING, CUTTING, REINED COW & DRESSAGE horses. Indoor/outdoor facilities, 10 minutes from Orinda. Over 35 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
Prestige Equestrians Julia Smith 831-236-5935 7324 Crow Canyon Road Castro Valley, CA 94552 Bus. ID: 7367 Send E-mail
Public Riding Thoroughbred Racing Trainer C.J. Wilson 818-970-2596 Albany, CA 94552 Bus. ID: 3637 Send E-mail
Rancho del Lago Marie Miller Cell Phone: 925-323-0219 2331 Rancho del Lago Road Briones, CA 94553 Bus. ID: 4955 Send E-mail
Royal Horses Stables Claudio Gallo 925-7890004 -, CA 94510 Bus. ID: 7993 Send E-mail
Royal Horses Stables Claudio Gallo 925-789-0004 American Canyon, CA 94503 Bus. ID: 6784 Send E-mail
Saddle Up Horse Training Tassahia Williamson 925-200-5904 2300 Cummings road Brentwood, California 94513 Bus. ID: 9051 Send E-mail
Santa Maria Training Stable Daniel Aristimuno 925-765-1525 950 N Gate Rd Walnut Creek, CA 94598 Bus. ID: 4400 Send E-mail
Shady Lane Farm Lindsay Anderson 925-285-6361 Fax: 935-1278 Cell Phone: 285-6361 PO Box 1224 111 Jennifer Lane Alamo, CA 94507 Bus. ID: 1095 Send E-mail
Shaffer Ranch Breanne Shaffer 925-(925)577-7766 4323 Briones Valley Rd Brentwood, CA 94513 Bus. ID: 7469 Send E-mail
Star Light Jessica Dozier 530-354-5698 Cell Phone: 530-354-5698 Oakley, CA Bus. ID: 3251 Send E-mail
Sunset Riding Academy Shawn Mott 925-862-9056 Fax: 925-862-0403 7587 Athenour Way P.O. Box 457 Sunol, CA 94586 Bus. ID: 1281 Send E-mailView Map
Tassajara Equestrian Center Molly Rosin Fax: 925-248-6902 Cell Phone: 559-287-7285 5945 Bruce Dr Pleasanton, CA 94588 Bus. ID: 2162 Send E-mail
The Dressage Arena Gail McGuffey 707-481-5512 100 Lynch Road Petaluma, CA 94954 Bus. ID: 5992
Waltzing Horses Sue Eoff 916-798-2954 Fax: 707-745-6221 Cell Phone: 916-798-2954 32955 Cole Grade Road Valley Center, CA 92082 Bus. ID: 1597 Send E-mail