1
Map
29128 Celestial
About This Property
Inside, the home opens to a welcoming entry with arched passageways with luxury vinyl plank wood flooring and tile throughout the main level. The interior is enhanced by wood plantation shutters and recessed lighting, creating a bright yet warm atmosphere. Multiple living and dining areas provide flexibility for entertaining, remote work, or multi-generational living.
The open-concept kitchen features granite countertops, abundant cabinetry, walk-in pantry, a stainless steel kitchen sink, and a center island that flows seamlessly into the family room. Built-in cabinetry in the living room adds both function and character.
A bedroom and full bathroom on the main level offer convenience for guests or extended family. Upstairs, Pergo flooring extends through the second level, including the expansive primary suite. The primary bathroom features mosaic tile and travertine flooring, dual vanities, a soaking tub, and a separate shower.
The backyard offers a private outdoor setting highlighted by fruit trees and a wood-burning firepit, ideal for gatherings or quiet evenings. Additional features include a dedicated laundry room and a three-car garage with epoxy flooring.
Conveniently located near schools, parks, shopping, and commuter access, this home offers comfort, space, and thoughtful upgrades throughout.
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 22, 2026 | Sold | ||
| Sold | |||
| Apr 1, 2026 | In contract | - | |
| In contract | |||
| Mar 24, 2026 | Relisted | $659,000 | |
| Relisted | |||
| Mar 22, 2026 | No longer available | - | |
| No longer available | |||
| Mar 14, 2026 | Price Decreased |
$659,000
↓ $10K
(1.5%) | |
| Price Decreased | |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017