Lyzbet Carolin Castillo Bosque
    Lyzbet Carolin Castillo Bosque
    (754) 308-4188lcastillo@providentlegacyrealtors.com
      • Home
      • Search
        • Search Listings
        • Featured Properties
        • Home Valuation
      • Buying
        • Buying Guide
        • Buy a Home in Hudson County
        • Mortgage Calculator
      • Selling
        • Selling Guide
        • Sell Your Home
      • About
        • Meet Lyzbet
        • Contact
        • Testimonials
      • Lyzbet Carolin Castillo Bosque (754) 308-4188
        lcastillo@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
      • Contact
      • Testimonials
      • Get Licensed

      Buying

      • Buying Guide
      • Mortgage Calculator

      Search

      • Featured Properties
      • Home Valuation

      Selling

      • Sell Your Home
      • Selling Guide

      Explore

      • Communities
      Lyzbet Carolin Castillo Bosque  - Footer Logo
      • Office Holidays/Closures
      • Fiduciary Responsibilities
      © 2025 Lyzbet Carolin Castillo Bosque . 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.

        $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)

        Lyzbet Carolin Castillo Bosque Real 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