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 = '64' and b.Exp_Date >= '2023-02-04' and a.subcat_id='96' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01')
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 = '64' and a.subcat_id='96' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01') 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).
Contact Saddles - Saddle Assessments via video or at your barn Fitting & re-flocking of most saddle brands. Custom Fit Albion New & Used Saddles. Certified Bit Fitting. Working with amateur to Olympic Grand Prix riders for 20+ years. Recognized by trainers, saddlers & Vets for their expertise. Serving CA, OR, WA, MT, AK, ID and NV. Email contactsaddles@aol.com 707-575-8637 Bus. ID: 3110 View Map
*SC Barns* SC Barns is the largest manufacturer of horse equipment, barns and buildings in Northern California. Products include barns, shelters, panels, gates, fencing, feeders, and arenas. Ryan Or Jeff 707-523-3513 3224 Dutton Ave Santa Rosa, Ca 95407 Bus. ID: 5957 Send E-mailView Map
Advanced Equine Saddle Fit Independent Saddle Fitting Consultations for English & Western riders. English saddle flocking. Western saddle/ pad assessments. Equine massage. Saddle consignment. Serving the Bay Area, the Central Valley from Redding to Fresno, and the foothills beyond. Please email for quickest response. Robyn Dorius Cell Phone: 209-585-6582 Hughson, CA 95326 Bus. ID: 7978 Send E-mailView Map
Contact Saddles - Saddle Assessments via video or at your barn Fitting & re-flocking of most saddle brands. Custom Fit Albion New & Used Saddles. Certified Bit Fitting. Working with amateur to Olympic Grand Prix riders for 20+ years. Recognized by trainers, saddlers & Vets for their expertise. Serving CA, OR, WA, MT, AK, ID and NV. Email contactsaddles@aol.com 707-575-8637 Bus. ID: 3110 View Map
Custom Horsehair Jewelry We make beautiful horsehair necklaces, bracelets and earrings! We can custom make one for you out of your own horse's tail or from our stock of horsehair. We are extremely reasonable in price ranging from $10-$75. Check us out on Facebook by searching Equine Tails Western Design! Ann Simon 707-732-1347 Petaluma, CA 94954 Bus. ID: 8986 Send E-mailView Map
Equestrienne Riding Apparel for Women and Girl equestrian athletes. Proud to design and manufacture in the USA - most of our manufacturing is done in the SF Bay Area! www.stickyseat.com San Anderson 415-595-9042 Fax: 415-460-1228 24 Moody Court San Rafael, CA 94901 Bus. ID: 5436 Send E-mailView Map
Ganado Feed Covering your livestock needs. We have alfalfa, oat, wheat, grass alfalfa hay, & all the grain you need. Our goal is to provide best quality hay at a fair price! We deliver at very competitive prices! @GanadoFeed Caeser Basanez 408-289-8626 info@ganadofeed.com 945 Lincoln Avenue San Jose, Ca 95126 Bus. ID: 6356 Send E-mailView Map
Nicker Bait Cookies For Horses We take pride in offering unique cookies, treats and gift items using premium ingredients your horse will flip over. We use San Francisco's own "Giusto's" ground flax, oat flour and barley (human grade) and Organic carrots, sweet potato, and banana. We top each cookie off with a special yummy treat! 510-733- 2126 castro valley, CA 94552 Bus. ID: 5859 Send E-mailView Map
Optimum Saddle Services Optimum saddle services provides Saddle repairs, wool re-flocking and wool conversions, billet repairs, leather re-conditioning, and custom dynamic saddle fittings Kelly 707-328-6763 11970 Canyon Dr. Guerneville, Ca 95446 Bus. ID: 8081 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
Tully Hole Saddlery Fine custom horse gear in the Californio tradition. Inspired by the classic gear of yesterday, built for the working cowboys of today. Bryan Kunic 831-524-5278 PO Box 301 Tres Pinos, CA 95075 Bus. ID: 6215 Send E-mailView Map
Napa Valley Equestrian Center Christine Fullin 707-255-0302 Fax: 707-255-0562 Cell Phone: 707-287-0611 1132 El Centro Avenue Napa, CA 94558 Bus. ID: 4924 Send E-mail
Polo Wrap.com Tack Shop Virginia Chatham 415-459-5906 Fax: (415) 459 - 0814 San Rafael, CA 94901 Bus. ID: 2561 Send E-mail