400 Mayfair Ct Alpharetta, GA 30009

Price
$1,295,000
Listed On
Type
For Sale
Status
Active
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
400 Mayfair Ct, Alpharetta, GA 30009
3 Beds
5 Bath
2729 sqft
Asking  $1,295,000

Snapshot

Type
For Sale
Category
Purchase
Property Type
Residential
Property Subtype
Townhouse
MLS Number
7813303
Parcel Number
12 258306940619
Property Sqft
2,729 sqft
Lot Size
Year Built
2026
Year Updated
Bedrooms
3
Bathrooms
5
Full Bathrooms
3
3/4 Bathrooms
0
Half Bathrooms
2
Quarter Bathrooms
0
Lot Size (in sqft)
-
Price Low
-
Room Count
-
Building Unit Count
-
Condo Floor Number
-
Number of Buildings
-
Number of Floors
3
Parking Spaces
0
Location Directions
Use address 180 Roswell Street, Alpharetta for directions. This home is located across the street from Wills Park.
Subdivision Name
Mayfair on Main
Franchise Affiliation
Sotheby's International Realty
Special Listing Conditions
Auction
Auction
Bankruptcy Property
Bankruptcy Property
HUD Owned
HUD Owned
In Foreclosure
In Foreclosure
Notice Of Default
Notice Of Default
Probate Listing
Probate Listing
Real Estate Owned
Real Estate Owned
Short Sale
Short Sale
Third Party Approval
Third Party Approval

Description

An elegant duet of two end-unit townhomes at Mayfair on Main presents a limited opportunity. This elegant four-story end-unit home is crowned by a rooftop terrace with a fireplace and sunset views over Wills Park to the west. The New Park Lane floor plan offers 2,729 square feet of masterfully curated living space, designed for those with the most refined tastes. With 3 bedrooms, 3 full baths, 2 half baths, and four expansive levels, this residence redefines luxury living through its perfect balance of form and function. An elevator connects each level seamlessly, from the elegant open-concept main living area with 10' ceilings to the showstopping top floor with an optional bar and rooftop terrace with fireplace, a private sanctuary ideal for alfresco entertaining beneath the stars. The terrace-level entertainment lounge, another great spot for a bar (optional feature), ensures every gathering is unforgettable, while the spacious primary suite offers a private retreat with a spa-inspired bathroom and a walk-in closet with a custom closet system. Bespoke, customizable finishes; classic architecture; multiple outdoor spaces; and direct access to the Alpha Loop, just steps from your front door, create a home unlike any other in Alpharetta. At Mayfair on Main, lifestyle extends far beyond your doorstep: stroll to the boutiques and fine dining of Downtown Alpharetta, explore The Maxwell just across the street, or connect effortlessly to Avalon. This is the marriage of Downtown Alpharetta's walkability and convenience with a luxury home. BUYER MAY MAKE THEIR OWN SELECTIONS (FOR A LIMITED TIME), INCLUDING HARDWOOD FLOORS, CABINETS, COUNTERTOPS, TILE, AND LIGHTING. FOR A LIMITED TIME, THE BUILDER IS OFFERING "$25K YOUR WAY" TO BE USED TOWARDS UPGRADES, CLOSING COSTS, OR A RATE BUYDOWN.

Open House Showings

Start TimeEnd TimeAppointment Required?
No

More Details

MLS Name
First Multiple Listing Service, Inc.
Source
ListHub
MLS Number
7813303
MLS ID
FMLSGA
Virtual Tour
PARTICIPANT
Name
Tricia Feagin
Primary Phone
(404) 272-4464
Key
3YD-FMLSGA-FEAGINP
Email
triciafeagin@atlantafinehomes.com
Fax
(770) 442-7317
BROKER
Name
Atlanta Fine Homes Sotheby's International Realty
Phone
(404) 237-5000
OFFICE
Name
Atlanta Fine Homes Sotheby's International
Phone
(770) 442-7300
Copyright © 2026 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.

Features

Basement
Basement
Dock
Dock
Elevator
Elevator
Fireplace
Fireplace
Greenhouse
Greenhouse
Hot Tub Spa
Hot Tub Spa
New Construction
New Construction
Pool
Pool
Sauna
Sauna
Sports Court
Sports Court
Waterfront
Waterfront
Accessibility
Accessible Elevator Installed
Accessible Elevator Installed
Appliances
Dishwasher
Dishwasher
Disposal
Disposal
Double Oven
Double Oven
Gas Range
Gas Range
Microwave
Microwave
Range Hood
Range Hood
Architectural Style
Other
Other
Construction Materials
Brick 4 Sides
Brick 4 Sides
 Frame
Frame
 Stone
Stone
Cooling
Central Air
Central Air
Exterior
Balcony
Balcony
Private Entrance
Private Entrance
Flooring
Tile - Ceramic
Tile - Ceramic
Hardwood
Hardwood
Heating
Central
Central
Interior
Crown Molding
Crown Molding
Double Vanity
Double Vanity
Elevator
Elevator
Entrance Foyer
Entrance Foyer
High Ceilings 9 ft Lower
High Ceilings 9 ft Lower
High Ceilings 10 ft Main
High Ceilings 10 ft Main
High Speed Internet
High Speed Internet
Low Flow Plumbing Fixtures
Low Flow Plumbing Fixtures
Recessed Lighting
Recessed Lighting
Walk-In Closet(s)
Walk-In Closet(s)
Parking
Garage
Garage
Patio and Porch
Deck
Deck
Property Condition
Under Construction
Under Construction
Roof
Composition
Composition
Metal
Metal
Rooms
Bathroom 5
Bathroom 5
Bedroom 3
Bedroom 3
Bedroom 2
Bedroom 2
 Game Room
Game Room
Bedroom 1
Bedroom 1
 Laundry Room
Laundry Room
 Family Room
Family Room
Bathroom 4
Bathroom 4
Bathroom 2
Bathroom 2
Bathroom 3
Bathroom 3
Den
Den
Bathroom 1
Bathroom 1
Utilities
Cable Available
Cable Available
View
Park
Park
Window
Insulated Windows
Insulated Windows
Double Pane Windows
Double Pane Windows
Aluminum Frames
Aluminum Frames

History

DateEventPrice$/SqftSource
Listed For Sale
Residential
$1,295,000$475Atlanta Fine Homes Sotheby's International
Report issue with price history

Taxes

YearAnnual AmountDescription
2024$0

Nearby Schools

Middle School

Fulton Science Academy

0.5 miles away06 - 08

Alternate Education

Independence Alternative School

0.8 miles away09 - 12

High School

Connected Academy

0.8 miles away11 - 12
Show more
Get more info on 400 Mayfair Ct, Alpharetta, GA 30009
Profile
Tricia Feagin
Listing Agent
(404) 272-4464
By pressing request info, you agree that Residential and real estate professionals may contact you via phone/text about your inquiry, which may involve the use of automated means.
Profile
Tricia Feagin
Listing Agent
(404) 272-4464
By pressing request info, you agree that Residential and real estate professionals may contact you via phone/text about your inquiry, which may involve the use of automated means.