Date
Details
Price
Change
Source
5/06/2022
Sold
$550,000
—
Public Record
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/46
$749,500 -$25,500 (-3.29%) Price Reduced
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/46
Property Description
Total SF does include ADU/APT Finished SF as well. 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.
Full Property Details
Full Property Details for 517 Locust St
Sign in to view more details. Local MLS Rules require you to be signed in. Not a member yet? Sign up now.
General
- Price: $749,500
- Taxes: $4,505 (2025)
- Status: Active
- Type: Single Family
- Source: MetroList_Colorado
- MLS ID: 6550382
- Updated: 8/21/2026
- Added to Site: 48 day(s) ago
Interior
- Interior Features: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, High Ceilings, High Speed Internet, Kitchen Island, Pantry, Quartz Counters, Radon Mitigation System, Vaulted Ceiling(s), Walk-In Closet(s)
- Appliances: Dishwasher, Dryer, Humidifier, Microwave, Oven, Range, Refrigerator, Sump Pump, Washer
- Flooring: Carpet, Tile, Vinyl
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 2
- 3/4 Bathrooms: 1
- Main Floor Baths: 1
Bedrooms
- Total Bedrooms: 5
- Bedrooms Main: 2
Additional Information
- Security/Safety: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)
Exterior
- Exterior Features: Balcony, Private Yard
- Porch/Patio/Deck: Covered, Front Porch, Patio
Parking
- Garage: Yes
- Garage Spaces: 2
- Total Spaces: 4
- Parking Features: Concrete, Gravel, Dry Walled, Exterior Access Door, Finished Garage, Insulated Garage, Lighted, Oversized, Storage
Location
- County: Weld
- Subdivision: Kerns Sub
School Information
- Elem School District: Weld RE-4
- Midd School District: Weld RE-4
- High School District: Weld RE-4
- Elementary School: Mountain View
- Middle School: Windsor
- High School: Windsor
Community
- Pets Allowed: Yes
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Forced Air, Natural Gas
Utilities
- Gas: Yes
- Sewer: Public Sewer
- Water: Public, Well
- Utility Description: Cable Available, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available
Structural Information
- Architectural Style: Contemporary
- Structure Type: House
- Construction: Frame, Other
- Basement: Yes
- Basement Desc.: Interior Entry, Partial, Sump Pump, Unfinished
- Roof: Composition
- Windows: Double Pane Windows, Window Coverings
- Square Feet: 3,126
- Sq. Ft. Source: Public Records
- Living Area: 2,468 Sq. Ft.
- Year Built: 1904
Lot Features
- Lot Size (Acres): 0.2
- Lot Size (Sq. Ft.): 8,750
- Street/Road Desc.: Paved
- Fence: Yes
- Lot Features: Irrigated, Landscaped, Level, Near Public Transit
- Zoning: SFR
- Fencing (Description): Partial
Financial Considerations
- Tax Amount: $4,505
- Tax Year: 2025
- Terms: Cash, Conventional, Jumbo, Other
Disclosures and Reports
- Ownership: Individual
- Special Conditions: None
- Legal Description: WIN 23162 L10 BLK6 KERNS
- Exclusions: Window Curtains/Drapes, Personal Belongings in both units.
- Property ID: R1536586
Listed by Colorado Flat Fee Realty Inc
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 517 Locust St —
Colorado Flat Fee Realty Inc
720-668-6633
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 517 Locust St
School District:Windsor School District Re-4
| Name | Grades | Distance |
|---|---|---|
Tozer Elementary School 501 Oak Street, Windsor, CO 80550 | PK-2 | 0.1 mi |
Mountain View Elementary School, Windsor, CO 810 3rd Street, Windsor, CO 80550 | 3-5 | 0.3 mi |
Windsor Middle School 900 Main Street, Windsor, CO 80550 | 6-8 | 0.5 mi |
Windsor High School 1100 Main Street, Windsor, CO 80550 | 9-12 | 0.7 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 517 Locust St
Tax History
Tax History for 517 Locust St
Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,505
—
$44,250
-2%
2025
$4,505
—
$45,050
-12%
2024
$4,518
72%
$51,030
50%
2023
$2,632
17%
$34,060
33%
2021
$2,246
-7%
$25,550
3%
2022
$2,411
45%
$24,840
29%
2020
$1,662
60%
$19,270
—
2019
$1,036
34%
$19,270
22%
2018
$776
-49%
$15,790
—
2017
$1,510
116%
$15,790
7%
2016
$700
8%
$14,790
—
2015
$651
16%
$14,790
148%
2014
$560
-1%
$5,960
—
2013
$567
—
$5,960
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 517 Locust St
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- 5Beds
- 3Total Baths
- 3,620Sq. Ft.
- MLS # 1061399
Listed by Resident Realty
- Single Family
- Active
- 5Beds
- 3Total Baths
- 3,018Sq. Ft.
- MLS # 1061560
Listed by RE/MAX Alliance-Windsor
- Single Family
- Active
- Updated 13 days ago
- 5Beds
- 3Total Baths
- 4,294Sq. Ft.
- MLS # 1066016
Listed by Hops & Homes
- Single Family
- Active
- Updated 5 days ago
- 5Beds
- 3Total Baths
- 4,373Sq. Ft.
- MLS # 1065992
Listed by 8z Real Estate
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
![[Address not provided], Severance, CO 80546 - Photo 1](https://m.cbhomes.com/p/1119/1066959/f50427740b1c42F/s23cc.webp)
- Farm
- Active
- Updated 9 hours ago
- MLS # 1066959
Listed by Hayden Outdoors - Windsor
- Single Family
- Active
- Updated 1 day ago
- 5Beds
- 3Total Baths
- 1,920Sq. Ft.
- MLS # 1066881
Listed by Realty One Group Fourpoints and Non-IRES
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 2Total Baths
- 1,423Sq. Ft.
- MLS # 1066792
Listed by DR Horton Realty LLC
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 2Total Baths
- 2,824Sq. Ft.
- MLS # 1066728
Listed by Kentwood RE Northern Prop Llc
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 3Total Baths
- 2,775Sq. Ft.
- MLS # 1065398
Listed by C3 Real Estate Solutions, LLC
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 3Total Baths
- 3,471Sq. Ft.
- MLS # 1065587
Listed by Your Castle Real Estate LLC
- Single Family
- Active
- Updated 3 days ago
- 5Beds
- 5Total Baths
- 4,912Sq. Ft.
- MLS # 1045052
Listed by Group Mulberry
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 4Total Baths
- 2,451Sq. Ft.
- MLS # 1064647
Listed by Kittle Real Estate
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 4Beds
- 3Total Baths
- 3,455Sq. Ft.
- MLS # 1054512
Listed by Realty One Group Fourpoints CO
Sold by C3 Real Estate Solutions, LLC
Sold by C3 Real Estate Solutions, LLC
- Single Family
- Closed
- 4Beds
- 3Total Baths
- 3,851Sq. Ft.
- MLS # 1049212
Listed by RE/MAX Alliance-FTC South
Sold by eXp Realty - Inspired Living Group
Sold by eXp Realty - Inspired Living Group
- Single Family
- Closed
- 4Beds
- 3Total Baths
- 3,280Sq. Ft.
- MLS # 1049975
Listed by Real
Sold by Picket Fence Properties
Sold by Picket Fence Properties
- Warehouse
- Closed
- MLS # 1056465
Listed and Sold by Colorado Commercial, Ltd
517 Locust Street, Windsor, CO 80550 (MLS# 6550382) is a Single Family property with 5 bedrooms, 2 full bathrooms and 1 partial bathroom. 517 Locust Street is currently listed for $749,500 and was received on July 04, 2026. Want to learn more about 517 Locust Street? Do you have questions about finding other Single Family real estate for sale in Windsor? You can browse all Windsor real estate or contact a Coldwell Banker agent to request more information.