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

52 Olivia Court
Palmetto, GA 30268
Shon Griffin with Virtual Properties Realty.com, original listing - (770) 495-5050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $630,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4472 Square Feet
Agency: Virtual Properties Realty.com
Agency Phone: (770) 495-5050

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Discover the ultimate blend of serenity and convenience in this stunning 4-bedroom, 3.5-bath, terraced, haven. Surrounded by natural beauty & nestled in the picturesque Palmetto area, yet mere minutes from innovative hubs and attractions.<br /> You will step inside to a well-designed & beautifully functional layout - with the 2-story foyer making a stunning first impression! Then come the dual staircases, providing effortless access to the upper levels, from anywhere in the home. At the heart of the home is the open-concept kitchen overlooking the 2 story family room. The kitchen boasts granite countertops and ample cabinetry for your culinary creativity. This open concept allows for familiar interaction while watching your favorite show & cooking your favorite dinners. <br /> The combination dining room & living room are perfectly situated for formal gatherings. Gorgeous hardwood floors are scattered throughout the main level, along with the 4th guest bedroom. <br /> Boasting impeccable curb appeal, this beautifully landscaped property seamlessly blends indoor and outdoor living but the pièce de résistance is the breathtaking backyard oasis!<br /> Transition to your outdoor experience beginning with your 1st cup of Java on the expansive screened-in porch, where high-performance composite TREX decking leads you down to the patio and garden area- where you may likely end the evening with your last glass of wine. Once there, you’ll find 2 charming fire pit areas -pergolas included- irrigation for the garden & flower beds -a charming outdoor shed with electricity - and a gentle creek that babbles and winds its way at the back of the property. The possibilities for outdoor living and creativity are endless.<br /> <br /> The perfectly finished basement, complete with dual ventilation systems, is a haven for hobbyists and entertainers alike, featuring a full-size workshop, a pool table/ gathering area, providing ample entertainment space for family movie nights or game nights<br /> <br /> You are just around the corner from Hubs and attractions! <br /> - 5 miles from Serenbe's thriving community, offering artisanal living, farm-to-table cuisine, and cultural events<br /> - 15 miles from Trilith, a futuristic town center, and the newly announced international soccer training facility<br /> - 12 miles to Peachtree City, with its scenic paths, golf courses, and charming downtown<br /> - 23 miles from Hartsfield-Jackson Atlanta International Airport, connecting you to global destinations<br /> <br /> Additional highlights include excellent school systems, providing peace of mind for families. The home’s electrical boxes have their own surge protectors, safeguarding your home's electrical systems<br /> Recent updates (2019-2024) include a new roof, a freshly painted exterior, a new water heater, stainless kitchen appliances, and newly painted deck, arbor & gutter guards.
MlsNumber: --
ListingId: 7456213


Listing Provided By: Virtual Properties Realty.com, original listing
Phone: (678) 997-0090
Office Phone: (770) 495-5050
Agent Name: Shon Griffin
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3403 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;
Real Estate Expert Photo for Linda Toppin
Linda Toppin
ASCIICTI Real Estate 415 Wolfe st. Fredericksburg VA, 22401 Dowtin Realty 1995 North ParkPlace SE, Atlanta. 30339
Call Today!: (540) 226-2045

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App