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 = 2456 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 = 2456 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 = 2456 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;

1687 Scott Farm Road
Afton, TN 37616

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2860
Agency: GREENEVILLE REAL ESTATE & AUCTION

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2010
Notes: THIS FULLY CUSTOM HOME HAS MUCH TO OFFER AND WILL CHECK EVERY BOX ON YOUR LIST. In Dec. 2023 a New Septic and Field Lines were installed to make this a 4 BR, 3BA on Two Levels. You will notice the elegant design and attention to detail in every room while focusing on efficient and practical living. Sitting in beautiful Greene County, this extraordinary home will mesmerize you with delightful MOUNTAIN SCENERY and peaceful COUNTRY LIVING. This OPEN FLOOR PLAN maximizes the space and is perfect for family gatherings or hosting social functions. The wide, inviting Front Porch provides an ideal space to entertain or escape after a long day with its MOUNTAIN VIEW. Upon entering the home, you immediately notice the impressive Hardwood Floors, a spacious Living Room centering around a stunning Fireplace, Highly Efficient Wood Burning (Insert), and a bright Kitchen for all your family and entertainment needs. The oversized Primary Bedroom has space to add an Office or Sitting Area. You will never get tired of looking out the windows at the Mountain View and Country Scenery. The Primary suite is finished beautifully with a Spacious Bathroom, Extra-Long Tub/Shower, a massive Walk-In-Closet housing a Supersized Washer and Dryer. The Main Level is completed with an additional Bedroom and Bath with Tub/Shower. As you make your way down the extra wide steps, you will find the Spacious Family Rm, which leads you into the 5 Additional Rooms. This home is a ONE OF A KIND STUNNER, Yes there is much more: 2 Additional Bedrooms with closets, no windows, Full Bath, 9' ceilings, a multipurpose room for your Office or Crafts, and a spacious Storage Rm WITH OUTSIDFE ENTRANCE. This 5.85 acres has 175' of road frontage to Add Another Home or Mini Farm. LOOKING FOR PRIVACY? You will find it here, being surrounded by 90 acres
MlsNumber: 9958606


Listing Provided By: GREENEVILLE REAL ESTATE & AUCTION, original listing
Name: GREENEVILLE REAL ESTATE & AUCTION
Phone: (423) 525-5341
Office Name: Greeneville Real Estate & Auction Team
Office Phone: (423) 525-5341
Agent Name: Cheryl Fillers
Disclaimer: Copyright © 2024 Tennessee Virginia Regional Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2456 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;
Real Estate Expert Photo for Jayda Harden
Jayda Harden
ASCIIThe Real Estate Depot
Call Today!: (423) 465-1024

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App