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 >= '2020-07-08' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2020-07-05')
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 > '2020-07-05') 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
Kul Hussun al-Melik Arabians Breeders of World Class Straight Egyptian Arabian Bloodstock. Standing fine SE stallions at stud w/ quality horses for sale. Marketing and photography services avail. Virtually visit us TODAY! Debbie Taylor 209-931-1705 Fax: none Cell Phone: 916 765 9561 12070 N. Tully Road Lodi, CA 9240 Bus. ID: 1718 Send E-mail
Search the Directory for:
