Search
Mixed-Use Five-Unit Investment Building
For Sale
Contact for pricing

223 Farren Ave, New Haven, CT 06513

Five-unit mixed-use building includes four 2-bedroom apartments and one commercial space.

Property Size3,432 SF
Price / SF$233.10
Days on Market137

Property Features for 223 Farren Ave

General Information

Standard status Active
Size 3,432 SF
Property subtype RETAIL

Additional Details

Multifamily Units 4

Building Details

Tenancy Multi
Listing Agency: Northeast Private Client Group | CT/Metro North
Listed By: Derek Mahabir · License #CT: 0798330
Source: Moodyscre
Added: Mar 16 Changed: Jul 27 Last Checked: Jul 29 at 2:32PM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Northeast Private Client Group | CT/Metro North

Investment Insights

Based on property information with market context.

223 Farren Avenue is a five-unit mixed-use building with four 2-bedroom apartments and one commercial space. The property is positioned to serve both residential and neighborhood commercial needs within an established corridor.

Situated in New Haven, the building benefits from an established neighborhood-oriented area that supports workforce housing and essential retail demand. The property’s access to industrial job centers, institutional employers, downtown New Haven, and nearby amenities is designed to support consistent renter demand.

The current configuration provides immediate rental income with value-add potential through unit renovations, offering a practical path to improving overall performance over time.

Key Highlights

  • Five‑unit mixed‑use building: four 2‑bedroom apartments plus one commercial space.
  • Stabilized cash‑flowing property with potential for NOI growth through unit renovations.
  • Four 2‑bedroom apartment units provide dependable residential tenancy.

Financial Insights For Apartment 5plus

Simulate Cap Rate and NOI

NOI Build-Up
Vacancy
income lost from leasable area expected to sit empty during the year — subtracted from gross rent.
EGI (Effective Gross Income)
gross rent minus vacancy losses — the realistic income before paying operating costs.
OpEx (Operating Expenses)
recurring costs to operate the property (property tax, insurance, utilities, maintenance, management) — excludes financing and capital improvements.
NOI (Net Operating Income)
income a property generates after operating costs but before financing and taxes.

Component $ $/SF
Gross rent $104.2k $30.36
− Vacancy −$6.5k −$1.88
EGI $97.7k $28.48
− OpEx −$44.0k −$12.81
NOI $53.8k $15.66
3,432 SF · lease $30.36/SF/yr · vacancy 6.20% · expense 45.00%

Alternative Uses

Best Use
Apartment 5plus
$767.9K
$671.9K – $895.9K (±1% cap)
NOI $53,754 @ 7.0% cap · market cap 6.72%
Second Best
Retail
$708.0K
$619.5K – $826.0K (±1% cap)
NOI $49,557 @ 7.0% cap · market cap 6.19%
Theoretical Best
Office A
$1.10M
$966.0K – $1.29M (±1% cap)
NOI $77,279 @ 7.0% cap · market cap 9.66%
Zoning and permitted uses should be independently verified with authorities.

Property Analytics

Current Use

Henry's Barbershop Barber Shop Flow barber shop Barber Shop Wear It’s At Clothing Store

Suggested Use

Top Pick Real Estate Agency Law Firm Dental Office Parking Lot & Garage Gym & Fitness Center Cafe & Coffee Shop

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

4
Residential units
Multi-tenant
Tenancy

Location Intelligence

Trade Area within ½ mile

550
Businesses Nearby

Demographics for 06513, CT

38,618
Population
17,006
Households
2.3
Avg Household Size
36
Median Age
19%
College-Educated
80%
High-School Grad
7.2 sq mi
ZIP Area
5,364
Density / Sq Mi
$46,520
Median Household Income
$38,369
Median Earnings
$1,208
Median Rent
$226,600
Median Home Value

Market

Vacancy Rate% for Multifamily in Northeast region

4% 2022
4.6% 2023
5.3% 2024
5.6% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Apartment building - Five-unit mixed-use building includes four 2-bedroom apartments and one commercial space.
Where is this apartment building located?
The property is located at 223 Farren Ave New Haven, CT.
What is the asking price?
The asking price for this property is $800,000.
What are key features of this property?
This property features: Five‑unit mixed‑use building: four 2‑bedroom apartments plus one commercial space.; Stabilized cash‑flowing property with potential for NOI growth through unit renovations.; Four 2‑bedroom apartment units provide dependable residential tenancy.
(203) 307-1583 Call to check price and availability
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message