This home's estimate is 21.1% higher than the average sale price ($664K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
470 Foster Rd, South Windsor, CT 06074
About this home
New Construction! Mannarino Built Luxury Custom Home. This Stately Colonial with 4 Bedrooms, 2.5 Bathrooms, 2 Car Garage offers a Custom Kitchen, Granite Counter tops, Stainless Steel Energy Star Appliances and Large Breakfast Bar. Family Room and Dining Area with Open Floor Plan. Propane Gas Fireplace, 9ft Ceilings on first floor, Central Air, Wainscoting, Crown Molding and Hardwood Floors. Formal Dining Room and Living Room with French Doors. Master Suite with Oversized Walk-In Closet, Ensuite Bathroom, Double Sinks, Jetted Tub and Tile Shower. 5th Bedroom could be the Perfect Bonus Room. Maintenance Free 14X16 Trex Deck Leading to a Private Wooded Backyard. Maintenance Free Vinyl Siding. Brick Paver Walkway. This Energy Efficient Home is Close to I-84, I-384,I-291,Buckland Hills Mall, and Evergreen Shopping Center. Ready for Immediate Occupancy.
Redfin Estimate
Earn from this home
List your home with Redfin and save $8,049
List your home for rent
Market trends in 06074, CT
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 470 Foster Rd
$144/sq ft
$148/sq ft
$156/sq ft
$156/sq ft
Tax history for 470 Foster Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Garage Information
- Garage & Parking: Attached Garage
- Garages Number: 2
Interior
- Interior Information
- Total Rooms: 10
- Laundry Room Location: First Floor
- Interior Features: Auto Garage Door Opener, Open Floor Plan, Cable - Pre-wired
- In-Law Apartment: No
- Fireplaces Total: 1
- Cooling System: Central Air
- Appliances Included: Dishwasher, Disposal, Gas Cooktop, Refrigerator, Range Hood, Wall Oven
- Bathroom Information
- # of Baths (Full): 2
- # of Baths (Half): 1
- Bedroom Information
- Beds Total: 5
- Room Information
- Rooms Additional: Bonus Room
- Room Count: 8
- Basement Description: Full With Hatchway, Unfinished
- Has Attic
- Attic Description: Storage Space
Exterior
- Exterior Features
- Exterior Siding: Vinyl Siding
- Exterior Features: Deck
- Property Information
- Property Type: Single Family For Sale
- Driveway Type: Asphalt, Paved
Financial
- Rental Information
- Lease Purchase YN: No
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Public Sewer Connected
- Hot Water Description: Propane
- Heat Type: Hot Air
- Heat Fuel Type: Propane
- Fuel Tank Location: In Ground
- Energy Features: Extra Insulation, Energy Star Rated, Thermopane Windows
- Electric Amperage: 200
Location
- HOA Information
- Association Amenities: Putting Green, Health Club, Medical Facilities, Park
- School Information
- High School: South Windsor
- Elementary School: Wapping
- Location Information
- State: Connecticut
- Nearby Amenities: Golf Course, Health Club, Library, Medical Facilities, Park, Shopping/Mall, Public Trash Pickup
- Directions: GPS Friendly Foster Road (not street)
- County: Hartford
Public facts
- Beds: 4
- Baths: 2.5
- Sq. Ft.: 3,046
- Stories: 2.0
- Lot Size: 1.79 acres
- Style: Single Family Residential
- Year Built: 2016
- Year Renovated: —
- County: Hartford County
- APN: 2666753
Around this home
Schools
Public K-5 • Assigned • 2.4mi
Public 6-8 • Assigned • 2.5mi
Public 9-12 • Assigned • 0.9mi
Lifestyle
Provided by Walk Score and Local Logic
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.
Nearby similar homes
New listings for sale in 06074
Home values near 470 Foster Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 1643 Sq. Ft. | $490,191 |
3 Beds | 2.5 Baths | 1504 Sq. Ft. | $486,565 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 1901 Sq. Ft. | $455,182 |
3 Beds | 2 Baths | 1831 Sq. Ft. | $479,901 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 3.5 Baths | 2944 Sq. Ft. | $685,542 |
3 Beds | 2.5 Baths | 1832 Sq. Ft. | $545,786 |
More real estate resources
- Cities
- Counties
- Popular Searches
| 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 |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
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.





































United States
Canada