517 Locust Street, Windsor, CO 80550

• 5 beds |
• 3 baths |
• 1,700 sqft

Property Description

Renovated 1904 Farmhouse with 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 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 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.

Listing Status:

Active

Data Last Updated:

July 5, 2026 at 7:21AM

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.