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 >= '2018-12-11' and (b.admin_appr = 'T' or b.submit_date > '2018-12-08')
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 > '2018-12-08') 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).
Lemke Saddle Services, Inc. For over 34 years, Lemke has proven expertise throughout the USA. Professional English/Western saddle fitting & consultation, custom design, & flocking. Wide variety of new top quality SDL Saddles, used consignment saddles & medical grade sheepskin pads. Offering clinics, ranch calls & consultation for all levels/disciplines. Sheryl Lemke 925-286-1434 Bay Area, CA 94517 Bus. ID: 3893 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.
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
Lemke Saddle Services, Inc. For over 34 years, Lemke has proven expertise throughout the USA. Professional English/Western saddle fitting & consultation, custom design, & flocking. Wide variety of new top quality SDL Saddles, used consignment saddles & medical grade sheepskin pads. Offering clinics, ranch calls & consultation for all levels/disciplines. Sheryl Lemke 925-286-1434 Bay Area, CA 94517 Bus. ID: 3893 Send E-mailView Map
ReactorPanel Saddle Company High-end flexible panel saddles. Fully adjustable; ultimate in comfort for horse & rider. Dressage, H/J, eventing, endurance. Also, find products that are good for the horse in our online store.
Carmi Weininger 510-698-6272 Fax: 698-6275 414 Lesser St. Oakland, CA 94601 Bus. ID: 1175 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
BUSINESS DIRECTORY
Search the Directory for:
