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 >= '2020-03-28' and (b.admin_appr = 'T' or b.submit_date > '2020-03-25')
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 > '2020-03-25') 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-mail
*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
FCP Barns & Buildings Manufacturer of Chew-Proof, Kick-Proof, Fire-Resistant, Low-Maintenance modular steel barns & buildings. FCP is proudly "Made In America". 951-678-4571 Wildomar, Ca 92595 Bus. ID: 8782 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
Olympia Footing - Footing and Arena Contractor Olympian Footing services all types of footing & arenas. We use laser guided grading equipment that allows us to provide exact depths for your footing. We install many textile products including GGT & Premiere Equestrian. We install and recondition base systems. Tony Judge 916-206-0662 2390 Brookwood Avn. Santa Rosa , CA 95404 Bus. ID: 8464 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
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
FCP Barns & Buildings Manufacturer of Chew-Proof, Kick-Proof, Fire-Resistant, Low-Maintenance modular steel barns & buildings. FCP is proudly "Made In America". 951-678-4571 Wildomar, Ca 92595 Bus. ID: 8782 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
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
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
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
Olympia Footing - Footing and Arena Contractor Olympian Footing services all types of footing & arenas. We use laser guided grading equipment that allows us to provide exact depths for your footing. We install many textile products including GGT & Premiere Equestrian. We install and recondition base systems. Tony Judge 916-206-0662 2390 Brookwood Avn. Santa Rosa , CA 95404 Bus. ID: 8464 Send E-mailView Map
An Equine Addiction,LLC RICHARD SNYDER 530-308-4582 Fax: 530-756-8343 Woodland, CA 95776 Bus. ID: 8714 Send E-mail
Blackburn Architects, P.C. Blackburn Architects 202-337-1755 Fax: 415-439-5299 1820 N St. NW Washington, DC 20036 Bus. ID: 3784 Send E-mail
Buckingham Resources LTD. Thomas Buckingham 424-322-7435 PO BOX 17058 California, CA 90209 Bus. ID: 6883 Send E-mail
Building the Equestrian Dream Carol Verbeeck 408-779-4844 P. O. Box 1731 Morgan Hill, CA 95038 Bus. ID: 4492 Send E-mail
Carport Direct Amy Lara 336-(336) 415-3616 737 South Main Street #3, Mount Airy, North Carolina 27030 Bus. ID: 9204 Send E-mail
Finta Hay Service Inc. Kevin Finta 925-516-5859 Fax: 925-516-7375 Cell Phone: 925-525-5329 4265 Camino Diablo Rd Byron, CA 94514 Bus. ID: 2362 Send E-mail
Hawkins Western World Gina Hunter 209-833-0313 19123 S Corral Hollow Road Tracy, CA 95304 Bus. ID: 5179 Send E-mail
Search the Directory for:
