27 Celeste Court #LOT71
About This Property
The Chopin floor plan offers 5 bedrooms & 4 full baths, thoughtfully designed to accommodate both everyday living & effortless entertaining. A highly desirable first-floor bedroom provides flexibility for guests, a home office, or multigenerational living, while the open-concept main living area features soaring 10ft ceilings and abundant natural light. A bright and inviting sunroom provides a peaceful retreat with views of the surrounding natural setting.
The thoughtfully designed kitchen features ceiling-height cabinetry, quartz countertops, and a stainless-steel gas range with a vented hood. Quartz countertops continue throughout the home, creating a cohesive & elevated aesthetic. Upstairs, an impressive loft offers versatile additional space ideal for a media room, home office, playroom, or gathering area. The spacious primary suite features a tray ceiling & a well-appointed primary bath with a large tiled shower, double-bowl vanity, and walk-in closet. 3 additional bedrooms, 2 additional bathrooms, and an upstairs laundry room provide exceptional flexibility & convenience.
High-end finishes come standard, including a durable metal roof, impact-rated windows & doors, luxury vinyl plank flooring throughout all common areas & bedrooms, tiled bathrooms, smooth-finish drywall, and 8ft interior doors. During the design appointment, homeowners have the opportunity to further personalize their residence with thoughtfully selected finishes & available upgrades, creating a home that is uniquely their own.
Prices may vary based on lot selection & available upgrades. This listing reflects the base price of the home. Photos are representative & are not of the exact home. Home is not furnished.
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 |
|---|---|---|---|
| Nov 5, 2026 | Listed by EXP Realty LLC | $804,900 | |
| Listed by EXP Realty LLC | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017