130 Turn of River Road | Stamford Turn Of River

$1,995,000 | 4 Beds | 4 Baths (3 Full, 1 Half) | 4,560 Sq. Ft.

Get excited about this stunning modern farmhouse nestled in one of the most desirable areas of Turn of River! Boasting approximately 4,600 square feet of beautifully designed living space, this home blends timeless charm with sleek, modern comforts. Step inside to an open floor plan with soaring 9-foot ceilings and seamless indoor/outdoor flow-perfect for entertaining year-round. The heart of the home features bright, airy living spaces that open onto a private backyard retreat. With 4 spacious bedrooms, including a luxurious primary suite, a private en-suite, and a classic Jack & Jill, there's room for everyone to feel at home. Need more space? A full walk-up attic and a large basement (24' x 46') offer endless possibilities, while the property also allows for a potential Accessory Dwelling Unit-ideal for guests, extended family, or rental income. Enjoy peace of mind with top-tier energy efficiency: hot air fueled by natural gas, a high-efficiency 60-gallon hot water tank, hydro air heating, central A/C, public water and sewer, and a rare 5-star efficiency rating. All of this, just minutes from the Sterling Golf Course, tennis courts, great dining, shopping, and the Merritt Parkway. SmartMLS 24090278

Directions to property: High Ridge Rd to Turn of River Rd

MLS Listing ID: 
SmartMLS 24090278
Building Details
Details about the building on a property.
Architectural Style: 
Farm House
Year Built: 
2025
Living Area: 
4,560
Fireplaces: 
2
Construction
Foundation Details: 
Concrete
Roof: 
Asphalt Shingle
Exterior: 
Clapboard
Room Details
Details about the rooms in the building.
Total Rooms: 
7
Total Bedrooms: 
4
Total Bathrooms: 
4
Total Full-Bathrooms: 
3
Total Half-Bathrooms: 
1
Utilities
Information about utilities available on the property.
Heating System: 
Hydro Air
Heating System Fuel: 
Gas In Street
Cooling System: 
Central Air
Water Source: 
Public Water Connected
Sewer: 
Public Sewer Connected
Lot/Land Details
Details about the lots and land features included on the property.
Acres: 
0.35
Waterfront: 
0
Water Body Category: 
Not Applicable
Lot Features
Garage: 
None
Public Record
Parcel Number: 
999999999
Annual Tax: 
$3,303.00
Property Zoning: 
R10
Listing Dates
Dates involved in the transaction.
Listing Entry Date/Time: 
4/25/2025
Contract Details
Details about the listing contract.
Possession: 
After house is built
Listing Participants
Participants (agents, offices, etc.) in the transaction.
Listing Agent Name: 
Phyllis Doonan
Listing Office Name: 
William Raveis Real Estate