1
Map
152 Sycamore Circle
About This Property
The first floor features a convenient bedroom and full bathroom, perfect for guests or flexible living arrangements. The eat-in kitchen provides a cozy spot for casual meals and offers great potential for modernization. Additional bedrooms upstairs provide ample space for work, or hobbies. Also boast a new heating system providing year round comfort and efficiency.
Set on a desirable lot in a sought-after community, this home is close to local shops, parks, the university, and all that Stony Brook has to offer. Whether you're an investor, first-time buyer, or someone looking to customize a home to their style, this property is full of promise.
Bring your ideas and make this Stony Brook home shine. . Price is firm, non negotiable
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 |
|---|---|---|---|
| Jun 24, 2026 | Listed by BERKSHIRE HATHAWAY | $639,996 | |
| Listed by BERKSHIRE HATHAWAY | |||
| May 22, 2026 | No longer available | - | |
| No longer available | |||
| Jan 22, 2026 | Price Increased |
$640,000
↑ $5K
(0.8%) | |
| Price Increased | |||
| Jan 20, 2026 | Price Decreased |
$635,000
↓ $50K
(7.3%) | |
| Price Decreased | |||
| Nov 21, 2025 | Listed by BERKSHIRE HATHAWAY | $685,000 | |
| Listed by BERKSHIRE HATHAWAY | |||
| |||
|
Discover the potential in this charming 4-bedroom, 2-bath Cape Cod–style home located in the heart of Stony Brook. Filled with character and ready for your personal touch, this home offers a fantastic opportunity to create the space you’ve always envisioned.
The first floor features a convenient bedroom and full bathroom, perfect for guests or flexible living arrangements. The eat-in kitchen provides a cozy spot for casual meals and offers great potential for modernization. Additional bedrooms upstairs provide ample space for family, work, or hobbies. Also boast a new heating system providing year round comfort and efficiency.
Set on a desirable lot in a sought-after community, this home is close to local shops, parks, the university, and all that Stony Brook has to offer. Whether you’re an investor, first-time buyer, or someone looking to customize a home to their style, this property is full of promise.
Bring your ideas and make this Stony Brook home shine
| |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017