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 = '8' and b.Exp_Date >= '2020-08-12' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2020-08-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 = '8' and b.serv_region = 'Central' and (b.admin_appr = 'T' or b.submit_date > '2020-08-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
Fox Farms LLC - Horse Board and Training facility, 8 miles from UC Davis. Full service sport horse farm with large jumping, dressage and covered arenas with outstanding footing. Personal care in a quiet setting. Big stalls w/paddocks, erociser & turn outs.hollyfoxfarms.com Holly Fox 530-902-1905 Davis, CA 95616 Bus. ID: 8238 Send E-mail
Mar Val Stables We are located just west of Lodi..
We have, since 1984, boarded English, Western retired horses
Plus since 1995 we have host Dressage in the Almonds show series Simon Tosh-Robb 209-368 7731 Cell Phone: 209-607-0156 706 Lucas Rd Lodi, CA 95242 Bus. ID: 219 Send E-mailView Map
Pheasant Ridge Farms Pheasant Ridge is a small boarding facility located in Vacaville. Our facilities include a covered and outdoor arena, both with sand/rubber footing. Stalls with individual paddocks/pastures. Julie Smith 530-530 219-1891 Skyhawk Lane Vacaville, CA 95688 Bus. ID: 5681 Send E-mailView Map
Arkenfield Farm Amanda Harrington 209-756-4417 4400 W Dickenson Ferry Rd merced, Ca 95341 Bus. ID: 9254 Send E-mail
Arrowhead Stables Laurie Alexander 209-481-2044 Manteca, CA 95337 Bus. ID: 5648 Send E-mail
AT Ranch Equestrian Center Della Todeschini 209-982-1699 Lathrop, CA Bus. ID: 4944 Send E-mail
AT Ranch Equestrian Center Della Todeschini 209-982-1699 Lathrop, CA Bus. ID: 4954 Send E-mail
Badger Valley Ranch and Farm Douglas Kellmann 916-612-0543 Fax: 687-0960 Cell Phone: 612-0543 11565 Badger Valley Rd Wilton, CA 95693 Bus. ID: 6931 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
Bear Creek Ranch, Lodi Robert Hoffmann 654 Hawes street Manteca, CA 95336 Bus. ID: 2542 Send E-mail
Cherry Stables 209-854-3540 Gustine, CA Bus. ID: 226 Send E-mail
Retire Your Horse 209-209-887-2604 Fax: 209-887-9106 PO Box 497 Linden, CA 95236 Bus. ID: 963 Send E-mail
Ridewell Ranch Kathy Stafford 209-747-8636 PO Box 717 Clements, CA 95227 Bus. ID: 6897 Send E-mail
Ridge Farms Laurie Ridge 559-709-9359 365 N Frankwood Ave Sanger, Ca 93657 Bus. ID: 6845 Send E-mail
Right Here Ranch Retired Horse Boarding Shayna Howitz 209-848-2715 Cell Phone: 602-3498 12700 Sierra View Dr. Oakdale, CA 95361 Bus. ID: 2539 Send E-mail
Rock n Horse Ariel Rodriguez 209-763-2659 Cell Phone: 209-327-0290 511 Hawks Landing Ct. P.O.Box 262 Wallace, CA 95254 Bus. ID: 1835 Send E-mailView Map
Ruiz Ranch Mike Ruiz 209-456-6513 Modesto, CA 95358 Bus. ID: 5268 Send E-mail
Sargent Equestrian Center Jeanne and Margot 209-727-0200 Fax: 209 727-0204 15757 E. Sargent Rd Lodi, CA 95240 Bus. ID: 5133 Send E-mail
Sequoia Morgan Ranch Sandy Cleveland 209-754-1940 Fax: 209-754-0344 Cell Phone: 419-1943 P. O. Box 390 11509 Worden Rd. Mountain Ranch, CA 95246 Bus. ID: 1686 Send E-mail
Search the Directory for:
