Start of property details
Property Details
Beautiful Custom home located in a large Cul-de-Sac and on one of the best lots in Heron Lakes! Breathtaking views and waterfront! The interior of this home is bursting with lavish and opulent finishes! This Stunning Oversized Kitchen is an entertainer's dream with two Islands opening to a large great room, sunroom, and Deck / balcony all overlooking water and beachfront. Luxurious master retreat with spa bath, heated floors and generous walk-in closet with private laundry hookups. The immense walk-out basement highlighting 10' ceilings is an entertainment mecca including an open theater, a stylish wet bar with 7' pass-through window to the back patio. Come live a life of luxury in the TPC golf course! Amenities Clubhouse, resort-style pool, Lake and Gym. Additional features include 4 Beds, Den, Spectacular exposed beams, Stunning fireplace, Oversized Great room doors, Tankless water heater, garage heater, Security System, In-home speakers and Patio- T.V and Hot tub hookups.
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_929728","AboveGradeFinishedArea":"3170","AccessibilityFeatures":null,"Appliances":"Gas Range\/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal","ArchitecturalStyle":"Ranch","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":"Common Amenities, Management","AssociationYN":"0","AttributionContact":"9705818838","Basement":"Walk-Out Access","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"3170","BuilderModel":null,"BuilderName":"Solace Custom Homes","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Clubhouse, Pool, Fitness Center, Park, Recreation Room","ComplexName":null,"ConstructionMaterials":"Wood\/Frame","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Larimer","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Carrie Martin","Exclusions":null,"ExteriorFeatures":null,"Fencing":null,"FireplaceFeatures":"Gas","FireplaceYN":"1","FireplacesTotal":null,"Flooring":null,"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":"Study Area, Eat-in Kitchen, Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, Two Primary Suites","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"One","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Cul-De-Sac, Near Golf Course","LotSizeArea":"20313.00","LotSizeSquareFeet":"20313.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Bill Reed","Model":null,"NewConstructionYN":"1","NumberOfUnitsTotal":null,"ListOfficeKey":"f0958785c62bfa8566c0cc08cd136dba","OfficePhone":"970-581-8838","OtherParking":null,"Ownership":null,"ParkingFeatures":"Heated Garage","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":"0","PropertyCondition":"Under Construction","PropertySubType":"Residential-Detached","public_remarks":"Beautiful Custom home located in a large Cul-de-Sac & on one of the best lots in Heron Lakes! Breathtaking views & waterfront! The interior of this home is bursting w\/ lavish & opulent finishes! This Stunning Oversized Kitchen is an entertainer's dream with two Islands opening to a large great room, sunroom, and Deck\/balcony all overlooking water and beachfront. Luxurious master retreat w\/spa bath, heated floors & generous walk-in closet w\/private laundry hookups. The immense walk-out basement highlighting 10' ceilings is an entertainment mecca including an open theater, a stylish wet bar w\/ 7' pass-through window to the back patio. Come live a life of luxury in the TPC golf course! Amenities Clubhouse, resort-style pool, Lake & Gym. Additional features include 4 Beds, Den, Spectacular exposed beams, Stunning fireplace, Oversized Great room doors, Tankless water heater, garage heater, Security System, In-home speakers & Patio- T.V & Hot tub hookups.","Roof":"Tile","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":"1104.00","Utilities":"Natural Gas Available","View":"Foothills View, Water","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Town of Berthoud","WaterfrontFeatures":"Abuts Pond\/Lake","WaterfrontYN":"1","WindowFeatures":null,"YearBuilt":"2021","Zoning":"RES","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"d6d0b96aa35e6499aed82ce7d69c655a","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"929728","acreage":null,"acres":"0.47","address":null,"address_direction":null,"address_flg":"1","address_num":"2091","agent_id":"P17232","area":"Loveland\/Berthoud","baths_total":"5.00","bedrooms_total":"4","car_spaces":"3","city":"Berthoud","coseller_id":null,"coagent_id":null,"days_on_market":"545","finished_sqft_total":"5153","geocode_address":null,"geocode_status":null,"lat":"40.337114","lon":"-105.109932","office_id":"SHAVO","office_name":"The Janes Group","orig_price":"1950000","photo_count":"13","previous_price":null,"price":"1950000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/154677fde03295b1907aff6474fa318d\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"3170","state":"CO","street_type":"Rd","street_name":"Scottsdale","sub_area":"HERON LAKES","unit":null,"zip_code":"80513","listing_dt":"2020-12-06","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P02902","sold_dt":"2022-06-03","sold_price":"2496117","webapi_update_dt":null,"update_dt":"2024-01-23 06:36:25","create_dt":"2020-12-06 19:07:03","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}