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 >= '2023-03-28' and b.serv_region = 'North Central' and (b.admin_appr = 'T' or b.submit_date > '2023-03-25')
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 > '2023-03-25') 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).
Brooks Equestrian Specializing in hunters, jumpers and equitation. We offer a small personalized training program to help you and your horse reach their goals. Lessons are taught with an emphasis on safety and horsemanship. Karine Brooks 530-306-6769 Shingle Springs, California Bus. ID: 7038 Send E-mailView Map
Four Star Farm Certified Level III ICP Eventing Instructor, USDF L-graduate dressage judge and USDF Silver medalist. Lessons and training for eventing, dressage,and jumpers. Sale horses, camps and clinics. Natalie Rooney Cell Phone: 707-312-1119 30486 Equus Lane Winters, CA 95694 Bus. ID: 2433 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
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
Valley Horse Center Training, breeding & sales from foal to finish. Honesty & integrity- foundation for good business, honest sales & quality horse training. Showing/competing in halter, sporthorse, trail, extreme cowboy race, endurance. Jodi Tuft 707-374-2858 Cell Phone: 707-688-1741 Red Bluff, CA Bus. ID: 1215 Send E-mailView Map
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:
