Listed by Sussy DeLeon of RE/MAX New Horizons
Outstanding mixed use opportunity in Providence's North End. This extensively renovated property offers an exceptional combination of commercial and residential space in a highly visible location near the intersection of Branch Avenue and Charles Street.The property features two commercial storefronts on the first floor, ideal for a variety of retail, office, professional, service, or business uses. Above are two spacious side by side townhouse style apartments, each offering 3 bedrooms, generous living space, modern finishes, and central air conditioning.Extensive improvements have been completed throughout the property, including major interior and exterior updates. The building offers the appearance, functionality, and convenience today's owners and tenants are seeking. With modern systems, updated finishes, attractive curb appeal, and flexible mixed use potential, this property is well suited for investors, business owners, or owner occupants. Strategically positioned on a busy corridor with excellent visibility and traffic exposure, this property offers outstanding potential for both commercial and residential income. Conveniently located near downtown Providence, Route 146, I 95, shopping, restaurants, and other amenities.A rare opportunity to own a turnkey mixed use property with multiple income streams in one of Providence's most accessible locations.

Listing Tools

Property Details of 248 Hawkins Street, North End

Property Details

Exterior Features

Community

Map Location

 IDX information is provided exclusively 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. Information is deemed reliable but is not guaranteed.  ©  2026 State-Wide Multiple Listing Service. All rights reserved.

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 Costello 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.