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 >= '2021-01-18' and a.subcat_id='13' and (b.admin_appr = 'T' or b.submit_date > '2021-01-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 = '8' and a.subcat_id='13' and (b.admin_appr = 'T' or b.submit_date > '2021-01-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).
American Canyon Training Center Proud Home to MQ Training & Awakening Sporthorses - 70 stalls w/paddocks, lit mirrored indoor, 2 outdoor, xlnt footing, Equiciser, roundpen, track + more; clean & feed daily $650/mo w/trailer parking. Training NOT REQUIRED. Stallions allowed. Resident owners. Marie Roehm 707-557-3801 Fax: 707-557-6024 Cell Phone: 415-317-2455 2130 American Canyon Road AMERICAN CANYON, CA 945031258 Bus. ID: 686 Send E-mailView Map
American Canyon Training Center Proud Home to MQ Training & Awakening Sporthorses - 70 stalls w/paddocks, lit mirrored indoor, 2 outdoor, xlnt footing, Equiciser, roundpen, track + more; clean & feed daily $650/mo w/trailer parking. Training NOT REQUIRED. Stallions allowed. Resident owners. Marie Roehm 707-557-3801 Fax: 707-557-6024 Cell Phone: 415-317-2455 2130 American Canyon Road AMERICAN CANYON, CA 945031258 Bus. ID: 686 Send E-mailView Map
Ann Simon Horsemanship Lessons, training and sales located at Pleasants Valley Arena in Vacaville. Beautiful facility with a large covered arena,round pens and trails. All ages and abilities welcome. Specializing in all around horsemanship with a focus in reining/cowhorse, barrel racing/gymkhana. Lesson horses available! Ann Simon Cell Phone: 707-732-1347 7680 Pleasants Valley Rd Vacaville, 95688 Bus. ID: 8896 Send E-mailView Map
Christiane Noelting Dressage Center The Dressage Center is a 40stall,40ac. facility with 3outdoor+ 2indoor arenas,irrigated pastures offering boarding,training,lessons,sell+breed horses,hosting clinics+3 three star Dressage Shows Christiane Noelting 707-454-0565 Fax: 707-454-0566 6954 Lewis Rd Vacaville, CA 95687 Bus. ID: 1290 Send E-mailView Map
Flying Horses Farms Davis Boarding/Lay-Ups. Enjoy your horse YOUR way! Green pastures/Big Stalls.Rates from $450 Daniela Camarra 530-756-3333 Cell Phone: 530-304-7629 25703 County Road 95 Davis, CA 95616 Bus. ID: 5408 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
Little Wing Stables Boarding, Retirement, and Rehabilitation Facility, specializing in superior care for aged equines and equines with unique rehab requirements Stalls w/paddocks,daily turnout,irrigated pastures,2X/day feeding(Teff/Alfalfa),daily cleaning,free trailer parking,trail access, outdoor arena & 70' Round Pen Kelly Calapp 707-449-0969 Cell Phone: 707-684-0608 6043 Kozy Lane Dixon, CA 95620 Bus. ID: 4780 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
Spring Creek Ranch Quaint boarding facility in Northern Vacaville. Stalls with long runs, large outside turnouts, outdoor and indoor arenas. Great facility for your retired horse where they receive loving care, peace and quiet, excellent feed, and room to roam. Full Board $280.00. Kathie Kimsey 707-592-8774 Vacaville, Ca 95688 Bus. ID: 6416 Send E-mailView Map
Valley Horse Center Training, breeding & sales from foal to finish. Honesty & integrity- foundation for good business, honest sales & quality horse training. Showing/competing in halter, sporthorse, trail, extreme cowboy race, endurance. Jodi Tuft 707-374-2858 Cell Phone: 707-688-1741 Red Bluff, CA Bus. ID: 1215 Send E-mailView Map
Country Club Farm Ruth Ankenbruck 707-693-0304 8119 King Road Dixon, CA 95620 Bus. ID: 403 Send E-mail
Search the Directory for:
