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 = '4' and b.Exp_Date >= '2019-08-20' and a.subcat_id='7' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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 = '4' and a.subcat_id='7' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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).
Los Altos Hounds 925-426-0827 Los Altos, CA 94588 Bus. ID: 6262 Send E-mail
New Heights Lessons and Training 2019 Promotion for new clients!!
Opening our program for 1/2 off training for all new incoming clients for the month of January at one of the bay area’s premier riding facilities. Space Limited. Call, Text or Email to inquire. David Acord Cell Phone: 925-858-6843 5945 Bruce Drive Pleasanton, CA 94588 Bus. ID: 9241 Send E-mailView Map
Santa Clara County Horsemen's Association, Inc. The Santa Clara County Horsemen's Association was founded in 1939, making it the oldest horsemen's association in California. Our purpose is to promote good fellowship between horsemen and horsewomen. 408-705-7024 20350 McKean Rd San Jose, CA 95120 Bus. ID: 8962 Send E-mailView Map
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:
