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

0 Metts - Overstreet Road
Bristol, GA 31518
Ryker Carter with Keller Williams Golden Isles, original listing - (912) 434-6477

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $412,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Keller Williams Golden Isles
Agency Phone: (912) 434-6477

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 125 acre(s)
Property Type: Land-Agriculture
Year Built: --
Notes: Escape to nature's embrace with this remarkable 125-acre property nestled along the picturesque Metts-Overstreet Road in Appling County, GA. Boasting nearly one mile of frontage along the waters of the Big Satilla Creek, this estate offers the perfect blend of serenity and adventure for outdoor enthusiasts and aspiring homeowners alike. A potential haven for your dream home, this property presents an idyllic setting for creating lasting memories amidst Georgia's natural beauty. With approximately 17 acres of thriving 3-year-old loblolly pines providing privacy from Metts Road, enjoy the tranquility of your private oasis while being surrounded by the sights and sounds of the forest. The pristine hardwood forest, adorned with majestic hardwoods and mixed pine timber, serves as an exceptional hunting ground and sanctuary for wildlife. Whether you're an avid hunter or nature enthusiast, the abundance of deer, turkey, and ducks offers endless opportunities for outdoor adventure and exploration. Immerse yourself in the tranquility of the Big Satilla Creek, where you can create your own access for leisurely fishing, birdwatching, or simply enjoying the sights and sounds of nature's symphony. Located just 90 miles from Jacksonville, FL, this property provides the perfect escape from the hustle and bustle of city life-a true sanctuary where you can unwind, recharge, and connect with the great outdoors.
MlsNumber: --
ListingId: 10278705


Listing Provided By: Keller Williams Golden Isles, original listing
Phone: (912) 434-6477
Office Phone: (912) 434-6477
Agent Name: Ryker Carter
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