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 = '81' and b.Exp_Date >= '2021-04-22' and (b.admin_appr = 'T' or b.submit_date > '2021-04-19')
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 = '81' and (b.admin_appr = 'T' or b.submit_date > '2021-04-19') 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
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
Wine Country Ranch Equipment All your fencing needs wire to pipe panels, Humane mats, feeders,wormers, used saddles and what ever else he finds to sell. Robert Gianachinni 707-528 8990 5300 Sebastopol Rd. Santa Rosa, CA 95407 Bus. ID: 3562 Send E-mailView Map