Skip to content

Back to search

Listing Provided By TRICIA FEAGIN with Atlanta Fine Homes Sotheby's International, 404-272-4464

  1. Photo 1 of 59, Alpharetta, GA 30009
  2. Photo 2 of 59, Alpharetta, GA 30009
  3. Photo 3 of 59, Alpharetta, GA 30009
  4. Photo 4 of 59, Alpharetta, GA 30009
  5. Photo 5 of 59, Alpharetta, GA 30009
  6. Photo 6 of 59, Alpharetta, GA 30009
  7. Photo 7 of 59, Alpharetta, GA 30009
  8. Photo 8 of 59, Alpharetta, GA 30009
  9. Photo 9 of 59, Alpharetta, GA 30009
  10. Photo 10 of 59, Alpharetta, GA 30009
  11. Photo 11 of 59, Alpharetta, GA 30009
  12. Photo 12 of 59, Alpharetta, GA 30009
  13. Photo 13 of 59, Alpharetta, GA 30009
  14. Photo 14 of 59, Alpharetta, GA 30009
  15. Photo 15 of 59, Alpharetta, GA 30009
  16. Photo 16 of 59, Alpharetta, GA 30009
  17. Photo 17 of 59, Alpharetta, GA 30009
  18. Photo 18 of 59, Alpharetta, GA 30009
  19. Photo 19 of 59, Alpharetta, GA 30009
  20. Photo 20 of 59, Alpharetta, GA 30009
  21. Photo 21 of 59, Alpharetta, GA 30009
  22. Photo 22 of 59, Alpharetta, GA 30009
  23. Photo 23 of 59, Alpharetta, GA 30009
  24. Photo 24 of 59, Alpharetta, GA 30009
  25. Photo 25 of 59, Alpharetta, GA 30009
  26. Photo 26 of 59, Alpharetta, GA 30009
  27. Photo 27 of 59, Alpharetta, GA 30009
  28. Photo 28 of 59, Alpharetta, GA 30009
  29. Photo 29 of 59, Alpharetta, GA 30009
  30. Photo 30 of 59, Alpharetta, GA 30009
  31. Photo 31 of 59, Alpharetta, GA 30009
  32. Photo 32 of 59, Alpharetta, GA 30009
  33. Photo 33 of 59, Alpharetta, GA 30009
  34. Photo 34 of 59, Alpharetta, GA 30009
  35. Photo 35 of 59, Alpharetta, GA 30009
  36. Photo 36 of 59, Alpharetta, GA 30009
  37. Photo 37 of 59, Alpharetta, GA 30009
  38. Photo 38 of 59, Alpharetta, GA 30009
  39. Photo 39 of 59, Alpharetta, GA 30009
  40. Photo 40 of 59, Alpharetta, GA 30009
  41. Photo 41 of 59, Alpharetta, GA 30009
  42. Photo 42 of 59, Alpharetta, GA 30009
  43. Photo 43 of 59, Alpharetta, GA 30009
  44. Photo 44 of 59, Alpharetta, GA 30009
  45. Photo 45 of 59, Alpharetta, GA 30009
  46. Photo 46 of 59, Alpharetta, GA 30009
  47. Photo 47 of 59, Alpharetta, GA 30009
  48. Photo 48 of 59, Alpharetta, GA 30009
  49. Photo 49 of 59, Alpharetta, GA 30009
  50. Photo 50 of 59, Alpharetta, GA 30009
  51. Photo 51 of 59, Alpharetta, GA 30009
  52. Photo 52 of 59, Alpharetta, GA 30009
  53. Photo 53 of 59, Alpharetta, GA 30009
  54. Photo 54 of 59, Alpharetta, GA 30009
  55. Photo 55 of 59, Alpharetta, GA 30009
  56. Photo 56 of 59, Alpharetta, GA 30009
  57. Photo 57 of 59, Alpharetta, GA 30009
  58. Photo 58 of 59, Alpharetta, GA 30009
  59. Photo 59 of 59, Alpharetta, GA 30009

Active

Price reduced

All 59 photos

Photos

Photo 1 of 59

Photo 1 of 59, Alpharetta, GA 30009

245 Mayfair Court

Alpharetta, GA 30009

$1,600,000

Beds
3
Baths
3 full, 2 half
Sq ft
3,577
Price per sq ft
$447
Year built
2026
Lot
0 acres
Garage
2 spaces

About this home

