For Sale
Photo 1 of House for sale at 244 Sherman Ave, Hamden, CT 06518 | MLS# 24189456 | Listing updated on 2026-09-16
Photo 2 of House for sale at 244 Sherman Ave, Hamden, CT 06518 | MLS# 24189456 | Listing updated on 2026-09-16
2
Beds Icon

Street View

$499,900

Monthly Est:$2,488

  • Beds Icon6 Beds
  • Beds Icon
    4 Baths
  • Beds Icon4,090sqft

244 Sherman Ave, Hamden, CT 06518

$2,488/moEst:

Get Pre-Approved

  • Duplex

  • Built in 1900

  • $-- HOA

  • 3,920.4 sqft lot

  • $122/sq.ft

Description

Exceptional value-add opportunity in the heart of New Haven's desirable Edgewood neighborhood! This unique multi-family property offers an exciting opportunity for investors, developers, and visionaries looking to unlock its full potential. Currently configured as a 2-family with 6 bedrooms and 6 full bathrooms, the property also comes with zoning-approved plans to convert it into a 5-family residence, creating a rare opportunity to significantly increase its income-producing potential. With generous square footage and a flexible layout, this property provides a strong foundation for a transformative renovation. Whether you're an experienced investor or looking for your next development project, the possibilities are substantial. Bring your contractor, your vision, and the right team to reimagine this property into a standout asset in one of New Haven's most established neighborhoods. Located in the sought-after Edgewood neighborhood, you'll enjoy convenient access to Edgewood Park, Yale University, Yale New Haven Hospital, local restaurants, shopping, public transportation, and major highways, making this an attractive location for future tenants. While the property requires significant renovation and is being offered as an opportunity for someone ready to add value, the approved conversion plans and prime location make it a truly compelling investment. Don't miss your chance to bring new life to a property with exceptional upside and long-term potential.

  • Houzeo last checked: 15 minutes ago
  • Listing updated: September 16, 2026 at 2:36 pm
  • Listing Provided by: Javyn Roundtree | Roundtree Realty LLC
  • Source: SMART MLS-CT | MLS#: 24189456 SMART MLS-CT

Property Details

  • Status

    Active

  • Type

    Multi Family

  • No. of Stories

    -

  • County

    New Haven County

  • City

    Hamden

  • Neighborhood

    --

  • Year Built

    1900

  • HOA Fees

    -

  • Finished Area

    4,090 sqft

  • Lot Size

    3,920.4 sqft lot

  • Basement Area

    - sqft

  • MLS Name

    SMART MLS

  • MLS Number

    24189456

  • MLS Status

    Active

  • Days on Market

    123

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

HOA Management

0

HOA Fees

$-/

Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 6

    Bathrooms: 4

Interior

  • Sewer

    Public Sewer Connected

  • Cooling

    None

  • Heating

    Oil, Natural Gas

Construction

  • Year Built

    Year Built: 1900

  • Home type

    Duplex

  • Architectural Style

    Units On Different Floors, Units Are Side By Side

  • Foundation Details

    Concrete

  • Roof

    Asphalt Shingle

Utilities & Energy

  • Basement

    Full, Unfinished

  • Water Source

    Public Water Connected

Other Features

  • Subdivision Name

    N/a

  • Lot Features

    Level Lot

Price History

DateEventPrice

07/07/2026

Source: mls_logoSMART MLS-CT #24189456

Listed for Sale

$499,900

$122/sqft

Based on information provided to and compiled by the SMART MLS, Inc. through Nov 07, 2026, 04:45AM. IDX information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. ©2026 SMART MLS, Inc. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group

Skip to Main Content