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 >= '2023-02-04' and a.subcat_id='44' 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 = '10' and a.subcat_id='44' 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).
Stallion Repro Services Offering Stallion Reproduction Services Including: Phantom Training, Fresh Collections and Shipping, Cryopreservation and more. Edgar Schutte 916-2032247 Woodland, California Bus. ID: 9508 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
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
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
Stallion Repro Services Offering Stallion Reproduction Services Including: Phantom Training, Fresh Collections and Shipping, Cryopreservation and more. Edgar Schutte 916-2032247 Woodland, California Bus. ID: 9508 Send E-mailView Map
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 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
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
Search the Directory for:
