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 = '86' 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 = '86' 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).
An Equine Addiction,LLC A.E.A. specializes in premium equestrian products & service. MICRORAIN & BIG SPRINKLERS, No More Mud with HOOFGRID, Groomers (Parma & custom), World Class Equine Products, Royalwire products, A & I products and much more. Locally owned & operated by fellow equestrians since 1998. RICHARD SNYDER 530-308-4582 Fax: 530-756-8343 Woodland, CA 95776 Bus. ID: 8714 Send E-mailView Map
RT Motors We specialize in pre-owned trucks. No haggle low upfront prices on late model low mileage trucks. We have your next work or two vehicle in stock! Family owned and operated in Tracey, CA. Ron Toor 209-535-6209 3602 Mars Way STE 107 Tracy, California 95377 Bus. ID: 9192 Send E-mailView Map
B & G Equipment Repair and Sales Bryan Burns 650-879-9592 Fax: 650-879-0210 PESCADERO, CA Bus. ID: 2586 Send E-mail
Morning Sun Ranch Gina Kindscher 831-722-4207 Cell Phone: 728-9139 815-a calabasas rd Watsonville, CA 95076 Bus. ID: 640 Send E-mail
Search the Directory for: