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 = '59' and b.Exp_Date >= '2021-10-27' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2021-10-24')
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 = '59' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2021-10-24') 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).
Black Feather Farms Friesians Breeding quality FPS/FHANA registered Friesians in the Baroque body style. Katherine Gutierrez 209-769-8324 Fax: 209 826 7755 Cell Phone: 209 769 8324 P.O. Box 2415 Los Banos, CA 93635 Bus. ID: 2311 Send E-mail
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
Healing Arenas, Inc. Our mission it to Provide public and charitable opportunities to support emotional healing through equine interaction, and provide safe and restorative homes for retired racehorses Julie Baker 209-900-7917 Cell Phone: 988-7800 PO Box 312 Escalon, CA 95320 Bus. ID: 8750 Send E-mailView Map
Search the Directory for:
