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 = '8' and b.Exp_Date >= '2019-04-19' and b.serv_region = 'Central Coast' 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 = '8' and b.serv_region = 'Central Coast' 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).
First Light Dressage Full service board with daily turnout. Lesson horses. Training through Grand Prix. Jonna Lorenz 831-338-2530 Scotts Valley, CA 95066 Bus. ID: 628 Send E-mailView Map
River View Ranch - Horse Boarding Stable River View Ranch is a premier boarding stable offering you and your horse a safe and functional facility located on 22 acres in South Salinas, CA. The facility includes many amenities. Darelyn Lanini 831-210-0215 Cell Phone: 831-210-0691 844 River Road Salinas, CA 93908 Bus. ID: 8111 Send E-mailView Map
River View Ranch Horse Boarding Stable 22 acre facility includes stall and paddocks, covered paddocks, pastures, 100'x300' lighted arena, 100x150 sand arena, round pen, horses fed twice daily, lessons available, full/partial care avail Darelyn Lanini 831-210-0215 Cell Phone: 8312100691 844 River Road Salinas, CA 93908 Bus. ID: 5880 Send E-mailView Map
SPCA Stables at Indian Springs SPCA Stables offers quality, affordable full-service, self-service, and retirement care boarding. We offer very large stalls, two riding arenas, lighting for evening riding, and multiple turnouts. Conveniently located on Indian Springs Road just off River Road in Salinas, 3.2 miles south of Hwy 68 831-373-2631 Monterey, CA 93908 Bus. ID: 8348 Send E-mailView Map
Bar JF Ranch Pauline Ferguson 209-209-847-9309 Oakdale, Ca 95361 Bus. ID: 8968 Send E-mail
Big Tree Ranch Bobby Paul 831-247-2394 140 Big Tree Lane Watsonville, CA 95076 Bus. ID: 8909 Send E-mail
Busted Flat Ranch Steve Myers 831-632-0428 Cell Phone: 261-4333 982 Dolan Rd. Moss Landing, CA 95012 Bus. ID: 432 Send E-mail
Cindy Brooks Training Cindy Brooks 650-529-9335 Cell Phone: 650-740-0123 641 East Campus Drive Stanford, CA 94305 Bus. ID: 4983 Send E-mail
Clark Valley Farm Inc. Dana Tryde 805-528-7395 Fax: 805-528-7195 Cell Phone: 234-2879 2310 Clark Valley Road Los Osos, CA 93402 Bus. ID: 1138 Send E-mail
Classical Training Jec Ballou 831-419-3445 Soquel, CA 95003 Bus. ID: 1950 Send E-mail
Classical Training Jec Ballou 831-419-3445 Soquel, CA Bus. ID: 3874 Send E-mail
Search the Directory for:
