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

1445 Hillside Drive
Grayson, GA 30017
Susan Mobbs Kliesen with RE/MAX Center, original listing - (770) 932-1234

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 5
Baths: Full: 4, ½: 3
Status: Active
SqFt: 11362 Square Feet
Agency: RE/MAX Center
Agency Phone: (770) 932-1234

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Welcome to this one-of-a-kind home. Combining the timeless traditional southern mansion with modern design aesthetics this home is like a rare jewel in every way. 12.65-acre estate with beautiful trees & emerald zoysia lawn. 11 two-story columns & grand sweeping staircase invite you in. Every room in the home features ornate woodwork from floor to ceiling that was originally imported from Italy. The study/formal salon to the left of the grand foyer and a gorgeous formal dining room to the right. The sunken great room features mahogany bookshelves, and two-story ceilings with gorgeous, stained woodwork. The completely remodeled kitchen is drop-dead gorgeous featuring white cabinetry, top-of-the-line Cambria Quartz counters, pot filler, 64-inch built-in refrigerator/freezer, Wolf double range w/a commercial grade vent hood, microwave & Bosch dishwasher. Huge custom walk-in pantry with a scullery area. The breakfast room will fit a table for 12 and has a built-in buffet. The sunken sunroom has gorgeous views of the yard and the pool. There are two primary bedrooms, one on the main and the larger one upstairs. Both suites feature a fireplace and newly renovated white marble bathrooms that are jaw-dropping. There is an elevator off the kitchen that takes you to all three floors. The laundry room is filled with tons of custom cabinets, a sink, a built-in mud area for coats & shoes, and space for an extra refrigerator. The secondary bedrooms feature large closets and adjoining bathrooms. Above the secondary bedrooms is a third-floor loft space that would make a great hobby or playroom. Hardwood floors throughout the home except for two closets & tile in the kitchen & laundry. There is an apartment for a housekeeper that features a full kitchen, family room, bedroom, and bathroom. The basement is finished with a half bath. There are two half baths on the main level. The 20x40 heated saltwater pool with a waterfall and hidden stone grotto. There is a sunken pavilion that has a fireplace, outdoor kitchen, & swim-up bar. Custom closets in every room. 16 Total Garage Spaces. 3-car oversized garage attached, 1-car boat door in the basement and there are floor drains in the basement and one of the previous owners would pull multiple cars into the basement and wash all their cars. The 60 x40 detached building or workshop can house 10-12 cars very easily. The building has electricity, heat & water and is stubbed for a bath. 3 water heaters. 6 HVAC Units. 5 Gas Fireplaces indoors and 1 electric fireplace at the pavilion. Roof is only 4 years old. Over $1,000,000 spent in renovations to bring this home to the showplace it is today. Seller is a licensed agent in the state of Georgia. Appointment Only.
MlsNumber: --
ListingId: 7513843


Listing Provided By: RE/MAX Center, original listing
Phone: (404) 510-1988
Office Phone: (770) 932-1234
Agent Name: Susan Mobbs Kliesen
Disclaimer: Copyright © 2025 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 = 3413 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 Curtis Miles
Curtis Miles
ASCIIKW Atlanta Partners
Call Today!: (706) 442-3892

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App