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 >= '2022-05-20' and (b.admin_appr = 'T' or b.submit_date > '2022-05-17')
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 > '2022-05-17') 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).
Rawking Horse Ranch Private Home Ranch excelling in Horsemanship across all disciplines and breeds. Specializing in Cowboy Dressage, Classical Dressage, and Cattle Work. Promoting Lusitano and Morgan Horses. 1131 Bear Creek Road Briones, CA 94553 Bus. ID: 8350 Send E-mailView Map
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
Search the Directory for:
