A unique opportunity in a Village Residential-Commercial district with a wide range of possibilities. The zoning allows uses including office, retail, restaurant, medical or veterinary practice, daycare, lodging, mixed-use development, and more, with additional uses available by conditional approval. The current owner has already invested significant time and effort exploring the property's potential, including working with professionals to better understand the building, site, and possibilities for future expansion. A substantial amount of information and due diligence is available to share with a serious buyer, providing a valuable head start for someone ready to bring their own vision to the property. The seller could consider selling approximately half an acre of residential land located behind the property. **This land is not included in the current listing or asking price, but interested buyers are encouraged to inquire.** If you're looking for a property with flexibility, potential, and some of the preliminary legwork already completed, this is an opportunity worth exploring.

Listing Tools

Property Details of 788 Hartford Avenue

Property Details

Map Location

Broker Reciprocity 

Copyright 2026 PrimeMLS, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this display comes in part from the IDX Program of PrimeMLS. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated September 5, 2026 8:38 AM UTC

 

Hi there! How can we help you?

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

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Diamond Realty. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

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.