Start of property details
Property Details
The Overlook at Mariana is an exquisite, GATED community nestled just West of Loveland near lakes, State Parks, and Mariana Butte Golf Course. Retreat into the security, serenity, and privacy of this enclave of stately homes, lush landscaping, and peaceful walking paths. Pristine 284 N. Cove Drive was a custom build for the current owners, reflecting exemplary craftsmanship and decorator-inspired interior selections. A double-sided fireplace, rich acacia flooring, stunning lighting, brick and "lodge" accents, and soaring ceilings are just a few of the homes many features. Also notable are the circular driveway with stained and stamped concrete, gorgeous granite patterns throughout and an exemplary chef's kitchen. The grand entryway is an inviting prelude to the superb floor plan, finished basement with a magnificent wet bar, expansive decks with privacy shades, and oversized 3 car garage. Truly, this hallmark masterpiece offers the Colorado lifestyle of your dreams.
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
Homeowner's Association
Exterior Features
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_963178","AboveGradeFinishedArea":"2191","AccessibilityFeatures":null,"Appliances":"Gas Range\/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal","ArchitecturalStyle":"Ranch","AssociationAmenities":null,"AssociationFee":"1325.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities","AssociationYN":"1","AttributionContact":"3035433083","Basement":"90%+ Finished Basement","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1901","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Concrete","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Larimer","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric","ElementarySchool":"Namaqua","Exclusions":"Seller's personal property, Washer and Dryer.","ExteriorFeatures":null,"Fencing":null,"FireplaceFeatures":"Double Sided","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":"Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Main Level","Levels":"One","ListingTerms":"Cash, Conventional, VA Loan","LivingArea":null,"LotFeatures":"Lawn Sprinkler System, Corner Lot","LotSizeArea":"14161.00","LotSizeSquareFeet":"14161.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Clark (Walt)","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"3b3e5de517522f5f57edec5582087e4e","OfficePhone":"303-543-3083","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, Oversized","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":"0","PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"The Overlook at Mariana is an exquisite, GATED community nestled just West of Loveland near lakes, State Parks, and Mariana Butte Golf Course. Retreat into the security, serenity, and privacy of this enclave of stately homes, lush landscaping, and peaceful walking paths. Pristine 284 N. Cove Drive was a custom build for the current owners, reflecting exemplary craftsmanship and decorator-inspired interior selections. A double-sided fireplace, rich acacia flooring, stunning lighting, brick & \"lodge\" accents, and soaring ceilings are just a few of the homes many features. Also notable are the circular driveway with stained and stamped concrete, gorgeous granite patterns throughout and an exemplary chef's kitchen. The grand entryway is an inviting prelude to the superb floor plan, finished basement with a magnificent wet bar, expansive decks with privacy shades, and oversized 3 car garage. Truly, this hallmark masterpiece offers the Colorado lifestyle of your dreams.","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":"4563.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","YearBuilt":"2013","Zoning":"R1","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"1ae6feee615106c236f862b64598c41e","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"963178","acreage":null,"acres":"0.33","address":null,"address_direction":"N","address_flg":"1","address_num":"284","agent_id":"P31185","area":"Loveland\/Berthoud","baths_total":"4.00","bedrooms_total":"5","car_spaces":"3","city":"Loveland","coseller_id":null,"coagent_id":"P06955","days_on_market":"30","finished_sqft_total":"4382","geocode_address":null,"geocode_status":null,"lat":"40.394807","lon":"-105.153252","office_id":"8ZRE","office_name":"8z Real Estate","orig_price":"975000","photo_count":"40","previous_price":null,"price":"975000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/963178\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"2191","state":"CO","street_type":"Dr","street_name":"Cove","sub_area":"Overlook At Mariana 1st Sub Lov","unit":null,"zip_code":"80537","listing_dt":"2022-04-18","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P02543","sold_dt":"2022-05-20","sold_price":"1025000","webapi_update_dt":null,"update_dt":"2024-01-23 06:36:25","create_dt":"2022-04-18 19:00:21","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}