33
Map
551 HIDDEN STREAM COURT
About This Property
Designed with endless opportunity, this home features a fully equipped in-law suite in the basement ideal for multi-generational living. The lower level includes a full kitchen, dining area, living room, full bathroom, and two separate rooms for added privacy and comfort.
As you enter the main level, you're welcomed by a formal dining room and a versatile bonus room, perfect for a home office or study. The heart of the home showcases an open-concept layout with a spacious kitchen, dining area, and family room. The family room is highlighted by a stunning floor to ceiling stone gas fireplace, creating a warm and inviting focal point. This level also includes a two-car garage, mudroom, first-floor laundry, and a convenient half bath.
Upstairs, the expansive primary suite offers two walk in closets and a en-suite bathroom featuring a dual vanity, soaking tub, and separate shower. Three additional generously sized bedrooms and a full bathroom complete the upper level.
Situated on a large, flat lot, the outdoor space provides endless possibilities whether you envision a custom patio, deck, or sunroom.
Listed By
Payment Calculator
Your Estimated Monthly Payment
Cap Rate Calculator
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.
Price History
| Date / Event | Date | Event | Price |
|---|---|---|---|
| Oct 6, 2026 | Price Decreased |
$599,900
↓ $30K
(4.8%) | |
| Price Decreased | |||
| Sep 16, 2026 | Price Decreased |
$629,900
↓ $9K
(1.4%) | |
| Price Decreased | |||
| Sep 3, 2026 | Price Decreased |
$639,000
↓ $11K
(1.7%) | |
| Price Decreased | |||
| Aug 20, 2026 | Price Decreased |
$649,900
↓ $29K
(4.3%) | |
| Price Decreased | |||
| Jun 4, 2026 | Price Decreased |
$679,000
↓ $20K
(2.9%) | |
| Price Decreased | |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
About Westminster
Similar Homes for Sale
Currently no similar homes aroundNearby Rentals
$1,800 /mo
- 2 Beds
- 1 Bath
- 2,086 ft²
$1,350 /mo
- 1 Bed
- 1 Bath
- 500 ft²
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017