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-02-18' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2019-02-15')
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 > '2019-02-15') 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).
Pine Mountain Lake Stables Located 24 miles outside of Yosmite National Park.
Riding lessons, day camps, lead line rides, overnight horse facilities, monthly boarding. Weddings, receptions, birthdays, family reunions, picnic in the park. Jeanna Santalucia 209-962-8667 13309 Clifton Way Groveland, CA 95321 Bus. ID: 2750 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
Pine Mountain Lake Stables Located 24 miles outside of Yosmite National Park.
Riding lessons, day camps, lead line rides, overnight horse facilities, monthly boarding. Weddings, receptions, birthdays, family reunions, picnic in the park. Jeanna Santalucia 209-962-8667 13309 Clifton Way Groveland, CA 95321 Bus. ID: 2750 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
BUSINESS DIRECTORY
Search the Directory for:
