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 >= '2022-07-06' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2022-07-03')
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 = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2022-07-03') 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).
Mar Val Stables We are located on 30 green acres with hundreds of shade trees just west of Lodi. Four different arenas, trial course, round pen
We have, since 1984, offered full care boarding, we cater for English, Western, retired horses, many on grass, two onsite trainers, clinics,
Simon Tosh-Robb 209-368 7731 Cell Phone: 209-607-0156 706 Lucas Rd Lodi, CA 95242 Bus. ID: 219 Send E-mailView Map
Eden Ranch Eden is a premier family-owned equestrian facility located in Fresno County. We offer lessons, training, and sport horse sales as well as clinics and other equestrian events. Eden's facilities include a covered full dressage court, a 400' jump arena and a few xcountry jumps and fitness track. Ananda Aspen 559-399-8455 Cell Phone: 559 779-1112 2176 N. Bethel Ave. Sanger, CA 93657 Bus. ID: 8679 Send E-mailView Map
EJ'S Equine Center Full service equestrian center. Training from beginner ages 4 and up to advanced competive riders. Lessons english and western available. Specializing in quality horses for sale to suit all types of riders. Jennifer Jones 209-620-3781 Ceres, Ca 95307 Bus. ID: 7401 Send E-mailView Map
Jen Hannink - Hannink Equine Center Jen has been training in California for many years. Showing horses from the Baby Greens to the Grand prix as well as instructing riders. Her students range from the beginner to World Cup Grand prix. Jen Hannink 209-526.0322 Fax: 209.526.2854 5437 Mchenry Ave. Modesto, CA 95356 Bus. ID: 5722 View Map
Mar Val Stables We are located on 30 green acres with hundreds of shade trees just west of Lodi. Four different arenas, trial course, round pen
We have, since 1984, offered full care boarding, we cater for English, Western, retired horses, many on grass, two onsite trainers, clinics,
Simon Tosh-Robb 209-368 7731 Cell Phone: 209-607-0156 706 Lucas Rd Lodi, CA 95242 Bus. ID: 219 Send E-mailView Map
A Gentle Touch Horse Training Melanie McCarthy Cell Phone: 559-474-2569 AGThorsetraining@aol.com Colt Starting,training,lessons,sales Madera, CA 93637 Bus. ID: 2003 Send E-mail
Andy Lockwood Andy Lockwood 805-748-5181 Cell Phone: 805-748-5181 3725 Buena Vista Road Ione, CA 95640 Bus. ID: 5603 Send E-mail
AT Ranch Equestrian Center Della Todeschini 209-982-1699 Lathrop, CA Bus. ID: 4954 Send E-mail
Autumn Sun Farms Sara Wortley 916-849-2947 Lodi, CA 95258 Bus. ID: 5744 Send E-mail
Ball N Chain Leslie Morgan 530-7491502 Marysville, CA 95901 Bus. ID: 5001 Send E-mail
Bear Creek Ranch, Home Of Roberts Arabians 209-931-4609 Cell Phone: 367-8779 Lodi, CA Bus. ID: 935 Send E-mail
Blue Sky Farm Carol Dirksen 916-687-8850 10321 Reigl Road Wilton, CA 95693 Bus. ID: 3047 Send E-mail
Search the Directory for:
