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='88' 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='88' 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).
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
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
Foxy Rider Farm Private Trainer with extensive 40+ years riding,training,showing ,background,H/J "A" Circuit,w/John French. English and Western. Specializing in flat work, ground manners,jumping, dressage, trail and obstacle training,behavior modification. Insured.Many references available. Lisa Frazier 650-868-0900 Cell Phone: 868-0900 2720 Alpine Rd Portola Valley , Ca 94028 Bus. ID: 9456 Send E-mail
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
Happy Trails Training & Horsemanship Western Dressage and Trail instruction for horses and their humans. Schoolhorses available. Riders of all ages and abilities most welcome, progessive training for all breeds including drafts, long-ears, and minis.
Erin Nicole Ury Cell Phone: 415-424-1442 Sebastopol, CA Bus. ID: 7670 Send E-mailView Map
Hurst Performance Horses Specializing in reining and reined cowhorses. Offering a full care training program, from basic colt starting to finished show horses. We provide our horses with top notch care at reasonable rates. Safe and easy lesson horses available for beginners-advanced riders. Live cattle available, call us! Philip Hurst 580-768-0036 7460 Crews Rd Gilroy, CA 95020 Bus. ID: 7994 Send E-mailView Map
Jenn Doubrava Performance Horses Specializing in Western Pleasure, English, Trail, and All Around. Youth, Amateurs and basic lessons welcome. We offer a very successful program for futurity horses and always have a nice selection of sale horses available. Showing at most major AQHA&APHA shows. Come be a part of this AMAZING team!! Jenn Doubrava 408-427-6731 7777 Frazier Lake Rd Gilroy, CA 95020 Bus. ID: 4573 Send E-mailView Map
Jill Carabelas Dressage Dressage training and lessons for beginners through Grand Prix. Kind approach with horses and riders. Come experience excellence in an atmosphere of friendship and comaraderie. Located at Summit Equestrian Center in Los Gatos. Jill Carabelas 831-818-1907 4900 Cherryvale Ave. Soquel, CA 95073 Bus. ID: 3049 Send E-mailView Map
Jillian "Tory" Montgomery ~ Montgomery Show Stable Tory is a professional rider/trainer for Montgomery Show Stable, based at The Yard Equine Center. Tory specializes in young sport horses & sale horses. Tory's extensive competition experience enhances her ability to develop young horses, prepare sale horses for the show ring. Jillian Montgomery 831-831 628-0801 Fax: 831 628-0802 270 Browns Valley Rd Paicines, CA 95043 Bus. ID: 7562 Send E-mailView Map
Katie Hoefs Dressage Dressage training program focuses on developing horses/rider combinations who are happy, correct and competitive in the show ring. Located at Woodmyst Farms in Gilroy. Katie Hoefs 650-714-7526 13388 Old Airline Hwy PO Box 147 Paicines, CA 95043 Bus. ID: 3851 Send E-mailView Map
Rancho Paso De Oro Quality Peruvian Paso Horses. Eileen Fowler 650-968-1689 Mountain View, CA Bus. ID: 2251 Send E-mailView Map
Rancho Paso De Oro Traditional Quality Peruvian Paso Horses Eileen Fowler 650-968-1689 Mountain View, CA Bus. ID: 2440 Send E-mailView Map
SAR Ranch English Hunter Jumping lessons specializing in children and adults of all ages, beginner Lead Line to Grand Prix. Sales, breeding and youngstock. Kerry Urquhart 831-637-3202 Cell Phone: 408-315-0042 908 Foxhill Circle Hollister, CA 95023 Bus. ID: 6374 Send E-mail
Shakespeare Farm Private Full Service Facility. Are you looking high quality personalized care and training with like-minded equestrians? Shakespeare Farm offers catered programs for every level of rider to assist Kimberly Ramirez 831-840-3335 Santa Cruz, CA 95065 Bus. ID: 1155 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