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

8502 Highway 19 S
Thomaston, GA 30286

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 1
Baths: 2
Status: Active
SqFt: --
Agency: RE/MAX Around Atlanta

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2005
Notes: THIS PROPERTY IN UPSON COUNTY MAILING ADDRESS CULLODEN 12 MILES FROM THOMASTON ---Hard to find River Retreat with approx 262 feet of river frontage with approx 3 secluded acres close to main roads. As you enter through gate you wind up circular drive and enter a private paradise with a fully furnished renovated cottage. Large spacious rooms give the feel of being removed from all of daily grinds. Large master features renovated open bath with tiled shower. Oversized great room and kitchen are complimented by cypress paneling, lots of light, and cozy fireplace. A second full bath for overnight guest or additional family members. Two pantries great for storage. Perfect screened porch with additional fireplace with antique mantel allows entry from rear and front of property. Just outside this porch is a customized firepit for smores !! Returning to great room exit onto deck that covers entire width of rear of cottage and overlooks river frontage plus sit on the raised observation portion. Cottage has gutters with leaf guards and outside lighting, Enjoy fresh air as wood ducks, beaver, mink, hawks, deer, wild turkey and an occasional bald eagle to name a few pass by as a peaceful feeling watching the river slowly pass settles in. Plenty of outside storage with building. Fiber optics is now installed. Room for horseshoes and unlimited games to play. Landscaping although relatively new affords low maintenance and features many native plants. There is plenty of room to add on if needed. This section of the flint river is private, secluded and under developed giving a natural feel. Macon, Butler, Columbus, Thomaston, Griffin are all close by to visit festivals or enjoy dinner out. 1,200 acre hunting club is within 5 miles of property. A boat ramp is minutes away. This is a place to get away from it all - to recharge yourself. Share with family and friends or use as a corporate retreat, or rental for clients looking for a getaway.300 year old fish weir close by. Property goes to center of river.
MlsNumber: 10256180


Listing Provided By: RE/MAX Around Atlanta, original listing
Name: RE/MAX Around Atlanta
Phone: (404) 252-7500
Office Name: RE/MAX Around Atlanta
Office Phone: (770) 350-7373
Agent Name: Terre Slaughter
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