Active$1,295,000
3 bd5 ba2,729 SFTownhouse
400 Mayfair Court
Alpharetta, GA 30009 · Mayfair on Main · 88 days listed
FMLS #7813303 · Listing Provided By Atlanta Fine Homes Sotheby's International · 404-272-4464
Active8 days listed
FMLS #7856088 · Listing Provided By Keller Williams Realty Atlanta Partners · 678-770-9946 · Listing agent Lana Efremova

*** LAST TOWNHOME OPPORTUNITY AT MAYFAIR ON MAIN! *** Don't miss your chance to own in one of Alpharetta's premier luxury communities, ideally positioned directly on the Alpha Loop in the heart of downtown Alpharetta. This exceptional Park Lane residence spans four beautifully designed levels and showcases extensive upgrades that elevate the home well beyond its original builder grade finishes. Offering 3 bedrooms, 3 full baths, 2 half baths, and a private elevator providing convenient access to every level, this residence delivers an impressive combination of luxury, sophistication, functionality, and location. The open concept main living level features a spacious kitchen overlooking the dining area and inviting gathering room with bar, creating an ideal setting for everyday living and entertaining. The oversized primary suite offers a private retreat with a luxurious ensuite bath and generous walk in closet. Multiple entertainment spaces distinguish this exceptional residence, including a spacious terrace level entertainment room with bar and an extraordinary top level retreat opening to a private rooftop terrace complete with fireplace, rooftop bar, and outdoor grill. Whether hosting guests or enjoying a quiet evening overlooking Alpharetta, these thoughtfully designed spaces offer an exceptional indoor and outdoor living experience. Extensive upgrades throughout the residence go far beyond standard builder offerings, with enhanced lighting, recessed can lighting, ceiling fans, upgraded bath hardware in all five bathrooms, and premium smart home technology. Additional features include four smart home thermostats, two Ring video cameras, washer and dryer, and AT&T 5G internet. A comprehensive ADT security system provides added convenience and peace of mind, featuring two alarm panels, a motion detector, four smoke and carbon monoxide detectors, and two door sensors. From the upgraded fixtures and finishes to the integrated technology and security features, every enhancement reflects an investment in comfort, quality, and modern luxury. Mayfair on Main places some of Alpharetta's most desirable destinations right outside your door. Enjoy direct access to the Alpha Loop, with The Maxwell and Wills Park just across the street. Downtown Alpharetta's exceptional shopping, dining, and entertainment are only two blocks away, while the renowned Avalon district is approximately 1.5 miles from home. This extraordinary location offers the energy and convenience of downtown living paired with the privacy, comfort, and sophistication of an exclusive luxury residential community. Adding even greater value to this remarkable opportunity, the seller is offering this extensively upgraded residence at $35,000 BELLOW PRICE ORIGINALLY PAID, allowing the next owner to enjoy the benefit of numerous enhancements beyond the original builder grade finishes without an increase over the seller's original purchase price. With four levels of beautifully appointed living and entertaining space, a private elevator, extensive upgrades, an exceptional rooftop terrace, and an unbeatable walkable location, this residence represents a rare opportunity in the heart of Alpharetta. As the last available townhome in Mayfair on Main, this is an opportunity to experience luxury downtown living at its finest!
Figures are list prices from current FMLS IDX inventory (Active, Active Under Contract and Pending), not sales prices or appraisals.
As reported in the listing. Verify with the school district.
Payment estimate
Prefilled with the list price of $1,300,000 and this week's average rate. Change anything to see your number.
$9,975/mo
This is an estimate only. Not a lender, not a loan offer and not a rate quote. Rates: Freddie Mac PMMS weekly average for 2026-10-22: 30-yr 7.32%, 15-yr 6.68%. Tax uses about 0.9% of price per year; insurance assumes $1,500 a year. Conventional adds 0.5% a year mortgage insurance under 20% down; FHA uses 3.5% minimum down, a 1.75% upfront premium financed and 0.55% a year MIP; VA adds a 2.15% funding fee financed under 5% down and no monthly MI. Talk to a licensed lender for a real quote.
Active$1,295,000
3 bd5 ba2,729 SFTownhouse
Alpharetta, GA 30009 · Mayfair on Main · 88 days listed
FMLS #7813303 · Listing Provided By Atlanta Fine Homes Sotheby's International · 404-272-4464
Active$1,250,000
3 bd4 ba3,148 SFTownhouse
Alpharetta, GA 30009 · Canton Street Commons · 151 days listed
FMLS #7778839 · Listing Provided By HOME Luxury Real Estate · 703-899-6663
Active$1,250,000
4 bd5 ba3,100 SFTownhouse
Alpharetta, GA 30009 · Uptown Rowe · 139 days listed
FMLS #7785929 · Listing Provided By Peachtree Town & Country · 404-671-9100
Active$1,250,000
3 bd4 ba3,540 SFTownhouse
Alpharetta, GA 30009 · Uptown Rowe · 138 days listed
FMLS #7786418 · Listing Provided By Peachtree Town & Country · 404-671-9100
Active$1,350,000
3 bd5 ba3,540 SFTownhouse
Alpharetta, GA 30009 · Uptown Rowe · 123 days listed
FMLS #7795124 · Listing Provided By Peachtree Town & Country · 404-671-9100
Active$1,249,000
4 bd4 ba2,767 SFTownhouse
Alpharetta, GA 30009 · Chiswick · 96 days listed
FMLS #7807007 · Listing Provided By Around Atlanta Realty · 404-845-3070
Use the "Ask about this home" form on this page and include the days and times that work for you. Jeff Crowe will follow up to set up a showing.
Send your question through the form on this page. Listing details come from FMLS and are provided by Keller Williams Realty Atlanta Partners, so confirm them before making an offer.
This page shows the status reported in FMLS (Active) as of the last update. Status can change quickly, so ask through the form to confirm before you tour.
It uses the list price, an average mortgage rate, the tax amount in the listing (or an estimated tax rate when none is given), estimated insurance and any HOA dues in the listing. It is an estimate only, not a loan offer. Talk to a licensed lender for a real quote.
See the similar homes section on this page, or browse all homes for sale in Alpharetta, GA.
Beyond homes
Jeff Crowe is a local, full-service agent with CENTURY 21 The Avenues who also works with buyers and sellers of apartment buildings, churches, commercial property and land across Georgia. The pages below are other property types and investor research, separate from this home listing.
Thinking about a rental or a building instead? Send Jeff a message.
Listings identified with the FMLS IDX logo come from FMLS and are 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 click here to review our DMCA policy and learn how to submit a takedown request. ©2026 First Multiple Listing Service, Inc.