Meticulously maintained and move-in ready, this versatile property offers exceptional visibility with prime frontage along The Derby Road/US Route 5 on a spacious 0.46-acre lot. Zoned Village Commercial Derby Center (VC/DC), the property provides a variety of potential uses including a primary residence, home occupation, office, personal service business, retail establishment, and numerous other conditional uses. The home features 930 sq.ft. of finished living space with an updated eat-in kitchen, comfortable living room, three bedrooms, and a full bath. Additional highlights include an enclosed front porch, full basement offering excellent storage and workshop space, attached two-car garage and a rear patio. Extensively renovated in recent years, improvements include a beautifully remodeled kitchen with quartz countertops and stainless steel appliances, updated bathroom, fresh interior and exterior paint, laminate flooring throughout, updated lighting, vinyl replacement windows, and more. Serviced by village water and sewer, high-speed cable and internet, and efficient propane forced hot air heat. The level lawn, paved driveway, and ample parking further enhance the property's appeal. Whether you're seeking an affordable home, business location, or investment opportunity, this turnkey property offers outstanding value, flexibility, and convenience in the heart of Derby Center.

Listing Tools

Property Details of 3174 Us Route 5

Property Details

Interior Features

Exterior Features

Utilities and Appliances

Community

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 June 19, 2026 1:54 PM 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 Jim Campbell Real Estate. 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.