1525 Wagonwheel Trail
About This Property
A grand staircase creates a stunning first impression upon entry. The private executive study has been completely reimagined with custom built-in shelving and designer lighting. Additional specialty spaces include a wine room, media room, and spacious game room.
One of the home's expansive living areas is anchored by a striking floor-to-ceiling stone fireplace that extends to the soaring ceiling. Dramatic ceilings accented by substantial exposed wood beams create an unforgettable focal point while filling the space with natural light. At the heart of the home, the beautifully updated chef's kitchen has been renovated to today's modern standards with timeless finishes and seamlessly connects to two dining spaces.
The luxurious primary suite is highlighted by a completely renovated spa-inspired bathroom with refined finishes. Throughout most of the home, LED lighting is enhanced by a Lutron Smart Lighting Control System, offering customized ambiance and convenience.
Designed for exceptional indoor-outdoor living, the backyard features a heated pool and spa, a fully equipped outdoor kitchen with a built-in gas grill and beverage cooler, and generous entertaining space. An electric gate opens to a private courtyard, providing added security, privacy, and distinguished curb appeal.
Additional highlights include a 3-car tandem garage and a newly installed cedar privacy fence (2026).
Every detail of this exceptional residence has been thoughtfully updated to deliver a lifestyle of luxury, comfort, and sophistication in one of Keller's most desirable settings.
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 |
|---|---|---|---|
| Sep 11, 2026 | Sold | ||
| Sold | |||
| Aug 14, 2026 | In contract | - | |
| In contract | |||
| Aug 4, 2026 | Price Decreased |
$1,075,000
↓ $20K
(1.8%) | |
| Price Decreased | |||
| Jul 1, 2026 | Listed by x2 Realty Group | $1,095,000 | |
| Listed by x2 Realty Group | |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017