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 >= '2020-07-08' and a.subcat_id='91' and (b.admin_appr = 'T' or b.submit_date > '2020-07-05')
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='91' and (b.admin_appr = 'T' or b.submit_date > '2020-07-05') 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
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
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
GaitedPleasureHorses.com For over 30 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
Ridge View Sporthorses Hanovarian Sporthorses carefully bred for the Serious Competitor. Fine horses for sale. 707-678-4394 Vacaville, CA Bus. ID: 1127 Send E-mail
The Dressage Arena Located in picturesque Penngrove, USDF gold medalist and RVT Gail McGuffey offers the finest in Dressage Prospects and Finished Sport Horses for sale. We have openings for quality sporthorses that need to be marketed and sold. Gail McGuffey 707-481-5512 100 Lynch Road Petaluma, CA 94954 Bus. ID: 5992 View 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
Valley Horse Center Training, breeding & sales from foal to finish. Honesty & integrity- foundation for good business, honest sales & quality horse training. Showing/competing in halter, sporthorse, trail, extreme cowboy race, endurance. Jodi Tuft 707-374-2858 Cell Phone: 707-688-1741 Vacaville, CA Bus. ID: 1215 Send E-mailView Map
Artisans Stables Lisa Niva 408-832-7660 San Martin, CA Bus. ID: 4036 Send E-mail
B&Z Horse Training Loren Harvey 916-747-7228 Garden Valley, CA Bus. ID: 3075 Send E-mail
Search the Directory for:
