451 Avenida Esplendor
About This Property
The property has great curb appeal, with a landscaped front yard, a gated paver driveway and no front-facing garage.
Inside the ornate double front doors, you'll find a dramatic foyer with soaring ceilings, marble floors, custom millwork and lots of natural light.
Beyond the parlor & formal dining room, the kitchen & living room anchor the rear of the floorplan. The gorgeous chef's kitchen features Shaker cabinetry, pro-grade stainless appliances, a granite slab backsplash and a massive quartz-topped island with a waterfall edge and seating for a crowd. There's also a beverage center, family drop zone and lovely gold fixtures – no detail was overlooked here!
The main level includes two large guest rooms – each with attached bathrooms. Perfect for in-laws or visitors!
Head upstairs to find the laundry room, a BONUS living room and the rest of the bedrooms. The isolated primary bedroom boasts a spa-like ensuite with a custom walk-in closet, a W/C, his&her vanities, a frameless glass shower and a free-standing soaking tub. (It's 5 bedrooms and 6 bathrooms, and the upstairs bonus space can be converted to a bedroom)
There are three guest rooms on the upper level – one even has a private balcony with amazing views! All guest rooms also include a stylish ensuite with all the same high-end materials found throughout the rest of the home.
Outside, the backyard backs up to a retaining wall, but the property line extends all the way up the hill, offering room for your garden, playscape or future pool. Don't forget about the 3-bay garage, with epoxy floors and tons of storage space.
This beautiful home is zoned to award-winning Walnut schools (all within 1.5 mi), with numerous hiking trails close by, too. There are countless shopping & dining options just 5 mins from your front door, and you can hop on the 60 Fwy in no time at all! You must come see this nearly-new MOVE-IN-READY home in person!
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 |
|---|---|---|---|
| Apr 10, 2026 | Sold | ||
| Sold | |||
| Apr 4, 2026 | In contract | - | |
| In contract | |||
| Sep 15, 2025 | Listed by Pinnacle Real Estate Group | $2,100,000 | |
| Listed by Pinnacle Real Estate Group | |||
| Jul 18, 2025 | Price Decreased |
$2,098,000
↓ $92K
(4.2%) | |
| Price Decreased | |||
| Jun 17, 2025 | Price Decreased |
$2,190,000
↓ $210K
(8.8%) | |
| Price Decreased | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017