Skip main navigation
Active
    • $1,650,000

    245 Mayfair Ct, Alpharetta, GA 30009

    3beds
    3,577sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence, Residential
    Built in 2026
    -- sqft lot
    $1,614,100 Zestimate®
    $461/sqft
    $350/mo HOA

    What's special

    Private elevatorsThree distinct living spacesWell-appointed walk-in pantryLarge frameless glass showerUnder-cabinet lightingSignature regent floorplanCovered kitchen porch
    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.
    29 days
    |
    359
    |
    21
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    TRICIA FEAGIN,

    Atlanta Fine Homes Sotheby's International 404-272-4464,

    Emily Tate,

    Atlanta Fine Homes Sotheby's International

    Source: FMLS GA,MLS#: 7784572MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 5
      • Full bathrooms: 3
      • 1/2 bathrooms: 2
      Rooms
      • Room types: Bonus Room, Exercise Room, Game Room, Media Room, Other
      Primary bedroom
      • Features: Oversized Master, Other
      • Level: Oversized Master, Other
      Bedroom
      • Features: Oversized Master, Other
      Primary bathroom
      • Features: Double Vanity, Separate His/Hers, Separate Tub/Shower, Soaking Tub
      Dining room
      • Features: Dining L, Open Concept
      Kitchen
      • Features: Breakfast Room, Cabinets Other, Cabinets Stain, Eat-in Kitchen, Keeping Room, Kitchen Island, Pantry Walk-In, Solid Surface Counters, View to Family Room
      Heating
      • Central
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Double Oven, ENERGY STAR Qualified Appliances, Gas Range, Microwave, Range Hood, Refrigerator, Self Cleaning Oven
      • Laundry: Laundry Room, Upper Level
      Features
      • Elevator, Entrance Foyer, High Ceilings 9 ft Lower, High Ceilings 10 ft Main, High Speed Internet, Walk-In Closet(s), Wet Bar
      • Flooring: Ceramic Tile, Hardwood, Tile
      • Windows: Double Pane Windows, Insulated Windows
      • Basement: Bath/Stubbed,Daylight,Driveway Access,Exterior Entry,Finished,Finished Bath
      • Number of fireplaces: 2
      • Fireplace features: Gas Log, Living Room, Outside
      • Common walls with other units/homes: No Common Walls
      Interior area
      • Total structure area: 3,577
      • Total interior livable area: 3,577 sqft
      • Finished area above ground: 3,577
      • Finished area below ground: 0
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Drive Under Main Level, Driveway, Garage, Garage Door Opener, Garage Faces Rear, Level Driveway
      • Attached garage spaces: 2
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: Accessible Elevator Installed
      Features
      • Levels: Three Or More
      • Patio & porch: Covered, Deck, Front Porch, Patio, Rear Porch, Rooftop
      • Exterior features: Balcony, Courtyard, No Dock
      • Pool features: None
      • Spa features: None
      • Fencing: Front Yard
      • Has view: Yes
      • View description: City, Park/Greenbelt, Other
      • Waterfront features: None
      • Body of water: None
      Lot
      • Features: Front Yard, Other
      Details
      • Additional structures: None
      • Parcel number: 12 258306940619
      • Other equipment: None
      • Horse amenities: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: European,Traditional
      • Property subtype: Single Family Residence, Residential
      Materials
      • Brick 4 Sides, Cement Siding, Stone
      • Foundation: Slab
      • Roof: Composition,Metal
      Condition
      • New Construction
      • New construction: Yes
      • Year built: 2026
      Details
      • Warranty included: Yes

      Utilities & green energy

      • Electric: 110 Volts, 220 Volts
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Cable Available, Electricity Available, Phone Available, Sewer Available, Water Available
      Green energy
      • Energy efficient items: None
      • Energy generation: None

      Community & HOA

      Community
      • Features: Dog Park, Homeowners Assoc, Near Public Transport, Near Schools, Near Shopping, Near Trails/Greenway, Sidewalks, Street Lights, Other
      • Security: Carbon Monoxide Detector(s), Fire Alarm
      • Subdivision: Mayfair On Main
      HOA
      • Has HOA: Yes
      • Services included: Maintenance Grounds, Trash
      • HOA fee: $350 monthly
      Location
      • Region: Alpharetta

      Financial & listing details

      • Price per square foot: $461/sqft
      • Date on market: 6/12/2026
      • Cumulative days on market: 302 days
      • Ownership: Fee Simple
      • Electric utility on property: Yes
      • Road surface type: Asphalt

        Estimated market value

        $1,614,100

        $1.53M - $1.69M

        $4,958/mo

        Price history

        DateEventPrice
        6/12/2026Listed for sale$1,650,000$461/sqft
        Source: FMLS GA #7784572 Report a problem
        6/5/2026Listing removed$1,650,000$461/sqft
        Source: FMLS GA #7749460 Report a problem
        5/29/2026Price change$1,650,000-6.4%$461/sqft
        Source: FMLS GA #7749460 Report a problem
        4/8/2026Listed for sale$1,762,020$493/sqft
        Source: FMLS GA #7749460 Report a problem
        4/1/2026Listing removed$1,762,020$493/sqft
        Source: GAMLS #10676915 Report a problem
        3/17/2026Price change$1,762,020+0%$493/sqft
        Source: FMLS GA #7704411 Report a problem
        1/17/2026Listed for sale$1,761,720$493/sqft
        Source: FMLS GA #7704411 Report a problem
        1/15/2026Listing removed$1,761,720$493/sqft
        Source: FMLS GA #7676005 Report a problem
        11/4/2025Listed for sale$1,761,720+0.3%$493/sqft
        Source: FMLS GA #7676005 Report a problem
        10/24/2025Listing removed$1,756,530$491/sqft
        Source: FMLS GA #7643274 Report a problem
        9/6/2025Listed for sale$1,756,530+1.8%$491/sqft
        Source: FMLS GA #7643274 Report a problem
        9/4/2025Listing removed$1,725,000$482/sqft
        Source: FMLS GA #7630850 Report a problem
        8/11/2025Listed for sale$1,725,000$482/sqft
        Source: FMLS GA #7630850 Report a problem
        7/11/2025Listing removed$1,725,000$482/sqft
        Source: FMLS GA #7532319 Report a problem
        3/3/2025Listed for sale$1,725,000$482/sqft
        Source: FMLS GA #7532319 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Downtown

        Getting around

        72 / 100
        Very Walkable
        27 / 100
        Some Transit
        48 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Hembree Springs
        • Middle: Northwestern
        • High: Milton - Fulton

        Source: FMLS GA. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Alpharetta Topics

                Search
                Updates
                Favorites
                Plan
                Inbox