Start of property details
Property Details
Come live a life of luxury at TPC Colorado! Custom home located in Cul-de-Sac on one of only 18 lots with personal access to McNeil Reservoir. This Stunning home offers an oversized Kitchen, with large Island opening to a large family room, disappearing wall leads you to your large covered deck with outdoor kitchen and amazing views across your beachfront to one of TPC's premier clubhouses and the 16th tee. 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, 2nd fireplace and a wet bar only adds to the quality of lifestyle this home and community offers. Amenities Clubhouse, resort-style pool, Lake and Gym. 5 Beds, study with private access to covered front courtyard, Stunning fireplace, built in A / V throughout. Still time to make your personal changes to this one.
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
Exterior Features
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_935800","AboveGradeFinishedArea":"2796","AccessibilityFeatures":null,"Appliances":"Gas Range\/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal","ArchitecturalStyle":"Contemporary\/Modern, Ranch","AssociationAmenities":null,"AssociationFee":"1400.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities","AssociationYN":"1","AttributionContact":"9702263990","Basement":"75%+Finished Basement","BasementYN":null,"BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"2796","BuilderModel":null,"BuilderName":"Rhoades Builds, LLC","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Clubhouse","ComplexName":null,"ConstructionMaterials":"Wood\/Frame","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Larimer","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric, Berthoud","ElementarySchool":"Carrie Martin, Berthoud","Exclusions":null,"ExteriorFeatures":"Gas Grill, Lighting","Fencing":null,"FireplaceFeatures":"2+ Fireplaces, Gas, Gas Logs Included, Family\/Recreation Room Fireplace, Basement","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":"Study Area, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, 9ft+ Ceilings","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"One","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Gutters, Sidewalks, Lawn Sprinkler System, Cul-De-Sac","LotSizeArea":"11839.00","LotSizeSquareFeet":"11839.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Bill Reed","Model":null,"NewConstructionYN":"1","NumberOfUnitsTotal":null,"ListOfficeKey":"b6f1f430cc21188b60c027eacacf2aa6","OfficePhone":"970-226-3990","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, >8' Garage Door","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":"0","PropertyCondition":"New, To be Built","PropertySubType":"Residential-Detached","public_remarks":"Come live a life of luxury at TPC Colorado! Custom home located in Cul-de-Sac on one of only 18 lots with personal access to McNeil Reservoir. This Stunning home offers an oversized Kitchen, with large Island opening to a large family room, disappearing wall leads you to your large covered deck with outdoor kitchen and amazing views across your beachfront to one of TPC's premier clubhouses and the 16th tee. Luxurious master retreat w\/spa bath, heated floors & generous walk-in closet w\/private laundry hookups. The immense walk-out basement highlighting 10' ceilings, 2nd fireplace and a wet bar only adds to the quality of lifestyle this home and community offers. Amenities Clubhouse, resort-style pool, Lake & Gym. 5 Beds, study with private access to covered front courtyard, Stunning fireplace, built in A\/V throughout. Still time to make your personal changes to this one.","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, Electricity Available, Other, Cable Available, Underground Utilities","View":"Foothills View, Water","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Town of Berthoud","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":null,"YearBuilt":"2021","Zoning":"SFR","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"54c2a853f429f48b6f013f5fdbc893bf","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"935800","acreage":null,"acres":"0.27","address":null,"address_direction":null,"address_flg":"1","address_num":"2588","agent_id":"P06995","area":"Loveland\/Berthoud","baths_total":"5.00","bedrooms_total":"5","car_spaces":"3","city":"Berthoud","coseller_id":null,"coagent_id":null,"days_on_market":"65","finished_sqft_total":"4900","geocode_address":null,"geocode_status":null,"lat":"40.336287","lon":"-105.110807","office_id":"9RMSA","office_name":"RE\/MAX Alliance-FTC South","orig_price":"1900000","photo_count":"2","previous_price":null,"price":"1900000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/84c64807c3e899b3bffaa07263e7ab87\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"2796","state":"CO","street_type":"Pkwy","street_name":"Heron Lakes","sub_area":"Heron Lakes","unit":null,"zip_code":"80513","listing_dt":"2021-03-20","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P19418","sold_dt":"2023-04-14","sold_price":"2316471","webapi_update_dt":null,"update_dt":"2024-01-23 06:36:25","create_dt":"2021-03-20 16:06: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}