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

1 Jacks Bluff Road
Townsend, GA 31331
Susan Moody with Darien River Realty, original listing - (912) 270-2962

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Darien River Realty
Agency Phone: (912) 270-2962

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 100 acre(s)
Property Type: Land-Other
Year Built: --
Notes: ATTENTION DEVELOPERS!!! GREAT OPPORTUNITY!!! LOCATION! LOCATION! LOCATION!<br /> IN THE HEART OF BEAUTIFUL McIntosh COUNTY SITS 100 ACRES JUST WAITING TO BE DEVELOPED! PHASE 2 OF JACKS BLUFF IS WAITING ON YOU! SOME OF THE GROUD WORK HAS ALREADY BEEN DONE. SOME OF THESE IMPROVEMENTS INCLUDES EXISTING SITE PLANS, GUTTERS, DRAINAGE SYSTEM, STORM PIPE, WATER RETENTION POND, CLEARED ROADS AND RIGHT OF WAYS AND A PRIVATE WELL SYSTEM. <br /> JUST A SHORT DRIVE TO GREAT SEAFOOD RESTAURANTS, SHOPPING, FISHING, BOATING (LOCAL BOAT RAMPS), GOLFING, HARRIS NECK NATIONAL WILD LIFE REFUGE AND SO MUCH MORE THAT McIntosh COUNTY HAS TO OFFER. ABOUT AND HOUR DRIVE NORTH TO SAVANNA AND ABOUT AN HOUR DRIVE SOUTH TO JACKSONVILLE, FL.<br /> CALL FOR A SHOWING, MORE INFORMATION AND TO SEE SITE PLANS...<br /> <br /> Note: Pics are of phase 1. Pics of phase 2 coming soon.
MlsNumber: --
ListingId: 1646956


Listing Provided By: Darien River Realty, original listing
Phone: (912) 270-2962
Office Phone: (912) 270-2962
Agent Name: Susan Moody
Disclaimer: Copyright © 2024 Golden Isles 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