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 = '6' and b.Exp_Date >= '2023-02-04' 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 = '6' 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).
*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
East Bay Dumpster We provide dumpsters for debris and manure removal. We are happy to service you one time, or we can set up weekly, bi-monthly or what fits your needs. We are serving ranches and horse stables with manure removal, clean up and various projects within a 50 mile radius from Brentwood California 94513. Dan Braudrick 925-783-1269 Brentwood, California 94513 Bus. ID: 9523 Send E-mailView Map
Equine Facility Design Professional design firm specializing in the design of sites and structures for use by the horse community. Matthew Johnson 503-650-1663 107 SE Washington Street Suite 265 Portland, OR 97214 Bus. ID: 1176 Send E-mailView Map
Equine Paver Solutions We specialize in Rubber Paver installation for your barn aisleways, wash racks, paddocks and stalls. We also offer stall mats removal and new installations. Noelle Kaeser 916-628-4837 Sacramento, California 95835 Bus. ID: 9441 Send E-mailView Map
Finta Hay Service Inc. Offering custom delivery w/truck and hay squeeze of Premium Horse Hay, Cow Hay and straw. Serving throughout California with great service and great rates. Kevin Finta 925-516-5859 Fax: 925-516-7375 4265 Camino Diablo Rd Byron, CA 94514 Bus. ID: 2362 Send E-mailView Map
Footings Unlimited Offering over 60 combinations of arena footings including Airfoot, Lightfoot, RX, Rubbermates, EuroFelt and many more. Buy direct from the source and save! 800-218-5172 Serving Nationwide, CA Bus. ID: 5440 View Map
G3 Enterprises - Minerals Division G3 Byron sand mine, located in the Northern California, is a reliable high-quality silica sand provider supporting Northern California's equine facilities. Our equestrian sand is all-natural and sub-angular offering excellent cushioning and controlled rolling for superior horse hoof bio-mechanics. 800-3218747 Modesto, CA 95358 Bus. ID: 9392 Send E-mailView Map
Innovative Equine Systems Innovative Equine Systems offers a complete line of equestrian facility products: barns/arenas, horse stalls, fencing, rubber flooring, stall/paddock surfacing, insect control and barn accessories. Dennis Marion 800-888-9921 Fax: 775-267-6857 2559 Precision Drive Suite 4 Minden, NV 89423 Bus. ID: 708 Send E-mailView Map
Livermore Feed & Farm Supply 925-447-4203 Fax: 925-447-5921 3170 Fourth St. Livermore, CA 94550 Bus. ID: 4643 Send E-mail
MetalCarports.com Metalcarports.com is a specialized metal structure retailer including Metal Horse Barns, Metal Carports, Metal Buildings, and Metal Garages. Our staff is trained to fulfill our customers requests, working one on one with you to understand and satisfy your needs. 877-517-4422 Mount Airy, NC 27030 Bus. ID: 9274 View Map
An Equine Addiction,LLC RICHARD SNYDER 530-308-4582 Fax: 530-756-8343 Woodland, CA 95776 Bus. ID: 8714 Send E-mail