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.

        $573,334
        For Sale

        1647 Tide Mill Rd. - Lot 77

        Cumming, GA 30040
        4 beds | 3.5 baths | 0.19 acres | #7690376
        • Save
        • Contact
        • Share
        • Price Change Alerts
        21 photos
        Type:Purchase
        Structure:House
        Zone:Residential

        Description

        Welcome home to your new Hartwell home in the highly desired Berkeley Mill! This popular Hartwell home built on homesite 77 is a rare find you won't want to miss! The first floor features the primary bed/bath on main, along with a private study, half bath, laundry room, and oversized gathering room with corner fireplace, all open to the stunning kitchen with burlap-stained cabinets. Entertaining is easy with the spacious upstairs loft, and three secondary bedrooms- one of the bedrooms offering a private en-suite bathroom, ideal for short and long-term guests. Don't miss your chance to tour this incredible home! Berkeley Mill is a beautiful community with walking trails, a fire pit, swimming pool with outdoor cabana, and a playground. Our location is within 5 minutes to Cumming City Center, and only 1 mile from interstate (GA-400). The list price includes design selections and current incentives. Pricing and promotions are subject to change without notice. Photos are of Hartwell model.

        • Interior Details
            • InteriorHigh Ceilings 9 ft Main, High Speed Internet, Recessed Lighting, Smart Home, Tray Ceiling(s), Walk-In Closet(s)
            • Fireplaces1
          • Heating & Cooling
            • CoolingCentral Air, Electric
            • HeatingCentral, Forced Air
          • Beds & Baths
            • Bathrooms3.5
            • Bedrooms4
            • Full Baths3
            • Half Baths1
            • Bedrooms on Main Level1
        • Property Details
            • Exterior FeaturesLighting, Rain Gutters
            • Exterior MaterialsLighting, Rain Gutters
            • ViewNeighborhood, Other
            • Lot FeaturesLandscaped, Other
            • Lot DescriptionLandscaped, Other
          • Measurements
            • Acres0.185
          • Parking
            • Parking FeaturesDriveway, Garage, Garage Door Opener, Garage Faces Front
            • Parking TypeDriveway
            • Parking Spaces2
        • Construction Details
            • StyleContemporary, Craftsman, Traditional
            • Property TypePurchase
          • Condition
            • Year Built2025
          • Material information
            • RoofRidge Vents, Shingle
        • Utilities / Energy Details
            • Utility FeaturesCable Available, Electricity Available, Natural Gas Available, Sewer Available, Underground Utilities, Water Available
            • AppliancesDishwasher, Disposal, Electric Oven, Gas Cooktop, Gas Range
            • Sewer InformationPublic Sewer
            • Utility SourcePublic
        • Community and Neighborhood Details
            • Community FeaturesCurbs, Homeowners Assoc, Near Beltline, Near Public Transport, Near Schools, Near Shopping, Near Trails/Greenway, Pool, Sidewalk
            • SubdivisionBerkeley Mill
          • Location
            • High SchoolForsyth Central
            • CountyForsyth - GA
            • Elementary SchoolCumming
            • Middle SchoolOtwell
        • Financial Details
            • Original List Price$573,334
            • Taxes Annual$0
          • HOA
            • Hoa Fees166
        • Other
            • MLS #7690376

        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: Jaymie Dimbath (#JDIMBATH)
        Listing Office: Pulte Realty of Georgia, Inc. (#EDIN01)

        Lyzbet Carolin Castillo Bosque Real Estate Group
        Facebook
        Google
        OR

        Interested in Purchasing 1647 Tide Mill Rd. - Lot 77?

        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