152 Sheffield Avenue New Haven, CT 06511
Listing Courtesy of: SMART MLS / Howard Hanna | Rand Realty / Autumn Furlow

  152 Sheffield Avenue New Haven, CT 06511

Active (5 Days)
$410,000
6
BED
2
BATH
3,184
SQFT

Description

Don't miss the opportunity to own this versatile 2-family home in a highly desirable neighborhood. Located just minutes from shopping, downtown, public transportation and top-rated schools. This property is perfect for families or investors. The unique combined 2nd and 3rd floor unit is ideal for a large family. Each unit offers spacious layouts with plenty of natural light. Ample off-street parking. This home offers flexibility, convenience and space all in one package. Sold As-Is Schedule your showing today! Highest and Best by 6/24/25 5pm

MLS #:
24105185
Taxes
$7,271(2024)
Lot Size
5,663 SQFT
Type
Multifamily
Year Built
1900
Style
Units on Different Floors
County
South Central Connecticut Planning Region
Community
N/a

Listed By

Autumn Furlow, Howard Hanna | Rand Realty
Source
SMART MLS
Last checked Jun 26 2025 at 12:35 AM GMT+0000
Bathroom Details
  • Full Bathrooms: 2
Lot Information
  • Level Lot
Property Features
  • Foundation: Concrete
Heating and Cooling
  • Hot Air
  • Ceiling Fans
Basement Information
  • Full
  • Partially Finished
Exterior Features
  • Vinyl Siding
  • Roof: Asphalt Shingle
  • Roof: Gable
Utility Information
  • Sewer: Public Sewer Connected
  • Fuel: Natural Gas
School Information
  • Elementary School: Celentano
  • High School: James Hillhouse
Garage
  • None
  • On Street Parking
  • Driveway
Living Area
  • 3,184 sqft
Location
   
Calculate drive times to this property
 
Powered by INRIX® Drive Time

Powered by Walk Score®

Estimated Monthly Mortgage Payment

*Based on Fixed Interest Rate withe a 30 year term, principal and interest only

Listing price
Down payment
%
Interest rate
%
Mortgage calculator estimates are provided by Howard Hanna Rand Realty and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: 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 2025 SmartMLS, Inc. Last Updated: 6/25/25 17:35