45
Map
38 Columbia
About This Property
The lower level offers a spacious and inviting den, a private bedroom, full bathroom, and laundry area. A separate walk-out entrance adds convenience and offers flexible living potential.
Main-level you'll find 2 bedrooms, full bathroom, a bright and airy living room, and an open-concept kitchen and dining area-perfect for everyday living and entertaining. Sliding glass doors lead to an elevated deck overlooking a beautifully large & leveled backyard.
(Seedlings have just been placed)
At the heart of the outdoor space is a 16' x 32' in-ground pool, featuring brand-new vinyl lining and a surrounding deck that offers generous space for outdoor dining, lounging, and summer gatherings-creating a true backyard oasis.
Engineered hardwood throughout brand new roof brand new siding with insulation
*New roof
*Brand new windows throughout.
*Waterproofing for the basement.
*LED recessed lighting throughout
*Washer dryer coming in next week
Potential Mother/Daughter or Rental Income Investment with proper permits.
All information is deemed reliable but should be independently verified.
A 2.5% Peconic Bay Region Community Preservation Transfer Tax may apply to the purchaser
Proof of funds required with all offers.
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 |
|---|---|---|---|
| Aug 1, 2026 | Sold | ||
| Sold | |||
| Jun 4, 2026 | Sold | ||
| Sold | |||
| May 8, 2026 | In contract | - | |
| In contract | |||
| Mar 11, 2026 | Listed by Signature Premier Properties | $999,000 | |
| Listed by Signature Premier Properties | |||
| |||
|
Experience modern living in this newly renovated split-level home, thoughtfully designed for comfort, flexibility, and style. The interior boasts brand-new windows throughout and a contemporary kitchen equipped with sleek stainless steel appliances.
The lower level offers a spacious and inviting den, a private bedroom, full bathroom, and laundry area. A separate walk-out entrance adds convenience and offers flexible living potential, perfect for a family room, guest quarters and so much more.
Main-level you'll find 2 bedrooms, full bathroom, a bright and airy living room, and an open-concept kitchen and dining area—perfect for everyday living and entertaining. Sliding glass doors lead to an elevated deck overlooking a beautifully large & leveled backyard.
At the heart of the outdoor space is a 16' x 32' in-ground pool, featuring brand-new vinyl lining and a surrounding deck that offers generous space for outdoor dining, lounging, and summer gatherings—creating a true backyard oasis.
Engineered hardwood throughout.
Waterproofing for the basement, LED recessed lighting throughout. New Washer and dryer are pending delivery.
**All information is deemed reliable but should be independently verified.
A 2.5% Peconic Bay Region Community Preservation Transfer Tax may apply to the purchaser
Proof of funds required with all offers**
| |||
| Dec 23, 2025 | In contract | - | |
| In contract | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017