Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
0 Beds
3 Baths
5,058 sqft

$799,900

1242 Whitney Avenue, Hamden CT, 06517

Price per sqft$158.15
Built in1900
Property size5,058 sqft
Property typeCommercial

Overview

Active

Listed Mar 25, 2026

Updated 3 weeks ago

Located in the heart of the Whitneyville neighborhood, 1242 Whitney Avenue presents a rare opportunity to acquire a fully occupied, turnkey mixed use investment property with strong in place income. This well-maintained building features two established retail tenants on the ground floor and a fully leased residential apartment on the second floor. The building includes a full basement for ample storage and six paved off street parking spaces-which is a premium in this area. The building is in excellent condition; a new roof was installed in 2023 and new Ac, furnace and HW heater in Soup Girl unit. Strategically located, offering quick access to downtown New Haven. It is just minutes from Yale University, Quinnipiac University, major employment centers, and key transportation routes. The area's mix of local businesses, residential density, and strong community character further enhances the property's appeal.

Additional information

MLS® ID
24161856

Interior Features

Bedrooms
0
Bathrooms
3
Cooling
Yes
Heating
Yes
Basement
No

Exterior Features

Lot Size
0.18 Acres

Other Property Details

Taxes
$18,950
Tax Frequency
Annually
MLS provider logo

Listed by Mark Foreman with Press/Cuozzo Realtors (203) 981-4551

The IDX display contains information sourced from SmartMLS, Inc. as of 9/16/2026. This information is for personal, non-commercial use only and may not be used for any purpose other than identifying properties the viewer may be interested in purchasing. MLS data is generally considered reliable but is not guaranteed accurate by the MLS. Buyers are responsible for verifying all information and should conduct their own investigation or consult a professional. Some MLS data may have been provided by sources other than the listing agent. Unless stated in writing, the Broker/Agent has not verified information obtained from outside sources. The Broker/Agent may or may not have been the listing and/or selling agent, and cannot guarantee the accuracy of any property location shown on a map. Any offer of compensation is made only to participants of the MLS where the listing is filed.

©2026 SmartMLS, Inc. All rights reserved.

Data last updated on 9/16/2026 at 5:46 AM UTC.

Powered by Luxury Presence