Start of property details
Property Details
Come experience luxury lakefront living in this exquisite custom built masterpiece situated on the BEST lot in the desirable Mariana Butte golf course community. Of the 8 homes with exclusive surface lake rights to Buckingham Lake, this is the only one that sits on a double sized lot (1.3 acres). Masterfully designed to showcase unobstructed views of the water and mountains from every window, you will feel like you are on vacation everyday! The impressive exterior consists of stucco siding, stone, a concrete tile roof, copper gutters, wood paneled garage doors, and massive stamped concrete circular driveway. Equally appealing are the "Colorado Rustic" finishes woven throughout the interior such as the rich knotty alder woodwork and built-ins in almost every room, log pillars, maple floors, stone, and tile. Breathtaking open main level features Great Room with soaring cathedral wood ceiling and stone fireplace, gourmet kitchen with Wolf range and custom hood, den with stained glass windows, and mudroom with connected 3 / 4 bath. Generous Primary Suite contains radiant heated bathroom floors, double sided fireplace, double headed shower, and closet with washer / dryer hook ups. Walkout basement includes 3 more beds with views, 2 baths, wet bar with wine cellar room, and gym / flex room. Bonus upper level office with built-in desks, wet bar, and balcony is the dream spot if you work from home! Split "his and her" finished garages with their own golf cart garage spaces and doors. Space to park your RV with its own dumping station. Enjoy multiple backyard patios, gas firepit area, beach with faucet, and attached "lake toys" room for storing your fishing gear, paddleboards, kayaks, etc. Wiring is in place to add a pool and / or hot tub. No monthly HOA fee, low taxes, and "in town" location make this home the whole package!
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
Tax
Heating, Cooling & Utilities
Utilities
Lot
Parking
Homeowner's Association
Exterior Features
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_996489","AboveGradeFinishedArea":"3390","AccessibilityFeatures":"Level Lot, Low Carpet, Main Floor Bath, Main Level Bedroom, Main Level Laundry","Appliances":"Gas Range\/Oven, Double Oven, Dishwasher, Refrigerator, Microwave","ArchitecturalStyle":"Ranch","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"1","AttributionContact":"9706691234","Basement":"Full, 90%+ Finished Basement, Walk-Out Access, Structural Floor, Built-In Radon","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"2812","BuilderModel":null,"BuilderName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Hiking\/Biking Trails","ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Stone, Stucco","Contingency":null,"Cooling":"Central Air, Attic Fan","CountyOrParish":"Larimer","CoveredSpaces":"4","DaysOnMarket":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"East","DoorFeatures":null,"Electric":"Electric, City","ElementarySchool":"Namaqua","Exclusions":"Sellers personal property & staging items. Washer\/Dryer negotiable","ExteriorFeatures":null,"Fencing":null,"FireplaceFeatures":"2+ Fireplaces, Gas, Double Sided, Family\/Recreation Room Fireplace, Primary Bedroom, 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, Radiant","HighSchool":"Thompson Valley","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, Eat-in Kitchen, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, 9ft+ Ceilings","LaundryFeatures":"Washer\/Dryer Hookups, In Basement","Levels":"One and One Half","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Lawn Sprinkler System, Water Rights Included, Level, Lake Access, Lake Front, Waterfront","LotSizeArea":"56475.00","LotSizeSquareFeet":"56475.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Clark (Walt)","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"ListOfficeKey":"21ebf8d0e0b568661e5ea5a87faa50d5","OfficePhone":"970-669-1234","OtherParking":null,"Ownership":null,"ParkingFeatures":"RV\/Boat Parking, Heated Garage, Oversized","ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Come experience luxury lakefront living in this exquisite custom built masterpiece situated on the BEST lot in the desirable Mariana Butte golf course community. Of the 8 homes with exclusive surface lake rights to Buckingham Lake, this is the only one that sits on a double sized lot (1.3 acres). Masterfully designed to showcase unobstructed views of the water & mountains from every window, you will feel like you are on vacation everyday! The impressive exterior consists of stucco siding, stone, a concrete tile roof, copper gutters, wood paneled garage doors, & massive stamped concrete circular driveway. Equally appealing are the \"Colorado Rustic\" finishes woven throughout the interior such as the rich knotty alder woodwork & built-ins in almost every room, log pillars, maple floors, stone, & tile. Breathtaking open main level features Great Room with soaring cathedral wood ceiling & stone fireplace, gourmet kitchen with Wolf range & custom hood, den with stained glass windows, & mudroom with connected 3\/4 bath. Generous Primary Suite contains radiant heated bathroom floors, double sided fireplace, double headed shower, & closet with washer\/dryer hook ups. Walkout basement includes 3 more beds with views, 2 baths, wet bar with wine cellar room, & gym\/flex room. Bonus upper level office with built-in desks, wet bar, & balcony is the dream spot if you work from home! Split \"his & her\" finished garages with their own golf cart garage spaces & doors. Space to park your RV with its own dumping station. Enjoy multiple backyard patios, gas firepit area, beach with faucet, & attached \"lake toys\" room for storing your fishing gear, paddleboards, kayaks, etc. Wiring is in place to add a pool and\/or hot tub. No monthly HOA fee, low taxes, & \"in town\" location make this home the whole package!","Roof":"Concrete","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":null,"Sewer":"City Sewer","SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"6526.00","Utilities":"Natural Gas Available, Electricity Available","View":"Mountain(s), Foothills View","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/vimeo.com\/865343310?share=copy","WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, City of Loveland","WaterfrontFeatures":"Abuts Pond\/Lake, Lake Front","WaterfrontYN":null,"WindowFeatures":"Window Coverings","YearBuilt":"2001","Zoning":"Res","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"b483e45797e19fc683228d3305e9c0fa","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"996489","acreage":null,"acres":"1.30","address":null,"address_direction":null,"address_flg":"1","address_num":"313","agent_id":"P15940","area":"Loveland\/Berthoud","baths_total":"5.00","bedrooms_total":"4","car_spaces":"4","city":"Loveland","coseller_id":null,"coagent_id":null,"days_on_market":"11","finished_sqft_total":"5891","geocode_address":null,"geocode_status":null,"lat":"40.39552","lon":"-105.14325","office_id":"8RM1L","office_name":"RE\/MAX Alliance-Loveland","orig_price":"2290000","photo_count":"40","previous_price":null,"price":"2290000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/2143c397d4bdd1bd4c3b847bf7176abd\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"3390","state":"CO","street_type":"Dr","street_name":"Rossum","sub_area":"Mariana Butte","unit":null,"zip_code":"80537","listing_dt":"2023-09-18","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"update_dt":"2023-09-30 02:30:14","create_dt":"2023-09-18 14:30:05","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}