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 = '26' and b.Exp_Date >= '2023-02-04' 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 = '26' 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).
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
RDLA Equestrian Cross Country Schooling Open 7 days a week. Please call for times and availability or view our web site www.rdlatoride.com. New Trainers welcome with students. Trainers on site for lessons if needed. Call for more info 510-538-8932. Leslie Hardy 510-538-8932 Cell Phone: 510-909-5770 12350 Cull Canyon Road Castro Valley, CA 94552 Bus. ID: 6056 Send E-mailView Map
Dark Horse Media Patti Schofler 707-763-1065 Petaluma, Ca 94952 Bus. ID: 6826 Send E-mail
Dennis Young, EMT-P Dennis Young 559-363-0514 2340 W. Cleveland Ave. #283 Madera, CA 93637 Bus. ID: 1840 Send E-mail
Diablo Ranch Events and Gatherings Kim Brumleve 945-925-837-2290 Cell Phone: 925-497-5454 1453 N gate Road Walnut Creek, Ca 94598 Bus. ID: 6111 Send E-mail