Skip main navigation
Off market
  • $1,422,500

    5 Prospect Ct, Hamden, CT 06517

    4beds
    5,690sqft
    SingleFamily
    Built in 2004
    0.45 Acres Lot
    $1,422,500 Zestimate®
    $250/sqft
    $5,038 Estimated rent

    Home value

    $1,422,500

    $1.29M - $1.58M

    $5,038/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $5,038/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,038/mo

    Rent Zestimate®

    Refinance and save

    $10,146/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $10,146/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Stunning newer brick Georgian colonial with 4 bedrooms and 5 baths located on a private cul-de-sac directly past the East Rock/ New Haven borderline. Live on coveted Prospect Hill just steps to THE FOOTE SCHOOL, EDGERTON PARK, and ALBERTUS MAGNUS. Two in law apartments with French doors that lead to the backyard and a stone oversized fireplace is extra space not included in the sq footage. A soaring 2 story foyer with raised paneling welcomes you into this exquisite home. Large living room with gas fireplace and coffered ceilings. Library/billards room with built-ins, can be used as an office. Formal dining room with tray ceiling and raised paneling off foyer and kitchen. Kitchen features top of the line stainless steel appliances, large center island and loads of storage and counter space. Wet bar directly off of kitchen, an entertainers dream space. 2 story family room with another gas fireplace off kitchen. Beautiful master bedroom suite with raised paneling, fireplace, double vanities, jacuzzi tub and walk-in shower. Gleaming hardwood floors throughout the first floor. A secret awaits as you enter the lower level; a revolving bookcase that is a facade for a private wine cellar. Minutes to Yale and downtown New Haven and on the Yale shuttle. A very unique and lavish property. Please call for your private showing.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 6
    • Full bathrooms: 5
    • 1/2 bathrooms: 1
    Heating
    • Other, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Refrigerator
    Features
    • Cable - Available, Open Floor Plan, Auto Garage Door Opener
    • Flooring: Other
    • Basement: Finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 5,690 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stone, Brick
    Lot
    • Size: 0.45 Acres
    Details
    • Parcel number: HAMDM2127B270L000000

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Roof: Slate
    Condition
    • Year built: 2004

    Utilities & green energy

    • Water: Public Water Connected

    Community & neighborhood

    Location
    • Region: Hamden

    Other

    Other facts
    • Appliances Included: Dishwasher, Dryer, Freezer, Range Hood, Washer, Disposal, Refrigerator, Gas Range, Gas Cooktop, Wine Chiller
    • Attic YN: 1
    • Attic Description: Walk-up, Finished
    • Direct Waterfront YN: 0
    • Exterior Features: Garden Area, Lighting, Patio, French Doors
    • Home Warranty Offered YN: 0
    • Basement Description: Fully Finished, Heated, Apartment, Cooled, Full With Walk-Out
    • Interior Features: Cable - Available, Open Floor Plan, Auto Garage Door Opener
    • Nearby Amenities: Park, Walk to Bus Lines, Private School(s), Shopping/Mall, Health Club, Playground/Tot Lot, Tennis Courts, Public Pool
    • Room Count: 0
    • Property Type: Single Family For Sale
    • Cooling System: Central Air
    • Driveway Type: Asphalt
    • Style: Colonial
    • Swimming Pool YN: 0
    • Heat Fuel Type: Natural Gas
    • Fuel Tank Location: Non Applicable
    • Hot Water Description: Natural Gas
    • Heat Type: Hot Air
    • Sewage System: Public Sewer Connected
    • Water Source: Public Water Connected
    • Fireplaces Total: 6
    • In Law Apartment YNP: Yes
    • Exterior Siding: Brick
    • Construction Description: Frame
    • Foundation Type: Concrete
    • Waterfront Description: Not Applicable
    • Roof Information: Slate
    • Assessed Value: 684670
    • Lot Description: Professionally Landscaped
    • Laundry Room Info: Upper Level
    • Property Tax: 30988
    • Tax Year: July 2017-June 2018

    Price history

    DateEventPrice
    11/1/2018Listing removed$825,000$145/sqft
    Source: Real Living Wareck D'Ostilio #170085144 Report a problem
    5/17/2018Price change$825,000-17.1%$145/sqft
    Source: Real Living Wareck D'Ostilio #170085144 Report a problem
    3/27/2018Price change$995,000-9.5%$175/sqft
    Source: Real Living Wareck D'Ostilio #170045751 Report a problem
    3/6/2018Listed for sale$1,100,000-26.7%$193/sqft
    Source: Real Living Wareck D'Ostilio #170045751 Report a problem
    5/26/2016Listing removed$1,500,000$264/sqft
    Source: GRL & Realtors, LLC #N351851 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$50,149 +48.4%$966,630 +59.1%
    2024$33,789 -1.4%$607,600
    2023$34,256 +1.6%$607,600

    Find assessor info on the county website

    Neighborhood: 06517

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Spring Glen
    • Middle: Hamden
    • High: Hamden

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $1,422,500
    2% more
    +$28,450
    With Zillow Showcase(estimated)
    $1,450,950