#24097329, David Fiske, Listing office: Houlihan Lawrence WD
#24102860·
Listing office: eXp Realty·
Listing agent: Maricela Herrera·
Listing office phone: (866) 828-3951
$335,000 List price
246 Sheffield Ave New Haven, CT 06511
3 beds
2 full
1,080 sqft
0.1 acres
$310 / sqft
House
Property details
About 246 Sheffield Ave
Welcome to this charming Cape Cod-style home in the heart of New Haven. This spacious single-family residence offers four bedrooms, three full bathrooms, and one half bath, making it ideal for families, home offices, or short-term rental opportunities. The interior features a cozy living room, separate dining area, and a functional, move-in-ready layout. Enjoy outdoor living with a fenced backyard-perfect for entertaining, pets, or relaxing-as well as a sunny deck for additional space. Conveniently located just 0.3 miles (5-minute walk) from Albertus Magnus College and close to Yale University and Science Park. Easy access to I-91, I-95, and the Wilbur Cross Parkway, with CT Transit Route 246 nearby for added transportation options.
Highlights
Home typeOther
HeatingForced Air
StatusAccepting Backup Offers
(Under Contract - Continue to Show)
(Under Contract - Continue to Show)
Size1,080 sqft
BasementYes
Lot size0.11 Acres
Year built1961
MLS #24102860
Summary
- Full Bathrooms: 2
- Appliances: Gas Range, Refrigerator
- Basement: Yes
- Total Bedroom Count: 3
- Attached Garage: No
- Private Pool: No
- Parking: None
- Heating: Forced Air
- Cooling: None
- List Price: $335,000
- Price/SqFt: $310
- Annual Tax Amount: $4,743
- Tax Year: 2024
- Lot: Level
- Directions: GPS friendly.
- Year Built: 1961
- Living Area: 1,080 SqFt
- Lot Size: 0.11 Acres
- MLS Number: 24102860
- Office Name: eXp Realty
- Office Phone: (866) 828-3951
- Office Email: tc.maricelaherrera@gmail.com
- Listing Agent: Maricela Herrera
Copyright © 2025 Smart MLS. 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.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/12/2025, 10:45:31 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| May 15, 2023 | Home Sold | $237,000 |
| Oct 17, 2007 | Home Sold | $172,900 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $123,200 | $4,743 |
| 2023 | $123,200 | $4,583 |
| 2022 | $123,200 | $4,897 |
| 2021 | $77,420 | $3,397 |
| 2020 | $77,420 | $3,397 |
| 2019 | $77,420 | $3,328 |
History based on county public records data.
Nearby schools
4
Lincoln - Bassett Community School
Public District PK-6
0.3 mi
•130 Bassett St
5
Barack H. Obama Magnet University School
Public Magnet PK-4
1.4 mi
•69 Farnham Ave
6
Helen Street School
Public District PK-6
1.7 mi
•285 Helen St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $44,462. The most common annual income of people living in New Haven, CT is less than $<35k. Typical family type is single, no kids. Typical level of education for residents in this area is high school diploma.
How much money do the neighbors make?
41%
<35k
31%
35k-100k
26%
100k-200k
2%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
55%
Single, No Kids
19%
Single, with Kids
14%
Married, No Kids
12%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
17%
<11 yrs old
7%
12-17 yrs old
40%
18-34 yrs old
29%
35-64 yrs old
7%
65+ yrs old
What do the neighbors do for fun?
Continuing Education Courses
Soccer
Pro Boxing
Where do the neighbors shop?
Express/Express For Men
Forever 21
Burlington
Where do the neighbors go to eat?
Qdoba
Dominos Pizza
Popeyes
What do the neighbors drive?
Volkswagen
Mazda
Dodge
What do the neighbors listen to?
Urban Contemporary
Rhythmic Contemporary Hits- Alternative
All data provided by Home Junction and Claritas
Similar homes for sale
3 days on Rocket
#24110290, Eric Radziunas, Listing office: Coldwell Banker Realty
21 hours on Rocket
#24110960, Danielle Marcellino, Listing office: Sterling Home Partners, LLC
#24082013, Martha Torres, Listing office: Century 21 Scala Group
#24105316, Javyn Roundtree, Listing office: ASJ Realty Partners
#24091876, Lisa Cozzi, Listing office: Century 21 AllPoints Realty
#24103668, Juan Osorio-Ramirez, Listing office: Alpha Capital Realty, LLC
#24095923, Michael Barbaro, Listing office: Huntsman,Meade & Partners Comp
Backup offers
#24092941, Wojtek Borowski, Listing office: Pearce Real Estate
#24086919, Wojtek Borowski, Listing office: Pearce Real Estate
Frequently asked questions
About 246 Sheffield Ave
The listing price of 246 Sheffield Ave property is $335,000.
The property 246 Sheffield Ave is a house located in New Haven, Connecticut, 06511.
Accepting Backup Offers: 246 Sheffield Ave is Accepting Backup Offers (Active Under Contract), there is still a chance to have your real estate agent submit an offer.
The nearby schools for 246 Sheffield Ave are: Lincoln - Bassett Community School (GreatSchools Rating 4/10), Barack H. Obama Magnet University School (GreatSchools Rating 5/10), Helen Street School (GreatSchools Rating 6/10), Celentano Biotech Health and Medical Magnet School (GreatSchools Rating 3/10), Worthington Hooker School (GreatSchools Rating 9/10), Wexler - Grant Community School (GreatSchools Rating 2/10), Highville Charter School (GreatSchools Rating 4/10), James Hillhouse High School (GreatSchools Rating 1/10), Wilbur Cross High School (GreatSchools Rating 1/10).
According to the records, the last property tax for 2024 is $4,743 (source: MLS/based on county public records data).
The last sale was on May 15, 2023 for $237,000 (source: MLS/tax record).
The property at 246 Sheffield Ave has 3 bedrooms and 2 bathrooms.
The property 246 Sheffield Ave is 1,080 SqFt (source: MLS/tax record).
The year of construction for 246 Sheffield Ave is 1961.
This home is located at 246 Sheffield Ave in New Haven, CT and zip code 06511 in the Prospect Hill neighborhood. This 1,080 square foot home, which was built in 1961, sits on a 0.11 acre lot. Features: 3 bedrooms, 2 bathrooms. It has been listed on Rocket Homes since June 19, 2025 and is currently priced at $335,000.
New Haven, CT housing market in June 2025 saw over 42 listings sold above listed price, more than 11 sold at listed price and over 31 sold below. The number of listings in New Haven, CT decreased by 3.3% between May and June 2025.
From Rocket Homes Real Estate and based on county public records data.