Skip main navigation
Off market
  • $1,455,000

    5 Prospect Ct, Hamden, CT 06517

    4beds
    5,690sqft
    SingleFamily
    Built in 2004
    0.45 Acres Lot
    $1,455,000 Zestimate®
    $256/sqft
    $5,463 Estimated rent

    Home value

    $1,455,000

    $1.32M - $1.60M

    $5,463/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,463/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,463/mo

    Rent Zestimate®

    Refinance and save

    $8,734/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

    $8,734/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 not currently displayed as for sale or rent on Zillow. This may be different from what's 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 & HOA

    Location
    • Region: Hamden

    Financial & listing details

    • Price per square foot: $256/sqft
    • Tax assessed value: $966,630
    • Annual tax amount: $50,149

    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
    2/4/2015Price change$1,500,000-11.8%$264/sqft
    Source: GRL & Realtors, LLC #N351851 Report a problem
    7/14/2014Listed for sale$1,700,000+13.7%$299/sqft
    Source: GRL & Realtors, LLP #N351851 Report a problem
    4/3/2012Listing removed$1,350
    Source: WEICHERT REALTORS-REGIONAL PRO #N322095 Report a problem
    1/25/2012Listed for rent$1,350
    Source: WEICHERT REALTORS-REGIONAL PRO #N322095 Report a problem
    7/19/2009Listing removed$1,495,000$263/sqft
    Source: Press/Cuozzo Realtors #N289616 Report a problem
    3/24/2009Price change$1,495,000-16.7%$263/sqft
    Source: Listhub #N289616 Report a problem
    11/9/2008Listed for sale$1,795,000+1203.6%$315/sqft
    Source: Listhub #N289616 Report a problem
    9/6/2002Sold$137,700+175.4%$24/sqft
    Source: Public Record Report a problem
    8/5/1996Sold$50,000+17.6%$9/sqft
    Source: Public Record Report a problem
    9/16/1991Sold$42,500$7/sqft
    Source: Public Record 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
    2022$33,710 +5.8%$607,600
    2021$31,863 +0%$607,600 +5.2%
    2020$31,863 -4.8%$577,500 -15.7%
    2019$33,453 +1.9%$684,670
    2018$32,837 +6%$684,670
    2017$30,988 -0.2%$684,670
    2016$31,057 +22.7%$684,670 +10.6%
    2015$25,310 +2.4%$619,290
    2014$24,728 +2.5%$619,290
    2013$24,115 +4.8%$619,290
    2012$23,000 +6.8%$619,290
    2011$21,533 -0.8%$619,290 -16.1%
    2010$21,706 +0%$737,800
    2009$21,699 0%$737,800
    2008$21,706 +1.1%$737,800
    2007$21,470 +4.1%$737,800
    2006$20,622 +186.6%$737,800 +343.4%
    2005$7,195 +263.9%$166,390 +216.5%
    2003$1,977 +9.1%$52,570
    2001$1,812 $52,570
    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,455,000
    2% more
    +$29,100
    With Zillow Showcase(estimated)
    $1,484,100