Active

400 Mayfair Court

Alpharetta, GA 30009
Mark as Favorite
Bed 3

Bed

Bath 5

Bath

SqFt2,729

Sqft

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.

Read More Expand

Detail Ic Property Details

Property Type : Residential

Price : $1,295,000

AD Id : 77904289

MLS Id : 7763190

Beds : 3

Living Area Size : 2,729

Year Built : 2026

Garage : 2

County : Fulton

Subdivision: Ultimar Condo

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 3

    Bathroom Information

    Total Baths: 5 Full Baths: 3 Half Baths: 2

    Room Information

    Basement: None
  • Flooring Information

    Ceramic Tile, Hardwood
  • Roofing Information

    Composition, Metal, Other
  • Interior Features

    Pantry, Kitchen Island, Crown Molding, Double Vanity, Elevator, Entrance Foyer, High Speed Internet, Low Flow Plumbing Fixtures, Recessed Lighting, Walk-In Closet(s) Roof: Composition, Metal, Other Appliances: Dishwasher, Disposal, Double Oven, Gas Range, Microwave, Range Hood Laundry Features: Laundry Room, Upper Level Window Features: Aluminum Frames, Double Pane Windows, Insulated Windows
  • Heating & Cooling

    Has Heating: Yes Heating: Central Has Cooling: Yes Cooling: Central Air

  • Building Information

    Year Built: 2026 Building Area Total: 2729 Construction Materials: Frame, Stone Patio And Porch Features: Covered, Deck Pool Features: None Private Pool: No View: Park/Greenbelt, Trees/Woods, Other Association Fee Frequency: Monthly
  • Exterior Features

    Exterior Features: Balcony, Private Entrance

  • Lot Information

    Lot Dimensions: x Lot Description: Corner Lot, Landscaped, Other

    Property Information

    Subdivision: Mayfair on Main Source Property Type: Residential Property SubType: Townhouse Levels: Three Or More Property Age: 0

  • Listing Price Information

    Listing Price: $1295000 Cash, Conventional

  • Tax Information

    Parcel Number: 12 258306940619 Tax Lot: 23 Tax Block: 0 Tax Year: 2024 Tax Legal Desc: -

  • Parking Information

    Attached, Garage

    Garage Information

    Has Garage: Yes Has Attached Garage: Yes Garage Space: 2
    Homeowners Association Information
    Has Association: Yes Included Fees: Maintenance Grounds, Maintenance Structure, Trash HOA: $425.00 Community Features: Park, Restaurant, Sidewalks, Street Lights, Other

  • School Information

    Elementary School: Hembree Springs
    Junior High School: Northwestern
    Senior High School: Milton - Fulton
  • Utility Information

    Cable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Underground Utilities
  • Location Information

    Direction: Use address 180 Roswell Street, Alpharetta for directions. This home is located across the street from Wills Park. WaterSource: Public Security Features: Smoke Detector(s), Carbon Monoxide Detector(s), Fire Alarm
Sell a home like this and save $77,201 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
9005 Woodland Trail, Alpharetta, GA, 30009 $715,000 3 4 2,625 2,625 SqFt
9005 Woodland Trail, Alpharetta, GA, 30009 $715,000 3 3 2,625 2,625 SqFt
9009 Woodland Trail, Alpharetta, GA, 30009 $735,000 4 4 2,624 2,624 SqFt
9009 Woodland Trail, Alpharetta, GA, 30009 $735,000 4 3 2,624 2,624 SqFt
9015 Woodland Trail #8, Alpharetta, GA, 30009 $724,900 4 4 --
9015 Woodland Trail #8, Alpharetta, GA, 30009 $724,900 4 3 --
2922 Webb Bridge Road #.., Alpharetta, GA, 30009 $340,000 2 2 1,260 1,260 SqFt
2922 Webb Bridge Road #.., Alpharetta, GA, 30009 $340,000 2 3 1,260 1,260 SqFt
5112 Woodland Lane, Alpharetta, GA, 30009 $399,000 3 3 --
653 Hanlon Way, Alpharetta, GA, 30009 $699,000 3 3 2,332 2,332 SqFt

Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. 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 (https://www.fmls.com/dmca.htm) to review our DMCA policy and learn how to submit a takedown request. © 2026 FMLS.

ByOwner last updated this listing 06/18/2026 @ 16:01

MLS: 7763190 LISTED BY: TRICIA FEAGIN, Atlanta Fine Homes Sotheby's International 770-442-7300 SOURCE: First Multiple Listing Service (FMLS)

Selling? Save $77,201 when you sell a home like this

Tour with a ByOwner Agent