Listing provided courtesy of Atlanta Fine Homes Sotheby's International- MLS# 7763190MLS Provider

400 Mayfair CourtAlpharetta, GA 30009

Condo/Townhouse · 3 Beds · 3 Full Baths · 2 Half Baths · 2,729 Sq. ft.
$1,295,000 Active

400 Mayfair Court Overview

Time on Site:
59 days
Visits:
2

This is the last opportunity - the final end unit townhome in an elegant two-unit townhome building at Mayfair on Main. 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,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.

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map

400 Mayfair Court Facts & Features

  • Type Condo/Townhouse
  • Sq. ft. 2,729
  • Price/Sq.ft. $475

Details

General

Association/HOA

  • Swim Tennis Fee: 0
  • Association Fee: 425
  • Association Fee 2: 0
  • Association Fee Frequency: Monthly
  • Association Fee Includes: Maintenance Grounds, Maintenance Structure, Termite, Trash
  • Association: Yes

School Information

  • Elementary School: Hembree Springs
  • Middle Or Junior School: Northwestern
  • High School: Milton - Fulton

Green Features

  • Green Building Verification Type: ENERGY STAR Certified Homes
  • Green Energy Efficient: Appliances, Construction, HVAC, Insulation, Windows
  • Green Energy Generation: None

Building Information

  • Year Built: 2026

Location/Region

  • County Or Parish: Fulton - GA
  • Subdivision Name: Mayfair on Main

Community/Development

  • Community Features: Homeowners Assoc, Near Beltline, Near Schools, Near Shopping, Near Trails/Greenway, Park, Restaurant, Sidewalks, Street Lights, Other
  • Number Of Units In Community: 2

Rent/Lease Information

  • Association Rent Restrictions: Yes
  • Land Lease: No

Tax Information

  • Tax Annual Amount: 0
  • Tax Year: 2024

General Information

  • Listing Terms: Cash,Conventional
  • Ownership: Fee Simple
  • Parcel Number: 12 258306940619
  • Property Condition: To Be Built
  • Property Sub Type: Townhouse
  • Property Type: Residential

Unit Information

  • Number of Units To Be Built: 24

Interior

Parking Information

  • Garage Spaces: 2

Beds/Baths

  • Bathrooms Full: 3
  • Bathrooms Half: 2
  • Bathrooms Total: 5
  • Bedrooms Total: 3

Building Interior

  • Above Grade Finished Area: 2729
  • Below Grade Finished Area: 0
  • Building Area Source: Builder
  • Building Area Total: 2729

General Information

  • Accessibility Features: Accessible Elevator Installed
  • Appliances: Dishwasher, Disposal, Double Oven, Gas Range, Microwave, Range Hood
  • Basement: None
  • Common Walls: 1 Common Wall
  • Cooling: Central Air
  • Electric: 110 Volts, 220 Volts, Other
  • Fireplace Features: Living Room, Outside
  • Fireplaces Total: 2
  • Flooring: Ceramic Tile, Hardwood
  • Heating: Central
  • 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)
  • Laundry Features: Laundry Room, Upper Level
  • Levels: Three Or More
  • Main Level Bathrooms: 0
  • Main Level Half Bathrooms: 1
  • Main Level Bedrooms: 0
  • Other Equipment: None
  • Security Features: Carbon Monoxide Detector(s), Fire Alarm, Smoke Detector(s)
  • Spa Features: None
  • Window Features: Aluminum Frames, Double Pane Windows, Insulated Windows

Room Information

  • Bedroom Features: Oversized Master,Roommate Floor Plan,Split Bedroom Plan

Exterior

Parking Information

  • Parking Features: Attached, Drive Under Main Level, Garage
  • Parking Total: 0

Lot Information

  • Land Lot: 694
  • Lot Features: Corner Lot, Landscaped, Other
  • Lot Size Acres: 0
  • Lot Size Dimensions: x
  • Lot Size Source: Not Available
  • Road Surface Type: Asphalt, Paved
  • Water Source: Public

Waterfront/View

  • Waterfrontage Length: 0
  • View: Park/Greenbelt, Trees/Woods, Other
  • Water Body Name: None
  • Waterfront Features: None

Building Exterior/Construction

  • Dock: None
  • Architectural Style: European, Traditional, Other
  • Construction Materials: Brick 4 Sides, Frame, Stone
  • Patio And Porch Features: Covered, Deck, Rooftop
  • Property Attached: Yes
  • Roof: Composition, Metal, Other

General Information

  • Exterior Features: Balcony, Private Entrance
  • Fencing: None
  • Horse Amenities: None
  • Other Structures: None
  • Pool Features: None
  • Pool Private: No
  • Road Frontage Type: City Street
  • Sewer: Public Sewer
  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Underground Utilities

400 Mayfair Court Neighborhood

Community

30009 (Alpharetta) Demographics

40
Median Age
1,925
Population Density (per sq. mile)
69%
College Educated
$113,562
Estimated Median Income
4,613
Estimated Total Home Owners
2,529
Estimated Total Renters
65% / 35%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

Understanding Mortgage Rates:
A Guide For Homebuyers

Learn More

* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

See What Your Home Is Worth

Instantly get a detailed home price estimate. See what your neighbors are selling their home for!

Calculate

400 Mayfair Court Market Data

Based on the last 30 days in this zip code

$1,134,910
Average List Price
$440
Average Price per Square Foot
67
Properties Sold
78
Average Days on Market
427
Properties for Sale
Calculations provided by Reliance Network

400 Mayfair Court History

Date Event Value Agent
5/1/2026Source: FMLS Added to Database
May 01, 2026

LET'S CONNECT

Harry Norman, REALTORS® has been helping local buyers and sellers just like yourself, locate the finest properties and negotiate the best deals. The team takes great pride in knowing the latest market conditions, government regulations, and upcoming developments — so that you don't have to.
Contact

NEWSLETTERS

For exclusive Atlanta news and market updates, sign up for our newsletter.
Sign Up