$1,800,000

Estimated payment $11,598/month

Total Views 41,019
5 Beds
6.5 Baths
6,034 Sq Ft
$298 Price per Sq Ft

Highlights

  • Colonial Architecture
  • Attic
  • Balcony
  • Deck
  • 3 Fireplaces
  • Thermal Windows

About This Home

Step into timeless elegance with this newly constructed 6,034 sq. ft. Colonial masterpiece, featuring a legally finished walk-out basement with an additional 2,678 sq. ft.-where luxury meets meticulous craftsmanship. Set behind stately stone pillars, the home welcomes you with a sweeping driveway, manicured gardens, and a pool site ready for your dream oasis. Inside, a sun-drenched, two-story marble foyer sets the stage for stunning architectural details throughout, including exquisite millwork, rich herringbone-patterned hardwood floors, and three fireplaces. Expansive windows flood the interior with natural light, while dual staircases add both grandeur and convenience. Perfect for entertaining and everyday living, the home offers an effortless flow between generously scaled rooms, all crowned by dramatic ceilings. Upgrades include a brand-new $40,000 HVAC system, a Well Pump and Wire (2022), a Hot Water Heater (2021), a Bosch AC System (2021) and Smart Home features (thermostats, lights, doors, cameras, garage doors) that provide year-round comfort in this extraordinary, move-in-ready residence. Assumable 10 year arm at 2 1/2 percent for about 1.1 million on this house. 6 years remaining.

Listing Agent

Ken Wile

Redfin Corporation License #REB.0791932 Listed on: 07/17/2025

Redfin Corporation

Co-Listing Agent

Zhizhe Dong

Redfin Corporation License #RES.0812693

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $25,104

Year Built

  • Built in 2003

Lot Details

  • 1 Acre Lot
  • Property is zoned RA1

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Clap Board Siding
  • Stone Siding
  • Radon Mitigation System

Interior Spaces

  • 6,034 Sq Ft Home
  • Central Vacuum
  • 3 Fireplaces
  • Thermal Windows
  • Walkup Attic

Kitchen

  • Oven or Range
  • Microwave
  • Bosch Dishwasher
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Laundry on upper level
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Home Security System
  • Storm Windows
  • Storm Doors

Parking

  • 3 Car Garage
  • Parking Deck

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Exterior Lighting

Schools

  • Northeast Elementary School
  • Turn Of River Middle School
  • Westhill High School

Utilities

  • Central Air
  • Heating System Uses Oil
  • Private Company Owned Well
  • Oil Water Heater
  • Fuel Tank Located in Basement

Listing and Financial Details

  • Exclusions: Please see the inclusion exclusions form.
  • Assessor Parcel Number 2307590

Home Details

Home Type

Single Family

Est. Annual Taxes

$25,104

Year Built

Built in 2003

Lot Details

0

Listing Details

  • Neighborhood: North Stamford
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 6034
  • Total Sq Ft: 6034
  • Year Built: 2003
  • New Construction: No/Resale
  • Nearby Amenities: Park
  • Exclusions: Please see the inclusion exclusions form.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Yes
  • Directions: Please use GPS.
  • Living Area Sq Ft Per Public Record: 6034
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 5
  • Total Bathrooms: 7
  • Full Bathrooms: 6
  • Half Bathrooms: 1
  • Fireplaces: 3
  • Attic Description: Walk-up
  • Basement Description: Full, Fully Finished, Walk-out
  • Interior Amenities: Central Vacuum, Security System
  • Appliances: Oven/Range, Microwave, Refrigerator, Dishwasher, Washer
  • Laundry Room Info: Upper Level
  • Attic: Yes
  • Street Number Modifier: 40

Exterior Features

  • Exterior Features: Balcony, Deck, Lighting, Patio
  • Exterior Siding: Clapboard, Stone
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 3
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: Oil, Domestic
  • Water Source: Private Well
  • Sewer: Septic

Schools

  • Elementary School: Northeast
  • Middle School: Turn of River
  • High School: Westhill
  • Intermediate School: Per Board of Ed

Green Features

  • Energy Features: Storm Doors, Storm Windows, Thermopane Windows

Lot Info

  • Acres: 1
  • Lot Description: Fence - Partial Fence - Stone Level Lot
  • Zoning: RA1
  • Parcel #: 2307590

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 25104
  • Total Assessed Value: 1078800
  • Mil Rate Total: 24.57

MLS Schools

  • Elementary School: Northeast
  • Middle Jr High School: Turn of River
  • High School: Westhill

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $25,104 $1,078,800 $255,450 $823,350
2024 $24,553 $1,078,800 $255,450 $823,350
2023 $26,387 $1,078,800 $255,450 $823,350
2022 $23,013 $874,040 $193,520 $680,520
2021 $22,699 $874,040 $193,520 $680,520
2020 $22,139 $874,040 $193,520 $680,520
2019 $22,139 $874,040 $193,520 $680,520
2018 $21,370 $874,040 $193,520 $680,520
2017 $25,960 $965,420 $201,940 $763,480
2016 $23,962 $965,420 $201,940 $763,480
2015 $23,305 $965,420 $201,940 $763,480
2014 $22,504 $965,420 $201,940 $763,480
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/17/2025 07/17/25 For Sale $1,800,000 +29.0% $298 / Sq Ft
06/28/2021 06/28/21 Sold $1,395,000 -3.7% $194 / Sq Ft
04/06/2021 04/06/21 For Sale $1,449,000 +20.8% $201 / Sq Ft
01/23/2015 01/23/15 Sold $1,200,000 -14.2% $167 / Sq Ft
12/24/2014 12/24/14 Pending -- -- --
05/12/2014 05/12/14 For Sale $1,399,000 -- $194 / Sq Ft
Source: SmartMLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $1,395,000 None Available
Warranty Deed $120,000 --
Warranty Deed $170,000 --
Warranty Deed $1,620,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $286,500 Stand Alone Refi Refinance Of Original Loan
Open $1,116,000 Purchase Money Mortgage
Closed $139,500 Purchase Money Mortgage
Previous Owner $700,000 No Value Available
Previous Owner $700,000 No Value Available
Source: Public Records

Source: SmartMLS

MLS Number: 24111962

SmartMLS

APN: STAM-000004-000000-002606