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 = '47' and b.Exp_Date >= '2019-06-19' and b.serv_region = 'North Central' and (b.admin_appr = 'T' or b.submit_date > '2019-06-16')
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 = '47' and b.serv_region = 'North Central' and (b.admin_appr = 'T' or b.submit_date > '2019-06-16') 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).
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
Gateway Farm Sport Horses Full care facility offering boarding, training, lessons, sales, breeding, camps, and Pony Club. Stalls, individual pastures, and group pastures w/shelters. Covered arena, sand jump arena, round pen and cross country course. Special pastures for retirees and mares/foals. In business since 1989. Liz Jenner 209-759-9700 Cell Phone: (209) 327-6858 Acampo, CA 95220 Bus. ID: 7609 Send E-mail
Hunter's Moon Stable NEW LOCATION- Brookside EQuestrian Center in Elk Grove, California. Offering riding lessons and training for all levels of horse and rider-beginning through advanced -in hunt seat equitation,hunters and jumpers. Christina OBrien Cell Phone: 812-2624 P.O.Box 221553 Sacramento, CA 95831 Bus. ID: 7344 Send E-mailView Map
Los Lagos Equestrian, Inc. Hunter/Jumper Training and Showing. Accepting new clients of all ages and levels. Training, Sales, Lessons (school horses available), Leases. Visit Web site at www.llhorses.com Carrie Orcutt 916-652-0904 Cell Phone: 759-2153 P.O. Box 2116 6525 Boulder Rd Granite Bay, CA 95746 Bus. ID: 6682 Send E-mail
Mokelumne River Ranch Equestrian Center 60+ acre Horse Park. Ride "Day or Night", "Rain or Shine". Three Arenas, Dressage Court, River Front Trail, Western Trail Training, Barrel Race Training, One Mile Loping Track, Lg. Stalls, Paddocks 916-837-2605 Thornton, CA 95686 Bus. ID: 5764
A-Z Horsemanship Alaina Sheffield 916-365-6857 6516 Young Oak Court Orangevale, CA 95662 Bus. ID: 8574 Send E-mail
Search the Directory for:
