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 >= '2020-07-12' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2020-07-09')
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 > '2020-07-09') 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).
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
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:
