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

4005 Highfield Drive
Grovetown, GA 30813
Anne Turner with WEICHERT REALTORS-CORNERSTONE, original listing - (706) 364-4234

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,900
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 3457 Square Feet
Agency: WEICHERT REALTORS-CORNERSTONE
Agency Phone: (706) 364-4234

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Welcome to this stunning move in ready home nestled on 1.77 acres in the coveted Anderson Farms community. The Sycamore Plan by First Choice Home Builders is designed with sophistication and functionality showcased by a two-story great room, enhanced moldings, and an open layout perfect for hosting and entertaining.<br /> <br /> The gourmet kitchen is a chef's dream, featuring a Thor gas range, a farmhouse sink, and a custom vent hood. With its expansive island, granite countertops, and walk-in pantry, this kitchen combines style and convenience. The adjacent family room shines with coffered ceilings, a gas fireplace, and custom-built cabinetry, creating an inviting living space.<br /> <br /> The main-level primary suite serves as a private retreat, luxurious en-suite bathroom with a large tiled shower and glass enclosure, garden tub, and a spacious closet with custom wood shelving, conveniently connecting to the laundry room. An additional bedroom and full bath on the main level provide flexibility for guests or a home office.<br /> <br /> Upstairs, discover 3 additional bedrooms, including one with a private bath and two sharing a Jack & Jill bathroom. A spacious loft offers space for relaxation or entertainment. Additionally, the home includes over 200 square feet of floored attic storage, providing extra room for your storage needs.<br /> <br /> Other exceptional features include hardwood flooring throughout the main living areas, Lutron blinds and plantation shutters, a tankless water heater, and a 12x19 covered back porch which is perfect for outdoor gatherings. The fully landscaped yard, equipped with a sprinkler system, enhances the home's curb appeal, while the storage shed and privacy fence offer practicality and seclusion.<br /> <br /> Seize the opportunity to own this exceptional home, offering a perfect blend of luxury, comfort, and meticulous design.
MlsNumber: --
ListingId: 534779


Listing Provided By: WEICHERT REALTORS-CORNERSTONE, original listing
Phone: (706) 250-1517
Office Phone: (706) 364-4234
Agent Name: Anne Turner
Disclaimer: Copyright © 2024 Greater Augusta 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