Title Page Background
DEBUG FN args: Array ( [0] => 423 [1] => [2] => [3] => agent ) BEFORE: Site: 423 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 423 Igate: njhud LocID: 423 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 423 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 423 [1] => [2] => [3] => lender ) BEFORE: Site: 423 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 423 Igate: njhud LocID: 423 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 423 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 423 [1] => [2] => [3] => other ) BEFORE: Site: 423 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 423 Igate: njhud LocID: 423 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 423 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

575 Indian Hills Parkway
Marietta, GA 30068
Ken Adcox with NorthGroup Real Estate, original listing - (404) 383-6616

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,950,000
Beds: 8
Baths: Full: 8, ½: 2
Status: Active
SqFt: 10262 Square Feet
Agency: NorthGroup Real Estate
Agency Phone: (404) 383-6616

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: ADDITIONAL PHOTOS, VIDEO AND FLOOR PLAN ARE COMING SOON! Homes like this don’t go on the market very often. This custom-built Capital Design Homes resale is the pinnacle of luxury living in Indian Hills—a golf course community renowned for its elegance, charm, and location. Every inch of this transitional-style masterpiece was thoughtfully designed, from its flowing floor plan to the designer finishes found throughout.<br /> <br /> Step through the stunning glass and metal double doors into a light-flooded, two-story foyer where 12-foot ceilings and oversized Pella windows immediately impress. To your left, a breathtaking three-story floating staircase makes a bold statement, while just beyond, the expansive dining room wows with high-end lighting and more glass-and-metal doors.<br /> <br /> An entertainer’s dream, the home features a fully outfitted butler’s pantry and passthrough to a hidden scullery kitchen, which connects seamlessly to the chef’s kitchen. Custom cabinetry, open shelving, premium appliances, and striking lighting elevate every culinary experience. Nearby are the well-appointed mudroom, half bath, and access to four garage bays.<br /> <br /> The heart of the home includes a cozy sitting area, a breakfast room with a view of the 9th hole of the Indian Hills golf course, and a two-sided fireplace shared with the inviting family room—all opening to a rear Trex deck perfect for outdoor enjoyment.<br /> <br /> To the left of the foyer, a refined reception room/study with fireplace and built-ins adds sophistication, while the main-level primary suite is a true retreat. Enjoy private deck access, a fireplace, and a wet bar with built-in beverage cooler. The spa-inspired bath features dual vanities, a soaking tub, dual-entry shower, laundry station, and two spacious closets.<br /> <br /> Upstairs, a wide hallway leads to five en-suite bedrooms, a kids’ lounge/study area, and a full laundry room with two washer/dryer sets.<br /> <br /> The finished terrace level impresses with 10-foot ceilings, two more bedrooms, a flex/office space, kitchenette with dual refrigerators, a rec room/family room, home theater, salon, steam shower, additional baths, and yet another laundry area for pool towels.<br /> <br /> Outside, the backyard oasis includes a heated, all-seasons pool and spa, a cozy fire pit, and a fully equipped outdoor kitchen—perfect for relaxing evenings and entertaining family and friends year-round.<br /> <br /> Located in the heart of Indian Hills, residents enjoy access to the 27-hole Indian Hills Country Club, renovated clubhouse, 8 tennis courts, 3 pools, and proximity to top-rated schools, shopping, and dining.<br /> <br /> Call your agent today to schedule a private showing—homes like this are rare.
MlsNumber: --
ListingId: 7567685


Listing Provided By: NorthGroup Real Estate, original listing
Phone: (770) 597-9711
Office Phone: (404) 383-6616
Agent Name: Ken Adcox
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cobb-northeast [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cobb-northeast State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cobb-northeast State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 423 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Ashley Fritts
Ashley Fritts
ASCIIRealty One Group Edge
Call Today!: (470) 313-1239

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cobb-northeast [3] => GA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cobb-northeast State: GA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cobb-northeast State: GA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 423 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Michael Rishel NMLS#227604
ASCIICTC Funding and Mortgage
Call Today!: (404) 423-6621

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App