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 = '47' and b.Exp_Date >= '2023-03-28' and b.serv_region = 'Central Coast' and (b.admin_appr = 'T' or b.submit_date > '2023-03-25')
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 = '47' and b.serv_region = 'Central Coast' and (b.admin_appr = 'T' or b.submit_date > '2023-03-25') 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).
Cypress Ridge Hunter/Jumper Competitive, full-service training barn. Conveniently located 25 min from San Francisco and 10 min from San Mateo.Call or message Nessa to set-up a jumping lesson on one of our horses today. Nessa Cossentine 831-234-3325 Woodside, CA 94062 Bus. ID: 8778 Send E-mailView Map
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
Jillian "Tory" Montgomery ~ Montgomery Show Stable Tory is a professional rider/trainer for Montgomery Show Stable, based at The Yard Equine Center. Tory specializes in young sport horses & sale horses. Tory's extensive competition experience enhances her ability to develop young horses, prepare sale horses for the show ring. Jillian Montgomery 831-831 628-0801 Fax: 831 628-0802 270 Browns Valley Rd Paicines, CA 95043 Bus. ID: 7562 Send E-mailView Map
Whisper Equestrian Center Boarding, Driving lessons, Training and sales of Shetland Ponies. Summer day camps Overnight Barn and Breakfast for you Equine.Located in the Aptos Hills. See our web site www.whisperponies.com. Julie Mabie 831-684-1555 Fax: 684-1842 Cell Phone: 359-0782 P.O. Box 1445 120 Pine Forest Dr. Aptos, CA 95001 Bus. ID: 5781 Send E-mail
A Horsemans Way Toby Mockler 831-2613231 Cell Phone: 8312613231 Salinas, CA 93901 Bus. ID: 2397 Send E-mail
Across The Diagonal Farm 831-624-2848 Fax: 831-624-2848 8767 Camel Valley Rd. Carmel, CA 93923 Bus. ID: 245 Send E-mail
Alison Potter Training Alison Potter 831-224-2727 1 Ivy Street Monterey, CA 93940 Bus. ID: 3716 Send E-mail
Canton Dressage Jason Canton 831-8312521842 Cell Phone: 8312521842 1840 41st ave Suite 102 #377 Capitola, CA 95010 Bus. ID: 8296 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
Cindy Martin Training & Behavior Coaching Cindy Martin Cell Phone: 809-3891 Carmel Valley, CA 93924 Bus. ID: 7720 Send E-mail
Classical Training Jec Ballou 831-419-3445 Soquel, CA Bus. ID: 2484 Send E-mail
Ellen El-Bisi Horse Training Ellen El-Bisi 831-247-3148 Fax: (408)847-8881 Cell Phone: (831)247-3148 14880 Pacheco Pass Hollister, CA 95023 Bus. ID: 4092 Send E-mail
Equine Athletes Robin Hambey Cell Phone: 408-804-3412 636 hall rd watsonville, CA 95076 Bus. ID: 2517 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: 4831 Send E-mail
Search the Directory for:
