This home's estimate is 13.6% lower than the average sale price ($194K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
175 Mill Pond Rd #404, Hamden, CT 06514
About this home
Freshly Updated 2 Bedroom, 1.5 bath ranch style condo at Mill Pond Village is ready for you to move right in! An open floor plan combines the large living room with slider to balcony deck, dining area and the updated kitchen with an open pass-through to the dining area. The kitchen has been updated with new cabinets, vinyl plank floor and new appliances including electric range, range hood, dishwasher and refrigerator. The pass-through window counter creates a nice spot to enjoy your morning coffee while gazing out the dining area window overlooking the woodland setting that surrounds the complex. The unit boasts a half bath and full bath both updated with new vanities and fixtures. The primary bedroom has its own private balcony deck, accessible through sliding glass door - perfect retreat at any time of the day. Adding to the allure of Mill Pond Village is an inground pool to enjoy in warmer months of the year. Each unit has assigned carport and assigned parking space, assigned storage and use of coin operated laundry. The monthly HOA fees include water and sewer fees. The complex is conveniently located near the Farmington Canal walking trail, shopping area, major roads and highways, and restaurants. Short drive to Sleeping Giant State Park, Quinnipiac University, and minutes to downtown New Haven. Don't miss out! SELLER REQUEST HIGHEST & BEST OFFERS BY MONDAY, APRIL 8TH BY 5PM.
Redfin Estimate
Earn from this home
List your home with Redfin and save $1,028
Get cash now or lower your monthly rate
List your home for rent
Market trends in 06514, CT
Last updated October 2026
Buyer's Market
Seller's Market
Balanced market
See all
Provided by Redfin
Sale history for 175 Mill Pond Rd #404
$2/sq ft
$2/sq ft
$182/sq ft
$160/sq ft
$147/sq ft
$159/sq ft
$85/sq ft
$91/sq ft
$39/sq ft
$119/sq ft
$105/sq ft
Tax history for 175 Mill Pond Rd #404
*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: Carport, Assigned Parking
- Garages Number: 1
- Parking Information
- Parking Total Spaces: 1
Interior
- Interior Information
- Total Rooms: 4
- Levels In Unit: 1
- Laundry Room Location: basement
- Laundry Room Info: Coin Op Laundry, Common Laundry Area
- Cooling System: Central Air
- Appliances Included: Electric Range, Range Hood, Refrigerator, Dishwasher
- Bathroom Information
- # of Baths (Full): 1
- # of Baths (Half): 1
- Bedroom Information
- Beds Total: 2
- Room Information
- Basement Description: None
Exterior
- Exterior Features
- Exterior Siding: Aluminum
- Exterior Features: Balcony
- Pool Information
- Swimming Pool
- Pool Description: In Ground Pool
- Building Information
- Construction Description: Frame
- Complex: Mill Pond Village
- Property Information
- Property Type: Condo/Co-Op For Sale
- Property Sub Type: Condominium
- Living Area SQFT Per Public Record: 935
Financial
- Assessments Information
- Assessed Value: $53,410
- Rental Information
- Property Management Type: Professional-Off Site
- Pets Allowed: Restrictions
- Pets Allowed Info: 1 small dog, 1 cat for o/
Utilities
- Utility Information
- Water Source: Public Water Connected
- Sewage System: Public Sewer Connected
- Hot Water Description: Electric, Domestic
- Heat Type: Heat Pump
- Heat Fuel Type: Electric
Location
- Multi-Unit Information
- Unit On Floor Number: 1
- Total Number of Units: 108
- HOA Information
- Has Home Owner's Assocation
- HOA Fee Frequency: Monthly
- HOA Fee Amount: $343
- Association Fee Includes: Grounds Maintenance, Trash Pickup, Snow Removal, Water, Sewer, Property Management, Pool Service, Insurance
- Association Amenities: Pool
- School Information
- High School: Hamden
- Elementary School: Per Board of Ed
- Location Information
- State: Connecticut
- Directions: Sanford Road to Mill Pond Road to Mill Pond Village
- County: New Haven
Public facts
- Beds: 2
- Baths: 1.5
- Sq. Ft.: 935
- Stories: 1.0
- Lot Size: —
- Style: Condo/Co-op
- Year Built: 1985
- Year Renovated: —
- County: New Haven County
- APN: 1141373
About this building
Around this home
Schools
- K - 12
- Preschool & daycare
Public K-6 • Assigned • 0.5mi
Public 7-8 • Assigned • 0.6mi
Public 9-12 • Assigned • 1.4mi
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 98° expected this year, 17 days in 30 years
27% chance of strong winds in next 30 years
4 unhealthy days expected this year, 6 days in 30 years
Sun exposure
In this area, properties receive around 8.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 06514
Home values near 175 Mill Pond Rd #404
| Address | Redfin Estimate |
|---|---|
2 Beds | 1.5 Baths | 935 Sq. Ft. | $189,278 |
2 Beds | 1.5 Baths | 1097 Sq. Ft. | $180,530 |
2 Beds | 1.5 Baths | 1097 Sq. Ft. | $144,089 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $180,980 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $188,321 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $174,527 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $176,871 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1.5 Baths | 977 Sq. Ft. | $189,927 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $187,084 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $183,298 |
2 Beds | 1.5 Baths | 1097 Sq. Ft. | $167,104 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $192,417 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $173,572 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $179,533 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1.5 Baths | 977 Sq. Ft. | $180,663 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $186,104 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $189,924 |
2 Beds | 3.5 Baths | 935 Sq. Ft. | $157,624 |
2 Beds | 1.5 Baths | 935 Sq. Ft. | $183,613 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $177,634 |
2 Beds | 1.5 Baths | 977 Sq. Ft. | $175,538 |
More real estate resources
- Counties
- Cities
- Popular Searches
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