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 = '23' and b.Exp_Date >= '2019-08-22' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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 = '23' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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).
Bayhill Equine, Inc. Bayhill Equine provides all aspects of equine medicine, surgery, and dentistry with a special emphasis on sports medicine and lameness. Our services include preventative health care, lameness diagnostics, pre-purchase examinations, advanced dentistry, general medicine, and reproductive services. Wayne Browning 650-851-2300 Fax: 650-367-7760 123 Belmont Avenue Redwood City, CA 94061 Bus. ID: 5465 Send E-mailView Map
Bayhill Equine, Inc. Bayhill Equine provides all aspects of equine medicine, surgery, and dentistry with a special emphasis on sports medicine and lameness. Our services include preventative health care, lameness diagnostics, pre-purchase examinations, advanced dentistry, general medicine, and reproductive services. Wayne Browning 650-851-2300 Fax: 650-367-7760 123 Belmont Avenue Redwood City, CA 94061 Bus. ID: 5465 Send E-mailView Map
Carrie Pierce, DVM Mobile Equine Veterinary Practice. 24hr Emergency service. Wellness care, power dentistry, prepurchase exams, lameness exams, etc. Serving the East Bay Tri-Valley area, also the Tracy and Brentwood areas by appt. Carrie Pierce DVM 925-734-5320 Pleasanton, CA 94588 Bus. ID: 6617 Send E-mailView Map
Ball N Chain Leslie Morgan 530-7491502 Marysville, CA 95901 Bus. ID: 5001 Send E-mail
Charles A Strickland DVM Chuck Strickland 925-925-625-1323 P.O. Box 2108 Brentwood, CA 94513 Bus. ID: 5691 Send E-mail
Cory H. Soltau, D.V.M. Cory Soltau 925-831-3450 240 Joseph Lane Pleasanton, CA 94588 Bus. ID: 6795 Send E-mail
Equine Dentistry Michelle Miller RVT--Dr. K. DeBolt DVM 925-922-9277 Livermore, CA 94550 Bus. ID: 3919 Send E-mail
High Sierra Equine Alternative Sports Medicine Alan White 530-401-1019 21083 Adamson Grass Valley, CA 95949 Bus. ID: 3985 Send E-mail
Lisa Atckison, DVM 707-479-3530 Sonoma, CA 95476 Bus. ID: 7013 Send E-mail
Marcus Rietema IAED/C Marcus Rietema 951-532-6378 P.O. Box 373 Livermore, CA 94551 Bus. ID: 3954 Send E-mail
MyEquineDentist.com Christine Griffin 760-789-3047 Cell Phone: 858-354-8291 1092 6th St Ramona, CA 92065 Bus. ID: 3369 Send E-mail
Pioneer Equine Hospital, Inc. Brad Jackman 209-847-5951 11536 Cleveland Ave. Oakdale, CA 95361 Bus. ID: 6924 Send E-mail
Sophie Russell, DVM Sophie Russell 925-420-0242 Lafayette, CA 94549 Bus. ID: 8639 Send E-mail
Search the Directory for:
