Start of property details
Property Details
Introducing Trumark's Festival 4B nestled in the charming Festival @ RainDance community. This stunning two-story home spans 2, 875 square feet of meticulously crafted living space, boasting five bedrooms, four baths, and a versatile flex office. This home welcomes you with a picturesque porch and a convenient secondary bedroom with an attached bath located just off the entryway. Step inside to discover the awe-inspiring great room, adorned with a soaring 20-foot open ceiling, a cozy gas fireplace, and an eye-catching black metal staircase / catwalk. Experience seamless indoor-outdoor living as double sliding glass doors from the great room and dining area lead to an expansive covered outdoor space, perfect for entertaining or unwinding amidst the fully landscaped and fenced yard. The heart of the home is the gourmet kitchen, where culinary delights await. Revel in the spacious walk-in pantry, center preparation island, and elegant features such as shaker style taupe cabinetry, Carrara Mist Quartz countertops and a tile backsplash, premium stainless steel appliances including a 5-burner gas cooktop, convection oven, built-in microwave, and dishwasher. Upstairs, a spacious rec room connects three secondary bedrooms. The primary suite is a luxurious retreat, featuring a spa-like bathroom with dual sinks, a walk-in shower, a freestanding bathtub, and an expansive walk-in closet. Additional amenities include a full unfinished basement, a tankless water heater, dual A / C units, and dual furnaces. Residents of this vibrant community enjoy an array of neighborhood amenities, including walking trails, orchards, and trash services, all included in metro district fees. Optional membership to the Raindance pool is available, with options combining amenities from Raindance and nearby Water Valley under the "WaterDance" banner.
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
HOA
Tax
Heating, Cooling & Utilities
Utilities
Lot
Parking
Exterior Features
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1007766","AboveGradeFinishedArea":"2875","AccessibilityFeatures":"Level Lot","Appliances":"Gas Range\/Oven, Refrigerator, Microwave, Disposal","ArchitecturalStyle":"Contemporary\/Modern","AssociationAmenities":null,"AssociationFee":"410.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities, Trash, Management, Utilities","AssociationYN":"1","AttributionContact":"9702068343","Basement":"Full, Unfinished","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"1383","BuilderModel":null,"BuilderName":"Trumark","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Clubhouse, Pool, Playground, Park, Hiking\/Biking Trails","ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Composition Siding","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Weld","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric, PVREA","ElementarySchool":"Skyview","Exclusions":"Seller's Personal Property, Clothes Washer and Dryer, Curtains.","ExteriorFeatures":"Lighting","Fencing":"Fenced, Wood","FireplaceFeatures":"Gas","FireplaceYN":"1","FireplacesTotal":null,"Flooring":"Wood Floors","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Windsor","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, Satellite Avail, High Speed Internet, Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Jack & Jill Bathroom, Kitchen Island, 9ft+ Ceilings","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Upper Level","Levels":"Two","ListingTerms":"Cash, Conventional, VA Loan","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level, Near Golf Course","LotSizeArea":"6889.00","LotSizeSquareFeet":"6889.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Windsor","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"24e5f9e679cc3e20159a282063efade0","OfficePhone":"970-206-8343","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":"Introducing Trumark's Festival 4B nestled in the charming Festival @ RainDance community. This stunning two-story home spans 2, 875 square feet of meticulously crafted living space, boasting five bedrooms, four baths, and a versatile flex office. This home welcomes you with a picturesque porch and a convenient secondary bedroom w\/an attached bath located just off the entryway. Step inside to discover the awe-inspiring great room, adorned with a soaring 20-foot open ceiling, a cozy gas fireplace, and an eye-catching black metal staircase\/catwalk. Experience seamless indoor-outdoor living as double sliding glass doors from the great room and dining area lead to an expansive covered outdoor space, perfect for entertaining or unwinding amidst the fully landscaped and fenced yard. The heart of the home is the gourmet kitchen, where culinary delights await. Revel in the spacious walk-in pantry, center preparation island, and elegant features such as shaker style taupe cabinetry, Carrara Mist Quartz countertops & a tile backsplash, premium stainless steel appliances including a 5-burner gas cooktop, convection oven, built-in microwave, & dishwasher. Upstairs, a spacious rec room connects three secondary bedrooms. The primary suite is a luxurious retreat, featuring a spa-like bathroom w\/ dual sinks, a walk-in shower, a freestanding bathtub, & an expansive walk-in closet. Additional amenities include a full unfinished basement, a tankless water heater, dual A\/C units, and dual furnaces. Residents of this vibrant community enjoy an array of neighborhood amenities, including walking trails, orchards, and trash services, all included in metro district fees. Optional membership to the Raindance pool is available, with options combining amenities from Raindance and nearby Water Valley under the \"WaterDance\" banner.","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":"6284.00","Utilities":"Natural Gas Available, Electricity Available, Cable Available","View":null,"ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/www.listingsmagic.com\/sps\/tour-slider\/index.php?property_ID=258490","WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Town of Windsor","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":null,"YearBuilt":"2022","Zoning":"RES","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"8ddc58957e763457c1b1bb69c8470caa","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"1007766","acreage":null,"acres":"0.16","address":null,"address_direction":null,"address_flg":"1","address_num":"1846","agent_id":"P18664","area":"Greeley\/Weld","baths_total":"4.00","bedrooms_total":"5","car_spaces":"3","city":"Windsor","coseller_id":null,"coagent_id":null,"days_on_market":"14","finished_sqft_total":"2875","geocode_address":null,"geocode_status":null,"lat":"40.450272","lon":"-104.931995","office_id":"REALW","office_name":"RE\/MAX Alliance-Wellington","orig_price":"950000","photo_count":"39","previous_price":"950000","price":"890000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/7e704474d8778d9c27bc360a48690efb\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"2875","state":"CO","street_type":"Dr","street_name":"Vista Valley","sub_area":"Raindance- Festival","unit":null,"zip_code":"80550","listing_dt":"2024-04-22","undercontract_dt":null,"openhouse_dt":"2024-04-28 17:00:00","price_change_dt":"2024-05-07","seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-10 15:33:50","create_dt":"2024-04-23 04:30:05","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}