Start of property details
Property Details
Discover luxury living at its finest, with this exquisite custom ranch home located in the prestigious Overlook gated community at Mariana Butte. Located on a quiet cul de sac with a meticulously maintained corner lot and walk out basement. This residence is a masterpiece of design and craftsmanship. With its high ceilings, oversized windows, and premium finishes throughout, including an open floor plan with double ovens, ash wood floors, and knotty alder cabinets, this home offers both elegance and comfort. Step outside to your own private oasis, where a covered patio and landscaped gardens create the perfect setting for outdoor relaxation and entertainment. Plus, with access to amenities such as hiking trails, parks, and the acclaimed Mariana Butte Golf Course, this community offers the perfect blend of luxury and convenience. Don't miss your chance to experience the best of Mariana Butte living - schedule a showing today and make this dream home yours.
Open House Announcements
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_1007686","AboveGradeFinishedArea":"1920","AccessibilityFeatures":null,"Appliances":"Electric Range\/Oven, Gas Range\/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Contemporary\/Modern, Ranch","AssociationAmenities":null,"AssociationFee":"1400.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities, Management","AssociationYN":"1","AttributionContact":"9708256601","Basement":"50%+Finished Basement, Walk-Out Access, Built-In Radon","BasementYN":null,"BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"1920","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Gated","ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Stone, Stucco","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Larimer","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric, City of LVLD","ElementarySchool":"Namaqua","Exclusions":"Seller's personal property","ExteriorFeatures":"Lighting, Balcony","Fencing":"Partial","FireplaceFeatures":"Living Room","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, Humidity Control","HighSchool":"Thompson Valley","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Satellite Avail, High Speed Internet, Separate Dining Room, Cathedral\/Vaulted Ceilings, Stain\/Natural Trim, Walk-In Closet(s), Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"One","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, Abuts Private Open Space","LotSizeArea":"14810.00","LotSizeSquareFeet":"14810.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Clark (Walt)","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"5b3cdc9f10e10eafe52aeed24f5f064b","OfficePhone":"970-223-6500","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener","ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Discover luxury living at its finest, with this exquisite custom ranch home located in the prestigious Overlook gated community at Mariana Butte. Located on a quiet cul de sac with a meticulously maintained corner lot and walk out basement. This residence is a masterpiece of design and craftsmanship. With its high ceilings, oversized windows, and premium finishes throughout, including an open floor plan with double ovens, ash wood floors, and knotty alder cabinets, this home offers both elegance and comfort. Step outside to your own private oasis, where a covered patio and landscaped gardens create the perfect setting for outdoor relaxation and entertainment. Plus, with access to amenities such as hiking trails, parks, and the acclaimed Mariana Butte Golf Course, this community offers the perfect blend of luxury and convenience. Don't miss your chance to experience the best of Mariana Butte living - schedule a showing today and make this dream home yours.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"4719.19","Utilities":"Natural Gas Available, Electricity Available, Cable Available","View":"Mountain(s)","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Little Thompson","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings","YearBuilt":"2015","Zoning":"R1","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"c34e65f2d5ea6d7b16f08ea0102425c6","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"1007686","acreage":null,"acres":"0.34","address":null,"address_direction":null,"address_flg":"1","address_num":"5649","agent_id":"P02267","area":"Loveland\/Berthoud","baths_total":"4.00","bedrooms_total":"4","car_spaces":"2","city":"Loveland","coseller_id":null,"coagent_id":null,"days_on_market":"9","finished_sqft_total":"2822","geocode_address":null,"geocode_status":null,"lat":"40.39387","lon":"-105.15377","office_id":"9CBCO","office_name":"Coldwell Banker Realty-FtC","orig_price":"990000","photo_count":"30","previous_price":null,"price":"990000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/e2228f86a7859a365c6ec33a10e1a3a9\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"1920","state":"CO","street_type":"Ct","street_name":"Red Thunder","sub_area":"Overlook at Mariana","unit":null,"zip_code":"80537","listing_dt":"2024-04-20","undercontract_dt":null,"openhouse_dt":"2024-05-04 17:00:00","price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-04 18:34:03","create_dt":"2024-04-20 23:30:07","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}