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 >= '2021-11-29' and (b.admin_appr = 'T' or b.submit_date > '2021-11-26')
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 > '2021-11-26') 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).
Martin Ranch Mfg Since 1974, Martin Ranch Mfg has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels. Custom work and special orders welcome. Lyle Smith 707-585-1100 522 Martin Avenue Rohnert Park, California 94928 Bus. ID: 3182 Send E-mail
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
Martin Ranch Mfg Since 1974, Martin Ranch Mfg has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels. Custom work and special orders welcome. Lyle Smith 707-585-1100 522 Martin Avenue Rohnert Park, California 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
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
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 Mfg Since 1974, Martin Ranch Mfg has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels. Custom work and special orders welcome. Lyle Smith 707-585-1100 522 Martin Avenue Rohnert Park, California 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
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
Search the Directory for:
