Mixed-Use Building with
For Sale
$799,900
1242 Whitney Avenue, Hamden, CT 06517
Commercial For Sale, Hamden, CT
Property Size5,058 SF
Lot Size0.18 Acres
Price / SF$158.15
Days on Market215
Property Features for 1242 Whitney Avenue
General Information
Property type
Commercial Sale
Property subtype
Other
Zoning
T3.5
Bathrooms
3
Full bathrooms
1
Half bathrooms
2
Rooms
Bathroom 3, Bathroom 1, Bathroom 2
Lot features
Level Lot
Directions
Whitney Ave between Putnam and Ralston
Subdivision
Whitneyville
Standard status
Active
Size
5,058 SF
Lot size
0.18 Acres
Additional Details
Tenant in Place
Yes
Mixed-Use Components
retail, residential
Taxes and HOA fees
Tax Year
2027
Tax Annual Amount
18950
Utilities
Sewer type
Public Sewer
Cooling system
Central Air
Water source
Public
Building Details
Year built
1900
Floors in Building
2
Buildings
1
Listing Agency:
Press/Cuozzo Realtors
(203) 288-1900
Listed By:
Mark Foreman
(203) 981-4551
Added: Mar 25
Changed: Oct 25
Last Checked: Oct 25 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.
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.
Investment Insights
Based on property information with market context.
This 5,058-square-foot mixed-use building combines two ground-floor retail spaces with a leased second-floor apartment. A full basement provides additional storage, while six paved off-street parking spaces serve the property. The building dates to 1900 and has received notable recent improvements, including a roof replacement in 2023 and updated air conditioning, furnace, and hot water equipment in one retail unit.
The property is located at 1242 Whitney Avenue in Hamden’s Whitneyville neighborhood, with access to downtown New Haven, Yale University, Quinnipiac University, employment centers, and regional transportation routes. Public water and public sewer serve the building, which is zoned T3.5.
The property is located at 1242 Whitney Avenue in Hamden’s Whitneyville neighborhood, with access to downtown New Haven, Yale University, Quinnipiac University, employment centers, and regional transportation routes. Public water and public sewer serve the building, which is zoned T3.5.
Key Highlights
- Fully leased configuration with two retail tenants and one second‑floor apartment
- 5,058 square feet on a 0.18‑acre lot
- Six paved off‑street parking spaces
Financial Insights
Estimated NOI and Cap Rate
NOI / Yr
$73,035
Cap Rate
9.13%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$1,460,700
$1.5M
Cap Rate 7%
$1,043,357
$1.0M
Cap Rate 9%
$811,500
$811.5K
Market Conditions
NOI Build-Up for 5,058 SF
Gross rent
$109.3K $21.60/SF
− Vacancy
−$4.9K −$0.97/SF
EGI
$104.3K $20.63/SF
− OpEx
−$31.3K −$6.19/SF
NOI
$73.0K $14.44/SF
Area
New Haven, CT
Vacancy
4.50%
Lease Rate
$21.60 /SF/Yr
Expense Ratio
30.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$1,460,700
Cap Rate 7%
$1,043,357
Cap Rate 9%
$811,500
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.
How Realmo checks its estimates
Property Analytics
Unlock full access to Insights
Subscribe to Realmo Intelligence
Open Analytics
Current Use
Lease Details
1
Residential units
100%
Occupancy
Multi-tenant
Tenancy
Location Intelligence
Trade Area within ½ mile
287
Businesses Nearby
7k
Monthly Visits Nearby
Explore this area
Business Placement
Foot Traffic Nearby
Shops & Services 100%
Citgo
Shops & Services
7,082 visits/mo
0.2 miles
Demographics for 06517, CT
14,954
Population
6,875
Households
2.2
Avg Household Size
45
Median Age
52%
College-Educated
96%
High-School Grad
5.0 sq mi
ZIP Area
2,991
Density / Sq Mi
$97,154
Median Household Income
$58,025
Median Earnings
$1,351
Median Rent
$313,000
Median Home Value
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Market
Vacancy Rate% for Retail in Northeast region
Frequently Asked Questions
What type of property is this?
Mixed-use property - Fully leased retail and residential property with basement storage, central air, and off-street parking.
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: Fully leased configuration with two retail tenants and one second‑floor apartment; 5,058 square feet on a 0.18‑acre lot; Six paved off‑street parking spaces
