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 = '10' and b.Exp_Date >= '2019-02-19' and a.subcat_id='44' and (b.admin_appr = 'T' or b.submit_date > '2019-02-16')
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 = '10' and a.subcat_id='44' and (b.admin_appr = 'T' or b.submit_date > '2019-02-16') 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 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
WHEELER PERFORMANCE HORSES World & Reserve World Champion trainers Jenn & Justin, specialize in western and english all around horses. From prospects to finished show teams, this well rounded program offers a tailored fit to each clients needs. Professionalism and quality care is what you will find at their private facility. Jenn Wheeler 408-4276731 351 Hospital Rd Hollister, CA 95023 Bus. ID: 9249 Send E-mailView Map
Buffington Performance Horses, LLC Kelli is now the Western trainer at the Woodland Stallion Station where they host a wide range of Events throughout the year. We welcome all horse lovers, riders and handlers to come visit our beautiful facilities, experience our friendly atmosphere and ride in our fun & educational events! Matt Buffington 916-753-4836 Cell Phone: 916-753-4836 Pleasant Grove, CA 95668 Bus. ID: 6600 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
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
Lazy K Bar T Quarter Horses We raise, train, and sell horses whose dams are foundation bred for disposition and crossed on a 4 X World Champion Barrel & Pole horse, Rene Dan Jet. Kate Ristow 805-238-9948 Cell Phone: 610-7183 2250 La Panza creston,, CA 93432 Bus. ID: 4529 Send E-mailView Map
Living Dreams Ranch Breeding, training, and sales of Quarters and Paints. Katie Hickey 530-320-0309 Placerville, CA 95667 Bus. ID: 2640 Send E-mail
Southern Cross Quarter Horses & Paints Breeders of fine quality AQHA and APHA horses for riding and halter. Stallion services, horses for sale. 530-824-2520 PO Box 273 Corning, CA Bus. ID: 1130
The Smokes Dude Smokes Dude is an APHA World Champion Working Cow Horse, a NRCHA Supreme Reined Cow Horse, sired by Winnerinic out of Smokes Belle and trained by Pat Hubbert. Standing at Bishop Lane Farm. Shilo Bishop 707-793-7521 1290 Goodwin Ave. Penngrove, CA 94951 Bus. ID: 1022 Send E-mail
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
WHEELER PERFORMANCE HORSES World & Reserve World Champion trainers Jenn & Justin, specialize in western and english all around horses. From prospects to finished show teams, this well rounded program offers a tailored fit to each clients needs. Professionalism and quality care is what you will find at their private facility. Jenn Wheeler 408-4276731 351 Hospital Rd Hollister, CA 95023 Bus. ID: 9249 Send E-mailView Map
Living Dream Quarter Horses Ann Torrez 707-566-8210 Fax: 707-566-8210 Cell Phone: 415-215-8012 423 Boyce Street Santa Rosa, CA 95410 Bus. ID: 3090 Send E-mail
Loleta Happy Horse Sandra Fotis 707-733-5608 Fax: 707-733-5089 Cell Phone: 707-845-3787 P.O. Box 520 276 Spring Street Loleta, CA 95551 Bus. ID: 1478 Send E-mail
Loomis Ranch Performance Horses mary ann loomis 530-294-5445 Cell Phone: 233-8413 bieber, CA 96009 Bus. ID: 1942 Send E-mail
BUSINESS DIRECTORY
Search the Directory for:
