460 Sterling Road
About This Property
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 |
|---|---|---|---|
| Jul 8, 2026 | In contract | - | |
| In contract | |||
| Mar 11, 2026 | Listed by Compass Greater NY, LLC | $6,695,000 | |
| Listed by Compass Greater NY, LLC | |||
| Dec 1, 2025 | Sold | ||
| Sold | |||
| Sep 20, 2025 | In contract | - | |
| In contract | |||
| Aug 26, 2025 | Listed by Houlihan Lawrence Inc. | $1,500,000 | |
| Listed by Houlihan Lawrence Inc. | |||
| |||
|
Are you ready for an exciting project in Sterling Ridge? Renovate, re-imagine and expand, or re-build completely…so many possibilities exist for this property with current home perched on a 1.08 acre corner lot in prestigious Sterling Ridge. This home has the unique history of originally being built circa 1900 as a cow barn, then in the 1940’s it was transformed into an impressive colonial. A grand staircase with marble steps and a custom iron railing have stood the test of time and speak to how special the home was in its day. A generous living room with picture windows, dentil moldings and a fireplace opens to patio and is mirrored by the formal dining room with picture window and opens to the another patio. The kitchen and study also open to the outdoors. A powder room and breakfast room complete the first floor. All five bedrooms have an ensuite or adjacent bathroom…the perfect set up to update to the current day. A two car garage, spacious basement and walk up insulated attic are a bonus.
Please submit best and final offers by Tuesday, Sept 9 at 5:00pm
| |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
About Harrison
Similar Homes for Sale
Currently no similar homes aroundNearby Rentals
$8,250 /mo
- 3 Beds
- 2 Baths
- 1,700 ft²
$8,250 /mo
- 3 Beds
- 2 Baths
- 1,700 ft²
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017