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 = '30' and b.Exp_Date >= '2021-08-05' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02')
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 = '30' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02') 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-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
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
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
Driscoll Ranches LLC Salina Plumb 650-747-9704 Fax: 650747-9732 La Honda, CA 94020 Bus. ID: 2337 Send E-mail
Equi-Tee Farm and Fence Joseph Berto 541-826-8301 10984 Meadows Raod White City, OR 97503 Bus. ID: 618 Send E-mail
Fence-World.com Angel Fox 877-336-2324 Apple Valley, CA 92308 Bus. ID: 9337 Send E-mail
Heartland Ranch Products Dave Pietrzcak 619-938-0203 12139 Moreno Ave. Lakeside, CA 92040 Bus. ID: 2829 Send E-mail
Indian Valley Ironworks Judy Bedell 805-467-3787 Fax: 467-3787 Cell Phone: 423-1896 P.O. Box 130 San Miguel, CA 93451 Bus. ID: 2129 Send E-mail
Jamestown Livestock Jeff Bridgewater 209-984-3234 Cell Phone: 209-352-2305 16206 State Hwy 108 Jamestown, CA 95327 Bus. ID: 2883
JW Corral Covers jason williams 707-330-7168 5141 Maple Rd. vacaville, CA 95687 Bus. ID: 2190 Send E-mail
LifeTime Lumber Products Nisha Mahler 760-634-6860 Fax: 760-634-6830 Cell Phone: 760-815-6529 4405 Manchester Avenue Suite 105 Encinitas, CA 92024 Bus. ID: 3246 Send E-mail
Search the Directory for:
