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.
Under contract cont. to show
$2,750,000
18 Rambling Brook Rd, Upper Saddle River Boro, NJ 07458
5beds
--sqft
Single Family Residence
Built in 2023
1.14 Acres Lot
$2,672,500 Zestimate®
$--/sqft
$-- HOA
What's special
- 28 days
- 1,220
- 53
Zillow last checked:
Listing updated:
Listed by:
Victoria Afia Agyeman 917-300-9843,
Coldwell Banker Realty
Source: GSMLS,MLS#: 4055592
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
| Date | Event | Price |
|---|---|---|
| 10/2/2026 | Listed for sale | $2,750,000+337.2% |
Source: | ||
| 4/14/2021 | Sold | $629,000 |
Source: Public Record Report a problem | ||
| 10/16/2020 | Listing removed | $629,000 |
Source: Prominent Properties Sotheby's International Realty-Saddle River #20041663 Report a problem | ||
| 10/4/2020 | Listed for sale | $629,000 |
Source: Prominent Properties Sotheby's International Realty-Saddle River #20041663 Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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






