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 = '8' 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 = '8' 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).
Arbalette Castle Ranch - Gold Country Retirement for Horses 320 acre historic ranch specializing in horse retirement. We are experienced horse professionals offering Paddocks, Mare Motels or Pastures with Creeks and Meadows. Horses checked daily, special feed programs available. Trainer or Barn references for your horse are required. Special Events Venue. Karan Eriksson 530-802-1281 6597 Smartsville Rd Smartsville, CA 95977 Bus. ID: 8059 Send E-mailView Map
Arbalette Castle Ranch - Gold Country Retirement for Horses 320 acre historic ranch specializing in horse retirement. We are experienced horse professionals offering Paddocks, Mare Motels or Pastures with Creeks and Meadows. Horses checked daily, special feed programs available. Trainer or Barn references for your horse are required. Special Events Venue. Karan Eriksson 530-802-1281 6597 Smartsville Rd Smartsville, CA 95977 Bus. ID: 8059 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
Flying Horses Farms Davis Boarding/Lay-Ups. Enjoy your horse YOUR way! Green pastures/Big Stalls.Rates from $450 Daniela Camarra 530-756-3333 Cell Phone: 530-304-7629 25703 County Road 95 Davis, CA 95616 Bus. ID: 5408 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
Oak Tree Farms On 40 gorgeous acres in Sierra Nevada Gold Country, OTF offers two arenas (1 covered) w/ great footing, sturdy stalls and shelters, trail access, pastures and paddocks of many sizes, peace and quiet. 530-432 1556 Penn Valley, CA 95946 Bus. ID: 2644 Send E-mail
Almondale Farms Capay, CA Bus. ID: 410 Send E-mail
Search the Directory for:
