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

5299 Leo Barber Road
Other, GA 31550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $460,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 3520
Agency: Keller Williams Realty Golden Isles

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential
Year Built: 1979
Notes: Tranquil Country Retreat on Nearly 12 Acres - 3 Bed, 3 Bath Home (1 bedroom with ensuite, office, bonus room, storage room) and Detached Garage/Shop.<br /> <br /> Escape to your own piece of paradise with this meticulously maintained country home nestled on nearly 12 acres of beautifully landscaped grounds. Offering a perfect blend of comfort and luxury, this charming property boasts stunning details inside and out. <br /> <br /> Located at the end of a quiet road, surrounded by approximately 30-year-old pine trees, this property offers unparalleled privacy and tranquility. Enjoy the serenity of rural living while still being within easy reach of nearby amenities.<br /> <br /> This 1.5-story home has a spacious layout and charming sunroom at the entrance of the master bedroom, providing the perfect retreat. <br /> French doors from the sunroom open onto a covered patio, seamlessly connecting indoor and outdoor living spaces.<br /> Luxurious master bedroom with a large ensuite bathroom and a huge walk-in closet.<br /> Top-of-the-line appliances in the well-appointed kitchen, perfect for culinary enthusiasts.<br /> Dedicated office space with multiple cabinets for storage, ideal for remote work or creative endeavors.<br /> Upstairs bonus room offering additional living space and extra storage options.<br /> Detached 28 x 68 garage/shop with a heated and cooled 9 x 23 office/bonus room upstairs, providing endless possibilities for hobbies or professional pursuits.<br /> 40 x 8 outdoor storage area within the shop, offering ample space for equipment and tools.<br /> Move-in ready condition, with meticulous attention to detail throughout the property.
MlsNumber: 1645910


Listing Provided By: Keller Williams Realty Golden Isles, original listing
Name: Keller Williams Realty Golden Isles
Phone: (912) 434-6477
Office Name: Keller Williams Realty Golden Isles
Office Phone: (912) 434-6477
Agent Name: Lindsey Tatum
Disclaimer: Copyright © 2024 Golden Isles Association 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