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

120 Hummingbird Way
Copperhill, TN 37317

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $579,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1564
Agency: Mountain Place Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2023
Notes: Nestled within the serene confines of a gated community, this stunning new home offers the epitome of luxury living amidst nature's splendors. Situated on a wooded lot, the residence boasts mountain views with some tree trimming. The home exudes a sense of spaciousness and elegance from the moment you step inside. The heart of the home, the kitchen, is a culinary enthusiast's dream, featuring a sleek island adorned with quartz countertops. Custom tile showers in the bathrooms add a touch of sophistication and individuality, elevating daily routines into indulgent rituals. Throughout the home, attention to detail is paramount, with wood trim accents lending a timeless charm to every corner. Hardwood floors grace each room, providing a seamless flow and inviting ambiance. The construction showcases quality craftsmanship, with 2x6 walls boasting foam insulation for optimal energy efficiency and comfort. Practicality meets luxury in the laundry/mudroom, where a stacked washer and dryer streamline chore. While a Kraus sink and Moen faucets add a touch of elegance to everyday tasks in the kitchen. Hot water at your call with a tankless heater. Pella windows flood the interiors with natural light, offering panoramic views of the picturesque surroundings and further enhancing the connection to the outdoors. Beyond its aesthetic appeal, this home is designed for longevity and sustainability, with an encapsulated crawl space ensuring a dry and healthy foundation for years to come. Every element has been thoughtfully chosen to create a haven of comfort, convenience, and beauty—a place where modern living harmonizes with the tranquility of nature. Detached garage is being finished out with electrical and garage doors.
MlsNumber: 20241852


Listing Provided By: Mountain Place Realty, LLC, original listing
Name: Mountain Place Realty, LLC
Phone: (706) 946-1520
Office Name: Mountain Place Realty, LLC
Office Phone: (706) 946-1520
Agent Name: Bill Banzhaf
Disclaimer: Copyright © 2024 River Counties 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