Title Page Background
DEBUG FN args: Array ( [0] => 3402 [1] => [2] => [3] => agent ) BEFORE: Site: 3402 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3402 Igate: njhud LocID: 3402 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 = 3402 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3402 [1] => [2] => [3] => lender ) BEFORE: Site: 3402 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3402 Igate: njhud LocID: 3402 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 = 3402 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3402 [1] => [2] => [3] => other ) BEFORE: Site: 3402 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3402 Igate: njhud LocID: 3402 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 = 3402 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

225 Maison Court
Roswell, GA 30076

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,100,000
Beds: 6
Baths: Full: 6, ½: 2
Status: Active
SqFt: 6185 Square Feet
Agency: Atlanta Fine Homes Sotheby's International
Agency Phone: (770) 442-7300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Welcome to Maison at Hollyberry—Roswell’s premier new luxury neighborhood, offering expansive, flat, pool-ready lots. Crafted with impeccable artistry by Elevation Building Co. and featuring exquisitely curated finishes from Hart & Lock Designs, every detail of this home embodies sophistication and style.<br /> From the moment you arrive, you'll be captivated by the timeless exterior—Lincoln-clad casement windows, stained garage doors, Coppersmith gas lanterns, and limestone accents set the stage for unparalleled elegance. Step inside and be awed by the dramatic two-story window framing the grand staircase, a breathtaking focal point of this masterpiece. Wide-plank hardwood floors flow throughout and illumination by Visual Comfort lighting, enhancing the home’s warmth and beauty. The thoughtfully designed floor plan includes a luxurious primary suite and an additional ensuite bedroom on the main level—offering both convenience and privacy. The great room is a true showstopper, boasting a diamond-pattern coffered ceiling, a striking linear fireplace, and an expansive sliding glass door that seamlessly connects to the covered outdoor limestone paver lanai. Perfect for entertaining, this outdoor retreat features a gas fireplace, an outdoor kitchen, and a pass-through service window. The chef’s kitchen is a culinary dream, complete with custom cabinetry, Wolf/Sub-Zero appliances, quartzite countertops, and an oversized scullery and pantry, featuring additional appliances—including a second dishwasher and microwave—ideal for effortless entertaining. Additional main-level highlights include a mudroom with a designer bench nook, a separate laundry room, and a private study with fluted glass-stained doors. A rear staircase leads to the in-law suite, already stubbed for a wet bar. The primary suite is a true retreat, with vaulted, beamed ceilings, a spa-like bath featuring a zero-entry, wall-to-wall dual shower, soaking tub, heated floors, and a custom walk-in closet. Upstairs, you’ll find three additional ensuite bedrooms, a second laundry, a media room, and a rec room with a wet bar, providing endless possibilities for entertainment and relaxation.<br /> And to complete this extraordinary offering—the level backyard is pool-ready, ensuring the ultimate in luxury living. Come live the Roswell Lifestyle! 2.5 miles to Downtown Roswell for shops/restaurants/music/farmers market. Multiple parks within 1.5 miles for tennis/pickelball/trails. 5 miles to Avalon the shopping premier spot in Alpharetta. Less than 4 miles to top rated public and private schools!
MlsNumber: --
ListingId: 7551681


Listing Provided By: Atlanta Fine Homes Sotheby's International, original listing
Phone: (678) 575-4439
Office Phone: (770) 442-7300
Agent Name: Bonnie Majher
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] => fulton-county-north [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: fulton-county-north State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: fulton-county-north 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 = 3402 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Anna Wheeler
Anna Wheeler
ASCIIKeller Williams Realty Metro Atlanta
Call Today!: (206) 920-4497

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => fulton-county-north [3] => GA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: fulton-county-north State: GA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: fulton-county-north 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 = 3402 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for George Wilson NMLS#2588901
George Wilson NMLS#2588901
ASCIIPrime Nationwide Mortgage
Call Today!: (912) 342-9623

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App