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 = '17' and b.Exp_Date >= '2019-08-19' and (b.admin_appr = 'T' or b.submit_date > '2019-08-16')
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 = '17' and (b.admin_appr = 'T' or b.submit_date > '2019-08-16') 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).
Lost Horse - Equine After Care & Cremation Transport Small family run company devoted to treating you and your horse with dignity, compassion and respect at a time of loss. Services include transport for cremation or necropsy. Licensed in CA, excellent references available. Bonnie Dilly 209-479-2842 Valley Springs, CA 95252 Bus. ID: 8793 View Map
CPM Equine and Livestock Removal CPM Equine and Livestock Removal provides compassionate, fast and caring removal of your deceased horse or livestock. Serving the San Francisco and Monterey Bay areas, same day service is available in most cases. We can also transport to cremation as well as UC Davis for post mortem necropsy. Adam Henderson 831-5668229 820 Park Row #340 Salinas, California 93901 Bus. ID: 9261 Send E-mailView Map
Janice Pementel Dead Stock Removal Specializing in Large and Small Dead Stock Removal. Family owned and operated since 1930. Cell Phone: 925-997-1387 PO Box 2497 Livermore, CA 94551 Bus. ID: 750 Send E-mailView Map
Lost Horse - Equine After Care & Cremation Transport Small family run company devoted to treating you and your horse with dignity, compassion and respect at a time of loss. Services include transport for cremation or necropsy. Licensed in CA, excellent references available. Bonnie Dilly 209-479-2842 Valley Springs, CA 95252 Bus. ID: 8793 View Map
Search the Directory for:
