517 Locust St

2,358 Sq. Ft.
$337 / Sq. Ft.
2,358
Sq. Ft.
$337
per Sq. Ft.

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...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.
  1. Listed by Corrine Lopez • Colorado Flat Fee Realty Inc
    P: (720)-668-6633 C: (720)-668-6633 corrine@coloradoflatfeerealty.com

Property Details for 517 Locust Street

Structure Type
House
Architectural Style
Contemporary
Levels
Two
Subdivision Name
WIN 23162 L10 BLK6 KERNS
Association
No
Multiple Associations
No
Basement
Yes
LISTING UPDATED: 07/05/2026 12:40 AM

Property Details for 517 Locust Street

StatusActive
MLS #6550382
Days on Compass1
Taxes$4,505 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1904
Lot Size0.20 AC / 8,750 SF
CountyWeld County

Location

Listing Courtesy of Colorado Flat Fee Realty Inc, Corrine Lopez
Add your commute

Building Information for 517 Locust Street

Stories-Year Built1904Building Size-Lot Size0.20 AC / 8,750 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$4,339 per month

30 year fixed, 6.36% Interest

Principal and Interest

$3,964

Property Taxes

$375

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 517 Locust Street

Interior Area & SqFt
Interior Area & SqFt
  • Building Area Total (SqFt Total): 2358
  • Sqft Total: 2358
  • Living Area (SqFt Finished): 1700
  • Above Grade Finished Area: 1700
  • Living SqFt: 1700
  • Sq Ft Apx: 0
  • Below Grade Unfinished Area: 658
  • Area Source: Public Records
  • PSF Total: 337
  • PSF Above Grade: 468
  • PSF Finished: 468
  • Master on Main: Yes
  • Room and Floor: Bedroom-Main-1, Bedroom-Main-2, Bathroom Full-Main-1, Kitchen-Main-1, Living Room-Main-1, Master Bedroom-Upper-1, Bathroom Three Quarter-Upper-1, Bedroom-Upper-1, Bedroom-Upper-2, Dining Room-Main-1, Laundry-Basement-1, Bathroom Full-Upper-1
  • Room Count: 12
  • Basement: Interior Entry, Partial, Sump Pump, Unfinished
  • Heating: Forced Air, Natural Gas
  • Cooling: Central Air
  • 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)
  • Security Features: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)
  • Flooring: Carpet, Tile, Vinyl
  • Window Features: Double Pane Windows, Window Coverings
  • Appliances: Dishwasher, Dryer, Humidifier, Microwave, Oven, Range, Refrigerator, Sump Pump, Washer
  • Laundry Features: Dishwasher, Refrigerator, Washer, Dryer, Microwave, Fire Alarm
Financials & Expenses
Fees & Restrictions
  • Pets Allowed: Cats OK, Dogs OK
Bed & Bath Summary
Bedrooms
  • Bedrooms Total: 5
  • Upper Level Bedrooms: 3
  • Main Level Bedrooms: 2
  • Lower Level Bedrooms: 0
  • Basement Level Bedrooms: 0
Bathrooms
  • Bathrooms Total: 3
  • Upper Level Bathrooms: 2
  • Main Level Bathrooms: 1
  • Lower Level Bathrooms: 0
  • Basement Level Bathrooms: 0
  • Bathrooms Full: 2
  • Bathrooms Three Quarter: 1
  • Bathrooms Half: 0
  • Bathrooms One Quarter: 0
Detailed Room Info
Room 1
  • Room Type: Bedroom
  • Room Level: Main
  • Room Description: Barn Door, Walk-in Closet
Room 2
  • Room Type: Bathroom Full
  • Room Level: Main
  • Room Description: Updated
Room 3
  • Room Type: Bedroom
  • Room Level: Main
Room 4
  • Room Type: Kitchen
  • Room Level: Main
  • Room Description: Stylish Back Splash, Updated White Cabinets, Quartz Counters, Island w/ Seating
Room 5
  • Room Type: Living Room
  • Room Level: Main
  • Room Description: Tall Ceilings, Tons of Charm , LVP Wood Plank Floor
