Seller's Agent in 2025
Michelle Mateo
Kaerus Property Group, LLC
(203) 494-9861
4 in this area
48 Total Sales
263 Sheffield Ave New Haven, CT 06511
Prospect Hill Neighborhood
12
Beds
1209
Baths
3,620
Sq Ft
6,098
Sq Ft Lot
Highlights
- Property is near public transit
- Thermal Windows
- Public Transportation
- Attic
- Porch
- 5-minute walk to Bassett Street Community Garden
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
Kaerus Property Group, LLC Brokerage Phone: (203) 494-9861 License #REB.0790458 Listed on: 09/04/2025
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
Location
- Property is near public transit
- Property is near a bus stop
Additional Features
- Porch
- 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
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 4, 2025
Closed on
Oct 31, 2025
Sold by
Sage Optimum Svcs Llc
Bought by
Tdd Enterprise Llc
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
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-16.68%
Original Mortgage
$483,750
Outstanding Balance
$483,750
Interest Rate
6.26%
Mortgage Type
New Conventional
Estimated Equity
$149,583
Purchase Details
Closed on
Sep 20, 2024
Sold by
Upscale Llc
Bought by
Sage Optimum Svcs Llc
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
Alvarado Brian M
Bought by
Upscale Llc
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
Closed on
Mar 12, 2013
Sold by
Ditman Henry and Bernblum Steven
Bought by
Ram Group Llc
Purchase Details
Closed on
Jun 9, 2008
Sold by
Deutsche Bank Natl T C
Bought by
Steinbach David and Steinbach Jody
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$175,000
Interest Rate
14%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Oct 31, 2001
Sold by
Oliver Myron and Brand Arthur L
Bought by
Goodman David
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
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $645,000 | -- | |
| Warranty Deed | $580,000 | None Available | |
| Warranty Deed | $580,000 | None Available | |
| Quit Claim Deed | -- | None Available | |
| Quit Claim Deed | -- | None Available | |
| Quit Claim Deed | -- | -- | |
| Quit Claim Deed | -- | -- | |
| Warranty Deed | $112,500 | -- | |
| Warranty Deed | $112,500 | -- | |
| Warranty Deed | $134,000 | -- | |
| Warranty Deed | $134,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $483,750 | New Conventional | |
| Previous Owner | $479,000 | Purchase Money Mortgage | |
| Previous Owner | $62,000 | Second Mortgage Made To Cover Down Payment | |
| Previous Owner | $159,600 | No Value Available | |
| Previous Owner | $175,000 | Purchase Money Mortgage |
Source: Public Records
Property History
| 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 Compared to Growth
Tax History
| 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
-
Michelle Mateo
-
Thomas Payne
T
Buyer's Agent in 2025
Thomas Payne
Century 21 Scala Group
(203) 233-7445
1 in this area
44 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
72 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
- 622 Winchester Ave
- 238 Newhall St
- 500 Prospect St Unit 1E
- 500 Prospect St Unit 4A
- 64 Lilac St
- 77 Hazel St
- 39 Lander St
- 81 Butler St
- 406 Newhall St
- 327 Shelton Ave
- 6 Prospect Ct
- 255 Starr St
- 254 Starr St
- 407 Shelton Ave
- 174 Butler St
- 98 Thompson St
- 855 Prospect St
- 245 Goodrich St
- 97 Goodyear St
- 39 Edwards St