Mixed-Use Five-Unit Investment
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
(203) 307-1583
Listed By:
Derek Mahabir · License #CT: 0798330
(203) 307-1583
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.
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
NOI $53,754 @ 7.0% cap · market cap 6.72%
Second Best
Retail
$708.0K
$619.5K – $826.0K
NOI $49,557 @ 7.0% cap · market cap 6.19%
Theoretical Best
Office A
$1.10M
$966.0K – $1.29M
NOI $77,279 @ 7.0% cap · market cap 9.66%
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Current Use
Lease Details
4
Residential units
Multi-tenant
Tenancy
Location Intelligence
Trade Area within ½ mile
550
Businesses Nearby
Explore this area
Business Placement
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
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.