2247 GREENCEDAR DRIVE
About This Property
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 |
|---|---|---|---|
| Sep 24, 2026 | Listed by EXP Realty, LLC | $825,000 | |
| Listed by EXP Realty, LLC | |||
| Aug 3, 2026 | Price Decreased |
$889,800
↓ $10K
(1.1%) | |
| Price Decreased | |||
| Jun 13, 2026 | Listed by Tesla Realty Group, LLC | $899,800 | |
| Listed by Tesla Realty Group, LLC | |||
| |||
|
Welcome to this magnificent Toll Brothers "Columbia" model brick Colonial, perfectly situated on a premium wooded lot in the desirable Cedarday community.
Offering ultimate privacy and a serene backyard setting, this home opens to a grand two-story foyer filled with natural light, flanked by an elegant formal living room and a dining room with gleaming hardwoods.
The seamless, open-concept layout leads to a chef’s dream: an extended gourmet kitchen (featuring a 5-foot extension) complete with a center island, granite countertops, 42-inch cabinetry, and stainless steel appliances. Adjacent, the inviting family room showcases a cozy gas fireplace set under a dramatic cathedral ceiling. A private main-level home office with an elegant bow window, a well-equipped laundry room, and access to the 2-car garage complete the main level.
Upstairs, double doors open to a luxurious owner's suite featuring a private sitting area, a walk-in closet, and a spa-like ensuite bath. The upper level also boasts a second en-suite bedroom and two additional bedrooms joined by a Jack-and-Jill bath.
The fully finished, expansive walk-out basement provides endless opportunities with a large recreation space, a fifth bedroom, a full bathroom, and ample storage.
Built with premium quality, the home features high-end Andersen windows, high-efficiency Toll Brothers insulation, and a reliable Carrier HVAC system. Outside, enjoy exceptional outdoor living on the maintenance-free Trex deck overlooking the quiet woods, with a convenient staircase leading down to a finished patio. Ideally located just minutes from premier shopping, dining, and everyday conveniences, this stunning home perfectly combines comfort, luxury, and an unbeatable setting.
| |||
| Sep 23, 2011 | Sold | ||
| Sold | |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017