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 = 2920 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2920 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2920 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

24199 Redstone Drive
Bristol, VA 24202

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,349,000
Beds: 6
Baths: 5
Status: Active
SqFt: 7386
Agency: CENTURY 21 SHAMROCK REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2007
Notes: Your future begins with the serenity of this beautiful 7.3+- acre estate! This distinguished architecturally designed contemporary home welcomes you with a scenic private paved driveway. You will immediately feel the tranquility that this estate offers. Approaching the front door, you will appreciate the enclosed area with the expansive front deck to sit and enjoy the sunrise with your favorite cup of coffee. Enter through your uniquely designed front door and be greeted by the spacious foyer along the formal dining room. You'll be in awe as you walk into the most spectacular great room with cathedral ceilings and a gorgeous wood-burning fireplace to cozy up to. The Marvin double pane windows & triple lock doors throughout the home create a brilliance of natural light as well as the security you desire. Walk out through the double sliding doors that open onto the spacious deck with flourishing tree coverage and feel as though you are in your own oasis with rustling trees and wildlife. The kitchen is every chef's dream with a Viking 6 burner gas stove & griddle, along with a Miele double convection oven/microwave, concrete counters, double sinks, filtered water in the wet bar, & you will love the exceptionally large pantry. Clean-up is a breeze with 3 Fisher & Paykel dishwashers. As you walk down the hallway on the Australian Cypress hardwood flooring, you will find the double doors leading to the primary bedroom encompassing an open ensuite with a double concrete vanity, large walk-in closet, and the walk-in shower you have dreamed of, with not 1 but 7 shower heads. Continue to the large laundry room with ample shelving & clothing racks. As you make your way across the hallway, you will find your office and 2 other bedrooms that are adjoined by a shared Jack and Jill bathroom for the kids or guests. This home is an entertainer & movie enthusiast's dream with surround sound in the living room & Primary bedroom, & pre-wiring for speakers in the office & rear deck. Cozy up to 2 wood-burning fireplaces located in the living room & LL family room. On the lower level find a 2nd primary & 2 addt'l bedrooms, 2 bathrooms, & a large bonus room w/closet ideal for a gym, 2nd kitchen, or 7th bedroom. 923+-sf storage area with plumbing, vents, & recessed lighting. The decks, lower patio, & dog pens are accessed through the great room, primary suite, family room & bonus room. A new 33' x 20' enclosed barn, built in 2022, including 3 stalls, tack/feed area, lg. attached chicken run, water & electric. The barn leads out to 7+- acres of pasture, treehouse, ½ court, & garden shed. Furniture negotiable. Owner/Agent<br /> Please see alternate listing for this home which includes an additional 13.23 +- acres MLS #9958415.
MlsNumber: 9963742


Listing Provided By: CENTURY 21 SHAMROCK REALTY, original listing
Name: CENTURY 21 SHAMROCK REALTY
Phone: (276) 628-8131
Office Name: Century 21 Diamond Real Estate
Office Phone: (276) 628-8131
Agent Name: Lynn Snow
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 = 2920 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 Felecia Leonard
Felecia Leonard
ASCIIUnited country Real Estate Blue Ridge Land & Auction
Call Today!: (423) 967-2187

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App