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

245 Mayfair CourtAlpharetta, GA 30009

Single Family · 3 Beds · 3 Full Baths · 2 Half Baths · 3,577 Sq. ft.
$1,650,000 Active

245 Mayfair Court Overview

Time on Site:
18 days
Visits:
0

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.

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

245 Mayfair Court Facts & Features

  • Type Single Family
  • Sq. ft. 3,577
  • Price/Sq.ft. $461

Details

General

Association/HOA

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

School Information

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

Green Features

  • Green Energy Efficient: None
  • 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: Dog Park, Homeowners Assoc, Near Public Transport, Near Schools, Near Shopping, Near Trails/Greenway, Sidewalks, Street Lights, Other
  • Number Of Units In Community: 0

Rent/Lease Information

  • Association Rent Restrictions: Yes
  • Land Lease: No

Tax Information

  • Tax Annual Amount: 0
  • Tax Year: 2024

General Information

  • Ownership: Fee Simple
  • Parcel Number: 12 258306940619
  • Property Condition: New Construction
  • Property Sub Type: Single Family Residence
  • Property Type: Residential

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: 3577
  • Below Grade Finished Area: 0
  • Building Area Source: Builder
  • Building Area Total: 3577

General Information

  • Accessibility Features: Accessible Elevator Installed
  • Appliances: Dishwasher, Double Oven, ENERGY STAR Qualified Appliances, Gas Range, Microwave, Range Hood, Refrigerator, Self Cleaning Oven
  • Basement: Bath/Stubbed, Daylight, Driveway Access, Exterior Entry, Finished, Finished Bath
  • Common Walls: No Common Walls
  • Cooling: Central Air
  • Electric: 110 Volts, 220 Volts
  • Fireplace Features: Gas Log, Living Room, Outside
  • Fireplaces Total: 2
  • Flooring: Ceramic Tile, Hardwood, Tile
  • Heating: Central
  • Interior Features: Elevator, Entrance Foyer, High Ceilings 9 ft Lower, High Ceilings 10 ft Main, High Speed Internet, Walk-In Closet(s), Wet Bar
  • 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
  • Spa Features: None
  • Window Features: Double Pane Windows, Insulated Windows

Room Information

  • Bedroom Features: Oversized Master,Other

Exterior

Parking Information

  • Parking Features: Attached, Drive Under Main Level, Driveway, Garage, Garage Door Opener, Garage Faces Rear, Level Driveway
  • Parking Total: 2

Lot Information

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

Waterfront/View

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

Building Exterior/Construction

  • Dock: None
  • Architectural Style: European, Traditional
  • Construction Materials: Brick 4 Sides, Cement Siding, Stone
  • Patio And Porch Features: Covered, Deck, Front Porch, Patio, Rear Porch, Rooftop
  • Property Attached: No
  • Roof: Composition, Metal

General Information

  • Exterior Features: Balcony, Courtyard, Private Entrance
  • Fencing: Front Yard
  • 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, Phone Available, Sewer Available, Water Available
-

245 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 unavailable, 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.

245 Mayfair Court Monthly Cost

$
$ %
%
$
$
* 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.

245 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

245 Mayfair Court History

Date Event Value Agent
6/12/2026Source: FMLS Added to Database
June 12, 2026