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

154 Millwood Road
Bristol, TN 37620

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 5
Baths: 5
Status: Active
SqFt: 5828
Agency: The Addington Agency Bristol

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Looking for a luxury in the heart of Bristol? Don't miss this one! First time ever listed on the market, this custom built one owner home has it all! Nestled on arguably the best lot in Bristol, this timeless estate offers 5 large bedrooms, 4.5 bathrooms, and over 5,200+ sqft of finished living space on 1.75 acres! Strategically positioned, this property is tucked away from the road, enjoying complete seclusion while boasting incredible curb appeal with mature landscaping, highlighted by the natural spring that runs throughout the property! Showcasing one-of-a-kind features, this residence comes complete with tons of character and charm including hardwood floors, custom-designed architraves, and transoms above the doorways, handmade 5-panel solid wood doors, plantation shutters, multiple fireplaces, plus so much more! Promoting turn key condition, this home also offers an updated kitchen with high end cabinetry, granite countertops, jenn-air appliances with a gas range, double oven, and open concept to the living room highlighted with vaulted ceilings, exposed beams, and custom built-ins on adjoining the floor-to-ceiling stone fireplace! Presenting a convenient floor plan with the primary bedroom on the main level, this suite is highlighted with vaulted ceilings, walk-in closets, and an en suite that offers a his and hers vanity, soaking tub, walk in tile steam shower, plus so much more! Built for entertaining, this home not only offers a luxurious interior but also comes equipped with an abundance of outdoor living space where you'll find the two story covered deck overlooking the view of the creek, and mountains in your backyard! Immaculately maintained, this home also provides a finished walk out basement equipped with a handcrafted bar built from reclaimed barnwood, wine cellar, stained concrete floors, tray ceilings highlighted with reclaimed beams, stone fireplace, attached garage, workout room, and easy access to the secluded back patio! Constructed with quality in mind, this home also promotes top notch mechanicals with a geothermal heating/cooling system, spray foam insulation, surround sound, central vac, security, and so much more! On the grounds of the property, you will find an abundance of wildlife, a park-like setting around the property, and a quick easy commute to the Country Club, The Virginian, The Olde Farm, King College, South Holston Lake, and anywhere in the TriCities! This description barely touches on all the details that this home offers, and is truly one of the highest quality properties to ever hit the market in our area! Priced to sell at $1.65M, call today to schedule your appointment! All information contained herein is gathered from third party sources, tax records, homeowner and is subject to buyers and buyers agent verification.
MlsNumber: 9966489


Listing Provided By: The Addington Agency Bristol, original listing
Name: The Addington Agency Bristol
Phone: (423) 845-5800
Office Name: The Addington Agency Bristol
Office Phone: (423) 845-5800
Agent Name: Garrett Addington
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 = 2508 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;
Stephanie & Mike Ransom
ASCIIEpique Realty
Call Today!: (423) 646-7754

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App