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 = '10' and b.Exp_Date >= '2021-10-27' and a.subcat_id='34' and (b.admin_appr = 'T' or b.submit_date > '2021-10-24')
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 = '10' and a.subcat_id='34' and (b.admin_appr = 'T' or b.submit_date > '2021-10-24') 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).
Boyd Morgans and Mobile Reproduction Services Boyd Morgans is located in the northern California foothills. Breeding quaility Morgans. I also travel to your barn for repro services, AI, training your stallion to collect, evaluate & ship semem. Sandra Boyd 530-622-8879 Cell Phone: 530 391-4270 PO Box 2173 Placerville, CA 95667 Bus. ID: 2350 Send E-mailView Map
Buffington Performance Horses, LLC Kelli is now the Western trainer at the Woodland Stallion Station where they host a wide range of Events throughout the year. We welcome all horse lovers, riders and handlers to come visit our beautiful facilities, experience our friendly atmosphere and ride in our fun & educational events! Matt Buffington 916-753-4836 Cell Phone: 916-753-4836 Pleasant Grove, CA 95668 Bus. ID: 6600 Send E-mailView Map
Aranaway Farm Mary Anne Morrison 541-476 9297 Grants Pass, CA 97527 Bus. ID: 5780 Send E-mail
Blue Sky Morgan Ranch LLC Athena Chiladakis 530-664-3961 Cell Phone: 510-407-3961 Tulelake, CA 96134 Bus. ID: 8854 Send E-mail
Search the Directory for:
