Skip main navigation
Off market
Street View
  • $1,322,800

    295 Erskine Rd, Stamford, CT 06903

    5beds
    6,096sqft
    SingleFamily
    Built in 1827
    2 Acres Lot
    $1,322,800 Zestimate®
    $217/sqft
    $8,213 Estimated rent
    Maximize your home sale
    Get more eyes on your listing so you can sell faster and for more.

    Home value

    $1,322,800

    $1.22M - $1.46M

    $8,213/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $8,213/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $8,213/mo

    Rent Zestimate®

    Refinance and save

    $7,455/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $7,455/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    This spectacular home has been beautifully restored....nothing to do but move in. Idyllic setting on established North Stamford street. The meticulous renovations include all baths with marble and high end fixtures, kitchen appliances, all new heating and air, newer over-sized thermal windows. septic system, well and well pump and a water purifying system. Wonderfully versatile home with a first floor guest room that may also be used as a master. The master suite on the second floor overlooks the spring fed pond from the Mianus watershed and ever changing waterfall. Some retained historical features include stone-flagged entry with wood chestnut beams, original pine floors, stamped tin ceiling and iron fencing. These gorgeous grounds offer some of the most breathtaking views of any North Stamford property. A dramatic Waterfall , an old fashioned swimming hole, now used for fishing, ice skating and swimming, fruit trees, gracefully aged magnolia, cooper beach and pine trees, perennial flowering plants offer seasons of pure ascetic joy and wonderful privacy on 2 acres. Only 6 owners yet such interesting history including visits from Anna Freud, Jackie Kennedy Onassis and Marilyn Monroe.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Oil
    Features
    • Security System, Auto Garage Door Opener
    • Basement: Partially finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 6,096 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Wood
    Lot
    • Size: 2 Acres
    Details
    • Parcel number: STAMM000B5992

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Roof: Asphalt
    Condition
    • Year built: 1827

    Utilities & green energy

    • Water: Private Well

    Community & neighborhood

    Location
    • Region: Stamford

    Other

    Other facts
    • Appliances Included: Dishwasher, Freezer, Washer, Refrigerator, Electric Cooktop, Electric Dryer
    • Attic YN: 1
    • Energy Features: Thermopane Windows, Programable Thermostat
    • Interior Features: Security System, Auto Garage Door Opener
    • Exterior Features: Stone Wall, Porch-Screened, Terrace, Fruit Trees
    • Exterior Siding: Clapboard, Wood
    • Fireplaces Total: 1
    • Fuel Tank Location: Above Ground
    • Home Warranty Offered YN: 0
    • Heat Fuel Type: Oil
    • Direct Waterfront YN: 1
    • Nearby Amenities: Library, Park, Public Rec Facilities, Private School(s), Shopping/Mall, Medical Facilities, Tennis Courts, Golf Course
    • Lot Description: Lightly Wooded, Water View, Fence - Full
    • Waterfront Description: Pond, Beach Rights, View, Direct Waterfront
    • Basement Description: Unfinished, Partial
    • Property Type: Single Family For Sale
    • Cooling System: Central Air, Zoned
    • Driveway Type: Asphalt, Circular
    • Sewage System: Septic
    • Style: Colonial, Antique
    • Swimming Pool YN: 0
    • Water Source: Private Well
    • Flood Zone YN: 0
    • Heat Type: Hot Air, Zoned
    • Hot Water Description: Electric
    • Rooms Additional: Workshop, Mud Room, Laundry Room
    • In Law Apartment YNP: Possible
    • Room Count: 13
    • Radon Mitigation Air YNU: Yes
    • Construction Description: Frame
    • Foundation Type: Stone
    • Roof Information: Asphalt Shingle
    • Exclusions: Call LB
    • Property Tax: 13835
    • Laundry Room Info: Main Level
    • Assessed Value: 540640
    • Tax Year: July 2017-June 2018

    Price history

    DateEventPrice
    11/16/2018Sold$775,000-3%$127/sqft
    Source: Smart MLS #170118209
    10/19/2018Pending sale$799,000$131/sqft
    Source: Coldwell Banker Residential Brokerage - Greenwich Office #170118209
    9/25/2018Price change$799,000-8.7%$131/sqft
    Source: Coldwell Banker Residential Brokerage - Greenwich Office #170118209
    8/23/2018Price change$875,000-5.4%$144/sqft
    Source: Coldwell Banker Residential Brokerage - Greenwich Office #170118209
    5/9/2018Price change$925,000-7%$152/sqft
    Source: Coldwell Banker Residential Brokerage - Greenwich Office #170054291

    Public tax history

    YearProperty taxesTax assessment
    2025$16,455 +2.6%$704,400
    2024$16,032 -7%$704,400
    2023$17,230 +17%$704,400 +26%

    Find assessor info on the county website

    Neighborhood: North Stamford

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Roxbury
    • High: Westhill

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a free Zillow Showcase℠ listing and you could sell for .
    $1,322,800
    2% more+ $26,456
    With Zillow Showcase(estimated)
    $1,349,256