Listing Tools

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.

Property Details of 1242 Whitney Avenue Whitneyville

Property Details

Interior Features

Utilities and Appliances

Nearest Landvest Office

Concord, MA

Concord, MA

24 Main Street,
Concord, MA 01742

Never Miss New Listings

Never miss new listings between $743,000 - $908,000 in this neighborhood
Successfully Subscribed!
Do not fill in this field:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

We will never spam you or sell your details. You can unsubscribe whenever you like.

Map Location

Do not fill in this field:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Schedule A Visit

Schedule a Visit

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The data relating to real estate for sale on this website appears in part through the SmartMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SmartMLS through a licensing agreement. Listing information is from various brokers who participate in the SmartMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2026 SmartMLS, Inc.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.