517 Locust Street, Windsor, CO 80550

• 4 beds |
• 2 baths |
• 1,700 sqft

Property Description

Renovated 1904 Farmhouse with Income-Producing ADU 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 ADU 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 two generously sized bedrooms and an updated full bath. Upstairs, the spacious primary suite showcases charming dormer ceilings, a walk-in closet with 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, expansive backyard, and the convenience of the newly built detached garage with ADU above. 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.

Listing Status:

Active

Data Last Updated:

July 5, 2026 at 5:20AM

Listing Office:

Colorado Flat Fee Realty Inc : 303-300-9660

Listing Agent:

Corrine Lopez : 720-668-6633

MLS ID:

6550382

Interior

• General: Breakfast BarCeiling Fan(s)Eat-in KitchenHigh CeilingsHigh Speed InternetKitchen IslandPantryQuartz CountersRadon Mitigation SystemVaulted Ceiling(s)Walk-In Closet(s)
• Appliances: DishwasherDryerHumidifierMicrowaveOvenRangeRefrigeratorSump PumpWasher
• Basement: Interior EntryPartialSump PumpUnfinished
• Flooring: CarpetTileVinyl
• A/C: Central Air
• Heating: Forced AirNatural Gas

Exterior

• General: BalconyPrivate Yard
• Style: Contemporary
• Other Structures: Front PorchPatioCovered
• Parking: ConcreteGravelDry WalledExterior Access DoorFinished GarageInsulated GarageLightedOversizedStorageParking spaces: 4

Construction

• Roofing: Composition
• Windows: Double Pane WindowsWindow Coverings
• General: Two

Location

• Road/Access: Paved
• Originating MLS: recolorado
• School District: Weld RE-4
• County: Weld

Lot

• Zoning: SFRWIN 23162 L10 BLK6 KERNSR1536586
• Fencing: Partial

Utilities

• Utilities: Cable AvailableElectricity AvailableElectricity ConnectedNatural Gas AvailableNatural Gas ConnectedPhone Available
• Water: PublicWell
• Sewer: Public Sewer

Financial

• Source: recolorado
• Ownership: Individual
• Exclusions: Window Curtains/DrapesPersonal Belongings in both units.