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 >= '2018-12-10' and (b.admin_appr = 'T' or b.submit_date > '2018-12-07')
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 > '2018-12-07') 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).
A Robinsons Equestrian Services/Who Rescues Who Located in the beautiful east bay hills, R.E.S. Offers the best in Training-Riding Lessons-Rehabs-Sales-Summer Camps
We guarantee personal attention, we welcome horses & Riders at all stages no drama Lisa Braden-Robinson 510-760-8909 Cell Phone: 510-760-8909 6667 Johnston Road Pleasanton, Calif 94588 Bus. ID: 9124 Send E-mailView Map
A Robinsons Equestrian Services/Who Rescues Who Located in the beautiful east bay hills, R.E.S. Offers the best in Training-Riding Lessons-Rehabs-Sales-Summer Camps
We guarantee personal attention, we welcome horses & Riders at all stages no drama Lisa Braden-Robinson 510-760-8909 Cell Phone: 510-760-8909 6667 Johnston Road Pleasanton, Calif 94588 Bus. ID: 9124 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
BUSINESS DIRECTORY
Search the Directory for:
