Skip main navigation
Under contract cont. to show
  • $2,750,000

    18 Rambling Brook Rd, Upper Saddle River Boro, NJ 07458

    5beds
    --sqft
    : 
    $17,543/mo
    Get pre-qualified
    Single Family Residence
    Built in 2023
    1.14 Acres Lot
    $2,672,500 Zestimate®
    $--/sqft
    $-- HOA

    What's special

    MODERN, SLEEK AND ABSOLUTELY BREATHTAKING! Exceptional opportunity to complete a striking 6,000-square-foot modern residence set on over one acre of private land. Floor-to-ceiling windows and expansive walls of glass create abundant natural light and seamless indoor-outdoor living. Features include white oak flooring, dramatic L-shaped fireplace, oversized bathrooms, generous walk-in closets, and a luxurious primary suite with spa-inspired ensuite.A separate 2,500-square-foot cabana with full bath offers tremendous flexibility for guest accommodations, pool house, wellness/fitness retreat, or entertainment space. Additional features include two private decks and a 2-car garage.Approximately 70% complete and offered AS IS, providing a rare opportunity to customize the remaining finishes and complete this exceptional modern estate to your vision. The attic can also be finished for extra living space.
    28 days
    1,220
    53

    Zillow last checked:

    Listing updated:

    Listed by:

    Victoria Afia Agyeman 917-300-9843,

    Coldwell Banker Realty

    Source: GSMLS,MLS#: 4055592MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 6
      • Full bathrooms: 5
      • 1/2 bathrooms: 1
      Primary bedroom
      • Description: Full Bath
      Bedroom 1
      • Level: Second
      Bedroom 2
      • Level: Second
      Bedroom 3
      • Level: Second
      Bedroom 4
      • Level: Second
      Primary bathroom
      • Features: Soaking Tub, Stall Shower
      Dining room
      • Level: First
      Family room
      • Level: First
      Kitchen
      • Features: See Remarks
      • Level: First
      Living room
      • Level: First
      Heating
      • See Remarks
      Cooling
      • 2 Units
      Appliances
      • Included: Carbon Monoxide Detector
      • Laundry: Level 1
      Features
      • Basement: None,Crawl Space
      • Number of fireplaces: 1
      • Fireplace features: Family Room

      Property

      Parking
      • Total spaces: 2
      • Parking features: 2 Car Width, Built-In Garage
      • Attached garage spaces: 2
      • Uncovered spaces: 2
      Lot
      • Size: 1.14 Acres
      • Dimensions: 1.140 AC
      Details
      • Parcel number: 1163002050000000150000

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Custom Home
      • Property subtype: Single Family Residence
      Materials
      • See Remarks, Wood Siding
      • Roof: See Remarks
      Condition
      • Under Construction
      • New construction: Yes
      • Year built: 2023

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Well
      • Utilities for property: See Remarks

      Community & HOA

      Community
      • Security: Carbon Monoxide Detector
      Location
      • Region: Upper Saddle River

      Financial & listing details

      • Tax assessed value: $567,200
      • Annual tax amount: $14,690
      • Date on market: 10/2/2026
      • Exclusions: Owner's Belongings
      • Ownership type: Fee Simple

        Estimated market value

        $2,672,500

        $2.54M - $2.81M

        $8,155/mo

        Price history

        DateEventPrice
        10/2/2026Listed for sale$2,750,000+337.2%
        Source: GSMLS #4055592 Report a problem
        4/14/2021Sold$629,000
        Source: Public Record Report a problem
        10/16/2020Listing removed$629,000
        Source: Prominent Properties Sotheby's International Realty-Saddle River #20041663 Report a problem
        10/4/2020Listed for sale$629,000
        Source: Prominent Properties Sotheby's International Realty-Saddle River #20041663 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$14,690 +1.7%$567,200
        2025$14,441 $567,200
        2024$14,441 +2.7%$567,200
        2023$14,067 +1.2%$567,200 +0.8%
        2022$13,902 +2%$562,600
        2021$13,635 +3.9%$562,600
        2020$13,129 +0.7%$562,600
        2019$13,033 $562,600
        2018$13,033 +4%$562,600
        2017$12,527 +1.5%$562,600
        2016$12,341 +1.9%$562,600
        2015$12,116 +1.6%$562,600
        2014$11,930 +2.3%$562,600
        2013$11,660 $562,600
        2012$11,660 +3%$562,600
        2011$11,323 +2.3%$562,600
        2010$11,064 +2.4%$562,600
        2009$10,805 $562,600
        2007-- $562,600
        2006-- $562,600
        2005-- $562,600
        2004-- $562,600
        2003-- $562,600
        2002-- $562,600 +66.1%
        2001-- $338,800
        Find assessor info on the county website

        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 07458

        Getting around

        0 / 100
        Car-Dependent
        15 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts