Start of property details
Property Details
Discover endless possibilities in this remarkable home in Windsor, Colorado. With additional living quarters downstairs, it's ideal for multigenerational living or generating income. Unlike neighboring homes, this custom-built gem stands out with its unique design and a stunning sunroom offering panoramic Rocky Mountain views. Owned and designed by the original owner, this home holds a rich history waiting to be uncovered. However, the full story awaits those who step through its doors-a tantalizing secret reserved for the fortunate few who curious enough to explore its story further. Conveniently located near shopping, dining, golf, great schools, and access to the Poudre River, it seamlessly blends suburban charm with city living. Don't miss this chance to own a piece of Windsor's past and future. Explore the potential in this one-of-a-kind home today.
Property Highlights
Location
Property Details
Building
Community
Local Schools
Interior Features
Bedrooms and Bathrooms
Rooms and Basement
Area and Spaces
Appliances
Interior Features
Heating and Cooling
Building Details
Construction
Materials
Terms
Terms
Taxes
Tax
Heating, Cooling & Utilities
Utilities
Lot
Parking
Exterior Features
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1002866","AboveGradeFinishedArea":"3034","AccessibilityFeatures":null,"Appliances":"Electric Range\/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave","ArchitecturalStyle":"Contemporary\/Modern","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"0","AttributionContact":"9703103690","Basement":"None","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"0","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Brick\/Brick Veneer","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Weld","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric, Xcel Energy","ElementarySchool":"Skyview","Exclusions":"Seller's Personal Property","ExteriorFeatures":null,"Fencing":"Partial, Wood","FireplaceFeatures":"2+ Fireplaces, Living Room, Family\/Recreation Room Fireplace","FireplaceYN":"1","FireplacesTotal":null,"Flooring":null,"FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air, Humidity Control","HighSchool":"Windsor","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Separate Dining Room, Sunroom","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"Bi-Level","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Cul-De-Sac, Corner Lot","LotSizeArea":"9448.00","LotSizeSquareFeet":"9448.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Windsor","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"ea857f6e86469312aea9ab997a9c9e29","OfficePhone":"970-449-7100","OtherParking":null,"Ownership":null,"ParkingFeatures":null,"ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Discover endless possibilities in this remarkable home in Windsor, Colorado. With additional living quarters downstairs, it's ideal for multigenerational living or generating income. Unlike neighboring homes, this custom-built gem stands out with its unique design and a stunning sunroom offering panoramic Rocky Mountain views. Owned and designed by the original owner, this home holds a rich history waiting to be uncovered. However, the full story awaits those who step through its doors-a tantalizing secret reserved for the fortunate few who curious enough to explore its story further. Conveniently located near shopping, dining, golf, great schools, and access to the Poudre River, it seamlessly blends suburban charm with city living. Don't miss this chance to own a piece of Windsor's past and future. Explore the potential in this one-of-a-kind home today.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Weld RE-4","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"2343.00","Utilities":"Natural Gas Available, Electricity Available","View":null,"ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Town of Windsor","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Bay Window(s), Sunroom","YearBuilt":"1996","Zoning":"RES","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"f5e2d5399ef2c7181d8cdd0bdbebc9f6","listing_status":"sold","mls_status":"Sold","mls_id":"boulder","listing_num":"1002866","acreage":null,"acres":"0.22","address":null,"address_direction":null,"address_flg":"1","address_num":"1228","agent_id":"P32681","area":"Greeley\/Weld","baths_total":"3.00","bedrooms_total":"5","car_spaces":"2","city":"Windsor","coseller_id":null,"coagent_id":null,"days_on_market":"57","finished_sqft_total":"3034","geocode_address":null,"geocode_status":null,"lat":"40.47752","lon":"-104.9198","office_id":"KWFTG","office_name":"Keller Williams Realty NoCo","orig_price":"575000","photo_count":"22","previous_price":null,"price":"575000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/9e866a82579d5034ddc4b3a4f3d497c8\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"3034","state":"CO","street_type":"Ct","street_name":"Teakwood","sub_area":"Riverbend","unit":null,"zip_code":"80550","listing_dt":"2024-02-08","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P19418","sold_dt":"2024-04-05","sold_price":"587000","webapi_update_dt":null,"update_dt":"2024-04-05 23:30:23","create_dt":"2024-02-08 18:30:15","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}