NOT LISTED FOR SALE

263 Sheffield Ave New Haven, CT 06511

Prospect Hill Neighborhood

Estimated Value: $622,000 - $643,000

12 Beds
1209 Baths
3,620 Sq Ft
$176/Sq Ft Est. Value

Sale Details

Date Sold: October 31, 2025

Last sale price $645,000 $178 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $4,169 / mo

57 Days on Market

Highlights

  • Property is near public transit and bus stop
  • Thermal Windows
  • Public Transportation
  • Attic
  • Porch
  • 5-minute walk to Bassett Street Community Garden

About This Home

As of October 2025

Don'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

Last Buyer's Agent

Thomas Payne

Century 21 Scala Group License #RES.0824672

Century 21 Scala Group

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

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$9,603

Year Built

Built in 1900

Lot Details

6,098 Sq Ft Lot

Listing Details

  • Neighborhood: Newhallville
  • Property Type: Multi-Family For Sale
  • Style: 3updown - Unit(s) per Floor
  • Sq Ft Est Heated Above Grade: 3620
  • Total Sq Ft: 3620
  • Year Built: 1900
  • New Construction: No/Resale
  • Nearby Amenities: Public Transportation, Walk to Bus Lines
  • Property Sub Type: 3 Family
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Directions: huntington rd to sheffield ave
  • Financing Used: Conventional ARM
  • Street Type: Avenue
  • Office Attribution Contact: (203) 889-0999
  • Reserve Prospect: No
  • Special Features: None

Interior Features

  • Total Bedrooms: 12
  • Total Bathrooms: 1209
  • Full Bathrooms: 3
  • Half Bathrooms: 1206
  • Attic Description: Access Via Hatch
  • Basement Description: Full
  • Attic: Yes

Exterior Features

  • Exterior Features: Porch
  • Exterior Siding: Wood
  • Foundation Type: Concrete
  • Roof Information: Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 3
  • Total Parking Spaces: 5
  • Garage And Parking: Detached Garage, Off Street Parking

Utilities

  • Cooling System: None
  • Heat Type: Hot Air
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: 40 Gallon Tank
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Schools

  • Intermediate School: Per Board of Ed

Green Features

  • Energy Features: Thermopane Windows

Lot Info

  • Acres: 0.14
  • Lot Description: Level Lot
  • Flood Zone: No
  • Zoning: RM2
  • Parcel #: 1249341

Multi Family

  • Gross Annual Income: 61200
  • Total Number Of Units: 3

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 9603

MLS Schools

  • Elementary School: Per Board of Ed
  • Middle Jr High School: Per Board of Ed
  • High School: Per Board of Ed

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
Current Estimated Value
$635,432

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$9,568
Avg. Annual Appreciation
-3.13%
Original Mortgage
$483,750
Outstanding Balance
$482,368
Interest Rate
6.26%
Mortgage Type
New Conventional
Estimated Equity
$153,064

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

Listed on
Feb 14, 2020
Closed on
Apr 17, 2020
Sold by
Steinbach David and Steinbach Jody
Bought by
Alvarado Brian M
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
9.93%
Original Mortgage
$353,479
Interest Rate
2.75%
Mortgage Type
FHA

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
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Tdd Enterprise Llc $645,000 --
Sage Optimum Svcs Llc $580,000 None Available
Sage Optimum Svcs Llc $580,000 None Available
Upscale Llc -- None Available
Upscale Llc -- None Available
Alvarado Brian M $360,000 None Available
Ram Group Llc -- --
Ram Group Llc -- --
Steinbach David $112,500 --
Steinbach David $112,500 --
Goodman David $134,000 --
Goodman David $134,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Tdd Enterprise Llc $483,750
Previous Owner Sage Optimum Svcs Llc $479,000
Previous Owner Upscale Llc $62,000
Previous Owner Alvarado Brian M $353,479
Previous Owner Goodman David $159,600
Previous Owner Goodman David $175,000
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

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

    Seller's Agent in 2025

    Michelle Mateo

    Kaerus Property Group, LLC

    (203) 494-9861

    3 in this area

    37 Total Sales

    Michelle Mateo
    Section Image

  • T

    Buyer's Agent in 2025

    Thomas Payne

    Century 21 Scala Group

    (203) 233-7445

    1 in this area

    48 Total Sales

    Thomas Payne
    Section Image

  • D

    Seller's Agent in 2020

    David Steinbach

    Anchor Real Estate LLC

    (860) 222-5198

    1 Total Sale

    David Steinbach
    Section Image
  • Rachel Mitchell

    Buyer's Agent in 2020

    Rachel Mitchell

    Venture Real Estate, Inc.

    (203) 823-2201

    64 Total Sales

    Rachel Mitchell
    Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24124271

SmartMLS

APN: NHVN-000254-000491-002100

Connecticut New Haven County New Haven 06511 Prospect Hill

263 Sheffield Ave, New Haven, CT

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.

SmartMLS 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
Your Personal Tour Guide

Ask me questions while you tour the home.