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 = '24' and b.Exp_Date >= '2021-01-15' and (b.admin_appr = 'T' or b.submit_date > '2021-01-12')
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 = '24' and (b.admin_appr = 'T' or b.submit_date > '2021-01-12') 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
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
Catanese & Wells, A Law Corporation T. Randolph Catanese, Esq. / Douglas R. Hume, Esq. 818-707-0407 Fax: 7071161 31416 W. Agoura Rd. Suite 240 Westlake Village, CA 91361 Bus. ID: 3762 Send E-mail
Hey & Hey Attorneys At Law LLP Polly Hey Panos 650-216-6012 Fax: 650-362-2197 Cell Phone: 650-465-7439 333 Bradford Street Suite 170 Redwood City, CA 94063 Bus. ID: 4005 Send E-mail
Law Office of Sandra Bignault Sandra Bignault 925-258-9660 Fax: 925-258-9660 21C Orinda Way, #265 Orinda, CA 94563 Bus. ID: 4752 Send E-mail
Law Offices of Katrin M. Cusack Katrin Cusack, Esq. 925-838-8805 Fax: 925-838-8806 PO Box 152 San Ramon, CA 94583 Bus. ID: 2016 Send E-mail
Law Offices of Lauren M. Terk Lauren Terk 415-464-4810 Fax: 464-0508 700 Larkspur Landing Circle, Suite 199 Larkspur, CA 94939-1754 Bus. ID: 907 Send E-mail
Search the Directory for:
