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

899 R Folsom Road
Adel, GA 31620
Joey Schramm with Southern Classic Realtors, original listing - (678) 635-8877

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Pending
SqFt: 2662 Square Feet
Agency: Southern Classic Realtors
Agency Phone: (678) 635-8877

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Nestled on a private 7.81 acres, this stunning modern lodge feel home is designed to harmonize with its breathtaking natural surroundings. As you step inside, you are greeted by the large foyer opening to soaring high ceilings that create an open and airy atmosphere. You will notice the abundance of natural light streaming all throughout! The heart of the home features a beautiful kitchen equipped with custom cabinets and top-of-the-line appliances, flowing seamlessly into the dining area, living room, and the sunroom. The charming sunroom is the perfect place for unwinding with a good book and coffee. The primary suite is a retreat within itself featuring the perfect accent wall, oversized windows, his and hers closets and vanities, a tiled shower, soaking tub, and easy access to the laundry room for your convenience. On the second story, the loft serves as the perfect place for a home office, play area, or hang-out spot, overlooking the downstairs living room. The two upstair suites offer a private escape, each with its own full bathroom and spacious walk-in closets. If all that is not enough, outback you have a 30x50 heated workshop with a 20x50 lean-to. This spacious area features an expansive ground floor ideal for various projects from woodworking to crafting or even as a garage for your hobbies. The high ceilings provide ample space for storage as well as an upstairs area for an additional storage space or office area. This property has it all! Experience the beauty of nature in this gorgeous lodge where everyday feels like a getaway.
MlsNumber: --
ListingId: 143586


Listing Provided By: Southern Classic Realtors, original listing
Phone: (229) 560-1199
Office Phone: (678) 635-8877
Agent Name: Joey Schramm
Disclaimer: Copyright © 2025 South Georgia MLS (Valdosta). 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