6504 County Road 54
Johnstown, CO, 80534 $ 12,850,000
Bedrooms7 Baths7.0 Sq 8,764 Monthly Estimate*
$ 88,752
Listed by eXp Realty - Northern CO
for $12,850,000 with 7 bedrooms and 7 full baths. This 8,764 square foot home was built in 2024 on a lot size of 71.
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!
See more
FeaturesGeneralLiving Area 8764
Sewer Septic Tank
Heating Forced Air
Cooling Ceiling Fan(s) Central Air
Utilities Electricity Available Natural Gas Available
Roof Composition
Appliances Bar Fridge Dishwasher Disposal Double Oven Dryer Microwave Oven Refrigerator Washer
Zoning Ag
Garage Spaces 15
Patio/Porch Features Deck Patio
Architectural Style Contemporary
Construction Materials Stone Wood Frame
Year Built 2024
View Mountain(s) Plains Water
Levels One
Property Subtype Single Family Residence
Parcel Number R8955571
County Weld
Property Type Residential
HOA N
Attached Garage Y
Subdivision Name N/A
Facing Direction West
Possible Use Agricultural Commercial Industrial Multi-Family Residential
Full Baths 4
Directions Due to road construction ONLY come from CR 17 turn east on CR 54. Go past the construction signs until you arrive at the gate to the property on your left. See supplements for map.
High School Roosevelt
City Johnstown
Senior Community Y/N N
High School District Johnstown-Milliken RE-5J
Lot Size Square Feet 3092760
Elementary School Letford
Property Attached Y/N N
Tax Annual Amount 9001
Middle/Junior High School Milliken
Virtual Tour https://thelakeatbigthompson.com/
Standard Status Active
Elementary School District Johnstown-Milliken RE-5J
Freehold IDX
See more
InteriorInterior Amenities Eat-in Kitchen Five Piece Bath In-Law Floorplan Jet Action Tub Kitchen Island No Stairs Open Floorplan Pantry Primary Suite Vaulted Ceiling(s) Walk-In Closet(s) Wet Bar
Basement Daylight Full Walk-Out Access
Flooring Wood
Fireplace Features Gas Living Room
Window Features Double Pane Windows Window Coverings
Half Baths 0
3/4 Baths 3
Laundry Features In Unit
Total Bedrooms 7
Total Baths 7
See more
ExteriorExterior Amenities Dog Run
Fencing Partial
Parking Features Heated Garage Oversized Oversized Door RV Access/Parking Tandem
Lot Features Ditch Level Meadow Rolling Slope Sprinklers In Front
Water Source Well
Lot Size Acres 71
See more
* Excluded FeaturesList ByExp Realty - Northern CoBroker
Affordability Calculator
- Monthly Principal & Interest
- $88,752
- Monthly Property Taxes
- $750
- Monthly Home Insurance
- --
Default based on a 30-year fixed rate of 7.375% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save NearbySingle family listings in Johnstown, CO
Average List Price $594,478
Percent of Sale Price 95%
About Johnstown, CO 14,650 Population
187% Since 2002
$ 84,411 Median Income
38.02 Median Age
35% Households with Children
Trends Information provided by ATTOM Data Solutions.
3043460 Elementary School
3043067 Middle School
Roosevelt High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 7/8/2026 | $12,850,000 | | Listed Price |