Skip To Content

6504 County Road 54

Johnstown, CO 80534
  • $12,850,000
  • STATUS: Active
  • ON SITE: 37 Days
  • MLS #: 1063603
UPDATED: 56 min ago
$12,850,000
  • 7
    BEDS
  • 71
    ACRES
  • 7
    BATHS
  • 0
    1/2 BATHS
  • 8,764
    SQFT
  • $1,466
    $/SQFT
Neighborhood:
N/A
Type:
Single-Family Home
Built:
2024
County:
Area:

School Information

Elementary School:
Middle School:
High School:
School District:

Description

The Lake at Big Thompson is a once-in-a-lifetime private waterfront estate in Johnstown, Colorado, delivering luxury living, resort-style recreation, and multiple income streams all in one spectacular package. At its heart is a private 28-plus acre lake with Big Thompson River frontage and a destination-quality fishery producing trophy walleye, largemouth bass, smallmouth bass, crappie, catfish, and Colorado state record winning sunfish and bluegill. Built in 2024, the luxury residence stuns with premium finishes including Wolf appliances, a commercial grade double Sub-Zero refrigerator, jaw dropping granite countertops, vaulted beamed ceilings, multiple steam showers, and a double jetted soaking tub with built-in TV, all opening to an expansive covered deck overlooking the water. The walk-out basement is perfect for entertaining featuring a wet bar, gym/flex room, golf and hunt simulator, and an extra bedroom and guest bathroom along with a walk-in secured vault room. A separate guest house adds flexible accommodations for family, friends, or clients. Exceptional waterfowl hunting adds significant income opportunity with two hunting blinds, including "The Train Station" complete with power, TV, and kitchen area. Outdoor living is unmatched, featuring a private sandy beach, sand volleyball court, and endless water recreation from boating and water skiing to paddle boarding and more. Outbuildings include a greenhouse, chicken coop, two detached shops, and a stainless-steel fish and game cleaning station, while a new high-capacity well completed in 2026 supports future expansion. Site plans and blueprints for a larger lodge, event venue, and lakeside boathouse unlock even more income potential. This gated waterfront estate sits minutes from Interstate 25 with easy access to Fort Collins and Denver. The Lake at Big Thompson is truly a once in a lifetime, can't-miss opportunity! Visit thelakeatbigthompson.com for even more info and photos!

Monthly Payment Calculator



IRES logo

© 2026 Information and Real Estate Services, LLC. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or EXP Realty. Data last updated: 2026-08-15T11:44:21.53.

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
www.findyournocohome.com/homes/178578446
Print Image

6504 County Road 54 Johnstown, CO 80534

  • Price: $12,850,000
  • Status: Active
  • On Site: 37 Days
  • Updated: 56 min ago
  • MLS #: 1063603
7
Beds
7
Baths
0
½ Baths
71
Acres
8,764
SQFT
$1,466
$/SQFT
2024
Built
Neighborhood:
N/A
County:
Weld
Area:
Greeley/Weld
Elementary School:
Letford
Middle School:
Milliken
High School:
Roosevelt
School District:
Weld Re-5J
Property Description
The Lake at Big Thompson is a once-in-a-lifetime private waterfront estate in Johnstown, Colorado, delivering luxury living, resort-style recreation, and multiple income streams all in one spectacular package. At its heart is a private 28-plus acre lake with Big Thompson River frontage and a destination-quality fishery producing trophy walleye, largemouth bass, smallmouth bass, crappie, catfish, and Colorado state record winning sunfish and bluegill. Built in 2024, the luxury residence stuns with premium finishes including Wolf appliances, a commercial grade double Sub-Zero refrigerator, jaw dropping granite countertops, vaulted beamed ceilings, multiple steam showers, and a double jetted soaking tub with built-in TV, all opening to an expansive covered deck overlooking the water. The walk-out basement is perfect for entertaining featuring a wet bar, gym/flex room, golf and hunt simulator, and an extra bedroom and guest bathroom along with a walk-in secured vault room. A separate guest house adds flexible accommodations for family, friends, or clients. Exceptional waterfowl hunting adds significant income opportunity with two hunting blinds, including "The Train Station" complete with power, TV, and kitchen area. Outdoor living is unmatched, featuring a private sandy beach, sand volleyball court, and endless water recreation from boating and water skiing to paddle boarding and more. Outbuildings include a greenhouse, chicken coop, two detached shops, and a stainless-steel fish and game cleaning station, while a new high-capacity well completed in 2026 supports future expansion. Site plans and blueprints for a larger lodge, event venue, and lakeside boathouse unlock even more income potential. This gated waterfront estate sits minutes from Interstate 25 with easy access to Fort Collins and Denver. The Lake at Big Thompson is truly a once in a lifetime, can't-miss opportunity! Visit thelakeatbigthompson.com for even more info and photos!
Exterior Features

Architectural Style In-Law AreaIncludes Rental UnitContemporary Construction Materials FrameStone Door Features French Doors Exterior Features Sprinkler System>8' Garage DoorHeated GarageOversized GarageTandem GarageDrive Through Garage Garage Sq Ft 2885 Garage Type Attached Parking Features Garage Door OpenerRV Access/ParkingAttached Patio And Porch Features PatioDeck Roof Composition Spa Features Bath View Mountain(s)HillsPlains ViewWaterPanoramic Waterfront YN No Window Features Window Coverings

Interior Features

Above Grade Finished Area 4826 Accessibility Features Level LotLevel DriveLow CarpetNo StairsOtherMain Floor BathMain Level BedroomStall ShowerMain Level Laundry All Bedrooms Conform Yes Appliances Gas RangeDouble OvenDishwasherRefrigeratorBar FridgeWasherDryerMicrowaveDisposalFire Alarm Basement FullPartially FinishedWalk-Out AccessDaylight Bathrooms Total Integer 7 Baths Full Additional 1 Baths Full Basement 0 Baths Full Lower 0 Baths Full Main 3 Baths Full Upper 0 Baths Half Additional 0 Baths Half Basement 0 Baths Half Lower 0 Baths Half Main 0 Baths Half Upper 0 Baths Rough In 0 Baths Three Quarters Additional 2 Baths Three Quarters Basement 1 Baths Three Quarters Lower 0 Baths Three Quarters Main 0 Baths Three Quarters Upper 0 Cooling Central AirCeiling Fan(s) Fireplace Features GasLiving Room Flooring Wood Has Family Room No Has Study Yes Heating Forced Air2 or more Heat Sources Interior Features Eat-in KitchenSeparate Dining RoomCathedral Ceiling(s)Open FloorplanWorkshopPantryWalk-In Closet(s)Wet BarWasher/Dryer HookupKitchen IslandTheatre RoomTwo Primary SuitesSteam ShowerHigh CeilingsBeamed Ceilings Levels One Living Area Source Other Main Floor Sq Ft 4826 Room Type Media Room

Property Features

Are Ditches Active No Association YN No Electric PVREA Exclusions Sellers personal property and mineral rights. Fencing PartialFencedDog Run/Kennel Flood Plain Minimal Flood or C Rating Gas Xcel Green Energy Efficient Southern ExposureWindowsHigh Efficiency Furnace Has Improvements No Has Irrigation Ditches No Has Metro Tax District No Has Water Rights No Horse Amenities Horse(s) AllowedZoning Appropriate for 1 HorseZoning Appropriate for 2 HorsesZoning Appropriate for 3 HorsesZoning Appropriate for 4+ HorsesPasture Irrigation Water Rights YN No Is Water Meter Installed Yes Listing Terms CashConventional1031 Exchange Lot Features WoodedEvergreen TreesDeciduous TreesNative GrassLevelRolling LotAbuts DitchAbuts Pond/LakeAbuts Stream/Creek/RiverAbuts Farm LandMeadowOutbuildingsHouse Faces WestLake AccessWaterfrontLake on LotMineral Rights Excluded New Construction Status Not NewPreviously Owned New Construction YN No Other Structures Storage Possible Use Single FamilyMulti-FamilyFarmBusinessCommercialAdditional UnitsIndustrial Property Sub Type Mixed Use Road Frontage Type County Maintained Sewer Septic Tank Special Listing Conditions Private Owner Tax Annual Amount 9001 Tax Year 2025 Utilities Natural Gas AvailableElectricity Available Water Source Well Zoning Ag

Listing information © 2026 Information and Real Estate Services
Listing provided courtesy of Liz Crews of eXp Realty - Northern CO: 9705682215.



IRES logo

© 2026 Information and Real Estate Services, LLC. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or EXP Realty. Data last updated: 2026-08-15T11:44:21.53.

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
 
https://bt-photos.global.ssl.fastly.net/ires/orig_boomver_1_1063603-2.jpg https://bt-photos.global.ssl.fastly.net/ires/orig_boomver_1_1063603-2.jpg https://bt-photos.global.ssl.fastly.net/ires/orig_boomver_1_1063603-2.jpg
Logo
EXP Realty
500 Whitcomb Street
Fort Collins CO, 80521