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 >= '2021-01-22' and (b.admin_appr = 'T' or b.submit_date > '2021-01-19')
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 > '2021-01-19') 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).
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
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
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:
