40
Map
17708 Cherry LN
About This Property
This six-bedroom home features a spacious primary suite with a full en-suite bathroom and a dedicated workstation-perfect for working from home or enjoying quiet moments of productivity. The additional bedrooms provide plenty of space for family, guests, or creative use such as a home office, media room, or playroom.
The open-concept kitchen is a standout, complete with stainless steel appliances, ample cabinetry, and bar seating that flows seamlessly into two large living areas-ideal for everyday living and entertaining.
Designed with recreation and wellness in mind, the home includes built-in spaces for fun and relaxation. Enjoy features like a game table, shuffleboard, arcade-style games, and a media area perfect for movie nights. Multiple workstations support both an active and remote-friendly lifestyle.
Step outside to a private backyard retreat featuring a string-lit pergola, outdoor dining area, propane grill, smokeless fire pit, and lawn games. Whether you're gathering with friends or enjoying a quiet evening under the stars, this outdoor space offers year-round enjoyment. **An adjacent lot is also available and negotiable with your offer-providing extra space for expansion, added privacy, or future development.**
Zoned commercial, this property opens the door to a range of possibilities. Whether you're envisioning a charming wedding venue, a profitable short-term rental, or a flexible live/work space, this home offers the rare opportunity to blend lifestyle and business in one ideal location.
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 9, 2026 | No longer available | - | |
| No longer available | |||
| Jul 10, 2025 | Listed by eXp Realty, LLC | $629,000 | |
| Listed by eXp Realty, LLC | |||
| Oct 6, 2021 | No longer available | - | |
| No longer available | |||
| Oct 11, 2020 | Price Decreased |
$225,000
↓ $50K
(18.2%) | |
| Price Decreased | |||
| Jul 26, 2020 | In contract | - | |
| In contract | |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017