Skip to content

517 Locust StreetWindsor, CO 80550

Kerns Sub · Weld County

$725,000List price
5Beds
2Baths
3,126Sq Ft
1904Year built
0.20Acre lot
2Garage
12 weeks agoOn market

Description

Total SF does include ADU/APT Finished SF as well $1,700 Rental income. Renovated 1904 Farmhouse w/ Income-Producing ADU/Apartment in the Heart of Windsor! Blending timeless historic charm with modern updates, this beautifully renovated farmhouse offers the perfect combination of character, comfort, and versatility. Situated on a spacious lot with no HOA. Home feat. a detached 2-car garage topped by a private 1-bedroom, 1-bath apartment, built in 2023 and is permitted for long-term or short-term rental and can be a secondary stream of income for the owner; multigenerational living, or a guest retreat. The inviting covered front porch welcomes you into a light-filled interior featuring expansive picture windows, and stylish wide-plank LVP flooring throughout the main living areas. The remodeled chef's kitchen is designed to impress w/ quartz countertops, GE slate stainless steel appliances, a gas range, custom tile backsplash, soft-close cabinetry, a center island with seating, and a walk-in pantry. The main level offers 2 sizable bdrms and an updated full bath. Upstairs, the spacious primary suite showcases charming dormer ceilings, a walk-in closet w/ a barn door, a sitting or dressing area, and an updated ensuite bath. A large secondary bedroom features a Juliet balcony overlooking the park-like backyard. The rare full-height basement provides endless possibilities for future expansion, including a home office, theater, game room, playroom, or non-conforming fifth bedroom. Enjoy the outdoor patio and expansive backyard. In addition to the detached garage, the driveway can easily park an additional 2-3 cars, plus off street parking, so TONS of parking available! Located just 1.5 blocks from Main Park and only three blocks from downtown Windsor's shops, restaurants, and community events, this one-of-a-kind property offers historic appeal, modern living, and exceptional income potential. This property is in a very desirable location in the heart of downtown Windsor.

Property Information

Property type
Residential
Sub-type
Single Family Residence
Structure type
House
Year built
1904
Living area
2,468 Sq Ft
Lot size
0.20 acres
Garage spaces
2
Parking spaces
4
Ownership
Individual
Zoning
SFR
Days on market
88
MLS® Listing#
6550382

Property Features

Interior
Breakfast Bar · Ceiling Fan(s) · Eat-in Kitchen · High Ceilings · High Speed Internet · Kitchen Island · Pantry · Vaulted Ceiling(s) · Walk-In Closet(s)
Exterior
Balcony · Private Yard
Appliances
Dishwasher · Dryer · Humidifier · Microwave · Oven · Range · Refrigerator · Washer
Cooling
Ceiling Fan(s) · Central Air
Heating
Forced Air · Natural Gas
Flooring
Carpet · Tile · Vinyl
Basement
Sump Pump · Interior Entry · Partial · Unfinished
Parking
Concrete · Gravel · Lighted · Oversized · Storage
Patio
Covered · Front Porch · Patio
Fencing
Partial
Lot features
Landscaped · Level · Near Public Transit
Construction
Frame · Other
Roof
Composition
Windows
Double Pane Windows · Window Coverings
Security
Carbon Monoxide Detector(s) · Smoke Detector(s)
Utilities
Natural Gas Available · Cable Available · Electricity Available · Electricity Connected · Natural Gas Connected · Phone Available
Sewer
Public Sewer
Water source
Private · Public · Well

Rooms

Main

  • Bathroom Full
  • Bedroom
  • Dining Room
  • Kitchen
  • Living Room

Upper

  • Bathroom Three Quarter
  • Bathroom Full
  • Bedroom

Basement

  • Laundry

Schools

Elementary
Mountain View
Middle
Windsor
High
Windsor

Financial Details

HOA
None
Annual taxes
$4,505Tax year 2025
Parcel number
R1536586
Metrolist Inc MLS - Professional (Denver) logo

Listing Courtesy: Colorado Flat Fee Realty Inc - 720-668-6633

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange (“IDX”) program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than EXIT Realty are marked with the IDX Logo. This information is being provided for the consumers’ personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought. The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.

PUBLISHER'S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.

METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.

Licensed in the state of Colorado

Data Terms of Use
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.

The information contained in this publication is subject to change without notice. METROLIST, INC. MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC. SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.

PUBLISHER'S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.

METROLIST, INC. will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.

©2017 METROLIST, INC. All Rights Reserved 7100 E. Belleview Ave. #110 Greenwood Village, CO 80111 USA

ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.

Commute Calculator

Explore commute times from 517 Locust Street, Windsor, CO 80550.

Travel mode

Connect with a Local Real Estate Expert