4
Map
18007 Sugar Pine Drive
About This Property
Welcome to a bold reimagining of luxury! Crafted without compromise. This architectural triumph by Aspen Developers is a two-story symphony of sophistication, seamlessly merging artistry and innovation across 5 expansive bedrooms, 5 full spa-inspired baths, and 2 refined powder rooms.
Step through soaring glass doors into a world of open-concept living, where clean lines, natural light, and curated textures evoke both grandeur and intimacy. The gourmet chef's kitchen is a culinary masterpiece. Appointed with sleek European cabinetry, waterfall quartz counters, and state-of-the-art smart appliances that respond to your lifestyle.
A bespoke studio offers flexible space for creation, focus, or retreat. Lavish living and entertaining areas flow effortlessly to covered patios, perfect for hosting under the stars.
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 |
|---|---|---|---|
| Aug 4, 2026 | Price Decreased |
$1,195,000
↓ $90K
(7%) | |
| Price Decreased | |||
| Jul 28, 2026 | Price Decreased |
$1,285,000
↓ $210K
(14.1%) | |
| Price Decreased | |||
| Apr 23, 2026 | Price Decreased |
$1,495,000
↓ $100K
(6.3%) | |
| Price Decreased | |||
| Nov 10, 2025 | Price Decreased |
$1,595,000
↓ $4K
(0.3%) | |
| Price Decreased | |||
| Nov 4, 2025 | Price Increased |
$1,599,000
↑ $104K
(7%) | |
| Price Increased | |||
Property Highlights
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017