Date
Details
Price
Change
Source
3/27/2026
Listed
$1,295,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/58
$1,295,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/58
Property Description
This is the last opportunity - the final townhome of one two-unit townhome building at Mayfair on Main creates a rare opportunity. This elegant four-story 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,831 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.
Full Property Details
Full Property Details for 400 Mayfair Ct
General
- Price: $1,295,000
- HOA FEE: $425/month
- Taxes: (2024)
- Status: Active
- Type: Townhouse
- Source: FMLS_Atlanta
- MLS ID: 7741589
- Updated: 3/28/2026
- Added to Site: 1 day(s) ago
Interior
- Interior Features: Crown Molding, Double Vanity, Elevator, Entrance Foyer, High Ceilings 9 ft Lower, High Ceilings 10 ft Main, High Speed Internet, Low Flow Plumbing Fixtures, Recessed Lighting, Walk-In Closet(s)
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Living Room, Outside
- Appliances: Dishwasher, Disposal, Double Oven, Gas Range, Microwave, Range Hood
- Flooring: Ceramic Tile, Hardwood
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 3
- Half Bathrooms: 2
- Primary Bathroom: Double Vanity, Shower Only
Bedrooms
- Total Bedrooms: 3
- Bedroom Features: Oversized Master Bedroom, Roommate Floor Plan, Split Bedroom Plan
Other Rooms
- Kitchen: Breakfast Room, Other Cabinets, Stained Cabinets, White Cabinets, Kitchen Island, Pantry Walk-In, Solid Surface Counters, Stone Counters, View to Family Room
- Dining Room: Open Concept
- Laundry: Laundry Room, Upper Level
Additional Information
- Amenities: Homeowners Assoc, Near Beltline, Near Schools, Near Shopping, Near Trails/Greenway, Park, Restaurant, Sidewalks, Street Lights, Other
- Security/Safety: Carbon Monoxide Detector(s), Fire Alarm, Smoke Detector(s)
- Equipment: None
Exterior
- Exterior Features: Balcony, Private Entrance
- Porch/Patio/Deck: Covered, Deck, Rooftop
Parking
- Garage Spaces: 2
- Parking Features: Attached, Drive Under Main Level, Garage
Location
- County: Fulton
- Subdivision: Mayfair on Main
- Driving Directions: Use address 180 Roswell Street, Alpharetta for directions. This home is located across the street from Wills Park.
School Information
- Elementary School: Hembree Springs
- Middle School: Northwestern
- High School: Milton - Fulton
Community
- Association: Yes
- Assoc. Fees Include: Maintenance Grounds, Maintenance Structure, Termite Control, Trash
- Units Assoc/Comm: 2
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Central
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Underground Utilities
Structural Information
- Architectural Style: European, Traditional, Other
- Detached/Attached: Attached
- Exterior Const.: Brick 4 Sides, Frame, Stone
- Basement Desc.: None
- Roof: Composition, Metal, Other
- Common Walls: 1 Common Wall
- Windows: Aluminum Frames, Double Pane Windows, Insulated Windows
- Stories/Levels: Three Or More
- Square Feet: 2,831
- Sq. Ft. Source: Builder
- Year Built: 2026
- Property Condition: To Be Built
Additional Structures
- Other Structures: None
Lot Features
- Property View: Park/Greenbelt, Trees/Woods, Other
- Lot Dimensions: x
- Frontage: City Street
- Street/Road Desc.: Asphalt, Paved
- Lot Features: Corner Lot, Landscaped, Other
- Fencing (Description): None
Water Features
- Docks: None
Financial Considerations
- Association Fee: $425
- Assoc Fee Freq.: Monthly
- Tax Year: 2024
- Terms: Cash, Conventional
Disclosures and Reports
- Property ID: 12 258306940619
- Lot Number: 23
Listed by Atlanta Fine Homes Sotheby's International
Listings identified with the FMLS IDX logo come from FMLS, are held by brokerage firms other than the owner of this website and the listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work, please click here to review our DMCA policy and learn how to submit a takedown request. © 2026 First Multiple Listing Service, Inc. Last Updated Mar 27 2026 10:2PM
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 400 Mayfair Ct —
Atlanta Fine Homes Sotheby's International
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 400 Mayfair Ct
School District:Fulton County School District
| Name | Grades | Distance |
|---|---|---|
Hembree Springs Elementary School 815 Hembree Road, Roswell, GA 30076 | PK-5 | 2.2 mi |
Northwestern Middle School 12805 Birmingham Highway, Alpharetta, GA 30004 | 6-8 | 2.8 mi |
Milton High School 13025 Birmingham Hwy, Alpharetta, GA 30004 | 9-12 | 2.9 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 400 Mayfair Ct
Estimate the Cost
Estimate the Cost for 400 Mayfair Ct
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 18 hours ago
- 4Beds
- 4Total Baths
Listed by Kimberlee Bryan (770) 623-1900
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Listings identified with the FMLS IDX logo come from FMLS, are held by brokerage firms other than the owner of this website and the listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work, please click here to review our DMCA policy and learn how to submit a takedown request. © 2026 First Multiple Listing Service, Inc. Last Updated Mar 27 2026 10:2PM
400 Mayfair Court, Alpharetta, GA 30009 (MLS# 7741589) is a Townhouse property with 3 bedrooms, 3 full bathrooms and 2 partial bathrooms. 400 Mayfair Court is currently listed for $1,295,000 and was received on March 27, 2026. Want to learn more about 400 Mayfair Court? Do you have questions about finding other Townhouse real estate for sale in Alpharetta? You can browse all Alpharetta real estate or contact a Coldwell Banker agent to request more information.