1242 Whitney Ave, Hamden, CT

Name: 1242 Whitney Ave, For Rent in Hamden - Zoocasa
Brand: Press/Cuozzo Realtors
SKU: 24161856
Price: 825000 USD

House

For Rent

Listed price in listed location currency (USD).

$825,000

030

MLS® 24161856

Overview

Key Facts

Type

Levels Commercial Lease

Size -

Garage

Date Available

Days Active 78

Lot Size

Approx. Age 1900

MLS® Number 24161856

Property Address: 1242 Whitney Ave, Hamden, CT, 06517-2811

Average square foot calculated using Size range provided by listing agent.

Description

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.

MLS® Number24161856

Laundry Level

Central VacNo

FireplaceNo

Acreage

Exterior

Garage

Approx. Age1900

Basement

Driveway

Garage Spaces

HeatNatural Gas, Hot Air

A/CCentral Air

Extras

Price History

Last Sold Price

$17$17

Appreciation

Avg. Days Listed

400 days

Today, For Rent for $825,000

For Rent · 78 days

$825,000

MLS® 24161856

3 months ago

Not Leased Yet

March 2026, For Rent for $825,000

For Rent · 78 days

$825,000

MLS® 24161856

3 months ago

Not Leased Yet

August 2025, Leased for $17

Leased · 400 days

$17

MLS® 24005172

10 months ago

Sold on Aug 20, 2025

Map

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment

I want to view this property

Yes, I'd like to receive free weekly market insights and buying and selling tips. Unsubscribe at any time.

By pressing "Take a Tour", I confirm that I have read and agree to the eXp Privacy Policy, and Terms of Use.

By pressing "Take a Tour", I am electronically signing and consenting to receive marketing comms about real estate brokerage and mortgage lending services, delivered via email, phone and/or text (using "automated technology" such as an automatic telephone dialing system, and/or an artificial or prerecorded voice), from eXp Realty® and its independent contractor real estate professionals and their affiliate SUCCESS® Lending using the contact information I provided. Your consent is not a condition of purchase and you may revoke it at any time by replying "STOP" to any texts. Text HELP for more info. Message and data rates may apply. You may also contact us directly at 1-844-683-4664.

Similar Listings

Comparable Properties

Company

Stay Connected

1-844-683-4663

[email protected]

800 - 1070 Douglas Street, Victoria, BC, V8W2C4

Download Our App

US Real Estate Listings Canada Real Estate Listings

Owned by

A group of people at an event are laughing and cheering, with one man enthusiastically greeting a seated couple in the front row.

The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.

eXp Realty holds real estate brokerage licenses in multiple states. Zoocasa (Canada), Inc. holds real estate brokerage licenses in multiple provinces. For information on licenses please contact us at [email protected]

For listings in Canada, the trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.

MLS® Compliance Statements
Tony King – Designated Managing Broker, Broker Operations – TX.
Texas Real Estate Commission information about brokerage services
Texas Real Estate Commission Consumer Protection Notice

eXp Realty® is committed to adhering to the guidelines of The New York State Fair Housing Regulations. The Fair Housing Notice →

*Standardized Operating Procedure for Purchasers of Real Estate Pursuant to Real Property Law 442-H. Learn More →

eXp Realty of California, Inc. | CA DRE# 01878277 | Deborah Penny – Designated Broker
eXp Realty of Southern California, Inc. | CA DRE# 02187306 | Gina Saad – Designated Broker
eXp Realty of Greater Los Angeles, Inc. | CA DRE# 02188471 | Anita Cruz – Designated Broker
eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas Penny – Designated Broker
Fair Housing and Reasonable Accommodations
DMCA Notice