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.
For sale
$499,900
244 Sherman Avenue, New Haven, CT 06518
6beds
4,090sqft
Multi Family
Built in 1900
-- sqft lot
$-- Zestimate®
$122/sqft
$-- HOA
What's special
Flexible layout
- 3 days |
- 262 |
- 12 |
Zillow last checked:
Listing updated:
Listed by:
Javyn Roundtree (475)227-4312,
Roundtree Realty LLC 475-227-4312,
Aharon Cowen 747-252-3955,
Roundtree Realty LLC
Source: Smart MLS,MLS#: 24189456
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 4
Heating
- Forced Air, Natural Gas, Oil
Cooling
- None
Appliances
- Included: Gas Water Heater, Water Heater
Features
- Basement: Full,Unfinished
- Attic: Pull Down Stairs
- Has fireplace: No
Interior area
- Total structure area: 4,090
- Total interior livable area: 4,090 sqft
- Finished area above ground: 4,090
Property
Lot
- Size: 3,920 Square Feet
- Features: Level
Details
- Parcel number: 1255589
- Zoning: RM2
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Units on different Floors,Units are Side-by-Side
- Property subtype: Multi Family
- Attached to another structure: Yes
Materials
- Clapboard
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1900
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Hamden
Financial & listing details
- Price per square foot: $122/sqft
- Tax assessed value: $335,510
- Annual tax amount: $13,219
- Date on market: 7/7/2026
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/7/2026 | Listed for sale | $499,900$122/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 06518
Nearby schools
GreatSchools rating
- 4/10Bear Path SchoolGrades: K-6Distance: 2 mi
- 5/10Hamden Middle SchoolGrades: 7-8Distance: 2.3 mi
- 4/10Hamden High SchoolGrades: 9-12Distance: 3.3 mi
Schools provided by the listing agent
- Elementary: Edgewood
- Middle: Enginering/Science
- High: James Hillhouse
Source: Smart MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- Connecticut
- New Haven County
- Hamden
- 06518
- 244 Sherman Avenue





