223 Farren Avenue | New Haven N/A

$899,000 | 6 Baths (4 Full, 2 Half) | 3,432 Sq. Ft.

Mixed-use property featuring 4 residential units and 1 commercial space in a prime New Haven County location. Offering 3,432 sq ft of total space on a 0.073-acre lot, this versatile investment opportunity is situated just seconds from the Quinnipiac River. Ideal for investors seeking steady rental income or an owner-occupant looking to run a business on-site. SmartMLS 24134133

Directions to property: GPS Friendly

MLS Listing ID: 
SmartMLS 24134133
Building Details
Details about the building on a property.
Year Built: 
1900
Living Area: 
3,432
Construction
Roof: 
Asphalt Shingle
Room Details
Details about the rooms in the building.
Total Rooms: 
0
Total Bedrooms: 
0
Total Bathrooms: 
6
Total Full-Bathrooms: 
4
Total Half-Bathrooms: 
2
Utilities
Information about utilities available on the property.
Heating System: 
Hot Water
Heating System Fuel: 
Natural Gas
Cooling System: 
None
Water Source: 
Public Water Connected
Sewer: 
Public Sewer Connected
Lot/Land Details
Details about the lots and land features included on the property.
Acres: 
0.07
Waterfront: 
0
Public Record
Parcel Number: 
1238509
Annual Tax: 
$8,872.00
Property Zoning: 
BA
Listing Dates
Dates involved in the transaction.
Listing Entry Date/Time: 
10/17/2025
Contract Details
Details about the listing contract.
Possession: 
Negotiable
Listing Participants
Participants (agents, offices, etc.) in the transaction.
Listing Agent Name: 
Patrick Precourt
Listing Office Name: 
Dorrance Realty