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

552 New Salem Common Nw
Marietta, GA 30064

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,600,000
Beds: 6
Baths: 7
Status: Active
SqFt: 10103
Agency: Atlanta Fine Homes Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2017
Notes: Experience absolute perfection! Nestled on an immensely private 1 +/-acre lot bordering the Kennesaw Mountain National Battlefield, this exquisite custom-manufactured "Alaska White" four-sides brick home is a modern masterpiece which impresses with every turn. Enter through the custom iron and glass double doors into the two-story foyer with a circular iron staircase which offers a sightline of the luxuriously landscaped backyard with elegant, heated saltwater pool, and outdoor living areas including a stacked stone fireplace, custom built privacy stone amphitheater, and a state-of-the-art surround sound system. Experience the best in entertaining guests and private relaxation with main level walkout to the pool with its sprawling covered terrace, covering the expansive length of the back of the home. The interior of the home impresses with its light-filled rooms and soaring ceiling heights, including a custom-designed, LCD-lighted barrel-vaulted ceiling covering the expanse of the second floor, intricate molding, designer lighting throughout the home, elegantly designed tile finishes in all bath spaces and an elaborate full-home automation system. Warm hardwoods flow seamlessly with boasting light entering through the floor-to-ceiling windows. Providing an intimate space for everyday living and entertaining, the high-end modern kitchen offers sleek cabinetry, integrated appliances and quartz countertops with subtle veining. Open to an intimate but large family room space, living room and dining room, the main level offers the perfect blend for casual living and large gatherings. The main level owner's suite is stunning elegance with its coffered, beamed ceiling, spa-inspired oversized bathroom with separate vanities, free-standing spa tub adjacent to a floor-to-ceiling stone wall, and an enviable oversized walk-in shower. The oversized closet with designer finishes, custom built-in's along with an island dressing area is impressive. The owner's suite private exit through the double doors is the perfect escape for relaxing by the fireplace and poolside. On the opposite wing of the home, a spacious guest suite, separate powder room and gym complete the main level. The second level en suite bedrooms are oversized, with custom ceiling features, en suite baths, including one with a steam shower; all with custom closet systems. Experience the highly custom theater with its star-light system and state-of-art surround system. Additional features include the climate-controlled garage which is perfect for the car enthusiast, spray foam insulation throughout and an infrared exterior home security system. Enjoy proximity to the Marietta Square, Wellstar Kennestone Hospital, an array of excellent schools, Kennesaw State University and McCollum Field International Airport. Your new lifestyle and vacation resort awaits! Broker Bonus of $15k. Valid for one month.
MlsNumber: 7290400


Listing Provided By: Atlanta Fine Homes Sotheby's International Realty, original listing
Name: Atlanta Fine Homes Sotheby's International Realty
Phone: (404) 835-9601
Office Name: Atlanta Fine Homes Sotheby's International
Office Phone: (770) 604-1000
Agent Name: Pamela Elledge
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 = 3410 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 Casey Sears
Casey Sears
ASCIICentury 21 Connect Realty
Call Today!: (678) 231-4516

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App