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

1934 U.s. Hwy 82
Georgetown, GA 39854
Jeanie Tillis with LAKE REAL ESTATE, original listing - (334) 616-7500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2548 Square Feet
Agency: LAKE REAL ESTATE
Agency Phone: (334) 616-7500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: A move-in-ready home at 1934 US Hwy 82, Georgetown, GA! Situated on Approximately 3.9 acres of meticulously landscaped grounds, this residence provides an exceptional blend of rural tranquility and modern luxury. The home, which was completely remodeled in 2013, encompasses 3 bedrooms and 3.5 bathrooms within approximately 2,550 square feet of thoughtfully designed living space. The interior highlights include real wood flooring, custom-built cabinets and built-ins, crown molding, and a fireplace with gas logs (propane). The property is equipped with a triple garage that features an elevator for convenient access to the main level, ensuring ease and accessibility. For those needing ample storage, the 40x78 metal building is ideal. Furthermore, the property boasts an outdoor cookhouse fully equipped with an additional room and bath, a large utility building with garage roll doors, R.V. hook-up, and an irrigation system, catering to a wide range of practical needs and outdoor activities. All appliances are included, with the option to negotiate for the furniture. This remarkable home provides a serene, fully manicured yard perfect for relaxation. Do not miss this opportunity to own a truly exceptional property in a tranquil, rural setting.
MlsNumber: --
ListingId: 27093


Listing Provided By: LAKE REAL ESTATE, original listing
Phone: (334) 750-9800
Office Phone: (334) 616-7500
Agent Name: Jeanie Tillis
Disclaimer: Copyright © 2024 Eufaula Board 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