The only move-in-ready opportunity! Experience a refined balance of sophistication and convenience in the heart of Downtown Alpharetta at Mayfair on Main. This exclusive collection of luxury new-construction single-family and townhomes offers private elevators, expansive rooftop terraces with fireplaces, and effortless access to Alpharetta’s premier dining, boutique shopping, entertainment, parks, and wellness destinations. With only 24 residences, this enclave elevates modern living through timeless design and thoughtful function. Here, luxury meets everyday ease in one of Georgia’s most sought-after downtown communities. This home is the signature Regent floorplan, designed for both connection and comfort, featuring three distinct living spaces, including a terrace-level lounge opening to a front courtyard. Enjoy multiple outdoor escapes, from a covered kitchen porch to a dramatic rooftop terrace with a fireplace and skyline views. Three bedrooms, three full baths, and two half baths are thoughtfully arranged across multiple levels. An open chef’s kitchen anchors the main level, with custom Wellborn cabinetry to the ceiling, under-cabinet lighting, pullouts, and a well-appointed walk-in pantry. The keeping room, dining area, and gathering room flow seamlessly, creating an elegant environment for daily living and entertaining. The expansive primary suite offers a spa-inspired bath with a soaking tub, a large frameless glass shower, and a custom walk-in closet. A private elevator services every floor for effortless movement throughout the home. More than a home, Mayfair on Main is a way of life. Just steps to the Alpha Loop, City Center, Avalon, and an array of parks, studios, golf options, and live music venues, this is downtown Alpharetta’s most distinguished new address for elevated living.

Listed
Aug 20, 2026
Updated
Nov 8, 2026, 3:41 AM ET
Property type
Residential, Single Family Residence
Subdivision
Mayfair on Main
FMLS #
7825000
County
Fulton - GA

Interior

Interior features
Elevator, Entrance Foyer, High Ceilings 9 ft Lower, High Ceilings 10 ft Main, High Speed Internet, Walk-In Closet(s), Wet Bar
Appliances
Dishwasher, Double Oven, ENERGY STAR Qualified Appliances, Gas Range, Microwave, Range Hood, Refrigerator, Self Cleaning Oven
Flooring
Ceramic Tile, Hardwood, Tile
Fireplaces
2
Fireplace features
Gas Log, Living Room, Outside
Basement
Bath/Stubbed, Daylight, Driveway Access, Exterior Entry, Finished, Finished Bath
Cooling
Central Air
Heating
Central
Laundry
Laundry Room, Upper Level
Kitchen
Breakfast Room, Cabinets Other, Cabinets Stain, Eat-in Kitchen, Keeping Room, Kitchen Island, Pantry Walk-In, Solid Surface Counters, View to Family Room
Primary bathroom
Double Vanity, Separate His/Hers, Separate Tub/Shower, Soaking Tub
Levels
Three Or More
Main-level bedrooms
0
Main-level bathrooms
0
Accessibility features
Accessible Elevator Installed
Windows
Double Pane Windows, Insulated Windows

Exterior

Exterior features
Balcony, Courtyard, Private Entrance
Patio and porch
Covered, Deck, Front Porch, Patio, Rear Porch, Rooftop
Construction materials
Brick 4 Sides, Cement Siding, Stone
Roof
Composition, Metal
Fencing
Front Yard
Pool features
None
Private pool
No
Spa
None
View
City, Park/Greenbelt, Other
Waterfront
None
Dock
None
Foundation
Slab

Lot & parking

Lot size (acres)
0
Lot dimensions
x
Lot features
Front Yard, Other
Garage spaces
2
Parking
Attached, Drive Under Main Level, Driveway, Garage, Garage Door Opener, Garage Faces Rear, Level Driveway
Total parking spaces
2

Utilities

Sewer
Public Sewer
Water source
Public
Utilities
Cable Available, Electricity Available, Phone Available, Sewer Available, Water Available
Electric
110 Volts, 220 Volts
Energy efficiency
None

HOA & taxes

Association
Yes
Association fee
350
Association fee frequency
Monthly
Association fee includes
Maintenance Grounds, Trash
Annual tax amount
0
Tax year
2024

Schools & community

Elementary school
Hembree Springs
Middle school
Northwestern
High school
Milton - Fulton
Subdivision
Mayfair on Main
County
Fulton - GA
Community features
Dog Park, Homeowners Assoc, Near Public Transport, Near Schools, Near Shopping, Near Trails/Greenway, Sidewalks, Street Lights, Other

Construction

Architectural style
European, Traditional
Year built
2026
Property subtype
Single Family Residence
Condition
New Construction
Building area (total)
3577
Above-grade finished area
3577
Below-grade finished area
0

Location

Payment estimate

An estimate by Abbe Real Estate. It is not a loan offer, and it is not information from FMLS.

From the listing; you can change it.

Enter your own figure.

Enter the rate you expect.

For example, the term you plan to choose.

Enter a down payment, an interest rate and a loan term to see an estimate.

Questions about this home?

Your message goes to Abbe Real Estate. Abbe Real Estate is not the listing brokerage for this home.

