15414 DERNA TERRACE
About This Property
The enclosed office with glass doors provides a quiet workspace, while both guest suites offer ideal privacy. A custom wine wall and bar create a warm, stylish focal point in the dining area-perfect for entertaining. The gourmet kitchen features stainless steel Monogram appliances, abundant storage, and a layout designed for effortless hosting.
Indoor living flows seamlessly to the stunning outdoor retreat, complete with an expansive pool and spa, travertine decking, outdoor kitchen, and fireplace. The panoramic screen showcases serene lake and golf views and unforgettable sunsets.
This true smart home allows you to control lighting, security, Sonos audio, thermostat, pool, spa, and more directly from your phone. Upgrades include impact windows, lanai sunshades, a tankless Rinnai water heater, designer tile flooring, upgraded baths, custom closets and pantries, security cameras, and a spacious three-car tandem garage.
Located in the resort-style community of Esplanade at Azario, residents enjoy a championship golf course, resort pool, poolside bar, spa, fitness center, tennis, and pickleball. ($1000 annual food & beverage minimum and $5,000 capital contribution due at closing. Golf membership included.)
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 |
|---|---|---|---|
| Mar 9, 2026 | Sold | ||
| Sold | |||
| Jan 26, 2026 | In contract | - | |
| In contract | |||
| Jan 4, 2026 | Listed by PREFERRED SHORE LLC | $1,900,000 | |
| Listed by PREFERRED SHORE LLC | |||
| Jun 21, 2023 | Sold | ||
| Sold | |||
| May 5, 2023 | Listed by PREMIER SOTHEBYS INTL REALTY | $1,915,000 | |
| Listed by PREMIER SOTHEBYS INTL REALTY | |||
| | |||
|
Finally! Move-in-ready, highly desirable Pallazio floor plan in Esplanade Azario with the most stunning lake and golf views! Before you even enter the home, you will be wowed by the gorgeous outdoor landscaping and lighting package that warms the heart. As you step inside and enter through the beautiful double glass doors of this three-bedroom, three-bath-plus-den home, you will notice all the exquisite custom designs in this open floor plan. The office has been enclosed with beautiful glass doors while the two-bedroom en suites offer privacy for your guests. Perfect for entertaining, there is a custom wine wall and bar in the dining room offering a warm seating and conversation area. As you entertain in your gourmet kitchen with stainless steel Monogram appliances with more than ample storage space, you will experience a hostess's dream. Your living space continues as you step outside to your outdoor retreat with expansive pool and spa, travertine flooring, outdoor kitchen and fireplace. Enjoy the views through the panoramic screen watching the water views, golf and out-of-this-world sunsets. This smart home has its security system, Lutron lighting, Sonos speakers, thermostat, pool, spa and more all controlled through your smartphone. No expense spared in this build with impact windows throughout, outdoor sunshades on the lanai, tankless Rinnai water heater, beautiful tile floors throughout, security system and cameras. Large three-car tandem garage, designer blinds, upgraded shower heads, baths and built-out custom closets and pantries. Located in the sought-after Esplanade at Azario community, this home offers resort-style amenities, including a championship golf course, resort-style pool, poolside bar, spa, fitness center, tennis courts and pickleball courts. ($500 food and beverage minimum annually, $5,000 capital contribution due at closing). This is a golf membership home.
| |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017