This home's estimate is 34.6% lower than the average sale price ($495K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
174 Prospect Hill Rd, Windsor, CT 06095
About this home
HIGHEST AND BEST OFFERS DUE BY 2/15/2024 AT 11:00AM. This raised ranch has a BRAND NEW ROOF, 3 bedrooms, 3 full baths, wood flooring in most rooms, and a fully finished basement. The living room has a bay window and wood flooring. The dining room abuts the living room, and has a French doors that lead to the multi-level deck overlooking the back yard. The kitchen has oak cabinetry and tile flooring. All three bedrooms have wood flooring, and the main bedroom has its own full bath with walk in shower. The lower level is fully finished, including a room with a fireplace, bar, and French doors leading to the deck in the back yard. There is also another separate room that could be used for an office, den, or whatever else you can think of, and another room with shelving for additional storage. This house has a 2 car attached garage, and is situated on a corner lot with a level yard and some trees. Schedule a showing today!
Redfin Estimate
Earn from this home
List your home with Redfin and save $3,239
List your home for rent
Market trends in 06095, CT
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 174 Prospect Hill Rd
$290/sq ft
$258/sq ft
$210/sq ft
Tax history for 174 Prospect Hill 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: 8
- Laundry Room Location: Basement
- Laundry Room Info: Lower Level
- Fireplaces Total: 1
- Bathroom Information
- # of Baths (Full): 3
- Bedroom Information
- Beds Total: 4
- Room Information
- Room Count: 6
- Basement Description: Full, Fully Finished
- Has Attic
- Attic Description: Access Via Hatch
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Aluminum
- Exterior Features: Deck
- Lot Information
- Lot Description: Level Lot
- Building Information
- Foundation Type: Concrete
- Construction Description: Frame
- Property Information
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 1240
- Driveway Type: Asphalt
Financial
- Assessments Information
- Assessed Value: $156,100
Utilities
- Utility Information
- Water Source: Public Water Connected
- Sewage System: Public Sewer Connected
- Hot Water Description: Oil
- Heat Type: Baseboard
- Heat Fuel Type: Oil
- Fuel Tank Location: Above Ground
Location
- School Information
- High School: Per Board of Ed
- Elementary School: Per Board of Ed
- Location Information
- State: Connecticut
- Directions: Poquonock Ave to Prospect Hill Road.
- County: Hartford
Public facts
- Beds: 4
- Baths: 3.0
- Sq. Ft.: 1,240
- Stories: 1.0
- Lot Size: 0.61 acres
- Style: Single Family Residential
- Year Built: 1979
- Year Renovated: —
- County: Hartford County
- APN: 772281
Other
- Documents & Disclosures
- Supplement Count Public: 1
Around this home
Schools
Public PreK-2 • Assigned • 0.8mi
Public 6-8 • Assigned • 3.7mi
Public 9-12 • Assigned • 3.8mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 97° expected this year, 16 days in 30 years
27% chance of strong winds in next 30 years
2 unhealthy days expected this year, 3 days in 30 years
Sun exposure
In this area, properties receive around 9 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 06095
Home values near 174 Prospect Hill Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 1.5 Baths | 2474 Sq. Ft. | $447,007 |
3 Beds | 2 Baths | 1736 Sq. Ft. | $318,056 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1398 Sq. Ft. | $371,228 |
3 Beds | 3 Baths | 2320 Sq. Ft. | $427,282 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1294 Sq. Ft. | $369,517 |
3 Beds | 1 Baths | 1188 Sq. Ft. | $302,465 |
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 | |||
| Hartford homes for sale | |||
| Middletown 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