Metro Denver Luxury Homes For Sale

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.

Features
: Forced Air, Natural Gas
: Central Air
: Sump Pump, Partial, Unfinished, Interior Entry
: Partial
: Cats OK, Dogs OK
: Carbon Monoxide Detector(s), Smoke Detector(s), Radon Detector
: Covered, Front Porch, Patio
: 4
: Dryer, Dishwasher, Microwave, Range, Refrigerator, Washer, Oven, Humidifier, Sump Pump
: Contemporary
: Concrete, Oversized, Finished Garage, Insulated Garage, Lighted, Storage, Exterior Access Door, Gravel, Dry Walled
: Composition
: Public Sewer
Address Map
CO
Weld
Windsor
80550
Locust
517
Street
W105° 5' 41.3''
N40° 28' 32.7''
Additional Information
: Frame, Other
Mountain View
: Balcony, Private Yard
: Carpet, Tile, Vinyl
2
Windsor
: Pantry, High Ceilings, Quartz Counters, Kitchen Island, Eat-in Kitchen, Vaulted Ceiling(s), High Speed Internet, Ceiling Fan(s), Radon Mitigation System, Walk-In Closet(s), Breakfast Bar
Yes
Yes
Cash, Conventional, Jumbo, Other
: Level, Near Public Transit, Landscaped, Irrigated
Windsor
Colorado Flat Fee Realty Inc
R1536586
: None
: House
WIN 23162 L10 BLK6 KERNS
$4,505
2025
: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Electricity Connected, Natural Gas Connected
: Double Pane Windows, Window Coverings
SFR
07/04/2026
2358
Active
Weld RE-4
Weld RE-4
Weld RE-4
07/05/2026
07/04/2026
Public, Well
: Two

WIN 23162 L10 BLK6 KERNS

517 Locust Street, Windsor, CO 80550

5 Bedrooms
3 Total Baths
1,700 Square Feet
$795,500
Listing ID #6550382
Basic Details
Property Type : Residential
Listing Type : For Sale
Listing ID : 6550382
Price : $795,500
Bedrooms : 5
Rooms : 12
Total Baths : 3
Full Bathrooms : 2
3/4 Bathrooms : 1
Square Footage : 1,700 Square Feet
Year Built : 1904
Lot Area : 8,750 Acres
Lot Acres : 0.2
Property Sub Type : Single Family Residence
Status : Active
Originating System Name : REcolorado
Mortgage Calculator
$
$ %
years
%
$ %per year
$ %per year

$
Contact Agent