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 = 454 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 454 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 454 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

600 Plainville Road Sw
Plainville, GA 30733

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,900
Beds: 3
Baths: 2
Status: Active
SqFt: --
Agency: Keller Williams Realty Signature Partners

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 43 acre(s)
Property Type: Residential
Year Built: 2019
Notes: Welcome to your own private oasis! Nestled on 43 acres of pristine land, this stunning property boasts a natural spring-fed pond stocked with fish, offering tranquil views and endless opportunities for relaxation and recreation. As you explore the grounds, you'll be captivated by the beauty of the ridge that graces the landscape, providing breathtaking panoramic views of the surrounding countryside. Imagine enjoying picturesque sunsets or stargazing from this elevated vantage point. Nature enthusiasts will appreciate the all-year-round stream of water meandering through the property, creating a soothing ambiance and supporting a diverse ecosystem. Whether you're an avid angler, hiker, or simply enjoy the serenity of the outdoors, this property offers something for everyone. Privacy is paramount on this expansive estate, offering a secluded retreat away from the hustle and bustle of city life. With a mix of open pastureland and dense mixed woods, you'll have ample space to roam and explore the natural beauty that surrounds you. For those dreaming of building their dream home, the possibilities are endless. With a Perc Test on file and multiple building sites to choose from, including the coveted ridge location, you can design a custom residence perfectly tailored to your preferences and lifestyle. Don't miss out on the opportunity to own this exceptional property where every day feels like a getaway. Experience the best of country living with modern comforts and natural wonders at your doorstep. Welcome home to your own slice of paradise!
MlsNumber: 10289265


Listing Provided By: Keller Williams Realty Signature Partners, original listing
Name: Keller Williams Realty Signature Partners
Phone: (404) 680-1228
Office Name: KW Signature Partners
Office Phone: (678) 631-1700
Agent Name: Wilfredo Barrera Guardado
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