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

1680 Thomas Drive
Hoschton, GA 30548

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 5
Baths: 5
Status: Active
SqFt: 4300
Agency: Sun Realty Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2023
Notes: Elegant and inviting, this modern contemporary farmhouse is situated on 1.84 acres of lush land, fully fenced with a privacy gate that welcomes you into your own private sanctuary. As you enter through the two-story grand entryway, you are immediately captivated by the open concept design that seamlessly blends functionality with style. The main floor boasts a luxurious primary suite adorned with timeless finishes in the en-suite bathroom, featuring a soaking tub, an oversized frameless shower and sizeable closet that conveniently connects to the mudroom and laundry. Additionally, you will find 3 bedrooms on the main floor accompanied by 2 full bathrooms and 1 half bath. The gourmet chef's kitchen equipped with top-of-the-line stainless steel KitchenAid appliances, quartz countertops, and custom cabinetry. The oversized kitchen island serves as both a focal point and gathering place as it overlooks the stunning living room adorned with beamed ceilings and custom built-ins with fireplace. A wet bar adds an element of sophistication while the 15-foot glass door beckons you to step outside onto the expansive back covered patio complete with an outdoor fireplace and your own personal oasis within the private backyard offering plenty of room for a future pool with irrigation. Upstairs this home offers an additional bedroom, full bathroom, loft with great office area and an oversized second living room with coffered ceilings, built-ins and fireplace. This home offers beautiful white oak true hardwoods throughout, custom European windows, central vacuum system, tankless hot water heater, spray foam insulation, 3 car garage with epoxied floors and dog shower. This home is conveniently located near restaurants, shops, Mall of Georgia, Gwinnett Exchange with quick convent access to highway 85 and highway 985 and HWY 124.
MlsNumber: 7324333


Listing Provided By: Sun Realty Group, LLC, original listing
Name: Sun Realty Group, LLC
Phone: (770) 318-7973
Office Name: Sun Realty Group, LLC.
Office Phone: (404) 410-0035
Agent Name: Cyrena Harrington
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 = 469 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 Scott Lacy
Scott Lacy
ASCIIPend Realty, LLC
Call Today!: (770) 722-5129

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App