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 = '22' and b.Exp_Date >= '2019-04-19' and (b.admin_appr = 'T' or b.submit_date > '2019-04-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 = '22' and (b.admin_appr = 'T' or b.submit_date > '2019-04-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).
DGB Equine Law DGB Equine Law provides Legal & Business Assistance including Equine Releases & Contracts of all types. We service throughout CA. We also offer help for your equine-related business, including risk analysis, ranch and barn management & Mediation for entire the equine community. Diana Bicksler, Esq. 925-838 9909 Danville, CA 94526 Bus. ID: 6475 Send E-mailView Map
Madonna Creek Weed Abatement Services An owner operated company specializing in brush mowing, weed abatement, pasture & large estate land maintenance as well as tick spraying. With a lifetime of farming & ranching experience, we will provide an honest, thorough yet affordable solution to your land maintenance needs. John Cozzolino 650-726-9614 Half Moon Bay, CA 94019 Bus. ID: 8678 Send E-mailView Map
Barbara C. Zimmerman Law Office Barbara Zimmerman 707-578-7555 Fax: 545-7230 131-A Stony Circle, Ste. 500 Santa Rosa, CA 95401 Bus. ID: 2774 Send E-mail
Barn Manager Micaela johnson 530-530-320-8094 Fax: 530-320-8094 Cell Phone: 530-320-8094 Berkeley, CA 94720 Bus. ID: 7527 Send E-mail
Financial Advisor / Merrill Lynch John Armstrong 408-554-7984 Cell Phone: 831 818-9572 10200 Love Creek Rd Ben Lomond, CA 95005 Bus. ID: 2167 Send E-mail
Financial Help for the HorseTrainer LaVergne Poe 650-529-1489 POBox 620096 Woodside, Ca 94062 Bus. ID: 6080 Send E-mail
Search the Directory for:
