Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (245)
    Mexico Listings (15)
    Advanced Search
Sell Find an Agent
BarrierFreeHome.com BarrierFreeHome.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BarrierFreeHome.com logo
Share
BarrierFreeHome.com logo
Ad #7837208
MLS #7763190
Listing photo

This is the last opportunity - the final end unit townhome in an

400 Mayfair Ct, Alpharetta, Georgia, 30009
$1,295,000
3Beds
5Baths
2,729Sqft
0Acres

About this property

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.

Property Features

3 Beds
5 Baths
2,729 Sqft
Built in 2026
0 Acres
3 Stories
Garage
Siding: Brick 4 Sides, Frame, Stone
Composition, Metal Roof
Has Fireplace
Central
Fulton County
Mayfair on Main Community

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

TRICIA FEAGIN

Atlanta Fine Homes Sotheby's International Realty

404-237-5000

Location

Map
Listing Agent: TRICIA FEAGIN 404-237-5000
Broker: Atlanta Fine Homes Sotheby's International Realty 404-237-5000 Listing Site
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.
BarrierFreeHome.com
Printed Jun 9, 2026

Photo Gallery

Listing Photo 1
Listing Photo 2
Listing Photo 3
Listing Photo 4
Listing Photo 5
Listing Photo 6
Listing Photo 7
Listing Photo 8
Listing Photo 9
Listing Photo 10
Listing Photo 11
Listing Photo 12
Listing Photo 13
Listing Photo 14
Listing Photo 15
Listing Photo 16
Listing Photo 17
Listing Photo 18
Listing Photo 19
Listing Photo 20
Listing Photo 21
Listing Photo 22
Listing Photo 23
Listing Photo 24
Listing Photo 25
Listing Photo 26
Listing Photo 27
Listing Photo 28
Listing Photo 29
Listing Photo 30
Listing Photo 31
Listing Photo 32
Listing Photo 33
Listing Photo 34
Listing Photo 35
Listing Photo 36
Listing Photo 37
Listing Photo 38
Listing Photo 39
Listing Photo 40
Listing Photo 41
Listing Photo 42
Listing Photo 43
Listing Photo 44
Listing Photo 45
Listing Photo 46
Listing Photo 47
Listing Photo 48
Listing Photo 49
Listing Photo 50

$1,295,000

3
Beds
5
Baths
2,729
Sqft

400 Mayfair Ct, Alpharetta, Georgia, 30009

By contacting this agent you agree to these Terms and Conditions.
Home Georgia Alpharetta
This is the last opportunity - the final end unit townhome in an
This is the last opportunity - the final end unit townhome in an
This is the last opportunity - the final end unit townhome in an
This is the last opportunity - the final end unit townhome in an
This is the last opportunity - the final end unit townhome in an
MLS# 7763190
Townhome/Townhouse For Sale

This is the last opportunity - the final end unit townhome in an

$1,295,000

400 Mayfair Ct, Alpharetta, Georgia, 30009

3
Beds
5
Baths
2,729
Sqft
0
Acres
$1,295,000
400 Mayfair Ct, Alpharetta, Georgia, 30009
3 Beds
5 Baths
2,729 Sqft
0 Acres

Accessibility Features

Accessible Elevator Installed
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.
9 days
on BarrierFreeHome.com
1
view
0
saves

Property Details

HOME DETAILS

3 Beds
5 Baths
2,729 Sqft
Built in 2026
0 Acres
3 Stories

EXTERIOR

Garage
Siding: Brick 4 Sides, Frame, Stone
Composition, Metal Roof

INTERIOR

Has Fireplace
Central

FINANCIAL & COMMUNITY

Fulton County
Mayfair on Main Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7837208
Viewed
1 time
Listing Status
Active
Added
May 30, 2026
Last Refresh
Jun 08, 2026 09:04:43 PM

Listing Information

Data Source
First Multiple Listing Service, Inc.
Source Property ID
7763190
Listing Agent: TRICIA FEAGIN 404-237-5000
Broker: Atlanta Fine Homes Sotheby's International Realty 404-237-5000 Listing Site
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.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BarrierFreeHome.com
Sell Your Home

Explore Similar Properties

For Sale
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between
Located in the highly sought-after Foundry community between

$1,275,000

4 Beds | 5.0 Baths | 3,125 Sqft

386 Concord St, Alpharetta, GA, 30009

Located in the highly sought-after Foundry community between

Added: 03/25/2026 • Updated: 05/23/2026
For Sale
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is
This luxury townhome in the sought-after community of Foundry is

$1,250,000

4 Beds | 5.0 Baths | 3,125 Sqft

320 Concord St, Alpharetta, GA, 30009

This luxury townhome in the sought-after community of Foundry is

Added: 04/02/2026 • Updated: 05/28/2026
For Sale
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing

$1,225,000

4 Beds | 4.0 Baths | 3,075 Sqft

531 S Main St 410, Alpharetta, GA, 30009

Inquire about 1st year rates as low as 2.78%, elevators, closing

Added: 02/13/2026 • Updated: 03/13/2026
For Sale
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing
Inquire about 1st year rates as low as 2.78%, elevators, closing

$1,180,000

4 Beds | 4.0 Baths | 3,075 Sqft

531 S Main St 210, Alpharetta, GA, 30009

Inquire about 1st year rates as low as 2.78%, elevators, closing

Added: 02/13/2026 • Updated: 03/30/2026
View more View More
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.06.09
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Alpharetta

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Alpharetta Real Estate Agent Info

About Alpharetta

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.06.09
Terms & Policy