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 Market159
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 1, Bathroom 2, Bathroom 3
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
Taxes and HOA fees
Tax Year
2026
Tax Annual Amount
18318
Utilities
Sewer type
Public Sewer
Cooling system
Central Air
Water source
Public
Amenities
full basement
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: Aug 30
Last Checked: Aug 30 at 3: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.
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 = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$73,035
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
9.13%
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
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
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.
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 rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
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.
Property Analytics
Property Profile
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
Market
Vacancy Rate% for Retail 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?
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
