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 = '79' and b.Exp_Date >= '2019-08-20' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17')
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 = '79' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17') 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).
Construction Equipment Services, an affiliate of Poplar Place Stables Compost removal via Freightliner truck tractor. Manure and shavings removed from stables are recycled to area farms to become soil amendment and fertilizer. Our removal costs allow us to give you the best value for your manure removal dollar. Water truck delivery also available. Chris Bearden 925-372-0629 Martinez, CA 94553 Bus. ID: 8388 Send E-mailView Map
Equine Waste Management/Wheeler Farms, LLC For 25 years we have assisted S.F. Bay Area stables reduce their stable waste disposal costs by using green recycling methods. Call us for information about our manure management programs. Cornelius Wheeler Stevenson 650-424-1896 Fax: 650-739-0322 Cell Phone: 650-444-4204 P.O. Box 19561 Stanford, CA 94309 Bus. ID: 6681 Send E-mailView Map
Ecology Action Ecology Action 831-426-5925 ext 132 PO Box 1188 Santa Cruz, CA 95061 Bus. ID: 2577 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
Search the Directory for:
