Start of property details
Property Details
Unbelievable quality and upgrades enhance this impeccable ranch in the coveted gated community of the Overlook at Mariana. Colored concrete walkway leads to welcoming covered porch, ideal for soaking in sunshine and the mountain views. Timber framing accentuates the vaulted ceilings in the heart of the home, warmed by floor to ceiling stone fireplace. The secluded primary suite includes spa-like features with dual glass vessel sinks and back-lit custom mirrors. A handmade steel rod trellis railing surrounds the staircase leading to a walkout basement with 3 additional bedrooms. Fabulous covered deck, secluded patio, stone accents and alcoves, and heated shop, are just a few amenities. This retreat abuts a tranquil greenbelt.
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
Green Energy
Utilities
Lot
Parking
Exterior Features
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1004623","AboveGradeFinishedArea":"2121","AccessibilityFeatures":"Level Lot, Level Drive, Accessible Hallway(s), Low Carpet, Main Floor Bath, Main Level Bedroom, Main Level Laundry","Appliances":"Gas Range\/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Ranch","AssociationAmenities":null,"AssociationFee":"1400.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities, Management","AssociationYN":"1","AttributionContact":"9704812037","Basement":"Full, 50%+Finished Basement, Walk-Out Access, Built-In Radon","BasementYN":null,"BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"2105","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Stone, Stucco","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Larimer","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"Northwest","DoorFeatures":null,"Electric":"Electric, City of LVLD","ElementarySchool":"Namaqua","Exclusions":null,"ExteriorFeatures":"Gas Grill","Fencing":null,"FireplaceFeatures":"Gas, Gas Logs Included, Double Sided, Living Room, Kitchen","FireplaceYN":"1","FireplacesTotal":null,"Flooring":"Wood Floors","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":"Thermostat","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":"Study Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral\/Vaulted Ceilings, Open Floorplan, Stain\/Natural Trim, Walk-In Closet(s), Wet Bar, Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Sink, Washer\/Dryer Hookups, Main Level","Levels":"One","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Sloped, Abuts Private Open Space","LotSizeArea":"12014.00","LotSizeSquareFeet":"12014.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Clark (Walt)","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"ab19ccfe049f0ecfa339026d86c83d04","OfficePhone":"970-663-0700","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, Heated Garage","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Unbelievable quality and upgrades enhance this impeccable ranch in the coveted gated community of the Overlook at Mariana. Colored concrete walkway leads to welcoming covered porch, ideal for soaking in sunshine and the mountain views. Timber framing accentuates the vaulted ceilings in the heart of the home, warmed by floor to ceiling stone fireplace. The secluded primary suite includes spa-like features w\/dual glass vessel sinks and back-lit custom mirrors. A handmade steel rod trellis railing surrounds the staircase leading to a walkout basement with 3 additional bedrooms. Fabulous covered deck, secluded patio, stone accents and alcoves, and heated shop, are just a few amenities. This retreat abuts a tranquil greenbelt.","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":"4828.00","Utilities":"Natural Gas Available, Electricity Available","View":"Foothills View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"District Water, Little Thompson","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Double Pane Windows","YearBuilt":"2014","Zoning":"R1","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"4a17e587e26f3cb208383f91a962c779","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"1004623","acreage":null,"acres":"0.28","address":null,"address_direction":"N","address_flg":"1","address_num":"270","agent_id":"P07332","area":"Loveland\/Berthoud","baths_total":"3.00","bedrooms_total":"4","car_spaces":"3","city":"Loveland","coseller_id":null,"coagent_id":"P23524","days_on_market":"1","finished_sqft_total":"3486","geocode_address":null,"geocode_status":null,"lat":"40.39468","lon":"-105.15298","office_id":"8GRPI","office_name":"Group Loveland","orig_price":"1125000","photo_count":"29","previous_price":null,"price":"1125000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/b953de076c546d12fe5cd52804e1862d\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"2121","state":"CO","street_type":"Dr","street_name":"Cove","sub_area":"Overlook at Mariana","unit":null,"zip_code":"80537","listing_dt":"2024-03-03","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P07332","sold_dt":"2024-03-18","sold_price":"1100000","webapi_update_dt":null,"update_dt":"2024-03-18 23:30:18","create_dt":"2024-03-08 00:30:39","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}