39
Map
39 Indian Pipe Drive
About This Property
The dramatic two-story family room is filled with natural light from picturesque windows and features a rear staircase that adds to the home's impressive architectural appeal. The spacious primary suite offers a large walk-in closet, while the recently remodeled, fully finished basement provides tremendous additional living space, a full bath, and excellent in-law potential.
Outside, enjoy your own private retreat with an in-ground pool, expansive patio, and exceptional privacy. Recent exterior improvements include a repaired pool liner, cedar siding replacements, fresh mulch and landscape edging, and updated outdoor lighting completed in summer 2026.
Numerous major updates provide added peace of mind, including a new roof (summer 2025), new furnace, new water heater, and new washer and dryer. Additional highlights include custom ceilings and moldings throughout, dual staircases, refinished hardwood floors, a three-car side-load garage, and beautiful cedar siding.
A wonderfully updated and meticulously maintained home offering exceptional space, privacy, and quality in one of the area's most desirable neighborhoods.
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 15, 2026 | In contract | - | |
| In contract | |||
| Aug 24, 2026 | Listed by Gucciardo Real Estate Group LLC | $1,049,800 | |
| Listed by Gucciardo Real Estate Group LLC | |||
| Oct 15, 2024 | Sold | ||
| Sold | |||
| Aug 2, 2024 | Listed by Gucciardo Real Estate LLC | $905,000 | |
| Listed by Gucciardo Real Estate LLC | |||
| | |||
|
Stunning Marini built Colonial in desirable Pond Hill. Situated on 2.53 acres you will find relaxing comes rather easily as you enjoy this open and upgraded floor plan. Chef quality kitchen with stylish decor similar to what you see in home magazines. Gorgeous quartz counters with SS appliances and as well as room for chef helpers. 2 story fam room with rear staircase and picturesque windows allows lots of sunshine to stream in. Great IG pool with patio and privacy galore. Primary suite with large closet. Full fin bsmnt with great inlaw potential. You will be pleased how nicely updated this home is.
| |||
| Oct 24, 2017 | Sold | ||
| Sold | |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
About Rensselaer
Similar Homes for Sale
Currently no similar homes aroundNearby Rentals
$1,600 /mo
- 3 Beds
- 1 Bath
- 1,053 ft²
$1,100 /mo
- 1 Bed
- 1 Bath
- 3,460 ft²
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017