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 = 729 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 729 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 729 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

1652 Thomas Drive
Hoschton, GA 30548

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 5
Baths: 6
Status: Active
SqFt: 4340
Agency: Atlanta Partners Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2018
Notes: Your dream home awaits nestled on a sprawling 5-acre parcel of tranquility. This 4-sided brick, 7000+ square feet potential (~$178/sq ft, fully finished!), exceptional estate boasts the timeless charm of a traditional craftsman home combined with modern finishes and conveniences. Privately tucked away, with a serene pond, a SIX car garage, two of which is detached with an unfinished apartment space with roughed-in electrical and plumbing above. This home has truly too many special features to list! (MUST SEE the full upgrades/special features list!) As you approach the welcoming entry, you're greeted by the grandeur of double alderwood and wrought iron doors and soaring ceilings in the foyer, setting the tone for the spacious elegance with 8' doors and 10'+ ceilings that lies within. The rustic yet modern aesthetic creates a cozy atmosphere drawing you further inside. The gourmet kitchen is an absolute, culinary dream - featuring a large island, abundance of custom and functional cabinetry, Calcutta quartz and leathered granite counters, and a sizable walk-in pantry, this space is designed for both culinary creativity and social gatherings, with an open view to the living room highlighted by a beautiful, oversized mantle and accent wall, tiled fireplace, beamed ceilings, numerous windows, and spacious and open formal dining room detailed with multiple chandeliers and judges paneling. The large primary suite, complete with a gorgeous ensuite, boasts a stunning, oversized shower and a freestanding soaking tub, custom his and her vanities, with an expansive closet includes ample wardrobe storage space, additional laundry hookups and a vanity makeup area. The main level also uniquely includes an additional guest suite on the main level, adding versatility of this home, along with the well-appointed upper level bedrooms, laundry room, storage closets throughout, and loft area. This home is a car enthusiast's dream with a four-car attached garage to the main dwelling, equipped with a level two electric vehicle wall charger, along with the additional detached two-car garage. The vast basement space offers endless possibilities - partially finished with a bathroom and an office space, pre-plumbed for a kitchen and bar, additional bedrooms and pre-wired for a theater room! Embrace the outdoors on the private 5 acres, which features a stocked pond, providing countless hours of relaxation and recreation. The backyard beckons for a future pool to be added, making it the ultimate retreat. Many many other special features and upgrades include: built in security system and pre-wired for camera system, whole house audio system, central vac system, custom spice and utensil cabinets, custom wooden mudroom and bench, pantry ice maker and water line access, 12x25 safe room/vault in basement and so much more! Conveniently located just off Hwy 211, this property provides easy access to I-85, and it's only 10-15 minutes away from the Chateau Elan Winery & Resort, medical offices, multiple golf courses, dining, downtown Braselton, Hoschton areas, and numerous other local conveniences. Don't miss the opportunity to make this beautifully and thoughtfully designed craftsman home your very own and experience the perfect fusion of traditional craftsmanship, modern luxury, and serene natural surroundings.
MlsNumber: 10248061


Listing Provided By: Atlanta Partners Realty LLC, original listing
Name: Atlanta Partners Realty LLC
Phone: (678) 775-2600
Office Name: Keller Williams Realty Atl. Partners
Office Phone: (678) 775-2600
Agent Name: Sandy Baker
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App