Save
Ask
Tour
Hide
$410,000
11 Days On Site
152 Sheffield AvenueNew Haven, CT 06511
For Sale|Duplex|Active Under Contract
6
Beds
2
Total Baths
2
Full Baths
3,184
SqFt
$129
/SqFt
1900
Built
County:
New Haven
Listing courtesy of Autumn Furlow of Howard Hanna Rand Realty
Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.
Call Now: 203-498-2031
Is this the listing for you? We can help make it yours.
203-498-2031Save
Ask
Tour
Hide
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
Save
Ask
Tour
Hide
Listing Snapshot
Price
$410,000
Days On Site
11 Days
Bedrooms
6
Inside Area (SqFt)
3,184 sqft
Total Baths
2
Full Baths
2
Partial Baths
N/A
Lot Size
0.13 Acres
Year Built
1900
MLS® Number
24105185
Status
Active Under Contract
Property Tax
$7,271
HOA/Condo/Coop Fees
N/A
Sq Ft Source
N/A
Friends & Family
Recent Activity
| yesterday | Listing updated with changes from the MLS® | |
| 5 days ago | Status changed to Active Under Contract | |
| 2 weeks ago | Listing first seen on site |
General Features
Acres
0.13
Foundation
Concrete Perimeter
Parking
PavedOn StreetPrivateNoneDriveway
Parking Spaces
4
Property Sub Type
Duplex
Sewer
Public Sewer
SqFt Total
3184
Style
Units on different Floors
Water Source
Public
Zoning
RM2
Interior Features
Basement
FullPartially Finished
Cooling
Ceiling Fan(s)
Heating
Natural GasForced Air
Save
Ask
Tour
Hide
Exterior Features
Construction Details
Vinyl SidingFrame
Lot Features
Level
Patio And Porch
Deck
Roof
Asphalt
Schools
School District
Unknown
Elementary School
Celentano
Middle School
Unknown
High School
James Hillhouse
Listing courtesy of Autumn Furlow of Howard Hanna Rand Realty
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 checked: 2025-07-01 11:38 AM UTC.
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 checked: 2025-07-01 11:38 AM UTC.
Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.