Provident Legacy
    CALL NOW
    (201) 809-9925admin@providentlegacyrealtors.com
    • Home
    • Search
      • General Search
      • Featured Sales
      • Featured Rentals
      • Home Valuation
      • Community Guides
    • Buying
      • Buying Guide
      • Buy a Home in Hudson County
      • Mortgage Calculator
    • Selling
      • Selling Guide
      • Sell Your Home
    • Get Licensed
    • About
      • Find An Agent
      • Leadership Team
      • Business Partnerships
      • LAD Policies
      • Contact
      • Testimonials
    • Join Us
      • Join Our Team
      • Provident Careers
    • CALL NOW(201) 809-9925
      admin@providentlegacyrealtors.com
      Copy Email
    • Provident Legacy Realtors
      177 Broadway
      Bayonne, NJ 07002
      (201) 809-9925
      admin@providentlegacyrealtors.com
      1220816
    • Provident Legacy Realtors Sugar Hill
      740 N Price Rd
      Sugar Hill, GA 30518
      (470) 797-7400
      admin@providentlegacyrealtors.com
      79174
    • Provident Legacy Realtors Cliffside Park
      607B Anderson Avenue
      Cliffside Park, NJ 07010
      (201) 809-9923
      admin@providentlegacyrealtors.com
      1220816

    Company

    • Home
    • Testimonials
    • Contact
    • Get Licensed
    • Find An Agent
    • Leadership Team

    Buying

    • Buying Guide
    • Buy a Home in Hudson County
    • Mortgage Calculator

    Search

    • Search New Jersey
    • Search Georgia
    • Featured Properties
    • Home Valuation

    Selling

    • Sell Your Home
    • Selling Guide

    Explore

    • Communities
    Provident Legacy - Footer Logo
    • Office Holidays/Closures
    • Fiduciary Responsibilities
    • Privacy
    • Terms
    • DMCA
    • Accessibility
    • Fair Housing
    © 2025 Provident Legacy Realtors. All rights reserved.
    Website built by CloseHack.
    All Jersey MLS

    The data relating to real estate for sale on this web-site comes in part from the Internet Listing Display database of the CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC. Real estate listings held by brokerage firms other than this site-owner are marked with the ILD logo. The CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC does not warrant the accuracy, quality, reliability, suitability, completeness, usefulness or effectiveness of any information provided. Copyright 2023, CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC. All rights reserved. The CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC retains all rights, title and interest in and to its trademarks, service marks and copyrighted material. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify properties the consumer may be interested in purchasing or renting.

    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.​

    New Jersey Multiple Listing Service, Inc.

    The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Provident Legacy are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. 

    All information deemed reliable but not guaranteed. Last date updated: 01/09/2023

    2023 New Jersey Multiple Listing Service, Inc. All rights reserved.  

    Garden State Multiple Listing Service

    The data relating to real estate for sale on this website comes in part from the IDX Program of Garden
    State Multiple Listing Service, L.L.C. Real estate listings held by other brokerage firms are marked as
    IDX Listing. Information deemed reliable but not guaranteed. The dissemination of listings on this website does not constitute the consent required by N.J.A.C. 11:5.6.1 (n) for the advertisement of listings exclusively for sale by another broker. Any such consent must be obtained in writing from the listing broker.

    Copyright © 2023 Garden State Multiple Listing Service, L.L.C. All rights reserved.

    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.

    Monmouth Ocean Regional MLS

    © Monmouth Ocean Regional MLS. All rights reserved. Information Deemed Reliable, but Not Guaranteed. Listing information is from various brokers who participate in IDX and not all listings may be visible on the site. The property information being provided is 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.

    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.

    South Jersey Shore Regional MLS

    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

    $3,975,000
    For Sale

    1770 Mayfield Road

    Alpharetta, GA 30009
    6 beds | 6 baths | 0.67 acres | #7687897
    • Save
    • Contact
    • Share
    • Price Change Alerts
    11 photos
    Type:Purchase
    Structure:House
    Zone:Residential

    Description

    Ultra-luxury new construction on a private non-HOA lot within walking distance of Downtown Alpharetta. This home is thoughtfully designed with refined architecture, elevated finishes, and a private guest suite with its own living quarters or executive office and separate entrance. Completion is expected in March 2026. Inside, a stunning 22’ vaulted living, kitchen, and dining space creates an unforgettable first impression. The room features a wood-burning fireplace, custom inset white-oak cabinetry, premium Taj Mahal Quartz, Italian alabaster/marble lighting, Wolf/Sub-Zero/Cove appliances, and a beautifully executed pantry. Every cabinet in the home is fully custom with dovetail drawers and Blum hardware, paired with 9.5” European white-oak flooring. The primary suite offers a serene retreat with a steam shower and a boutique-style closet with LED lighting, glass-front cabinetry, and a glass-topped island. The finished terrace level adds 10’ ceilings, a guest bedroom, a concrete encased safe room/storm shelter, a fully equipped home theater, a home gym with a built in infrared red light sauna and shower/cold plunge, and direct walkout access to a private pool and spa. The backyard and side yard extends further to wooded greenspace for complete privacy. Above the garage, a separate guest apartment includes a full kitchen, secondary master bedroom, bathroom, closet, and private entrance—perfect for extended family or a dedicated office. Additional features include upgraded high-efficiency HVAC, spray-foam insulation, three oversized garages with 10’×9’ doors, motorized blinds, built-in indoor and outdoor speakers, and integrated security cameras. *Renderings are a representation of work to be performed.*

    • Interior Details
        • InteriorHigh Ceilings 10 ft Main, High Ceilings 10 ft Lower, High Ceilings 10 ft Upper, Cathedral Ceiling(s), Double Vanity, Entrance Fo
        • Fireplaces3
      • Heating & Cooling
        • CoolingElectric, Gas, Ceiling Fan(s)
        • HeatingElectric, Natural Gas
      • Beds & Baths
        • Bathrooms6.0
        • Bedrooms6
        • Full Baths6
        • Bedrooms on Main Level2
    • Property Details
        • Exterior FeaturesLighting, Private Entrance, Private Yard
        • Exterior MaterialsLighting, Private Entrance, Private Yard
        • Pool FeaturesHeated, In Ground, Salt Water, Private
        • Lot FeaturesBack Yard, Landscaped, Front Yard
        • Lot DescriptionBack Yard, Landscaped, Front Yard
        • ViewTrees/Woods
      • Measurements
        • Acres0.67
      • Parking
        • Parking FeaturesAttached, Garage Door Opener, Covered, Driveway, Electric Vehicle Charging Station(s)
        • Parking TypeGarage
    • Construction Details
        • Basement DescriptionFinished, Finished Bath, Exterior Entry, Interior Entry, Walk-Out Access
        • StyleEuropean, Modern
        • Property TypePurchase
        • Basement1
        • Basement Finished1
      • Condition
        • Year Built2026
      • Material information
        • RoofComposition
    • Utilities / Energy Details
        • AppliancesDishwasher, Disposal, Refrigerator, Microwave, Range Hood, Tankless Water Heater
        • Utility FeaturesElectricity Available, Water Available, Sewer Available, Natural Gas Available
        • Sewer InformationPublic Sewer
        • Utility SourcePublic
    • Community and Neighborhood Details
        • Subdivisionn/a
      • Location
        • High SchoolMilton - Fulton
        • Middle SchoolNorthwestern
        • CountyFulton - GA
        • Elementary SchoolAlpharetta
    • Financial Details
        • Original List Price$3,975,000
        • Taxes Annual$860
    • Other
        • MLS #7687897

    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 8:18 AM. Source: FMLS

    Provided By
    Listing Agent: Sophia Carrese (#SOPHIACARRESE)
    Listing Office: Atlanta Communities (#ATCM06)

    Provident LegacyReal Estate Group
    Facebook
    Google
    OR

    Interested in Purchasing 1770 Mayfield Road?

    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