# 1242 Whitney Avenue, Hamden, CT 06517 > **TL;DR:** 0bd/3ba commercial, $799,900 ($158/sqft), built 1900, 5,058 sqft. > A/C. Est. $4,278/mo. Listed 217 days. ## Property at a Glance | Attribute | Value | |-----------|-------| | Price | $799,900 | | Price/sqft | $158 | | Bathrooms | 1 full, 2 half | | Square Feet | 5,058 | | Year Built | 1900 | | Lot Size | 7,841 sqft (0.18 acres) | | Stories | 2 | | Property Type | Commercial (Other) | | Status | Active | | Days on Market | 217 | ## Estimated Monthly Costs | Category | Amount | |----------|--------| | Principal & Interest (20% down, 30-year at 6.5%) | $4,045 | | Estimated Insurance | $233 | | **Total** | **$4,278** | ## Key Amenities - A/C ## Property Highlights - Built in 1900 - 0.18 acre lot - 2 stories ## Description ### 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. ## Location - **Address:** 1242 Whitney Avenue, Hamden, CT 06517 - **County:** New Haven ## Listing Agent - **Name:** Mark Foreman - **Brokerage:** Press/Cuozzo Realtors - **Broker Phone:** 203-288-1900x123 ## Photos ![1242 Whitney Avenue - Photo 1](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f444650447r.jpg) ![1242 Whitney Avenue - Photo 2](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f2752371213r.jpg) ![1242 Whitney Avenue - Photo 3](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f3815381738r.jpg) ![1242 Whitney Avenue - Photo 4](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f2798356225r.jpg) ![1242 Whitney Avenue - Photo 5](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f165909289r.jpg) ![1242 Whitney Avenue - Photo 6](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f3157706816r.jpg) ![1242 Whitney Avenue - Photo 7](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f780429552r.jpg) ![1242 Whitney Avenue - Photo 8](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f1988582848r.jpg) ![1242 Whitney Avenue - Photo 9](http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f516807812r.jpg) --- **MLS#:** 24161856 | **Updated:** 2026-10-25 **Source:** listhub *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.* [View on PropertySimple](https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974) --- ## Structured Data ```json { "@context": "https://schema.org", "@type": "RealEstateListing", "@id": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974#listing", "url": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974", "name": "1242 Whitney Avenue, Hamden, CT 06517", "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.", "image": [ "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f444650447r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f2752371213r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f3815381738r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f2798356225r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f165909289r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f3157706816r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f780429552r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f1988582848r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f516807812r.jpg" ], "primaryImageOfPage": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f444650447r.jpg", "caption": "1242 Whitney Avenue - Hamden, CT" }, "datePosted": "2026-03-25", "dateModified": "2026-10-25T12:23:20.327Z", "mainEntity": { "@type": "Place", "@id": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974#property", "name": "1242 Whitney Avenue, Hamden, CT 06517", "address": { "@type": "PostalAddress", "streetAddress": "1242 Whitney Avenue", "addressLocality": "Hamden", "addressRegion": "CT", "postalCode": "06517", "addressCountry": "US" }, "image": [ "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f444650447r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f2752371213r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f3815381738r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f2798356225r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f165909289r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f3157706816r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f780429552r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f1988582848r.jpg", "http://lh.rdcpix.com/49b422928ee320957538f74c41c4e454l-f516807812r.jpg" ], "identifier": { "@type": "PropertyValue", "propertyID": "MLS", "value": "24161856" }, "amenityFeature": [ { "@type": "LocationFeatureSpecification", "name": "Cooling", "value": "Central Air" }, { "@type": "LocationFeatureSpecification", "name": "Air Conditioning", "value": true } ], "additionalProperty": [ { "@type": "PropertyValue", "name": "Lot Size", "value": "0.18 acres" }, { "@type": "PropertyValue", "name": "Stories", "value": 2 }, { "@type": "PropertyValue", "name": "Property Subtype", "value": "Other" }, { "@type": "PropertyValue", "name": "Property Type", "value": "Commercial" } ] }, "offers": { "@type": "Offer", "@id": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974#offer", "url": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974", "price": 799900, "priceCurrency": "USD", "businessFunction": "http://purl.org/goodrelations/v1#Sell", "availability": "https://schema.org/InStock", "seller": { "@id": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974#agent" } }, "provider": { "@type": "Person", "@id": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974#agent", "name": "Mark Foreman", "worksFor": { "@type": "Organization", "@id": "https://staging.propertysimple.ai/listing/1242-whitney-avenue-hamden-ct-06517-b64e02f8e9c2431c8e82b8524c532974#brokerage", "name": "Press/Cuozzo Realtors", "telephone": "203-288-1900x123", "logo": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/c5ababc31d52725c011d53aa951d01c2k-c2825068748r.jpg" } } } } ```