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

945 Big Cedar Dr
Dunlap, TN 37327

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $515,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2683
Agency: Crye-Leike Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1997
Notes: Beautiful custom built 4 bedroom home in highly desired Old Madison Estates. All homes in this scenic and quiet setting are well maintained in top condition. Professionally landscaped , you'll enter 945 Big Cedar into the hardwood floored foyer with hall closet.. To the left is a dedicated office / study and beyond that are 2 bedrooms and a shared bath. The center of the home has the living room which leads to the climate controlled sunroom, full of light and comfort and beautiful ceramic tile floor. . You can enjoy cook outs on the freshly updated and stained large rear deck from here too. Chef's kitchen will delight with the many upgrades .Theres a breakfast nook to enjoy your morning coffee overlooking the backyard AND a formal dining room too. Owners bedroom suite in the rear has private entrance to the rear deck and features a spacious bathroom with double vanities, separate shower and jetted tub. In the hallway you'll find the laundry room and easy access to the 2 car garage . Through the garage there's a wonderful workshop/ extra storage area. Upstairs there's a 4th bedroom for larger families . Or use it as an exercise room or craft room. The choice is yours. So many updates** here including all new high grade carpeting ( 2022) in all bedrooms and living room. <br /> This gorgeous home is priced RIGHT , so don't delay in scheduling so you can get WOWED yourself.<br /> **** NOTE. <br /> Extra .63 acre adjoining lot is also privately available for purchase <br /> (114M C 004.00)<br /> ** New 30 year Architectural Shingles Roof in 2017<br /> New Package Unit AC/ Gas heat unit for main level in 2016.<br /> New multi zoned heat exchange AC / heat unit for upstairs bedroom and Main Bedroom. in 2019 ( both have separate thermostats.).<br /> 50 gallon water heater with hot water circulator pump.<br /> Low E insulated Windows. <br /> Whole house HEPA air filters.
MlsNumber: 1381192


Listing Provided By: Crye-Leike Realtors, original listing
Name: Crye-Leike Realtors
Phone: (256) 656-8747
Office Name: Crye-Leike, REALTORS
Office Phone: (423) 870-5202
Agent Name: Kevin Wohl
Disclaimer: Copyright © 2024 Greater Chattanooga 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