26
Map
$2,750,000
●
House -
In Contract
18 Rambling Brook Rd
Upper Saddle River Boro, NJ 07458
5 Beds
5 Baths,
1
Half Bath
$14,728
Est. Monthly
About This Property
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.
Unit Size
-
Days on Market
-
Land Size
1.14 acres
Price per sqft
-
Property Type
House
Property Taxes
$1,224
HOA Dues
-
Year Built
1961
Listed By
Payment Calculator
Home Price
Down Payment
%
Loan Term
Interest %
Your Estimated Monthly Payment
Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:
Cap Rate Calculator
Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate
100% Occupancy
N/A (extreme outlier) What does this mean?
Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.
How much can I actually make?
Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.
How is cap rate calculated?
Cap Rate = Net Operating Income (NOI) / Property Asset Value.
When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.
Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.
Last updated: 6 days ago (GSMLS #4055592)
Price History
| Date / Event | Date | Event | Price |
|---|---|---|---|
| Oct 27, 2026 | In contract | - | |
| In contract | |||
| Sep 29, 2026 | Listed by COLDWELL BANKER REALTY | $2,750,000 | |
| Listed by COLDWELL BANKER REALTY | |||
Property Highlights
Fireplace
Parking Details
Has Garage
Parking Features: Built-In Garage
Garage Spaces: 2
Interior Details
Half Bathrooms: 1
Full Bathrooms: 5
Appliances: Carbon Monoxide Detector
Rooms: 16
Has Fireplace
Fireplace Features: Family Room
Fireplaces: 1
Basement: Crawl Space
Exterior Details
Architectural Style: Custom Home
Year Built: 2023
Construction Materials: See Remarks, Wood Siding
Lot Size Area: 49658.4
Lot Size Units: Square Feet
Lot Size Acres: 1.14
Lot Size Square Feet: 49658.4
Water Source: Well
Financial Details
Tax Assessed Value: $567,200
Tax Annual Amount: $14,690
Utilities Details
Cooling Type: 2 Units
Heating Type: See Remarks
Sewer : Septic Tank
Building Info
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Comparables
Unit
Status
Status
Type
Beds
Baths
ft²
Price/ft²
Price/ft²
Asking Price
Listed On
Listed On
Closing Price
Sold On
Sold On
HOA + Taxes
About Upper Saddle River
Similar Homes for Sale
Currently no similar homes aroundNearby Rentals
Last Updated: 6 days ago
Data Source: GSMLS, MLS#
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. Copyright © 2026 Garden State Multiple Listing Service, L.L.C. All rights reserved. Notice: 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. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.
Data Source: GSMLS, MLS#
Your Privacy Choices
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017