- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
Street View
$499,900
Monthly Est:$2,488
6 Beds
- 4 Baths
4 full baths
4,090sqft
244 Sherman Ave, Hamden, CT 06518
$499,900
$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

Property Details
Status
Active
Type
Multi Family
No. of Stories
-
County
City
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!
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
| Date | Event | Price |
|---|---|---|
07/07/2026 Source: | Listed for Sale | $499,900 $122/sqft |
Find Homes by Property Features in Hamden, CT
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