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 >= '2022-05-20' and (b.admin_appr = 'T' or b.submit_date > '2022-05-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 > '2022-05-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).
Fairytale Friesian Finder Service Inc Specializing in Importation and Sales of Friesians Suitable for Dressage AND Pleasure/Trail Riding.EXCEPTIONALLY beautiful trail/pleasure horses, as well as offer accomplished sport horses! https://www.blacksterlingfriesians.com/friesian-horses-for-sale/
BlackSterlingFriesians Weir Cell Phone: 272-2112 2392 mar east st tiburon, CA 94920 Bus. ID: 4375 Send E-mailView Map
GaitedPleasureHorses.com For over 40 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
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
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
County Saddlery Northern California Manna Chertov 707-7077996228 Cell Phone: 7077996228 6391 Blank Rd Sebastopol, CA 95472-6148 Bus. ID: 9433 Send E-mail
Custom Saddlery Robyn Drake 650-228-8006 Half Moon Bay, CA 94019 Bus. ID: 9262 Send E-mail
Search the Directory for:
