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.
No photo available
$795,500 New to Website
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.
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: $795,500
- Taxes: $4,505 (2025)
- Status: Active
- Type: Single Family
- Source: MetroList_Colorado
- MLS ID: 6550382
- Updated: 7/6/2026
- Added to Site: 2 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: 2,358
- Sq. Ft. Source: Public Records
- Living Area: 1,700 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,821Sq. Ft.
- MLS # 1061250
Listed by Andy Hawbaker (970) 203-5066
- Single Family
- Active
- 5Beds
- 3Total Baths
- 4,137Sq. Ft.
- MLS # 1056917
Listed by LPT Realty, LLC.
- Single Family
- Active
- 5Beds
- 3Total Baths
- 3,620Sq. Ft.
- MLS # 1061399
Listed by Resident Realty
- Single Family
- Active
- 5Beds
- 3Total Baths
- 3,458Sq. Ft.
- MLS # 1061484
Listed by Group Harmony
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
- 3Beds
- 3Total Baths
- 3,128Sq. Ft.
- MLS # 1063366
Listed by Realty One Group Fourpoints
- Single Family
- Active
- Updated 5 days ago
- 4Beds
- 2Total Baths
- 2,914Sq. Ft.
- MLS # 1063086
Listed by Keller Williams Realty NoCo
- Single Family
- Active
- Updated 3 days ago
- 5Beds
- 4Total Baths
- 2,348Sq. Ft.
- MLS # 1063301
Listed by eXp Realty LLC
- Single Family
- Active
- Updated 3 days ago
- 3Beds
- 3Total Baths
- 2,756Sq. Ft.
- MLS # 1063247
Listed by eXp Realty - Northern CO
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 1 day ago
- 5Beds
- 5Total Baths
- 3,809Sq. Ft.
- MLS # 1062901
Listed by The Woodrum Team (970) 223-6500
- Single Family
- Active
- Updated 6 days ago
- 4Beds
- 3Total Baths
- 3,570Sq. Ft.
- MLS # 1061540
Listed by Michelle Algueseva Nelson (303) 748-5247
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 3Total Baths
- 2,914Sq. Ft.
- MLS # 1057716
Listed by Grimes Real Estate
- Single Family
- Active
- Updated 6 days ago
- 4Beds
- 3Total Baths
- 1,942Sq. Ft.
- MLS # 1055799
Listed by RE/MAX Alliance-FTC South
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
- 5Beds
- 4Total Baths
- 3,883Sq. Ft.
- MLS # 1045774
Listed by Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins
Sold by Keller Williams-DTC
Sold by Keller Williams-DTC
- 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 $795,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.