Start of property details
Property Details
With DOUBLE the amenities, this home is one you will not want to pass up, especially if you are looking to HOST and entertain. With TWO kitchens, TWO laundry rooms and TWO primary bedrooms with on-suite bathrooms, you will have plenty of space for your family and guests. Cozy up to one of the TWO fireplaces, or sit outside and enjoy the sunset on one of the THREE outdoor patios. Relax at the bar in your walk-out basement or catch the Super Bowl game on your in-home movie theater screen! No need to worry about keeping the house just the right temperature with TWO furnaces, TWO A / C units and TWO water heaters providing optimal comfort. The Mariana Butte club house is in walking distance up the road, and the open space playground is right down the block. Grab your paddleboard or kayak and hit the Boedecker and Lon Hagler Reservoir right around the corner for all of your outdoor activities. Be sure to plug in your electric vehicle in the charger located in the garage when you return back home, and park your toys behind the gate on the side of the house.!
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_1001386","AboveGradeFinishedArea":"3768","AccessibilityFeatures":"Main Floor Bath, Main Level Bedroom, Main Level Laundry","Appliances":"2 or more H20 Heaters, Electric Range\/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Contemporary\/Modern","AssociationAmenities":null,"AssociationFee":"125.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Trash","AssociationYN":"1","AttributionContact":"9706822251","Basement":"90%+ Finished Basement, Walk-Out Access","BasementYN":null,"BathroomsFull":"5","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"1748","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Clubhouse, Playground, Park, Hiking\/Biking Trails","ComplexName":null,"ConstructionMaterials":"Wood\/Frame","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Larimer","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric","ElementarySchool":"Namaqua","Exclusions":"Sellers personal property","ExteriorFeatures":"Hot Tub Included","Fencing":"Wood","FireplaceFeatures":"2+ Fireplaces, Gas","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, 2 or more Heat Sources","HighSchool":"Thompson Valley","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral\/Vaulted Ceilings, Pantry, Walk-In Closet(s), Two Primary Suites","InternetAddressDisplayYN":null,"LaundryFeatures":"Main Level","Levels":"Three Or More","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Curbs, Sidewalks, Lawn Sprinkler System, Water Rights Excluded, Mineral Rights Excluded, Cul-De-Sac, Corner Lot, Near Golf Course","LotSizeArea":"13939.00","LotSizeSquareFeet":"13939.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Walt Clark","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"06c0231508762770402398a8b04e4c53","OfficePhone":null,"OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, RV\/Boat Parking","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck, Enclosed","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"With DOUBLE the amenities, this home is one you will not want to pass up, especially if you are looking to HOST and entertain. With TWO kitchens, TWO laundry rooms and TWO primary bedrooms with on-suite bathrooms, you will have plenty of space for your family and guests. Cozy up to one of the TWO fireplaces, or sit outside and enjoy the sunset on one of the THREE outdoor patios. Relax at the bar in your walk-out basement or catch the Super Bowl game on your in-home movie theater screen! No need to worry about keeping the house just the right temperature with TWO furnaces, TWO A\/C units and TWO water heaters providing optimal comfort. The Mariana Butte club house is in walking distance up the road, and the open space playground is right down the block. Grab your paddleboard or kayak and hit the Boedecker and Lon Hagler Reservoir right around the corner for all of your outdoor activities. Be sure to plug in your electric vehicle in the charger located in the garage when you return back home, and park your toys behind the gate on the side of the house.!","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":null,"SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"3236.00","Utilities":"Natural Gas Available, Electricity Available","View":"Plains View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, City of Loveland","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings","YearBuilt":"2000","Zoning":"RES","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"2250cca9c2332eb33842ae04145e3972","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"1001386","acreage":null,"acres":"0.32","address":null,"address_direction":null,"address_flg":"1","address_num":"457","agent_id":"P32666","area":"Loveland\/Berthoud","baths_total":"5.00","bedrooms_total":"7","car_spaces":"3","city":"Loveland","coseller_id":null,"coagent_id":null,"days_on_market":"130","finished_sqft_total":"5516","geocode_address":null,"geocode_status":null,"lat":"40.39681","lon":"-105.13699","office_id":"07524","office_name":null,"orig_price":"835000","photo_count":"31","previous_price":null,"price":"835000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/a8fb5410d43d303fe4145355c4c40d42\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"3768","state":"CO","street_type":"Ct","street_name":"Foothills","sub_area":"Mariana Butte PUD","unit":null,"zip_code":"80537","listing_dt":"2024-01-09","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P01591","sold_dt":"2024-02-23","sold_price":"828000","webapi_update_dt":null,"update_dt":"2024-02-27 01:30:05","create_dt":"2024-01-10 00:30:08","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}