Start of property details
Property Details
Impeccably designed, custom home in the highly desirable Overlook at Mariana gated community in Loveland. A stunning, zero step entrance invites you into a warm, open-concept great room with grand cathedral ceilings, timber beams and a floor-to-ceiling, quarry stone, gas fireplace. This Custom Energy Star home showcases attention to detail throughout, featuring hickory wood flooring, Alder kitchen cabinetry, doors and trim, granite countertops and travertine tile flooring and backsplash. Solid wood interior doors in this unique home lead to 2 impressive main-level bedrooms, including the remarkable primary retreat, boasting a 4-piece bathroom and walk-in closet. Basement also features quality finishes with option to add in a third bedroom and bathroom. Over 1, 000 sq. ft. of possibilities for the unfinished basement space. No METRO tax. Close proximity to Mariana Butte Golf Course, Devil's Backbone, grocery. Easy access to Estes Park. 3.5 acres of common green space and gorgeous walking paths.
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_964935","AboveGradeFinishedArea":"1749","AccessibilityFeatures":"Level Lot, Accessible Hallway(s), Low Carpet, Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry","Appliances":"Gas Range\/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Microwave, Disposal","ArchitecturalStyle":"Patio Home, Ranch","AssociationAmenities":null,"AssociationFee":"1325.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities","AssociationYN":"1","AttributionContact":"9702236500","Basement":"Full, 50%+Finished Basement, Built-In Radon","BasementYN":null,"BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1727","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Park","ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Stone, Stucco","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Larimer","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"North","DoorFeatures":null,"Electric":"Electric","ElementarySchool":"Namaqua","Exclusions":"Seller's Personal Property","ExteriorFeatures":"Recreation Association Required","Fencing":"Partial","FireplaceFeatures":"Gas, Gas Logs Included, Great Room","FireplaceYN":"1","FireplacesTotal":null,"Flooring":null,"FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":"HVAC","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, Kitchen Island, 9ft+ Ceilings, Beamed Ceilings","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"One","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level, Within City Limits","LotSizeArea":"8409.00","LotSizeSquareFeet":"8409.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","ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":"0","PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Impeccably designed, custom home in the highly desirable Overlook at Mariana gated community in Loveland. A stunning, zero step entrance invites you into a warm, open-concept great room with grand cathedral ceilings, timber beams and a floor-to-ceiling, quarry stone, gas fireplace. This Custom Energy Star home showcases attention to detail throughout, featuring hickory wood flooring, Alder kitchen cabinetry, doors & trim, granite countertops and travertine tile flooring & backsplash. Solid wood interior doors in this unique home lead to 2 impressive main-level bedrooms, including the remarkable primary retreat, boasting a 4-piece bathroom & walk-in closet. Basement also features quality finishes with option to add in a third bedroom & bathroom. Over 1, 000 sq. ft. of possibilities for the unfinished basement space. No METRO tax. Close proximity to Mariana Butte Golf Course, Devil's Backbone, grocery. Easy access to Estes Park. 3.5 acres of common green space and gorgeous walking paths.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"District Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"3826.00","Utilities":"Natural Gas Available, Electricity Available, Cable Available","View":"City","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"District Water, Little Thompson","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings, Double Pane Windows","YearBuilt":"2013","Zoning":"PUD","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"49a753db3c55035fe2a6f5ffd1d87913","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"964935","acreage":null,"acres":"0.19","address":null,"address_direction":null,"address_flg":"1","address_num":"170","agent_id":"P00343","area":"Loveland\/Berthoud","baths_total":"2.00","bedrooms_total":"2","car_spaces":"2","city":"Loveland","coseller_id":null,"coagent_id":null,"days_on_market":"15","finished_sqft_total":"2365","geocode_address":null,"geocode_status":null,"lat":"40.39329","lon":"-105.15148","office_id":"9CBCO","office_name":"Coldwell Banker Realty-FtC","orig_price":"819500","photo_count":"26","previous_price":null,"price":"819500","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/898eaa1109ba8e03bd6c1c49ff0ba995\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"1749","state":"CO","street_type":"Dr","street_name":"Two Moons","sub_area":"Overlook at Mariana","unit":null,"zip_code":"80537","listing_dt":"2022-05-02","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P14212","sold_dt":"2022-06-27","sold_price":"813500","webapi_update_dt":null,"update_dt":"2024-01-23 06:36:25","create_dt":"2022-05-08 18:20:06","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}