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;

874 Alvin Roach Rd
Rutledge, TN 37861
Fred DeFoe with Southern Homes & Farms, LLC, original listing - (865) 471-0070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2512 Square Feet
Agency: Southern Homes & Farms, LLC
Agency Phone: (865) 471-0070

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1992
Notes: Are you looking for that special place in the country? This estate has much to offer. Let's start with the land. Thirty acres, all usable, currently in hay field and a few acres of hardwoods providing shade for the livestock. There are pear and peach trees trees, grape vines, many flowering trees and shrubs including a weeping cedar, dogwoods, burning bush and more. The inground pool overlooks the back field. Watch the deer and turkey play while you swim. The home has 3 bedrooms, 2 have en-suite baths, 3 full baths in all. The great room is made bright and sunny with French doors to the covered porch, many windows to show off the views, and skylights over the kitchen area. The wood burning fireplace for those cool Tennessee nights. The kitchen has an abundance of solid wood cabinets, appliance garage and shelving. The island has a breakfast bar. Behind the kitchen is a sunroom that can be used as a formal dining room, den, gym, so many opportunities for this space. <br /> Other rooms: A walk in pantry, laundry room, mechanical room. Park your car in the garage or covered carport, which doubles as an open porch. Now, out to the barn. 40 x 60, 3 large barn doors-you can drive straight through! And a walk-in door. Skylights, water and power. There is also a smaller garage/chicken house/ wood shed for all the gardening things. The home sits on a knoll with views on every side. More photos and video coming soon.
MlsNumber: --
ListingId: 1277328


Listing Provided By: Southern Homes & Farms, LLC, original listing
Phone: (865) 471-0070
Office Phone: (865) 471-0070
Agent Name: Fred DeFoe
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