This home's estimate is 23.4% higher than the average sale price ($642K) 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 $7,916
List your home for rent
Market trends in 06074, CT
Last updated October 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
- K - 12
- Preschool & daycare
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 | 1504 Sq. Ft. | $465,714 |
4 Beds | 1.5 Baths | 1246 Sq. Ft. | $436,997 |
3 Beds | 2.5 Baths | 2024 Sq. Ft. | $520,143 |
3 Beds | 1.5 Baths | 1194 Sq. Ft. | $385,196 |
4 Beds | 1.5 Baths | 1246 Sq. Ft. | $388,392 |
3 Beds | 2.5 Baths | 2457 Sq. Ft. | $595,491 |
3 Beds | 2.5 Baths | 1388 Sq. Ft. | $449,344 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 1831 Sq. Ft. | $459,352 |
3 Beds | 1.5 Baths | 1288 Sq. Ft. | $411,202 |
3 Beds | 2.5 Baths | 2631 Sq. Ft. | $604,928 |
3 Beds | 1.5 Baths | 1288 Sq. Ft. | $397,307 |
3 Beds | 2 Baths | 1831 Sq. Ft. | $495,104 |
4 Beds | 2.5 Baths | 1536 Sq. Ft. | $480,777 |
4 Beds | 4 Baths | 2994 Sq. Ft. | $654,044 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 1832 Sq. Ft. | $530,866 |
3 Beds | 1.5 Baths | 1194 Sq. Ft. | $403,841 |
5 Beds | 2.5 Baths | 2219 Sq. Ft. | — |
3 Beds | 2.5 Baths | 1832 Sq. Ft. | $520,600 |
3 Beds | 3 Baths | 1424 Sq. Ft. | $495,669 |
3 Beds | 2.5 Baths | 1288 Sq. Ft. | $448,058 |
3 Beds | 2 Baths | 1546 Sq. Ft. | $546,408 |
More real estate resources
- Counties
- Cities
- Popular Searches
| Worcester County homes for sale | |||
| Fairfield County homes for sale | |||
| Suffolk County homes for sale |
| West Hartford homes for sale | |||
| Newington homes for sale | |||
| Hartford 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