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='90' 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='90' 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).
Alex Greer Dressage Developing harmonious partnerships with happy horse and rider athletes of all levels performing at their best. Beautiful private dressage facility and horse-friendly amenities close to Marin and San Francisco. Petaluma, CA Bus. ID: 9391 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
Alex Greer Dressage Developing harmonious partnerships with happy horse and rider athletes of all levels performing at their best. Beautiful private dressage facility and horse-friendly amenities close to Marin and San Francisco. Petaluma, CA Bus. ID: 9391 Send E-mailView Map
Alioto Arabians & Half Arabians Quality Arabians and Half Arabian horses for sale. Visit our web site www.extendinc.com/aliotoarabians. Georgann Alioto 530-269-3001 Grass Valley, CA 95602 Bus. ID: 1015 Send E-mail
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
All The Kings Horses Peaceful boarding and training facility. Management lives onsite. Pastures, paddocks, stalls, covered and outdoor arena, trails around property. Sale horses. Pony lesson program. Best rates in area! Erin King Jackson 415-385-8354 Cell Phone: 415-385-8354 4650 Petrified Forest Road Calistoga, CA 94515 Bus. ID: 8556 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
Blue Chip Stables Located in Penngrove, Blue Chip Stables is a peaceful and private full service facility. The program emphasis is on success in performance through correct fundamentals. USDF certified trainer and instructor Lee Webster specializes in the training and sale of young horses. Lee Webster 707-794-9299 Fax: 707-794-9693 Blue Chip Stables 4795 Acacia way Penngrove, CA 94951 Bus. ID: 956 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
Four Star Farm Certified Level III ICP Eventing Instructor, USDF L-graduate dressage judge and USDF Silver medalist. Lessons and training for eventing, dressage,and jumpers. Sale horses, camps and clinics. Natalie Rooney Cell Phone: 707-312-1119 30486 Equus Lane Winters, CA 95694 Bus. ID: 2433 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
Icssoma Farm Home of well trained horses. Riding instruction and camps. Sebastopol, CA Bus. ID: 1088 Send E-mailView Map
J-Dot Stables Owner Jack Burns provides classical training for the modern horse and rider in dressage, jumping, and working equitation. Lusitano sales available. Located at Sonoma Equestrian Center. Jack Burns 707-239-2290 2989 Napa Rd. Sonoma, CA 95476 Bus. ID: 5878 Send E-mailView Map
L Bar D Ranch We breed, raise and promote American Quarter Horses. We are dedicated to performance horses mostly reining, roping, barrel racing, and team penning horses.
Larry and Debbie Strain 707-795-5283 775 Palm Avenue Penngrove, CA 94951 Bus. ID: 189 Send E-mailView Map
Mattias Ekeroth Training Stables Mattias Ekeroth Stables welcomes all ages and levels for full training - from the short stirrup to Grand Prix. Mattias Ekeroth 707-975-5104 PO Box 633 Penngrove, CA 94951 Bus. ID: 3121 Send E-mailView Map
Oak Creek Ranch Riding Academy Is a non-profit organization. We offer a full boarding facility, with 12x12 stalls w/runs. Pasture board, indoor arena, two outdoor arena and jumping arena. 60ft round pen and a creek running along si Kathy Jefferson 954-707-995-3907 P.O. Box 1014 11440 Spruce Grove Road Lower Lake, Ca 95457 Bus. ID: 6149 Send E-mailView Map
Robyn's Horseplay LESSONS and TRAINING: Quality Horsemanship, Encouraging a better relationship between horses and riders. Solutions for Troubled horses. Classical, practical, kind approach with a 'natural' influence for all levels and disciplines. Get Out on the Trails, Stay Safe and Have Fun. Robyn Spector-McCallister 707-272-2127 Fort Bragg, CA 95437 Bus. ID: 1905 View Map
Rubicon Farms RUBICON FARMS RE-OPENING:
Rubicon Farms has re-opened at beautiful Double B Farms in Sebastopol.
[just 1/2 North of Sonoma Horse Park]
We specialize in show hunters/jumpers/equitation & sales.
LesAnn LeClaire 415-269-5377 808 Pepper Rd Petaluma, CA 94952 Bus. ID: 9436 Send E-mailView Map
Silver Bay Stables Silver Bay Stables offers Full training, Sales, Import and Consignment for Hunters/Jumpers and Ponies. Julie Young 707-9532831 1702 willowside rd Santa Rosa, ca 95401 Bus. ID: 9380 Send E-mailView Map
Silver Bay Stables We offer training, sales, consignment and importing of both hunter/jumper and equitation horses and ponies. Julie Young 707-953-2831 2276 Crane Canyon Rd Santa Rosa, CA 94931 Bus. ID: 8022 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
VSEquine LLC Van Sweden Equine Training located in Mt. Shasta, CA offering a comprehensive lesson & training program whether your goals are competition or personal satisfaction. Ruth Van Sweden 530-925-2608 Mt. Shasta, CA Bus. ID: 378 Send E-mailView Map