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;

348 Burkhart Road
Rutledge, TN 37861
Tammy Franklin with Franklin Realty, original listing - (865) 484-0660

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,900
Beds: 3
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3326 Square Feet
Agency: Franklin Realty
Agency Phone: (865) 484-0660

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: A private country setting surrounds this newly constructed home on 37 unrestricted mostly wooded acres. Located within minutes of Cherokee Lake. Enjoy the mountain views and wildlife as you relax in the peace and solitude this property offers! The rear outdoor living space offers a massive deck that is partially covered. As you enter through the front door a large foyer with a half bath welcomes you. You'll enjoy family gatherings in the spacious great room with tons of natural light and a unique tiled fireplace to cozy up around. The well-designed kitchen has tons of cabinet and pantry space, and a large kitchen island designed for seating. The home offers a split bedroom floor plan, to the left of the great room the primary bedroom is 20 x 15 and access to the rear deck. The primary bath does not disappoint with a soaking tub with a two-entrance tiled shower room behind it and large oversized dimensional closet. Two additional bedrooms to the right with ensuite baths, tiled showers, and rear deck access. Upstairs has a long garrison walkway overlooking the great room currently used as an office. Laundry room is on the main level conveniently located as you come in from the garage. The oversized garage has dual access with doors on each side. There is a theater room above the garage with a half bath and fireplace perfect for enjoying football games and family movie night. The basement is 2800 sq ft of unfinished area with unlimited possibilities. There are few things that have not been completed in the home as the photo's reveal - upstairs railings, deck railing, interior trims, and baseboards. The sample of the kitchen back splash on the counter has been purchased and the seller will leave the materials to be installed by the buyer. The seller requires a 45-day closing time frame. Located within 15 minutes of Jefferson City. 20 minutes to Morristown. Knoxville is 35-45 minutes to the west. The Great Smoky Mountains and all this has to offer is within an hour.
MlsNumber: --
ListingId: 302830


Listing Provided By: Franklin Realty, original listing
Phone: (865) 654-1110
Office Phone: (865) 484-0660
Agent Name: Tammy Franklin
Disclaimer: Copyright © 2024 Great Smoky Mountains Association of 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