.png?1686864051)
BEDS5
BATHS3 full
SQUARE FEET2,358
MLS#6550382
STATUSActive
PROPERTY TYPEResidential - Single Family
SUBDIVISIONKerns Sub
SCHOOLWeld RE-4
Listing Courtesy of:
Colorado Flat Fee Realty Inc
Agency Contact: 720-668-6633
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 chefs 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 Windsors 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.
Property Features
Property Type: Residential - Single Family
Basement: Interior Entry, Partial, Sump Pump, Unfinished
Cooling: Central Air
Garage: 2
Heating: Forced Air, Natural Gas
Home Style: Contemporary
Lot Size: 0.20 Acres
Roof Type: Composition
Stories: 2.0
Taxes: $4,505
Year Built: 1904
Amenities
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)
Balcony
Private Yard
Feature Descriptions
Appliances: Dishwasher, Dryer, Humidifier, Microwave, Oven, Range, Refrigerator, Sump Pump, Washer
Baths 3/4: 1
Baths Full: 2
Baths Half: 0
Baths Total: 3
Days on Site: 10
Exclusions: Window Curtains/Drapes, Personal Belongings in both units.
Exterior: Frame, Other
Fencing: Partial
Flooring: Carpet, Tile, Vinyl
Lot: Irrigated, Landscaped, Level, Near Public Transit
Parcel#: R1536586
Parking: Concrete, Gravel, Dry Walled, Exterior Access Door, Finished Garage, Insulated Garage, Lighted, Oversized, Storage
Parking Notes: Concrete, Gravel, Dry Walled, Exterior Access Door, Fi
Patio/Porch: Covered, Front Porch, Patio
Pets Allowed: Cats OK, Dogs OK
Security: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)
Sewer: Public Sewer
Utilities: Cable Available, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available
Water: Public, Well
Window: Double Pane Windows, Window Coverings
Local Schools
High School: Windsor
Middle School: Windsor
Elementary School: Mountain View
School District: Weld RE-4
Listed By / Shown By
Listed By
Agency Name: Colorado Flat Fee Realty Inc
Agency Contact: 720-668-6633
Shown By
Agent Name: The Home Team
Agent Phone: (719) 661-1199
Agency Title: The Cutting Edge, Realtors
Estimate Your Payment
Estimated Payment
$ 4,525.86 per month $3,918.42 Principal & Interest $375.42 Property Tax $232.02 Homeowner's InsuranceChange Payment Information
Based on information submitted to the MLS GRID. 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
METROLIST, INC., DBA RECOLORADO Disclaimer & Copyrights
The content relating to real estate for sale in this website comes in part from the Internet Data eXchange ("IDX") program of REcolorado®. All information subject to change and should be independently verified. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought. The information contained in this publication is subject to change without notice. METROLIST, INC., DBA REcolorado, MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA REcolorado, SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
PUBLISHER'S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
COPYRIGHT © 2020 by METROLIST, INC., DBA RECOLORADO® – All Rights Reserved 6455 S. Yosemite St., Suite 500 Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
The data relating to real estate for sale on this web site comes in part from the REcolorado®. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) nor shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
517 Locust Street | MLS# 6550382
This single family home located at 517 Locust Street, Windsor, CO 80550 is currently listed for sale with an asking price of $795,500. This property was built in 1904 and has 5 bedrooms and 3 full baths with 2358 sq. ft. Locust Street is located in the Kerns Sub subdivision within the Weld RE-4 school district. Search Kerns Sub real estate on home-team.thecuttingedgerealtors.com today.