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 >= '2019-08-20' and a.subcat_id='34' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17')
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 > '2019-08-17') 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
Monarch Stables Specializing in the Saddleseat horse, American Saddlebreds, Morgans, Friesians, etc. Lessons, training, sales and horses for lease. Our goal is helping you and your horse reach your personal best and have fun on the journey! Community atmosphere, kind supportive people. Brigitte Scholl 707-291-0591 Santa Rosa, CA Bus. ID: 6132 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:
