Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2455 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2455 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2455 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

274 Richland Rd
Blaine, TN 37709

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,500
Beds: 3
Baths: 4
Status: Pending
SqFt: 3118
Agency: Wallace

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2006
Notes: East Tennessee Equestrian Estate with stunning Mount LeConte views- 3 pastures on 10.22 acres with 3 barns. A once in a lifetime opportunity to own a horse farm in this private exclusive equestrian community . Located in River Ranch Subdivision - offering the best combination of location, land, and amenities. Just 20 minutes from downtown Knoxville, shopping, dining, and healthcare. Capture year-round views from inside and out on the front covered porch. Spend days and nights by the custom-built Gazebo. Host family and friends in the screened in back porch. Fly fishermen enjoy some of Tennessee's best tailwater trout fishing on the famous Holston River along the banks of River Ranch Subdivision. This custom farmhouse home features exquisite wide plank heart of pine flooring throughout the spacious main floor. ADA friendly wide halls and doors contribute to the beauty and function of this immaculate 2 story farmhouse. The large eat in kitchen is designed for holiday cooking. Cook a feast in both the wall mounted and regular ovens. A spacious island with integrated sink offers room for everyone to enjoy. The large formal dining has a wood burning fireplace and mountain views. The main level provides a large study with closet space. This main floor provides 2-3 bedrooms and 2.5 bathrooms, while upstairs offers ample quarters for any number of guests. The upstairs layout has a full bath, the large ''Bunkhouse'', and yet more space for play, sleep, or quiet reading after a full day on horseback. One of the three Barns is equipped with a full active Solar system able to power the entire home. The water is utility provided, so there is no well maintenance with which to contend. Efficient, beautiful, and cost-effective living. Come and see for yourself the care and attention to detail of this amazing Tennessee equestrian property. Contact us for a private showing today.
MlsNumber: 1263943


Listing Provided By: Wallace, original listing
Name: Wallace
Phone: (865) 584-4000
Office Name: Wallace
Office Phone: (865) 693-1111
Agent Name: Jeff McCormick
Disclaimer: Copyright © 2024 East Tennessee Realtors®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App