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

1018 Blacks Creek
Clayton, GA 30525
Lynda Hester with Compass, original listing - (404) 668-6621

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,995,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Compass
Agency Phone: (404) 668-6621

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 208 acre(s)
Property Type: Land-Unimproved Land
Year Built: --
Notes: Stunning 208-Acre Mountain Retreat with Private Lake, Pond, and 5,000+ Sq Ft Lodge-Style Home Welcome to "Turkey Cove," a rare and extraordinary 208-acre legacy property, rich with history and natural beauty, located just 2 miles east of Highway 441, near the North Carolina and South Carolina borders. Surrounded by the 15,850-acre Warwoman Wildlife Management Area on three sides, this serene estate offers complete privacy while being immersed in the wilderness. The management area is located on land owned by the U.S. Forestry Service, offers hunting opportunities for deer, bear, turkey, and small game, creating a perfect retreat for nature enthusiasts. This exceptional property features a 2-acre private lake and a peaceful half-acre swimming and reflection pond, along with bold streams that crisscross the land and cascade down the mountainsides. Access to the property is through a gated entrance, with a half mile-long paved driveway leading to a stunning lodge-style home, perfectly perched on a hill overlooking the pond. The 5,000+ square-foot home boasts four bedrooms and four and a half baths, offering spacious and comfortable living. In addition to the main home, the property includes a detached four-car garage with ample space for a workshop, riding lawnmowers, and a utility vehicle ('mule'), along with various other practical tools for maintaining this vast estate. A private mini suite with a bedroom and bath is situated over the garage. Historically an apple orchard in the early 1900s, remnants of the original homestead and roadbeds still remain, blending the past with the present. For over 26 years, no hunting has been allowed, allowing the land to flourish with abundant wildlife. The property earned the name "Turkey Cove" due to the numerous wild turkeys that have roamed the area since the early 1900s, and today, the forest continues to teem with wildlife. Surrounded by the beauty of 15,850 acres of protected National Forest, this estate offers a unique opportunity to enjoy unmatched tranquility and the splendor of nature. Turkey Cove is truly a private sanctuary, perfect for outdoor enthusiasts, conservationists, or those seeking a secluded retreat with history, charm, and limitless potential. Legacy properties of this caliber are rarely available. Don't miss your chance to own this extraordinary piece of Georgia's mountain history. Schedule a private tour today to explore everything this remarkable property has to offer.
MlsNumber: --
ListingId: 10407688


Listing Provided By: Compass, original listing
Phone: (404) 668-6621
Office Phone: (404) 668-6621
Agent Name: Lynda Hester
Disclaimer: Copyright © 2024 Georgia 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App