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 >= '2019-04-23' and a.subcat_id='96' and (b.admin_appr = 'T' or b.submit_date > '2019-04-20')
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 > '2019-04-20') 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).
*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
Martin Ranch Supply Since 1974, Martin Ranch Supply has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels and offers a full line of fencing. Exiss & Sooner trailers, supplies, tack and over 10,000 products in stock. Custom work and special orders welcome. 707-585-1313 Rohnert Park, CA 94928 Bus. ID: 3182 Send E-mailView 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
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
Fairytale Friesian Finder Service INC Specializing in Importation and Sales of Friesians Suitable for Dressage AND Pleasure/Trail Riding. sponsorship opportunities available. Janna Weir Cell Phone: 272-2112 59 Baywood Canyon Rd fairfax, CA 94930 Bus. ID: 4375 Send E-mailView Map
Martin Ranch Supply Since 1974, Martin Ranch Supply has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels and offers a full line of fencing. Exiss & Sooner trailers, supplies, tack and over 10,000 products in stock. Custom work and special orders welcome. 707-585-1313 Rohnert Park, CA 94928 Bus. ID: 3182 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
Whole Equine Healthy Horses, Naturally! The Bay Area's online resource for natural care products for horses from supplements and first aid products to premier brushes and hoof boots. Montara, CA 94037 Bus. ID: 8719 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
Quality Tack Broker Dean MacCracken 415-455-9208 2067A 5th Ave San Rafael, CA 94901 Bus. ID: 5574 Send E-mail
ReactorPanel Saddle Company Carmi Weininger 510-698-6272 Fax: 698-6275 414 Lesser St. Oakland, CA 94601 Bus. ID: 1175 Send E-mail
Saddles to Boots Inc. 707-707-823-9700 Fax: 707-823-9700 6144 Sebastopol Road Sebastopol, CA 95472 Bus. ID: 3271 Send E-mail
Saddles to Boots Inc. 6144 Sebastopol Road Sebastopol, CA 95472 Bus. ID: 3701 Send E-mail
Search the Directory for:
