Off Market Sep 2020 for $370K

$673,871

Est. refi paymentEst. refi $2,413/mo

•

2,944

sq ft

400 Foster Rd, South Windsor, CT 06074

About this home

Very unique home on large level lot with completely updated interior. First floor has been completely remodeled and features new kitchen, bathroom, hardwood floors with a huge family room that has lots of windows overlooking the backyard and exterior access to the patio. Second floor features 4 bedrooms, 3 new bathrooms, new carpet and a large master bedroom suite. Lots of additional new features such as roof, oil tanks, exterior patio, granite stairs, a/c condenser.

Single-familyProperty Type

1976Year Built

0.92 acresLot Size

$229Est. Price/Sq.Ft.

2 car garageParking

Listed by Kris Lippi • Get Listed Realty

Bought with Mark Rondeau • Realty One Group Cutting Edge

Source:Smart MLS #170323712

Redfin Estimate

$673,871

$304K since sold in September 2020$6,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 25.4% higher than the average sale price ($537K) of 6 comparable homes.

SOLD JUN 1, 2026
$600,000
A
4 beds2.5 baths2,641 sq ft
11 Kupchunos Rd, South Windsor, CT 06074
SOLD JUN 12, 2026
$602,025
B
4 beds2.5 baths1,906 sq ft
30 Valley View Dr, South Windsor, CT 06074
SOLD JUL 28, 2026
$569,900
C
4 beds2.5 baths2,080 sq ft
8 Hanover Ln, South Windsor, CT 06074
SOLD AUG 7, 2026
$540,000
D
3 beds2 baths2,124 sq ft
697 Governors Hwy, South Windsor, CT 06074
SOLD DEC 23, 2025
$350,000
E
4 beds3.5 baths3,039 sq ft
88 Andreis Trl, South Windsor, CT 06074
SOLD MAR 13, 2026
$562,500
F
3 beds3 baths3,066 sq ft
51 Carriage Dr, South Windsor, CT 06074

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$372,106

Est. take-home

List your home with Redfin and save $6,739

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,341/mo

Redfin rental estimate

List your home for rent

Market trends in 06074, CT

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

105.9%

0.3% MoM

Median sale price

$463K

$17K MoM

Avg. days on market

10d

1 days MoM

Recently sold homes

116

18 MoM

New listings for sale

COMING SOON
$435,000
3 beds2.5 baths1,938 sq ft
105 High St, South Windsor, CT 06074
OPEN THU, 5PM TO 6PM
$549,900
4 beds2.5 baths2,884 sq ft
26 Rustic Ln, South Windsor, CT 06074
COMING SOON
$349,900
2 beds2.5 baths1,300 sq ft
505 Mill Pond Dr #505, South Windsor, CT 06074
$534,900
4 beds3 baths2,304 sq ft
746 Avery St, South Windsor, CT 06074
COMING SOON
$529,900
3 beds3 baths1,910 sq ft
658 Foster St, South Windsor, CT 06074
$449,900
3 beds2 baths1,414 sq ft
12 Stiles Ct #12, South Windsor, CT 06074
$395,000
3 beds2 baths1,883 sq ft
7 Bittersweet Ln #7, South Windsor, CT 06074
$178,500
2 beds1 bath814 sq ft
949 Pleasant Valley Rd Unit 10-12, South Windsor, CT 06074
$679,900
4 beds2.5 baths2,986 sq ft
20 Christine Ln, South Windsor, CT 06074
OPEN SAT, 10AM TO 1PM
$419,000
3 beds1 bath1,584 sq ft
200 Brook St, South Windsor, CT 06074
See all

Provided by Redfin

Sale history for 400 Foster Rd

Date

Event

Price

Smart MLS #170323712

Sep 30, 2020

Sold

$370,000

$126/sq ft

Aug 11, 2020

Contingent

—

Aug 4, 2020

Listed

$350,000

$119/sq ft

Public Records

May 30, 2019

Sold

$75,000

$25/sq ft

Smart MLS #G10124777

Apr 27, 2016

Listing Removed

—

Apr 13, 2016

Listed

$299,000

$102/sq ft

Smart MLS #G10032274

Oct 1, 2015

Listing Removed

—

Apr 2, 2015

Listed

$339,000

$115/sq ft

Smart MLS #G694618

Nov 30, 2014

Listing Removed

—

Sep 3, 2014

Listed

$342,900

$116/sq ft

Smart MLS #G685350

Jul 31, 2014

Listing Removed

—

Jun 5, 2014

Listed

$359,000

$122/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$12,777 (+3.3%)

$108,500 + $250,300

$358,800

2024

$12,364 (+4.0%)

$108,500 + $250,300

$358,800

2023

$11,891 (+12.0%)

$108,500 + $250,300

$358,800

2022

$10,615 (+2.4%)

$108,500 + $165,300

$273,800

2021

$10,366 (−0.4%)

$108,500 + $165,300

$273,800

2020

$10,406 (+24.1%)

$108,500 + $166,200

$274,700

2019

$8,384 (+2.2%)

$108,500 + $109,270

$217,770

2018

$8,203 (−1.1%)

$108,500 + $109,270

$217,770

2017

$8,293 (−7.5%)

$108,500 + $109,270

$217,770

2016

$8,965 (+5.1%)

$108,500 + $131,600

$240,100

2014

$8,526 (+1.8%)

$108,500 + $131,600

$240,100

2012

$8,379

$108,500 + $131,600

$240,100

Tax history for 400 Foster Rd

Year

Property tax

Land + Additions

Assessment*

2025

$12,777 (+3.3%)

$108,500 + $250,300

$358,800

2024

$12,364 (+4.0%)

$108,500 + $250,300

$358,800

2023

$11,891 (+12.0%)

$108,500 + $250,300

$358,800

2022

$10,615 (+2.4%)

$108,500 + $165,300

$273,800

2021

$10,366 (−0.4%)

$108,500 + $165,300

$273,800

2020

$10,406 (+24.1%)

$108,500 + $166,200

$274,700

2019

$8,384 (+2.2%)

$108,500 + $109,270

$217,770

2018

$8,203 (−1.1%)

$108,500 + $109,270

$217,770

2017

$8,293 (−7.5%)

$108,500 + $109,270

$217,770

2016

$8,965 (+5.1%)

$108,500 + $131,600

$240,100

2014

$8,526 (+1.8%)

$108,500 + $131,600

$240,100

2012

$8,379

$108,500 + $131,600

$240,100

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

0.92 Acres

Year renovated

—

Sq. Ft.

2,944

Year built

1976

Style

Single Family Residential

County

Hartford County

APN

707952

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 10, 2026.

Property details

Parking

Garage Information
Garage & Parking: Attached Garage
Garages Number: 2

Interior

Interior Information
Total Rooms: 9
Laundry Room Info: Lower Level
Interior Features: Open Floor Plan
Fireplaces Total: 2
Cooling System: Central Air
Appliances Included: Electric Cooktop, Oven/Range, Wall Oven, Microwave, Refrigerator, Dishwasher

Bathroom Information
# of Baths (Full): 3
# of Baths (Half): 1

Bedroom Information
Beds Total: 4

Room Information
Basement Description: Crawl Space, Sump Pump
Has Attic

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Brick, Wood

Lot Information
Lot Description: Level Lot

Building Information
Foundation Type: Concrete
Construction Description: Frame, Brick

Property Information
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 2944
Driveway Type: Paved

Financial

Assessments Information
Assessed Value: $274,700

Utilities

Utility Information
Water Source: Public Water Connected
Sewage System: Public Sewer Connected
Hot Water Description: Oil
Heat Type: Hot Air
Heat Fuel Type: Oil
Fuel Tank Location: In Garage

Location

School Information
Middle Jr High School: Edwards
High School: South Windsor
Elementary School: Pleasant Valley

Location Information
State: Connecticut
Directions: Ellington Rd to Foster Rd
County: Hartford

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 2,944
Stories: 2.0
Lot Size: 0.92 acres
Style: Single Family Residential
Year Built: 1976
Year Renovated: —
County: Hartford County
APN: 707952

Home facts updated by county records on Jul 10, 2026

Other

Documents & Disclosures
Supplement Count Public: 1

Around this home

Schools

Pleasant Valley School

Public PreK-5 • Assigned • 2.1mi

9/10

Timothy Edwards School

Public 6-8 • Assigned • 2.5mi

8/10

South Windsor High School

Public 9-12 • Assigned • 1.0mi

10/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Historical weather

South Windsor, CT • 06074

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.1 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.

9.1 hrs

4.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$641,000 – $775,000

Reach more buyers when you sell with Redfin. Save up to $6,739 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

OPEN THU, 5PM TO 6PM

$549,900

4 beds2.5 baths2,884 sq ft

26 Rustic Ln, South Windsor, CT 06074

$459,900

4 beds1.5 baths2,618 sq ft

436 Avery St, South Windsor, CT 06074

NEW CONSTRUCTION

$1,080,000

5 beds4.5 baths3,904 sq ft

460 Miller Rd, South Windsor, CT 06074

OPEN FRI, 5:30PM TO 7:30PM

$469,900

4 beds2.5 baths2,168 sq ft

346 Long Hill Rd, South Windsor, CT 06074

$395,000

3 beds2 baths1,883 sq ft

7 Bittersweet Ln #7, South Windsor, CT 06074

3D WALKTHROUGH

$474,000

3 beds2.5 baths1,890 sq ft

105 Windsorville Rd, South Windsor, CT 06074

New listings for sale in 06074

COMING SOON

$435,000

3 beds2.5 baths1,938 sq ft

105 High St, South Windsor, CT 06074

OPEN THU, 5PM TO 6PM

$549,900

4 beds2.5 baths2,884 sq ft

26 Rustic Ln, South Windsor, CT 06074

COMING SOON

$349,900

2 beds2.5 baths1,300 sq ft

505 Mill Pond Dr #505, South Windsor, CT 06074

$534,900

4 beds3 baths2,304 sq ft

746 Avery St, South Windsor, CT 06074

COMING SOON

$529,900

3 beds3 baths1,910 sq ft

658 Foster St, South Windsor, CT 06074

$449,900

3 beds2 baths1,414 sq ft

12 Stiles Ct #12, South Windsor, CT 06074

$395,000

3 beds2 baths1,883 sq ft

7 Bittersweet Ln #7, South Windsor, CT 06074

$178,500

2 beds1 bath814 sq ft

949 Pleasant Valley Rd Unit 10-12, South Windsor, CT 06074

$679,900

4 beds2.5 baths2,986 sq ft

20 Christine Ln, South Windsor, CT 06074

Home values near 400 Foster Rd

Data from public records.

Address	Redfin Estimate
296 Foster Road, South Windsor, CT 3 Beds \| 2.5 Baths \| 1574 Sq. Ft.	$429,487
416 Foster Road, South Windsor, CT 3 Beds \| 2.5 Baths \| 1504 Sq. Ft.	$493,602

Address	Redfin Estimate
385 Foster Road, South Windsor, CT 3 Beds \| 2.5 Baths \| 1643 Sq. Ft.	$488,841
455 Foster Road, South Windsor, CT 3 Beds \| 2 Baths \| 1831 Sq. Ft.	$476,910

Address	Redfin Estimate
399 Foster Road, South Windsor, CT 3 Beds \| 2 Baths \| 1901 Sq. Ft.	$455,182
340 Foster Road, South Windsor, CT 4 Beds \| 3 Baths \| 1764 Sq. Ft.	$575,377

Property information provided by Smart MLS when last listed in 2020. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Hartford County	Agents near me	Westport, CT homes for sale	Hartford County Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	Hartford County Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

West Hartford homes for sale
Hartford homes for sale
Middletown homes for sale

Worcester County homes for sale
Fairfield County homes for sale
Suffolk County homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06074, CT

Sale history for 400 Foster Rd

Tax history for 400 Foster Rd

Public record

Property details

Around this home

Schools

Lifestyle

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06074

Home values near 400 Foster Rd

More real estate resources