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;

1806 Grassy Creek Road
Copperhill, TN 37317

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,900
Beds: 4
Baths: 4
Status: Active
SqFt: 3087
Agency: Country Corners Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2022
Notes: ~Contemporary Mountain Living w/ deeded Ocoee River access~ Escape to this stunning 4BR, 4BA contemporary mountain retreat nestled on 3 acres of picturesque acreage w/ common deeded river access on the tranquil Ocoee River. Common river front lot features new pavilion & steps into the river just a stone's throw away. Enjoy fishing, tubing or just relaxing in the sun - this river frontage offers you your own private "island" to enjoy. Emmerse yourself in the natural beauty that surrounds it as you take in breathtaking river views below from inside your own living room. Open floor plan w/ upgrades galore. Great Rm features modern gas log FP w/ a "wall of glass" creating a cozy & inviting atmosphere. Soaring cathedral ceilings throughout providing an abundance of natural light & showcasing the stunning river and acreage below. The chef's kitchen is a culinary enthusiast's dream, featuring custom cabinetry, upgraded appliances, and elegant marble countertops. Fin. basement offers a spacious recreation rm/media rm complete with a wet bar, perfect for entertaining guests opening onto terrace level patio where you can relax in the hot tub and admire the meticulously landscaped yard. As you approach the property, you'll be greeted by a private driveway with a gated fenced in driveway to this contemporary estate that sets the tone for the luxury that awaits. The low-maintenance exterior, featuring concrete siding and metal porch posts with cable railings, ensures that your time is spent enjoying the serene surroundings rather than on upkeep. This property offers an abundance of outdoor living areas, including a wrap-around deck on the main level with an outdoor sectional sofa and gas firepit, providing the perfect space for al fresco dining and lounging. Nice level usable yard is a great place to enjoy "the great outdoors". Located approx. 15 minutes to downtown Blue Ridge & minutes to Copperhill, TN & Murphy, NC. Experience the epitome mountain living.
MlsNumber: 404352


Listing Provided By: Country Corners Realty LLC, original listing
Name: Country Corners Realty LLC
Phone: (706) 964-6470
Office Name: Country Corners Realty
Office Phone: (706) 964-6470
Agent Name: Nathan Fitts
Disclaimer: Copyright © 2024 Northeast Georgia Board 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