Ask Abbe Real Estate about this home
What would you like?

By sending, you agree Abbe Real Estate may contact you by email or phone about this inquiry.

All photos (59)

  1. Photo 1 of 59, Alpharetta, GA 30009
  2. Photo 2 of 59, Alpharetta, GA 30009
  3. Photo 3 of 59, Alpharetta, GA 30009
  4. Photo 4 of 59, Alpharetta, GA 30009
  5. Photo 5 of 59, Alpharetta, GA 30009
  6. Photo 6 of 59, Alpharetta, GA 30009
  7. Photo 7 of 59, Alpharetta, GA 30009
  8. Photo 8 of 59, Alpharetta, GA 30009
  9. Photo 9 of 59, Alpharetta, GA 30009
  10. Photo 10 of 59, Alpharetta, GA 30009
  11. Photo 11 of 59, Alpharetta, GA 30009
  12. Photo 12 of 59, Alpharetta, GA 30009
  13. Photo 13 of 59, Alpharetta, GA 30009
  14. Photo 14 of 59, Alpharetta, GA 30009
  15. Photo 15 of 59, Alpharetta, GA 30009
  16. Photo 16 of 59, Alpharetta, GA 30009
  17. Photo 17 of 59, Alpharetta, GA 30009
  18. Photo 18 of 59, Alpharetta, GA 30009
  19. Photo 19 of 59, Alpharetta, GA 30009
  20. Photo 20 of 59, Alpharetta, GA 30009
  21. Photo 21 of 59, Alpharetta, GA 30009
  22. Photo 22 of 59, Alpharetta, GA 30009
  23. Photo 23 of 59, Alpharetta, GA 30009
  24. Photo 24 of 59, Alpharetta, GA 30009
  25. Photo 25 of 59, Alpharetta, GA 30009
  26. Photo 26 of 59, Alpharetta, GA 30009
  27. Photo 27 of 59, Alpharetta, GA 30009
  28. Photo 28 of 59, Alpharetta, GA 30009
  29. Photo 29 of 59, Alpharetta, GA 30009
  30. Photo 30 of 59, Alpharetta, GA 30009
  31. Photo 31 of 59, Alpharetta, GA 30009
  32. Photo 32 of 59, Alpharetta, GA 30009
  33. Photo 33 of 59, Alpharetta, GA 30009
  34. Photo 34 of 59, Alpharetta, GA 30009
  35. Photo 35 of 59, Alpharetta, GA 30009
  36. Photo 36 of 59, Alpharetta, GA 30009
  37. Photo 37 of 59, Alpharetta, GA 30009
  38. Photo 38 of 59, Alpharetta, GA 30009
  39. Photo 39 of 59, Alpharetta, GA 30009
  40. Photo 40 of 59, Alpharetta, GA 30009
  41. Photo 41 of 59, Alpharetta, GA 30009
  42. Photo 42 of 59, Alpharetta, GA 30009
  43. Photo 43 of 59, Alpharetta, GA 30009
  44. Photo 44 of 59, Alpharetta, GA 30009
  45. Photo 45 of 59, Alpharetta, GA 30009
  46. Photo 46 of 59, Alpharetta, GA 30009
  47. Photo 47 of 59, Alpharetta, GA 30009
  48. Photo 48 of 59, Alpharetta, GA 30009
  49. Photo 49 of 59, Alpharetta, GA 30009
  50. Photo 50 of 59, Alpharetta, GA 30009
  51. Photo 51 of 59, Alpharetta, GA 30009
  52. Photo 52 of 59, Alpharetta, GA 30009
  53. Photo 53 of 59, Alpharetta, GA 30009
  54. Photo 54 of 59, Alpharetta, GA 30009
  55. Photo 55 of 59, Alpharetta, GA 30009
  56. Photo 56 of 59, Alpharetta, GA 30009
  57. Photo 57 of 59, Alpharetta, GA 30009
  58. Photo 58 of 59, Alpharetta, GA 30009
  59. Photo 59 of 59, Alpharetta, GA 30009

Copyright 2026 First MLS. Listing content is believed accurate but not guaranteed.

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 click here to review our DMCA policy and learn how to submit a takedown request. © 2026 FMLS.

Abbe Real Estate

A trade name of Ryan Abbe Properties LLC

License #H-81887

13010 Morris Road, suite 650, Alpharetta, GA 30004

Office: (470) 383-3020

Listing search provided and supported by Ryan Abbe Properties LLC (Abbe Real Estate), ops@abberealestate.com, (470) 383-3020.

Report a data error

Equal Housing Opportunity. Abbe Real Estate supports the Fair Housing Act and equal housing opportunity for all.

Privacy notice

Terms of use

Listing data last updated Nov 8, 2026, 3:41 AM ET