Title Page Background
DEBUG FN args: Array ( [0] => 455 [1] => [2] => [3] => agent ) BEFORE: Site: 455 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 455 Igate: njhud LocID: 455 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 455 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 455 [1] => [2] => [3] => lender ) BEFORE: Site: 455 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 455 Igate: njhud LocID: 455 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 455 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 455 [1] => [2] => [3] => other ) BEFORE: Site: 455 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 455 Igate: njhud LocID: 455 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 455 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

151 Lewis Road
Cairo, GA 39828
Mary Hoy with Bennett Real Estate Co, original listing - (229) 233-5043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $660,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3643 Square Feet
Agency: Bennett Real Estate Co
Agency Phone: (229) 233-5043

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: This stunning 4-bedroom, 4 bath stone and log home sits on nearly 4 private acres overlooking a shared 6-acre lake, combining rustic elegance with modern upgrades. A circular driveway leads to a spacious 4-car garage and an inviting entrance, where you'll find floor-to-ceiling stonework and a double-sided fireplace with a cypress stone mantle. The great room and dining area feature a wall of windows and soaring 20-foot tongue-and-groove cypress ceilings, flooding the space with natural light and scenic views. The main-level master suite includes a private office overlooking the lake and a luxurious ensuite bath. Each bedroom offers its own full bathroom, including the upstairs rooms which feature pine ceilings, pine floors milled from the property, and large dormers ideal for office or play areas. The oversized kitchen is a chef's dream, with custom hickory cabinetry, a walk-in pantry, floating island, picture windows, and new appliances. The screened back porch is the place to unwind and take in the views. The property also has a screened addition with a bar for hanging out with friends or family and an additional screened area perfect for a hot as well as a screened lakeside area to enjoy the scenery. A versatile loft upstairs makes a great game or lounge area. The detached ~1,800 sq ft 4-bay garage includes a floored storage attic, blown-in insulation and could be future living space. high ceilings and utility sink. Recent updates include a brand-new roof on both home and garage, new sod, sheetrock and paint upstairs, a firepit with swings, water drainage system, water softener on the well, , and night/day window tint that enhances views while ensuring privacy. With a vapor barrier and dehumidifier under the home you can ensure this home is protected. This exceptional property blends craftsmanship, comfort, and lakeside tranquility—offering a one-of-a-kind retreat with room to grow.
MlsNumber: --
ListingId: 925496


Listing Provided By: Bennett Real Estate Co, original listing
Phone: (229) 403-4048
Office Phone: (229) 233-5043
Agent Name: Mary Hoy
Disclaimer: Copyright © 2025 Thomasville Area 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