Room 6
  • Room Type: Bedroom
  • Room Level: Upper
  • Room Description: Seating Area, Huge Walk-in Closet, Carpet
Room 7
  • Room Type: Bathroom Three Quarter
  • Room Level: Upper
  • Room Description: Tile, Updated Vanity
Room 8
  • Room Type: Bedroom
  • Room Level: Upper
  • Room Description: Private Balcony, Carpet
Room 9
  • Room Type: Dining Room
  • Room Level: Main
  • Room Description: DR/KI Combo, Eat-in Kitchen
Room 10
  • Room Type: Laundry
  • Room Level: Basement
  • Room Description: Washer and Dryer Included
Room 11
  • Room Type: Bedroom
  • Room Level: Upper
  • Room Description: Apartment Upper Bedroom
Room 12
  • Room Type: Bathroom Full
  • Room Level: Upper
  • Room Description: Apartment Full Bathroom
Parking
Parking
  • Parking Features: Concrete, Gravel, Dry Walled, Exterior Access Door, Finished Garage, Insulated Garage, Lighted, Oversized, Storage
  • Attached Garage: No
  • Parking Type: Garage (Detached), Off-Street
  • Parking Description: Garage (Detached)-2, Off-Street-2
  • Parking Details: 2
  • Parking Total: 2
  • Garage Spaces: 2
  • Offstreet Spaces: 2
  • Parking Count: 4
  • Carport Spaces: 0
  • Reserved Spaces: 0
  • RV Spaces: 0
Association Information
Association Information
  • Association Fee Total Annual: $0
  • Senior Community: No
Site & Location Information
School Information
  • Elementary School: Mountain View
  • Elementary School District: Weld RE-4
  • Middle Or Junior School: Windsor
  • Middle Or Junior School District: Weld RE-4
  • High School: Windsor
  • High School District: Weld RE-4
Site & Location Information
  • Lot Size Acres: .20
  • Lot Size Square Feet: 8750
  • Lot Features: Irrigated, Landscaped, Level, Near Public Transit
  • Zoning: SFR
  • Fencing: Partial
  • Accessibility Features: Level, Paved
  • Property Exclusions: Window Curtains/Drapes, Personal Belongings in both units.
Building Information
Outbuildings
  • Out Building Count: 0
  • Horse: No
Building Information
  • Construction Materials: Frame, Other
  • Roof: Composition
  • Exterior Features: Balcony, Private Yard
  • Patio And Porch Features: Covered, Front Porch, Patio
  • Livable Structure Count: 1
Water & Utilities
Water & Utilities
  • Water Included: Yes
  • Water Source: Public, Well
  • Well Type: Irrigation
  • Well Usage: Domestic
  • Issued Well Permit Numbers: 74789-A
  • Utilities: Cable Available, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available
  • Sewer: Public Sewer

Public Records for 517 Locust Street

Taxable ValueLand$4,140Additions$29,920Total$34,060
Tax Record2023$2,632 ($219 / month)
Home Facts
Beds4Total Finished SqFt1,700 SqFtAbove Grade Finished SqFt1,700 SqFtUnfinished Basement SqFt658 SqFtStories2Lot Size8,756 SqFtStyleSingle Family ResidenceYear Built1904Year Renovated2020CountyWELDAPNR1536586

Schools near 517 Locust Street

This home is within Weld County Reorganized School District No. Re-4.
Rating
School
Type
Grades
Distance
Public - PK to 2
Public - 3 to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Tozer Elementary School
PublicPK to 2

Mountain View Elementary School
Public3 to 5

Windsor Middle School
Public6 to 8

Windsor High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

517 Locust Street is a single family home for sale in Windsor, CO 80550. This property was listed for sale on July 4, 2026 by Colorado Flat Fee Realty Inc, it's currently listed at $795,500. This listing's school district is Weld County Reorganized School District No. Re-4. Nearby schools include Tozer Elementary School, Mountain View Elementary School and Windsor Middle School. 517 Locust Street is a 5-bed, 3-bath, 2,358 sqft single family home built in 1904.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Colorado Flat Fee Realty Inc, Corrine Lopez

Based on information submitted to the MLS GRID as of 07/05/2026 12:40 AM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.