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

1120 Heards Ferry Road
Sandy Springs, GA 30328

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active Under Contract
SqFt: 5000 Square Feet
Agency: Keller Williams Rlty First Atl
Agency Phone: (404) 531-5700

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Refrigerator, Oven - Double
Architectural Style: New Traditional
Construction Materials: Brick
Cooling: Ceiling Fan(s)
Flooring: Carpet, Tile, Hardwood
Heating: Forced Air
Interior Features: Walk-in Closet(s), In-law Floorplan, Bookcases, Double Vanity, Master On Main Level
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5

Window Features

Exterior Features: Gas Grill
Parking Features: Garage
Roof: Composition

Neighborhood/Schools

Elementary School/District: Heards Ferry
Middle/Junior High School/District: /Visalia Schools
High School/District: Riverwood
Subvidision Name: Sandy Springs

Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: Here is a once in a lifetime opportunity to own 2+ acres estate with a gated entrance. This home has been meticulously maintained and has a lot of added features located near the number one public school and one of the top three private schools in Georgia. The grounds are adorned with many statues and fountains promoting an exceptional view from many rooms. Pavers and bricks break up the concrete drive making the approach stately. In addition, there is a separate guest house with a three car garage for the auto enthusiast (total 5 car garage). The finest interior finishes including exquisite molding complement the spacious layout. The two story foyer welcomes guests with marble floors metal custom stair spindles, and hardwood stair treads. The main level has nine foot ceilings. There is a formal living room with a fireplace with dark walnut hardwoods underneath carpet.. The dining room has full length mirrors, an antique chandelier and marble floors. The den has judges paneling and a fireplace. Pass through the the solarium with and antique fountain. The huge media room It has surround sound system, custom liquor cabinet refrigerator, sink, wine storage, and glass shelving. The Paladian windows also have custom screens to raise or lower and a retractable awning. Notice the patio with a built in grill and room for outside furniture. A wet bar and guest bath can be seen on the way through to the kitchen and breakfast room. The kitchen has all new white cabinets, new tile backsplash, porcelain floors, and stainless steel appliances, included with the stove is a built-in steamer, and built-in refrigerator and desk. A breakfast area and sun room graces the main floor as well. There is also a second master bedroom and bathroom suite with two walk in closets. Upstairs are three more bedrooms including the main master bedroom with a large custom lighted double trey ceiling, custom new walk-in closet area , large bathroom suite with double vanities, separate shower toilet area and Jacuzzi tub in the center closed off with bi-fold doors, and has lots of light from two large windows looking out into the trees. The completely finished terrace level comes complete with outside entrance with a covered sitting area, a bedroom turned office, and a bathroom. This area faces a built in bar with refrigerator, tv and speakers. Anyone up for a game of pool. Speaking of safes there are 2 hidden safes in the house, and three fire places. All the windows in the estate were recently replaced with double pained windows.
MlsNumber: --
ListingId: 10224136


Listing Provided By: Keller Williams Rlty First Atl, original listing
Phone: (404) 531-5700
Office Phone: (404) 531-5700
Agent Name: Deborah Harris Race
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.


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 = 2222 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 Joel Dunham
Joel Dunham
ASCIIWindermere Real Estate
Call Today!: (971) 221-3482

Local Mortgage Pro

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 = 2222 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 Torianna Quinn NMLS#1493398
Torianna Quinn NMLS#1493398
ASCIIPrimary Residential Mortgage, Services Oregon and Washington
Main: (541) 207-2150

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App