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

239 Hargrove
Winterville, GA 30683
Dave Banks with Virtual Properties Realty.com, original listing - (770) 495-5050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $642,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3284 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: 2023
Notes: Welcome to YOUR DREAM HOME that you have been waiting to come back on the Market; so your family can move right in. This beautiful new 2-year-old home is located in highly sought after Oglethorpe County. The home rest on almost 2 acres of one of the premium corner lots of Hargrove Crossing that is located just minutes from downtown Winterville, home of the "Marigold Festival." Also, just a short drive to downtown Athens and the new super Kroger next to the UGA Veterinary School. Beautiful landscaping catches your eye as you walk into the foyer of single level living. This home has 4 bedrooms and 3 baths on the main floor and bonus bedroom above the garage with a half-bath. The kitchen is just a dream come true for the whole family: custom made cabinets surrounds the area with "Lazy Susan" corner cabinets, soft close deep drawers, and drawer-hidden trash can receptacle. The Samsung Stainless Steel appliances are as good as new: oven doubles with an "Air-Fryer" so no need for that bulky fryer on your countertop and has a smooth surface stove. The refrigerator is a 4 drawer: 2 top French door with ice maker and water dispenser for refrigerated items, middle drawer can be a freezer or just for refrigerated item and the bottom is a large freezer. Dishwasher is attached to a beautiful breakfast bar that can hold up to 4 stools for those quick meals or morning breakfast. Counter space in abundance made of custom granite and backslash to match. Great kitchen for entertaining! The great room is home to the dining and living area. The room is large with a back wall of windows and French doors that opens to the screened in porch and open area for barbecuing or just sitting to enjoy a lovely sunset (see pics). The living area boast of beautiful custom beams and true hardwood floors throughout the house. The fireplace is absolutely gorgeous with custom rock hearth that just flows anchors the open concept design of the home. The remote fireplace is electric with a heating fan and sits between built in shelves and custom cabinets waiting for your decorative touch! The home also comes with a pantry that you probably can never fill up and a laundry room that is out of this world. Cabinets all-around, built-in sink, washer and dryer and has direct access to the exterior. Your Families Personal Mudroom! Primary Bedroom Suite is full of natural light for the sitting area that faces out to the beautiful backyard. It also has direct access to the screened in porch. His and Her closets lead to the sauna like bath with his/her vanities, along with a custom tiled over-sized shower. Three other bedrooms and two baths are on the main floor all with custom tile and granite counter tops. There is a 3-car garage attached to the house that has 1 programmable remote for all 3 doors. Outside is a 28x24 detached building that is used as an additional garage but the choice is yours: theater room, family fun room or man cave. Truly a space to express your imagination. Unbelievably low property tax rate, and refreshed price is ready for you! 3rd party Inspection Report available! This home is vacant and ready to move-in!
MlsNumber: --
ListingId: 10441914


Listing Provided By: Virtual Properties Realty.com, original listing
Phone: (770) 495-5050
Office Phone: (770) 495-5050
Agent Name: Dave Banks
Disclaimer: Copyright © 2025 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.


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 = 419 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;
Jen White
ASCIIKeller Williams
Call Today!: (706) 540-9416

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App