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

159 Crooked River Drive
Woodbine, GA 31569
Nicole Readdick with Coldwell Banker Access Realty, original listing - (912) 882-5450

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3024 Square Feet
Agency: Coldwell Banker Access Realty
Agency Phone: (912) 882-5450

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: STUNNING WATERFRONT PROPERTY WITH 150 +/- FEET OF FRONTAGE ON CROOKED RIVER. THIS HALF ACRE SITE OFFERS INCREDIBLE SUNRISE VIEWS WITH TRUE DEEP WATER. THERE IS A STATIONARY DOCK IN PLACE AND THE WATER FRONTAGE IN COMBINATION WITH THE DEPTH ACCOMMODATES MOST BOATS. THE EXTERIOR INCLUDES A FENCED YARD, WORKSHOP, AND SEVERAL GORGEOUS SHADE TREES. STEP INSIDE TO AN EXPANSIVE KITCHEN EQUIPPED FOR A CHEF: ENJOY AN ABUNDANCE OF CABINETRY AND COUNTER SPACE, A 6-BURNER GAS RANGE, AND A WALK-IN PANTRY. THE EAT-IN KITCHEN INCLUDES AN ISLAND WITH A BREAKFAST BAR OPEN TO THE LIVING AREA. THE FAMILY ROOM FEATURES SEVERAL WINDOWS OVERLOOKING THE WATER THAT ALLOW FOR ADDITIONAL NATURAL LIGHTING. DON'T MISS THE WOOD-BURNING FIREPLACE AND BEAUTIFUL HARDWOOD FLOORS IN THE LIVING AREA. THE UNIQUE ARCHITECTURE OF THIS HOME IS DESIGNED WITH TWO SPACIOUS BEDROOMS AND A SHARED BATH ON EACH WING OF THE HOME- MAKING THIS A FOUR BEDROOM HOME. THE LAUNDRY ROOM ALSO INCLUDES A HALF BATH. THE EXTERIOR CONSTRUCTION IS LOW-MAINTENANCE TABBY AND THE LOT IS FENCED ON THE ROAD AND SIDES OF THE HOME. CONVENIENCE IS KEY- THIS HOME IS LOCATED APPROXIMATELY 700 FEET FROM THE WELL-MAINTAINED HARRIETTS BLUFF PUBLIC BOAT RAMP. ENJOY THE SAVINGS: THIS IS NO FLOOD INSURANCE REQUIRED, NO CITY TAXES, AND NO WATER/SEWER BILL. THIS PROPERTY IS NOT LOCATED IN AN HOA. PRE-APPROVAL OR PROOF OF FUNDS REQUIRED FOR SHOWINGS.
MlsNumber: --
ListingId: 10332001


Listing Provided By: Coldwell Banker Access Realty, original listing
Phone: (912) 882-5450
Office Phone: (912) 882-5450
Agent Name: Nicole Readdick
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.


Local Real Estate Expert

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 = 410 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;
Trevor Long
ASCIIColdwell Banker Access Realty
Call Today!: (912) 266-2206

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App