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 = '145' and b.Exp_Date >= '2021-08-05' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02')
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 = '145' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02') 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 Boutique dressage training, sales, and imports. Helping horse and rider athletes of all ages develop to their potential with an individualized and rewarding approach. Clients range from Training Level to Prix St. Georges. Based at a state-of-the-art dressage facility in Napa. 100 Rapp Ln Napa, CA 94558 Bus. ID: 9391 Send E-mailView Map
Alex Greer Dressage Boutique dressage training, sales, and imports. Helping horse and rider athletes of all ages develop to their potential with an individualized and rewarding approach. Clients range from Training Level to Prix St. Georges. Based at a state-of-the-art dressage facility in Napa. 100 Rapp Ln Napa, CA 94558 Bus. ID: 9391 Send E-mailView Map
Demerara Stables Over 20 years experience in starting and training young horses and in rehabilitation. We produce happy, well adjusted, amateur-friendly horses that excel in jumpers, hunters, and dressage. We transform horses' bodies and minds so they are fitter, stronger, more willing partners for years to come. Lauren Lockliear 740-807-1141 San Gregorio, California Bus. ID: 9416 Send E-mailView Map
EJ Dressage Erika Jansson 707-707-326-7612 Cell Phone: 707-326-7612 Penngrove, CA 94951 Bus. ID: 7359 Send E-mail
Equestrian Games Riding Academy Cecelia Duncan 510-313-3171 Cell Phone: 510-313-3171 5320 Bruce Street Pleasonton , CA 94506 Bus. ID: 9382 Send E-mail
Search the Directory for:
