RENTED MAY 22, 2026

175 Mill Pond Rd Unit 215 Hamden, CT 06514

Estimated Value: $156,000 - $180,000

2 Beds
1.5 Baths
977 Sq Ft
$174/Sq Ft Est. Value

Highlights

  • In Ground Pool
  • Partially Wooded Lot
  • Ceiling Fan
  • Property is near public transit and shops
  • Public Transportation
  • Baseboard Heating

About This Home

As of May 2026

This beautifully updated 2-bedroom, 1.5-bath unit offers the perfect mix of comfort, convenience, and natural surroundings. Bright and open, it features wood floors in the living and dining rooms, newly painted interiors throughout, and modern updates including LED recessed lighting in the living room, kitchen, and hallway. The dining room and bedrooms include new ceiling fans with light fixtures, and the dining area opens to a private outdoor deck surrounded by nature. You'll also enjoy the rare convenience of an in-unit washer/dryer, efficient AC and heating units, and access to a community pool during the summer months. A dumpster is located on-site for easy disposal. Located just 10 minutes from Quinnipiac University's Hamden Campus and Sleeping Giant State Park, 20 minutes from Quinnipiac's North Haven Campus and Yale University, this home offers both tranquility and accessibility. Step right into your backyard and onto the scenic Farmington Canal Heritage Trail for walking, running, or biking.

Last Agent to Rent the Property

Alan Spotlow

William Raveis Real Estate Brokerage Phone: (203) 584-4300 License #RES.0819730 Listed on: 10/22/2025

William Raveis Real Estate

Last Renter's Agent

Marilyn E. Profit

Coldwell Banker Realty License #RES.0821598

Coldwell Banker Realty

Property Details

Home Type

  • Apartment

Year Built

  • Built in 1985

Home Design

  • Wood Siding

Interior Spaces

  • 977 Sq Ft Home
  • Ceiling Fan

Kitchen

  • Electric Range
  • Dishwasher

Bedrooms and Bathrooms

  • 2 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Utilities

  • Window Unit Cooling System
  • Baseboard Heating

Additional Features

  • In Ground Pool
  • Partially Wooded Lot
  • Property is near public transit and shops

Listing and Financial Details

  • Assessor Parcel Number 1141326

Community Details

Amenities

  • Public Transportation

Pet Policy

  • Pets Allowed with Restrictions

Property Details

Home Type

Apartment

Year Built

Built in 1985

Lot Details

0 Sq Ft Lot

Rental Info

  • Lease Price Description: Per Month
  • Pets Allowed: Restrictions
  • Rental Duration: Yearly Unfurnished
  • Smoking Allowed: No

Listing Details

  • Neighborhood: N/A
  • Property Type: Residential Rental
  • Style: Apartment
  • Sq Ft Est Heated Above Grade: 977
  • Total Sq Ft: 977
  • Year Built: 1985
  • New Construction: No/Resale
  • Nearby Amenities: Commuter Bus, Medical Facilities, Park, Public Transportation, Shopping/Mall
  • Property Sub Type: Condominium Rental
  • Direct Waterfront: No
  • Directions: When pulling into the complex, stay to the left and head up the hill.
  • Street Type: Road
  • Tenant Responsibility: Credit Check Electricity Heat Hot Water Internet Liability Insurance
  • Office Attribution Contact: (203) 453-0391
  • Reserve Prospect: No
  • Special Features: None

Interior Features

  • Total Bedrooms: 2
  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Basement Description: None
  • Appliances: Electric Range, Refrigerator, Dishwasher, Washer, Dryer
  • Laundry Room Info: Main Level
  • Attic: No

Exterior Features

  • Exterior Siding: Wood
  • Waterfront Description: Not Applicable
  • Swimming Pool: Yes
  • Pool: In Ground Pool

Utilities

  • Cooling System: Ceiling Fans, Window Unit
  • Heat Type: Baseboard
  • Heat Fuel Type: Electric
  • Hot Water Description: Domestic
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Lot Info

  • Lot Description: Lightly Wooded
  • Zoning: R5
  • Parcel #: 1141326

MLS Schools

  • Elementary School: Per Board of Ed
  • High School: Per Board of Ed

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
May 10, 2023
Sold by
Bought by
Current Estimated Value
$169,587

Purchase Details

Closed on
Aug 5, 2010
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$84,000
Interest Rate
4.73%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$139,000 None Available
$105,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Previous Owner $84,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
05/22/2026 05/22/26 Rented $2,000 0.0% --
05/22/2026 05/22/26 Under Contract -- -- --
10/22/2025 10/22/25 For Rent $2,000 -- --
Source: SmartMLS

Agents Affiliated with this Home

  • A

    Landlord's Agent in 2026

    Alan Spotlow

    William Raveis Real Estate

    (203) 584-4300

    84 Total Sales

    Alan Spotlow
    Section Image
  • Marilyn E. Profit

    Tenant's Agent in 2026

    Marilyn E. Profit

    Coldwell Banker Realty

    (203) 526-4152

    109 Total Sales

    Marilyn E. Profit
    Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24135263

SmartMLS

APN: HAMD-002728-000043-000000-000032

Connecticut New Haven County Hamden 06514

175 Mill Pond Rd Unit 215, Hamden, CT

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

SmartMLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.