Home / Recently Sold / Stamford
Closed · For Rent
$5,500/mo
Asked $5,650/mo · Sold 2026-07-01

314 Erskine Road, Stamford, Connecticut 06903

4 beds 5 baths 5,894 sq ft Residential Rental Built 1985

About this home

Come see this private North Stamford home beautifully situated on picturesque waterfront property and featuring open, airy rooms! Be the first to enjoy the stunning new kitchen with quartz countertops, new designer baths and polished hardwood floors! A 2-story entry greets and leads to the open living room with sliders to the super large entertainer's deck overlooking scenic postcard views. You'll also find a home-office/den with vaulted ceilings & fireplace in addition to the formal dining room. This home offers 2 Primary bedroom suites, one on the main level featuring sliders to a balcony overlooking the water and a walk-in closet/dressing area, indulgent whirlpool tub and separate shower stall. The second level of this home offers another primary ensuite bedroom, 2 additional bedrooms and designer full bath. The basement offers plenty of storage and flexible additional space ideal for exercise or other pursuits. A 2-car garage, central air and postcard setting complete this idyllic package.

Status
Closed
Type
Residential Rental
Price
$5,500/mo
Beds
4
Baths
5
Interior
5,894 sq ft
Lot
1.67 ac
Year Built
1985
MLS #
24161248
ZIP
06903
Days on Market
95
Heat
Oil · Hot Air
Cooling
Central Air
Water
Private Well
Sewer
Septic
Parking
Attached Garage, Off Street Parking, Driveway (2-car)
Laundry
Main Level — main level

Flood risk: check the FEMA flood map for this address.

Availability, Pets & Lease

Pets
Restrictions
Pet policy
Per owner discretion + pe
Tenant pays
Air Conditioning, All Utilities, Cable TV, Credit Check, Electricity, Grounds Maintenance, Heat, Hot Water, Internet, Liability Insurance, Snow Removal, Trash Service

Schools

Elementary
Roxbury
Middle / Jr High
Cloonan
High School
Westhill

Interior

Appliances
Cook Top, Wall Oven, Range Hood, Refrigerator, Dishwasher, Washer, Dryer
Basement
Full, Storage
Fireplaces
2
Total rooms
12

Building & Exterior

Style
Contemporary
Siding
Stone, Wood
Exterior features
Porch, Deck
New construction
No/Resale

Lot & Land

Zoning
RA2
Lot
Secluded, Rear Lot, Lightly Wooded, Water View
Waterfront
Pond, Walk to Water, View
Direct waterfront
Yes

What's nearby

Grocery
Acme3.59 mi away
Also nearby
Trader Joe's3.7 mi away
Pharmacy
Walgreens5.23 mi away
Train
New Canaan Station5.23 mi awayMetro-North Railroad
Elementary
Roxbury
Middle
Cloonan
High school
Westhill
~4.4 miAcme — 3.59 miTrader Joe's — 3.7 miWalgreens — 5.23 miNew Canaan — 5.23 mi
This homeGroceryPharmacyTrain

Real streets from OpenStreetMap; distances are straight-line from the property, not driving routes.

Distances are straight-line from the property, not driving or walking routes. Places data © OpenStreetMap contributors.

Listing & sale history

Every time this exact home has come to market in the MLS data this site tracks. Where a sale closed, the recorded sale price is shown; "asking" marks a price the home was listed at rather than what it sold for.

2026-07-01Sold — $5,500/mo asked $5,650/mo (this listing)MLS 24161248
2025-01-15Sold — $4,950/moMLS 24034055

Public record

From the Stamford assessor's public property record. These figures describe the property as the town has it on file and can differ from the listing — a finished basement or an addition may not be reflected in the assessor's living area.

Year built1985
Living area5,694 sq ft
Total rooms12
Lot size1.67 acres
Stories1.5
HeatForced Air-Duc
ExteriorVertical
Assessed value$720,170
Town appraisal$1,028,810
Last recorded sale2005 — $1,245,000

Recorded sales

Deed transfers on file with the Stamford land records, newest first. These are recordings rather than MLS sales, so they include transfers that were never listed. Nominal and $0 transfers (estate, trust and family conveyances) are excluded.

Listing courtesy of Coldwell Banker Realty — Melanie Healey · (203) 322-2300

More rentals in Stamford

Closest in price to this one.

← Back to all Stamford listings