Start of property details
Property Details
Welcome to your dream home in beautiful Colorado! This stunning property offers 3 spacious bedrooms, 4-car garage, and breathtaking views of the Rocky Mountains. As you step inside, you'll be greeted by a grand foyer that leads to a bright and open living area with soaring ceilings and large windows that showcase the picturesque scenery.The gourmet kitchen is a chef's dream with modern appliances, ample counter space, and a convenient breakfast bar. Enjoy meals in the formal dining area, or step outside to the expansive deck for al fresco dining and entertaining. The master suite is a luxurious retreat, complete with a spa-like en-suite bathroom and a private balcony where you can take in the stunning mountain views. Two additional bedrooms offer plenty of space for family and guests, with a shared full bathroom and a powder room for added convenience.The 4-car garage provides ample space for all your vehicles and outdoor gear, and there's even room for a workshop or storage area. This property is located in a highly sought-after neighborhood, with easy access to hiking trails, parks, and top-rated schools.Don't miss your chance to own this exceptional Colorado home! Contact us today to schedule a showing.
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_983125","AboveGradeFinishedArea":"2046","AccessibilityFeatures":"Main Floor Bath, Main Level Bedroom, Main Level Laundry","Appliances":"Gas Range\/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Contemporary\/Modern, Ranch","AssociationAmenities":null,"AssociationFee":"1325.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities, Utilities","AssociationYN":"1","AttributionContact":"9702236500","Basement":"Full, Unfinished, Daylight, Rough-in for Radon","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"2046","BuilderModel":null,"BuilderName":"Custom On-Site Builders","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Hiking\/Biking Trails","ComplexName":null,"ConstructionMaterials":"Stone, Stucco","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Larimer","CoveredSpaces":"4","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"Northwest","DoorFeatures":"French Doors","Electric":"Electric, City of LVLD","ElementarySchool":"Namaqua","Exclusions":"Seller's personal property","ExteriorFeatures":"Lighting","Fencing":"Partial, Metal Post Fence","FireplaceFeatures":"Gas, Gas Logs Included, Great 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","HighSchool":"Thompson Valley","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Satellite Avail, High Speed Internet, Eat-in Kitchen, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"One","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Curbs, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac","LotSizeArea":"11987.00","LotSizeSquareFeet":"11987.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, Oversized, Tandem","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":"0","PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Welcome to your dream home in beautiful Colorado! This stunning property offers 3 spacious bedrooms, 4-car garage, and breathtaking views of the Rocky Mountains. As you step inside, you'll be greeted by a grand foyer that leads to a bright and open living area with soaring ceilings and large windows that showcase the picturesque scenery.The gourmet kitchen is a chef's dream with modern appliances, ample counter space, and a convenient breakfast bar. Enjoy meals in the formal dining area, or step outside to the expansive deck for al fresco dining and entertaining. The master suite is a luxurious retreat, complete with a spa-like en-suite bathroom and a private balcony where you can take in the stunning mountain views. Two additional bedrooms offer plenty of space for family and guests, with a shared full bathroom and a powder room for added convenience.The 4-car garage provides ample space for all your vehicles and outdoor gear, and there's even room for a workshop or storage area. This property is located in a highly sought-after neighborhood, with easy access to hiking trails, parks, and top-rated schools.Don't miss your chance to own this exceptional Colorado home! Contact us today to schedule a showing.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Licensed Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"3910.00","Utilities":"Natural Gas Available, Electricity Available","View":"Foothills View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Little Thompson","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings, Double Pane Windows","YearBuilt":"2018","Zoning":"R1","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"ee18a783f0146a4e5821576f8fbf8c00","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"983125","acreage":null,"acres":"0.28","address":null,"address_direction":null,"address_flg":"1","address_num":"5602","agent_id":"P02267","area":"Loveland\/Berthoud","baths_total":"3.00","bedrooms_total":"3","car_spaces":"4","city":"Loveland","coseller_id":null,"coagent_id":null,"days_on_market":"37","finished_sqft_total":"2046","geocode_address":null,"geocode_status":null,"lat":"40.39329","lon":"-105.15391","office_id":"9CBCO","office_name":"Coldwell Banker Realty-FtC","orig_price":"900000","photo_count":"30","previous_price":"849900","price":"839950","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/109c2683b2e2a662dc71971a881dfc97\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"2046","state":"CO","street_type":"Ct","street_name":"Red Thunder","sub_area":"Overlook at Mariana","unit":null,"zip_code":"80537","listing_dt":"2023-03-08","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":"2023-06-24","seller_id":"P17784","sold_dt":"2023-08-11","sold_price":"815000","webapi_update_dt":null,"update_dt":"2024-01-23 06:36:25","create_dt":"2023-03-09 01:01:45","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}