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 = '73' and b.Exp_Date >= '2019-04-19' and (b.admin_appr = 'T' or b.submit_date > '2019-04-16')
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 = '73' and (b.admin_appr = 'T' or b.submit_date > '2019-04-16') 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).
The Yard Equine Center Meet the Montgomery Family! Vickie & Pat built an incredible rehabilitation center for the sport horse from the ground up. The 2 followed their path fueled by a shared passion that lead to the creation of this peaceful retreat for your horse. Rehab to Ringside, Foals to Retired we are here for you! Vickie & Pat Montgomery 831-831 628-0801 Fax: 831 628-0802 Cell Phone: 650 678-8902 270 Browns Valley Rd Paicines, CA 95043 Bus. ID: 7076 Send E-mailView Map
Blew By U Horse Transportation I am available for emergencies and experienced in hauling horses that may not want to get in another trailer. Call day or night. Billy Brucker 707-695-5901 Santa Rosa, CA Bus. ID: 1406 Send E-mailView Map
The Yard Equine Center Meet the Montgomery Family! Vickie & Pat built an incredible rehabilitation center for the sport horse from the ground up. The 2 followed their path fueled by a shared passion that lead to the creation of this peaceful retreat for your horse. Rehab to Ringside, Foals to Retired we are here for you! Vickie & Pat Montgomery 831-831 628-0801 Fax: 831 628-0802 Cell Phone: 650 678-8902 270 Browns Valley Rd Paicines, CA 95043 Bus. ID: 7076 Send E-mailView Map
A Lone Roan Trailering Services Amber Macdonald 925-305-7499 Cell Phone: 92530057499 Brentwood, CA 94513 Bus. ID: 5997 Send E-mail
Clay Jackson Transport Clay Jackson Transport 877-747-2486 Sausalito, CA 94965 Bus. ID: 9243 Send E-mail
Search the Directory for:
