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 = '64' and b.Exp_Date >= '2023-02-04' and b.serv_region = 'Central Coast' 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 = '64' and b.serv_region = 'Central Coast' 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).
Equoware Equestrian Boutique and Tack Store @ Corralitos Riding Club You may have seen our Equoware trailer at horse shows in Northern California. And we are proud to announce the grand opening of our new location at the Corralitos Riding Club in Watsonville, CA. Maxwell Cain 831-461-4181 1079 Green Valley Rd. Watsonville, CA 95076 Bus. ID: 9543 Send E-mailView Map
The Treeless Saddle Connection Treeless Saddle Dealer, treeless saddle pads and accessories for Ansur, Bob Marshall, Balance, Barefoot, Freeform, Sensation, Star Trekk, Torsion & others. Expert saddle fitting assistance. Kaaren Jordan 805-688-2503 875 Carriage Drive Solvang, CA 93463 Bus. ID: 2629 Send E-mail
Bit N Spur Tack & Apparel Gary Miller 831-455-1281 Fax: 455-0386 Cell Phone: 320-7551 275 River Road Salinas, CA 93908 Bus. ID: 2553 Send E-mailView Map
Classical Horseman Carla Byrd 805-473-0445 Fax: 474-1197 Cell Phone: 709-8862 201 E. Branch St. Arroyo Grande, CA 93420 Bus. ID: 4926 Send E-mail
Express Hay & Tack Supply Edie Atkins 408-779-6621 Fax: 779-8657 Cell Phone: 594-1148 14905 Olive Avenue Morgan Hill, CA 95037 Bus. ID: 5076 Send E-mail
Fayters Equine Emporium A Full Service Store Cher Fayter 831-385-8515 Cell Phone: 805 610 9368 69400 Jolon Road Bradley, CA 93426 Bus. ID: 4825 Send E-mail
Search the Directory for:
