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

130 Stone Ridge Drive
Andersonville, TN 37705
Hilary Kilgore with Realty Executives Associates, original listing - (865) 588-3232

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $954,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4787 Square Feet
Agency: Realty Executives Associates
Agency Phone: (865) 588-3232

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2012
Notes: This beautiful 4-bedroom, 3.5-bathroom home blends comfort, style, and plenty of space to spread out. Sitting on over 1.5 acres this home offers a bright, open layout with room for everything—whether you're hosting friends, working from home, or just relaxing. Plus, you're only about 30 minutes from downtown Knoxville, so you can easily enjoy everything Market Square & our beautiful scruffy city have to offer- that includes great festivals, quaint locally-owned shops and some of the best food.<br /> <br /> <br /> On the walk-in level you'll find the large, open living area, formal dining, home office, half bath and a kitchen that's a 10/10! This part of the home is perfect for hanging out with family and friends. There's even access to the deck just off the kitchen. Perfect when grilling season rolls around!<br /> <br /> The kitchen is a dream with lots of counter space, large prep island, modern appliances, and plenty of room to cook or entertain. Right off the kitchen, you've got a formal dining room, making it easy to host holiday meals or dinner parties.<br /> <br /> Upstairs, you'll find three bedrooms, including the primary suite, which is truly a retreat. There's enough room for a cozy reading nook or sitting area, making it a perfect place to unwind after a long day. The en suite bathroom offers a soaking tub and walk-in, tiled shower. The primary closet is more than a walk-in. So much space- it's practically another room! The laundry room is upstairs too, right near the bedrooms, so doing laundry is that much easier.<br /> <br /> The fourth bedroom is on the lower level -in the fully-furnished basement with walk-out access. This provides a flexible space for guests, a hang out space for older kids, or a private retreat. It makes a great playroom, too! There's a large gathering space, mini kitchen, bedroom and full bathroom on this level, too. This would be a great play room, in-law retreat or weekend hang out.Movie night - activated! The movie projector will remain with the home.<br /> <br /> <br /> Kids and kids at heart will love the bookcase door on the basement level! <br /> <br /> The 3-car garage and an adjacent mudroom offer tons of storage and easy access to the home on the main level. Shed those snow boots and scarves.<br /> <br /> With over 1.5 acres of land, there's so much room to enjoy the outdoors. Whether you're grilling out, throwing a party, or just enjoying some peace and quiet, the backyard is ready for whatever you have in mind.<br /> <br /> Water softener remains with the home. <br /> Seller has had a pre-listing home inspection done and will happily provide a copy of that as well as a list of improvements & repairs that they've done as a result.<br /> <br /> Aspire Park is 14 miles and Stardust Marina is 4 miles away.<br /> <br /> Home was professionally measured by Knoxville Appraisal Company prior to listing.<br /> <br /> <br /> <br /> <br /> <br /> Washer and gas dryer remain with the home as do the radon mitigation system & water filtration.<br /> <br /> Buyer to verify all information for accuracy. Information is deemed reliable but not guaranteed.
MlsNumber: --
ListingId: 1286723


Listing Provided By: Realty Executives Associates, original listing
Phone: (865) 803-6201
Office Phone: (865) 588-3232
Agent Name: Hilary Kilgore
Disclaimer: Copyright © 2025 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.


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 = 2427 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 Don and Vivienne Rolfe
Don and Vivienne Rolfe
ASCIIRE/MAX Preferred Properties, Inc
Vivienne: (865) 505-1776
Don: (865) 346-8657

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App