Christopher Reid
Coldwell Banker Realty
(475) 265-6047
57 Total Sales
2 in Prospect Hill
$280K - $1.4M Price Range
263 Sheffield Ave New Haven, CT 06511
Prospect Hill NeighborhoodEstimated Value: $464,000 - $666,081
12
Beds
1209
Baths
3,620
Sq Ft
$169/Sq Ft
Est. Value
Highlights
- Property is near public transit and bus stop
- Thermal Windows
- Public Transportation
- Attic
- Porch
- Level Lot
About This Home
As of October 2025Don't miss this solid investment opportunity! This well-maintained 3-family home offers three generous units, each with 4 bedrooms and 1 bathroom. Featuring hardwood floors throughout and 1206 sq. ft. per unit, the property provides both comfort and income potential. The 1st and 2nd floor units have been fully renovated, complete with washer/dryer hookups, while the 3rd floor is currently vacant, ready for a new tenant or owner occupancy. Additional highlights include: Full, unfinished basement for storage 3-bay detached garage plus off-street parking for 5 cars New roof installed less than a year ago Strong rental history with reliable income Conveniently located close to Albertus Magnus College, Yale University, downtown New Haven, and local parks, this property is ideal for investors or multi-generational living.
Last Agent to Sell the Property
Michelle Mateo
Kaerus Property Group, LLC Brokerage Phone: (203) 494-9861 License #REB.0790458 Listed on: 09/04/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Property Details
Home Type
- Multi-Family
Est. Annual Taxes
- $9,603
Year Built
- Built in 1900
Lot Details
- 6,098 Sq Ft Lot
- Level Lot
Parking
- 3 Car Garage
Home Design
- Concrete Foundation
- Frame Construction
- Shingle Roof
- Wood Siding
Interior Spaces
- 3,620 Sq Ft Home
- Thermal Windows
- Basement Fills Entire Space Under The House
- Attic or Crawl Hatchway Insulated
Bedrooms and Bathrooms
- 12 Bedrooms
Additional Features
- Porch
- Property is near public transit and bus stop
- Heating System Uses Natural Gas
Community Details
- 3 Units
- Public Transportation
- Gross Income $61,200
Listing and Financial Details
- Assessor Parcel Number 1249341
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 4, 2025
Closed on
Oct 31, 2025
Sold by
Bought by
Seller's Agent
Michelle Mateo
Kaerus Property Group, LLC
Buyer's Agent
Thomas Payne
Century 21 Scala Group
List Price
$622,900
Sold Price
$645,000
Premium/Discount to List
$22,100
3.55%
Views
64
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$31,980
Avg. Annual Appreciation
-6.47%
Purchase Details
Closed on
Sep 20, 2024
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$479,000
Interest Rate
6.49%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Dec 7, 2022
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$62,000
Interest Rate
6.95%
Mortgage Type
Second Mortgage Made To Cover Down Payment
Purchase Details
Listed on
Feb 14, 2020
Closed on
Apr 17, 2020
Sold by
Bought by
Seller's Agent
David Steinbach
Anchor Real Estate LLC
Buyer's Agent
Rachel Mitchell
Venture Real Estate, Inc.
List Price
$349,900
Sold Price
$360,000
Premium/Discount to List
$10,100
2.89%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.83%
Original Mortgage
$353,479
Interest Rate
2.75%
Mortgage Type
FHA
Purchase Details
Closed on
Mar 12, 2013
Sold by
Bought by
Purchase Details
Closed on
Jun 9, 2008
Sold by
Bought by
Purchase Details
Closed on
Oct 31, 2001
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Prospect Hill, CT
-
Christopher Reid
-
John Hill
John Hill
Seabury Hill REALTORS
(475) 267-2882
416 Total Sales
21 in Prospect Hill
$189K - $2.3M Price Range
-
Lisa Nussbaum
Lisa Nussbaum
Top Tier Realty Group, LLC
(475) 330-3428
57 Total Sales
1 in Prospect Hill
$799,000 Price
-
David Brewster
David Brewster
Berkshire Hathaway NE Prop.
(224) 479-1612
41 Total Sales
1 in Prospect Hill
$660,000 Price
-
Santiago Jaraba
Santiago Jaraba
Whitestone Real Estate Group
(888) 483-4006
331 Total Sales
1 in Prospect Hill
$520,000 Price
-
Khaliq Brown
Khaliq Brown
CLMA Realty
(833) 910-1439
26 Total Sales
2 in Prospect Hill
$195K - $2.1M Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $645,000 | -- | ||
| $580,000 | None Available | ||
| -- | None Available | ||
| $360,000 | None Available | ||
| -- | -- | ||
| $112,500 | -- | ||
| $134,000 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Closed | $479,000 | ||
| Previous Owner | $62,000 | ||
| Previous Owner | $36,447 | ||
| Previous Owner | $353,479 | ||
| Previous Owner | $159,600 | ||
| Previous Owner | $283,500 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 10/31/2025 10/31/25 | Sold | $645,000 | +3.5% | $178 / Sq Ft | |
| 09/04/2025 09/04/25 | For Sale | $622,900 | +73.0% | $172 / Sq Ft | |
| 04/20/2020 04/20/20 | Sold | $360,000 | +2.9% | $99 / Sq Ft | View Prior Sale |
| 02/26/2020 02/26/20 | Pending | -- | -- | -- | |
| 02/14/2020 02/14/20 | For Sale | $349,900 | -- | $97 / Sq Ft |
Source: SmartMLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $9,603 | $243,740 | $33,600 | $210,140 |
| 2024 | $9,384 | $243,740 | $33,600 | $210,140 |
| 2023 | $9,067 | $243,740 | $33,600 | $210,140 |
| 2022 | $9,689 | $243,740 | $33,600 | $210,140 |
| 2021 | $6,266 | $142,800 | $26,880 | $115,920 |
| 2020 | $6,266 | $142,800 | $26,880 | $115,920 |
| 2019 | $6,138 | $142,800 | $26,880 | $115,920 |
| 2018 | $6,138 | $142,800 | $26,880 | $115,920 |
| 2017 | $5,524 | $142,800 | $26,880 | $115,920 |
| 2016 | $4,322 | $104,020 | $11,970 | $92,050 |
| 2015 | $4,322 | $104,020 | $11,970 | $92,050 |
| 2014 | $4,322 | $104,020 | $11,970 | $92,050 |
Source: Public Records
Agents Affiliated with this Home
-
M
Seller's Agent in 2025
Michelle Mateo
Kaerus Property Group, LLC
-
Thomas Payne
T
Buyer's Agent in 2025
Thomas Payne
Century 21 Scala Group
(203) 233-7445
1 in this area
51 Total Sales
-
David Steinbach
D
Seller's Agent in 2020
David Steinbach
Anchor Real Estate LLC
(860) 222-5198
1 Total Sale
-
Rachel Mitchell
Buyer's Agent in 2020
Rachel Mitchell
Venture Real Estate, Inc.
(203) 823-2201
61 Total Sales
Map
Source: SmartMLS
MLS Number: 24124271
APN: NHVN-000254-000491-002100
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 653 Winchester Ave
- 393 Huntington St
- 40 Read St
- 246 Newhall St
- 110 Sheffield Ave
- 500 Prospect St Unit 1E
- 212 Newhall St
- 550 Prospect St Unit 8
- 24 Hazel St
- 39 Shepard St
- 74 Starr St
- 406 Newhall St
- 113 Ivy St
- 65 Thompson St
- 327 Shelton Ave
- 251 Starr St
- 130 Hazel St
- 254 Starr St
- 398 Shelton Ave
- 90 Marlboro St
- 263 Sheffield Ave Unit 3
- 273 Sheffield Ave
- 257 Sheffield Ave
- 259 Sheffield Ave Unit Prospect Hill
- 259 Sheffield Ave Unit 2
- 259 Sheffield Ave
- 253 Sheffield Ave Unit 1L
- 253 Sheffield Ave
- 128 Sheldon Terrace
- 245 Sheffield Ave Unit b
- 245 Sheffield Ave
- 245 Sheffield Ave Unit A
- 132 Sheldon Terrace Unit 6
- 132 Sheldon Terrace Unit 5
- 132 Sheldon Terrace Unit 4
- 132 Sheldon Terrace Unit 3
- 132 Sheldon Terrace Unit 2
- 132 Sheldon Terrace Unit 1
- 276 Huntington St
- 280 Huntington St
Your Personal Tour Guide
Ask me questions while you tour the home.