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 = '139' and b.Exp_Date >= '2019-08-20' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17')
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 = '139' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17') 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).
Drake Equine LLC dba Drake Saddle Savvy Representing Custom Saddlery and Prestige Italia in NorCal and New Mexico. Offering sales and service on any make of english saddle. Robyn Drake 650-228-8006 Cell Phone: 650-228-8006 Half Moon Bay, CA 94019 Bus. ID: 9257 Send E-mailView Map
Custom Saddlery Dressage, Jumping, and Eventing.
Design your very own saddle! Endless possibilities! Leading through Innovation and Service since 1992. Robyn Drake 650-228-8006 Half Moon Bay, CA 94019 Bus. ID: 9262 Send E-mailView Map
Drake Equine LLC dba Drake Saddle Savvy Representing Custom Saddlery and Prestige Italia in NorCal and New Mexico. Offering sales and service on any make of english saddle. Robyn Drake 650-228-8006 Cell Phone: 650-228-8006 Half Moon Bay, CA 94019 Bus. ID: 9257 Send E-mailView Map
ELLA Palo Alto ELLA, an acronym for Equestrian Lifestyle Luxury Art, is a boutique in Palo Alto's Town & Country Village, across from Stanford University, and an online shop at: www.ellapa.com. We carry English apparel, technical riding gear, as well as, equestrian inspired home and gift collections.
Fairytale Friesian Finder Service INC Specializing in Importation and Sales of Friesians Suitable for Dressage AND Pleasure/Trail Riding.Helping riders acquire the Friesian that is RIGHT for them. EXCEPTIONALLY beautiful trail/pleasure horses, as well as offer accomplished sport horses! Janna Weir Cell Phone: 272-2112 59 Baywood Canyon Rd fairfax, CA 94930 Bus. ID: 4375 Send E-mailView Map
GaitedPleasureHorses.com For over 30 years Gaited Pleasure Horses ranch has specialized in providing gentle gaited trail horses best matched to your personal riding level. Our horses are fairly priced and comes with a limited purchase guarantee. Other services: transport, custom gaited horse saddles, and new & used tack. Terry Zygalinski Cell Phone: 831-818-5932 110 Paddon Road Royal Oaks, CA 95076 Bus. ID: 3012 Send E-mailView Map
Prestige Italia A perfect fit is a thing of beauty. Designed to be comfortable for the horse and to satisfy experts, amateurs and young riders. Eventing, Show Jumping, Cross Country, Endurance, Dressage, Junior Robyn Drake 650-228-8006 Cell Phone: 650-228-8006 Half Moon Bay, CA 94019 Bus. ID: 9258 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
Saddlery Dresch LLC Exquisite Quality Made-to-Measure English Saddles, uniquely designed and hand made for Horse and Rider. Dublin, Ca 94568 Bus. ID: 8569 Send E-mailView Map
Schleese Saddlery Service Ltd. Member of the Saddlefit4Life global network of equine professionals dedicated to comfort, protection and performance of the horse. Using diagnostics, our saddlefitters will find you the best solutions on-site. Sabine Schleese 905-898-8335 Fax: 905-898-8399 34 Centennial Avenue Holland Landing, Ont, Canada, L9N 1H2 Bus. ID: 5407 Send E-mailView Map
Tealwood Tack Company Offering consignment services for English saddles and tack. Currently accepting new pieces at competitive consignment rates. Please contact us for details! Tatiana Viau Davis, CA 95616 Bus. ID: 8769 Send E-mail
Search the Directory for:
