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 = '19' and b.Exp_Date >= '2023-02-01' and (b.admin_appr = 'T' or b.submit_date > '2023-01-29')
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 = '19' and (b.admin_appr = 'T' or b.submit_date > '2023-01-29') 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).
Alternative Methods in Horsemanship Tina offers humane, healing education for the horse and the human. Her background includes TTEAM,Centered Riding, Feldenkrais. She travels monthly into various parts of the Bay Area. Tina Hutton 530-745-9582 Fax: 530-745-9583 PO Box 7253 Auburn, CA 95604 Bus. ID: 2679 Send E-mail
Cevalo Riding Academy - Got Jump? Cevalo offers year-round riding lessons for both children and adults. Whether you're a beginner or have been riding for years, our experienced instructors and talented school horses will help you build confidence, advance your riding, and and have fun. Jump in and join us! 408-227-3529 Fax: 408-227-3529 www.cevaloridingacademy.org Morgan Hill, CA 95037 Bus. ID: 172 Send E-mailView Map
Christiane Noelting Dressage Center The Dressage Center is a 40stall,40ac. facility with 3outdoor+ 2indoor arenas,irrigated pastures offering boarding,training,lessons,sell+breed horses,hosting clinics+3 three star Dressage Shows Christiane Noelting 707-454-0565 Fax: 707-454-0566 6954 Lewis Rd Vacaville, CA 95687 Bus. ID: 1290 Send E-mailView Map
Equinology and Caninology Choose the program referred by veterinarians! Certification Courses in Equine & Canine Body Work, massage, MFR, saddle fit, anatomy, nutrition and more. Learn from the best; Clayton, Ridgway, Pattillo, Thompson, Crabbe, and Wetzler. Module courses to accommodate the working student. NCBTMB approved Debranne Pattillo 707-884-9963 Gualala, CA 95445 Bus. ID: 7123 Send E-mailView Map
Harris Equines We offer equine services in northwestern California. Harris Equines operates on a foundation of understanding equines and developing functional, comfortable and safe relationship. We offer training and retraining, lessons on our gentle, beautiful horses, and pony parties/rides for teeny tots. Danielle Harris 707-444-2214 Eureka, CA 95503 Bus. ID: 7640 Send E-mailView Map
Jenny Call, Myofascial Release Myofascial Release Therapy is a very safe and gentle technique that works within the bodies 3 dimensional connective tissue system to release restrictions and help bring the body back into balance. Jenny Call 831-421-2584 Cell Phone: 421-2584 2783 Pine Flat Road Santa Cruz , Ca 95060 Bus. ID: 8846 Send E-mailView Map
Jill Carabelas Dressage Dressage training and lessons for beginners through Grand Prix. Kind approach with horses and riders. Come experience excellence in an atmosphere of friendship and comaraderie. Located at Summit Equestrian Center in Los Gatos. Jill Carabelas 831-818-1907 4900 Cherryvale Ave. Soquel, CA 95073 Bus. ID: 3049 Send E-mailView Map
Saddle Fit Specialist Independent saddle fitting services. Clinics, saddle evaluations, flocking adjstments, pad recommendations & repairs.
Master Saddler Association trained saddle fitter serving NORCAL, Reno & Hawaii Teri Rohm 510-825-2399 Fax: 510 825-2399 Cell Phone: 510 825-2399 P O Box 215 Sunol, CA 94586 Bus. ID: 9230 Send E-mailView Map