Skip main navigation
Accepting backups
  • Price cut: $20.5K (7/26)
    $775,000

    517 Locust Street, Windsor, CO 80550

    5beds
    3,126sqft
    : 
    $4,869/mo
    Get pre-qualified
    Single Family Residence
    Built in 1904
    8,750 Square Feet Lot
    $760,200 Zestimate®
    $248/sqft
    $-- HOA

    What's special

    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.
    44 days
    |
    538
    |
    19
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Corrine Lopez 720-668-6633,

    Colorado Flat Fee Realty Inc

    Source: REcolorado as distributed by MLS GRID,MLS#: 6550382MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 3
      • Full bathrooms: 2
      • 3/4 bathrooms: 1
      • Main level bathrooms: 1
      • Main level bedrooms: 2
      Bedroom
      • Description: Barn Door, Walk-In Closet
      • Level: Main
      Bedroom
      • Level: Main
      Bedroom
      • Description: Seating Area, Huge Walk-In Closet, Carpet
      • Features: Primary Suite
      • Level: Upper
      Bedroom
      • Description: Private Balcony, Carpet
      • Level: Upper
      Bedroom
      • Description: Apartment Upper Bedroom
      • Level: Upper
      Bathroom
      • Description: Updated
      • Level: Main
      Bathroom
      • Description: Tile, Updated Vanity
      • Level: Upper
      Bathroom
      • Description: Apartment Full Bathroom
      • Level: Upper
      Dining room
      • Description: Dr/Ki Combo, Eat-In Kitchen
      • Level: Main
      Kitchen
      • Description: Stylish Back Splash, Updated White Cabinets, Quartz Counters, Island W/ Seating
      • Level: Main
      Laundry
      • Description: Washer And Dryer Included
      • Level: Basement
      Living room
      • Description: Tall Ceilings, Tons Of Charm , Lvp Wood Plank Floor
      • Level: Main
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Dryer, Humidifier, Microwave, Oven, Range, Refrigerator, Washer
      Features
      • 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)
      • Flooring: Carpet, Tile, Vinyl
      • Windows: Double Pane Windows, Window Coverings
      • Basement: Interior Entry,Partial,Sump Pump,Unfinished
      Interior area
      • Total structure area: 3,126
      • Total interior livable area: 3,126 sqft
      • Finished area above ground: 2,468
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 4
      • Parking features: Concrete, Dry Walled, Exterior Access Door, Insulated Garage, Lighted, Oversized, Storage
      • Garage spaces: 2
      • Details: Off Street Spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Covered, Front Porch, Patio
      • Exterior features: Balcony, Private Yard
      • Fencing: Partial
      Lot
      • Size: 8,750 Square Feet
      • Features: Irrigated, Landscaped, Level, Near Public Transit
      Details
      • Parcel number: R1536586
      • Zoning: SFR
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Contemporary
      • Property subtype: Single Family Residence
      Materials
      • Frame, Other
      • Roof: Composition
      Condition
      • Year built: 1904

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public, Well
      • Utilities for property: Cable Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available

      Community & HOA

      Community
      • Security: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)
      • Subdivision: Kerns Sub
      HOA
      • Has HOA: No
      Location
      • Region: Windsor

      Financial & listing details

      • Price per square foot: $248/sqft
      • Tax assessed value: $720,707
      • Annual tax amount: $4,505
      • Date on market: 7/4/2026
      • Listing terms: Cash,Conventional,Jumbo,Other
      • Exclusions: Window Curtains/Drapes, Personal Belongings In Both Units.
      • Ownership: Individual
      • Electric utility on property: Yes
      • Road surface type: Paved

        Estimated market value

        $760,200

        $722,000 - $798,000

        $2,818/mo

        Price history

        DateEventPrice
        8/8/2026Pending sale$775,000$248/sqft
        Source: REcolorado as distributed by MLS GRID #6550382 Report a problem
        7/26/2026Price change$775,000-2.6%$248/sqft
        Source: REcolorado as distributed by MLS GRID #6550382 Report a problem
        7/4/2026Listed for sale$795,500+44.6%$254/sqft
        Source: REcolorado as distributed by MLS GRID #6550382 Report a problem
        5/6/2022Sold$550,000$176/sqft
        Source: IRES as distributed by MLS GRID #961475 Report a problem
        4/5/2022Pending sale$550,000$176/sqft
        Source: IRES as distributed by MLS GRID #961475 Report a problem
        3/25/2022Listed for sale$550,000+46.7%$176/sqft
        Source: IRES as distributed by MLS GRID #961475 Report a problem
        4/27/2020Sold$375,000+2.7%$120/sqft
        Source: Public Record Report a problem
        3/29/2020Pending sale$365,000$117/sqft
        Source: Hub Real Estate #907634 Report a problem
        3/26/2020Listed for sale$365,000+78.9%$117/sqft
        Source: Hub Real Estate #907634 Report a problem
        12/3/2019Sold$204,000$65/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$4,505 -0.3%$44,250 -1.8%
        2025$4,518 +71.7%$45,050 -11.7%
        2024$2,632 +9.2%$51,030 +49.8%
        2023$2,411 +7.3%$34,060 +37.1%
        2022$2,246 +35.2%$24,840 -2.8%
        2021$1,662 $25,550 +32.6%
        2020$1,662 +114.2%$19,270
        2019$776 -25.1%$19,270 +22%
        2018$1,036 +33.5%$15,790
        2017$776 -48.6%$15,790 +6.8%
        2016$1,510 +132.1%$14,790
        2015$651 +16.2%$14,790 +148.2%
        2014$560 $5,960
        2013-- $5,960 -55.6%
        2012-- $13,420
        2011-- $13,420 +2%
        2010-- $13,160
        2009-- $13,160 +9%
        2008-- $12,070
        2007-- $12,070 -13.5%
        2006-- $13,950
        2005-- $13,950 +3.4%
        2004-- $13,490 -1%
        2003-- $13,620 +4.4%
        2002-- $13,050 +16.4%
        2001-- $11,210
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 80550

        Getting around

        62 / 100
        Somewhat Walkable
        46 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Mountain View
        • Middle: Windsor
        • High: Windsor
        • District: Weld RE-4

        Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes