• Sign Up
  • Log In
Osmany Dilone
Osmany Dilone
(848) 666-0632osmany@providentlegacyga.com
  • Home
  • Search
    • Search Listings
    • Featured Properties
    • Home Valuation
  • Buying
    • Buying Guide
    • Mortgage Calculator
  • Selling
    • Selling Guide
    • Sell Your Home
  • About
    • Meet Osmany
    • Contact
    • Testimonials
  • Osmany Dilone(848) 666-0632
    osmany@providentlegacyga.com
    Copy Email
  • Provident Legacy Realtors Sugar Hill
    740 N Price Rd
    Sugar Hill, GA 30518
    (470) 797-7400
    admin@providentlegacyrealtors.com
    79174

Company

  • Home
  • Contact
  • Testimonials
  • Get Licensed

Buying

  • Buying Guide
  • Mortgage Calculator

Search

  • Featured Properties
  • Home Valuation

Selling

  • Sell Your Home
  • Selling Guide

Explore

  • Communities
Osmany Dilone - Footer Logo
    • Privacy
    • Terms
    • DMCA
    • Accessibility
    • Fair Housing
    © 2026 Provident Legacy Realtors. All rights reserved.
    Website built by CloseHack.
    First Multiple Listing Service, Inc.

    ​ 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. © 2022 First Multiple Listing Service, Inc.​

    Georgia MLS

    The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of GAMLS. All real estate listings are marked with the GAMLS Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. Copyright 2023 GAMLS. All rights reserved.

    Hudson Multiple Listing Service

    IDX information for Hudson Multiple Listing Service is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.

    $1,761,720
    For Sale

    245 Mayfair Court

    Alpharetta, GA 30009
    3 beds | 4 baths | #7704411
    • Save
    • Contact
    • Share
    • Price Change Alerts
    245 Mayfair Court
    39 photos
    Type:Purchase
    Structure:House
    Zone:Residential

    Description

    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 offering 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 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 soaking tub, large frameless glass shower, and custom walk-in closet. A private elevator services every floor for effortless movement throughout the home. For a limited time, enjoy “$40K Your Way” a flexible builder incentive designed to accommodate your lifestyle, whether through closing cost support, a mortgage rate buy-down, or curated design enhancements. 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.

    • Interior Details
        • InteriorElevator, Entrance Foyer, High Ceilings 9 ft Lower, High Ceilings 10 ft Main, High Speed Internet, Walk-In Closet(s), Wet Bar
        • Fireplaces2
      • Heating & Cooling
        • CoolingCentral Air
        • HeatingCentral
      • Beds & Baths
        • Bathrooms4.0
        • Bedrooms3
        • Full Baths3
        • Half Baths2
    • Property Details
        • Exterior FeaturesBalcony, Courtyard, Private Entrance
        • Exterior MaterialsBalcony, Courtyard, Private Entrance
        • ViewCity, Park/Greenbelt, Other
        • Lot FeaturesFront Yard, Other
        • Lot DescriptionFront Yard, Other
      • Parking
        • Parking FeaturesAttached, Drive Under Main Level, Driveway, Garage, Garage Door Opener, Garage Faces Rear, Level Driveway
        • Parking TypeGarage
        • Parking Spaces2
    • Construction Details
        • Basement DescriptionBath/Stubbed, Daylight, Driveway Access, Exterior Entry, Finished, Finished Bath
        • StyleEuropean, Traditional
        • Property TypePurchase
        • Basement1
        • Basement Finished1
      • Condition
        • Year Built2025
      • Material information
        • RoofComposition, Metal
    • Utilities / Energy Details
        • AppliancesDishwasher, Double Oven, ENERGY STAR Qualified Appliances, Gas Range, Microwave, Range Hood, Refrigerator, Self Cleaning Oven
        • Utility FeaturesCable Available, Electricity Available, Phone Available, Sewer Available, Water Available
        • Sewer InformationPublic Sewer
        • Utility SourcePublic
    • Community and Neighborhood Details
        • Community FeaturesDog Park, Homeowners Assoc, Near Public Transport, Near Schools, Near Shopping, Near Trails/Greenway, Sidewalks, Street Lights,
        • SubdivisionMayfair on Main
      • Location
        • Elementary SchoolHembree Springs
        • High SchoolMilton - Fulton
        • Middle SchoolNorthwestern
        • CountyFulton - GA
    • Financial Details
        • Original List Price$1,761,720
        • Taxes Annual$0
      • HOA
        • Hoa Fees350
    • Other
        • OwnershipFee Simple
      • Source
        • MLS #7704411

    Location

    Legal

    ​ 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. © 2022 First Multiple Listing Service, Inc.​

    Last Updated: 09/17/2025 9:42 AM. Source: FMLS

    Provided By
    Listing Agent: TRICIA FEAGIN (#FEAGINP)
    Listing Office: Atlanta Fine Homes Sotheby's International (#ATFH02)

    Osmany DiloneReal Estate Group
    Facebook
    Google
    OR

    Interested in Purchasing 245 Mayfair Court?

    Get an estimate on monthly payments on this property.

    Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

    Estimated Monthly Payment
    $0.00
    Loan Amount
    $0.00
    $
    years

    Down Payment

    $
    %
    10.0%

    Interest Rate

    %
    6.0%

    Tax Rate

    %
    2.6%
    $
    $
    annually
    $
    monthly