Movoto Real Estate
  • Map Image
  • Map Image
  • Map Image

244 Sherman Ave, Hamden, CT 06518

$499,900
•
  • 6

    bed

  • 4

    bath

  • 4,090

    Sqft ($122/Sqft)

Multi-family for sale 92 days

About 244 Sherman Ave

Property type Multi-family
Year built 1900
HOA fee $0/month
Lot size 3,920 Sqft
Movoto estimate
Property 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.
Listed by
Listing Agent - Javyn Roundtree
Listing Office - Roundtree Realty LLC
Source: CONNECT MLS mls logo
MLS#24189456 • last updated 3 months ago
Movoto checked CONNECT MLS for data 6 minutes ago
Request a virtual or in-person tour
Overview
Cooling/AC None
Heating Hot Air
Type Multi-Family For Sale
SubType 2 Family
SqFt 4090
Status Active
MLS # 24189456
Lot Size (Acres) 0.09
Property Tax 13408
Property Condition No/Resale
Interior
Total # of Bathrooms 4
# of Full Baths 4
Total # of Bedrooms 6
Total # of Rooms 11, 11
Exterior
Exterior Clapboard
Foundation Concrete
Roofing Asphalt Shingle
Lot Description Level Lot
Amenities / Utilities
Sewer/ Septic Public Sewer Connected
Location
Waterfront Not Applicable
Elementary School Edgewood
High School James Hillhouse
Middle School Enginering/Science
APN 1255589
Directions Lock Door Please
Multifamily Details
Total # of Units 6
Tour this home
When would you like to see 244 Sherman Ave?
question
Have a question about this property? Call us at (844) 430-0869

Around the neighborhood

Explore everything this neighborhood has to offer.
40/100
Walk
63/100
Family
54/100
Dining
82/100
Pet
  • Real Estate
  • CT
  • New Haven County
  • Hamden
  • 06518
  • 244 Sherman Ave

My commute

Enter a destination to see travel time and distance.
By entering my info and clicking Ask a Question below, I am providing my e-signature and express written consent to receive marketing emails, calls, and texts (including via automatic telephone dialing systems, AI generative, artificial or pre-recorded voice technology) relating to my inquiry from Movoto (and parties calling/messaging on their behalf) even if my number appears on the company, state, or national Do Not Call Registry. You also agree to ourTerms and Conditions and Privacy Policy. Consent not required to receive services (call 1-844-420-1270 to be connected without providing consent).

Nearby homes for sale in Hamden, CT

Nearby recently sold homes in Hamden, CT

Newest listings in 06518

Meet with a real estate agent today (844) 430-0869
The multiple listing information is provided by SMART MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Buyer to verify all information. The information provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing information updated every 15 minutes. Terms of use & Privacy Policy, California Privacy Info. Copyright © 2005 - 2026 Movoto, Inc. All rights reserved. Equal Housing Opportunity CalDRE CalDRE #01517281
Movoto Real Estate is committed to ensuring accessibility for individuals with disabilities. We are continuously working to improve the accessibility of our web experience for everyone. We welcome feedback and accommodation requests, please submit them here.
The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2026 SmartMLS, Inc.
Requests for information regarding mortgage products will be directed to Movoto.com affiliate, Lower, LLC - a licensed Mortgage Lender (NMLS #1124061), or, based on your location, may be redirected to a participating mortgage marketing partner that may pay Lower, LLC for any consumer contact information provided through this site.