Turnkey Mixed-Use Investment
1242 Whitney Avenue Hamden, CT 06517
For Sale
$799,900
COMMERCIAL - Hamden, CT
Property Size5,058 SF
Lot Size0.18 Acres
Price / SF$158.15
Days on Market125
Property Features for 1242 Whitney Avenue
General Information
Property type
Commercial Sale
Property subtype
Other
Zoning
T3.5
Bathrooms
3
Rooms
Bathroom 3, Bathroom 2, Bathroom 1
Standard status
Active
Size
5,058 SF
Lot size
0.18 Acres
Taxes and HOA fees
Tax Year
2026
Tax Annual Amount
18318
Utilities
Sewer type
Public Sewer
Cooling system
Central Air
Water source
Public
Building Details
Year built
1900
Floors in Building
2
Listing Agency:
Press/Cuozzo Realtors
(203) 288-1900
Listed By:
Mark Foreman · License #RES.0827812
(203) 981-4551
Added: Mar 25
Changed: Jul 26
Last Checked: Jul 27 at 1:06PM
MLS# 24161856
Copyright © 2026 SmartMLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Investment Insights
Based on property information with market context.
1242 Whitney Avenue is a well-maintained, fully occupied mixed-use building featuring two established retail tenants on the ground floor and a fully leased residential apartment on the second floor. The property includes a full basement for storage and six paved off-street parking spaces. Recent building improvements include a new roof installed in 2023. In the Soup Girl unit, new A/C, furnace, and a hot water heater were installed.
Located in the Whitneyville neighborhood of Hamden, the building offers quick access to downtown New Haven and is described as minutes from Yale University, Quinnipiac University, major employment centers, and key transportation routes.
The property is listed under zoning T3.5.
Located in the Whitneyville neighborhood of Hamden, the building offers quick access to downtown New Haven and is described as minutes from Yale University, Quinnipiac University, major employment centers, and key transportation routes.
The property is listed under zoning T3.5.
Key Highlights
- Mixed‑use investment building fully occupied with two ground‑floor retail tenants and one fully leased residential apartment
- Six paved off‑street parking spaces
- Full basement for storage
Financial Insights For Retail
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 | $109.3k | $21.60 |
| − Vacancy | −$4.9k | −$0.97 |
| EGI | $104.3k | $20.63 |
| − OpEx | −$31.3k | −$6.19 |
| NOI | $73.0k | $14.44 |
5,058 SF · lease $21.60/SF/yr · vacancy 4.50% · expense 30.00%
Alternative Uses
Best Use
Apartment 5plus
$1.13M
$990.3K – $1.32M
NOI $79,222 @ 7.0% cap · market cap 9.90%
Second Best
Retail
$1.04M
$912.9K – $1.22M
NOI $73,035 @ 7.0% cap · market cap 9.13%
Theoretical Best
Office A
$1.63M
$1.42M – $1.90M
NOI $113,892 @ 7.0% cap · market cap 14.24%
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Property Profile
Location Intelligence
Current Use
Frequently Asked Questions
What type of property is this?
Mixed-use property - Fully occupied mixed-use building with two ground-floor retail tenants and a leased second-floor apartment, plus six paved off-street spaces.
Where is this mixed-use property located?
The property is located at 1242 Whitney Avenue Hamden, CT.
What is the asking price?
The asking price for this property is $799,900.
What are key features of this property?
This property features: Mixed‑use investment building fully occupied with two ground‑floor retail tenants and one fully leased residential apartment; Six paved off‑street parking spaces; Full basement for storage
