Title Page Background
DEBUG FN args: Array ( [0] => 469 [1] => [2] => [3] => agent ) BEFORE: Site: 469 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 469 Igate: njhud LocID: 469 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 469 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 469 [1] => [2] => [3] => lender ) BEFORE: Site: 469 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 469 Igate: njhud LocID: 469 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 469 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 469 [1] => [2] => [3] => other ) BEFORE: Site: 469 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 469 Igate: njhud LocID: 469 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 469 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4630 Sierra Creek Drive
Hoschton, GA 30548

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $689,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 4716 Square Feet
Agency: Winfield Realty Group, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: Welcome home to this stunning residence nestled in the desirable Sierra Creek community! This meticulously maintained home boasts ample space for living and entertaining with elegant touches throughout. The main living area features woodwork details, including coffered ceilings and built-in bookcases enhancing the main living area's charm. The open-concept kitchen is a chef's dream with bright white cabinets, granite countertops, a spacious island perfect for entertaining and a walk-in pantry for even more storage. The main level also has a formal dining room, as well as a bedroom and full bathroom.<br /> <br /> Upstairs, you’ll find an oversized primary suite, complete with a luxurious spa-like bathroom featuring double vanities, a walk-in shower, and a soaking tub. Upstairs there are three additional bedrooms with spacious closets, offering a generous amount of storage, and an additional great room ensuring there's plenty of room for everyone.<br /> <br /> Embrace the potential of the (approx) 1,300 square foot partially finished basement awaiting your personal touch. Step into the main living area with 10’ 8" ceilings and tons of natural light. Adjacent, discover a large bedroom and bathroom, functional with shower/tub, toilet, and vanity. The unfinished bonus workshop area is also great for additional storage, if you’re a hobbyist, or DIY enthusiast. With finished light fixtures, plumbing, and ready-to-paint walls, this basement space is ready for your customization for guests or as a private retreat.<br /> <br /> Step outside to your own private oasis, complete with a fenced in yard, and a deck spanning the length of the home, with a partially covered back patio, ideal for outdoor relaxation and gatherings. <br /> <br /> This home is located in the highly-rated Gwinnett County School system, near Mulberry Park, the Mall of Georgia, The Exchange, Coolray Field, and Northeast Georgia Medical Center; you'll enjoy easy access to healthcare, shopping, dining, and entertainment options. Plus, enjoy Sierra Creek community amenities, including a pool, tennis courts, clubhouse, and playground.<br /> <br /> This home offers the perfect blend of luxury and convenience. Don't miss out on the opportunity to make this exceptional residence your forever home!
MlsNumber: --


Listing Provided By: Winfield Realty Group, Inc., original listing
Phone: (770) 380-4880
Office Phone: (678) 430-3600
Agent Name: Grace Theus
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => jackson-county [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: jackson-county State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: jackson-county State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 469 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jim Savadelis
ASCIIThe Hartwell Team at Keller Williams Realty Atlanta Partners
Call Today!: (678) 232-5879

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App