6504 County Road 54 Johnstown, CO 80534
Listing Courtesy of: MLS LogoIRES LLC as distributed by MLS GRID / Listed By: eXp Realty Northern Co - Contact:  9705682215

  6504 County Road 54 Johnstown, CO 80534

Active (8 Days)
$12,850,000 (USD)
7
BED
7
BATH
8,764
SQFT

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!

MLS #:
1063603
Taxes
$9,001(2025)
Lot Size
71 acres
Type
Single-Family Home
Year Built
2024
Style
In-Law Area, Includes Rental Unit, Contemporary
Views
Plains View, Panoramic, Mountain(s), Water, Hills
School District
Weld Re-5J
County
Weld County

Listed By

Liz Crews, eXp Realty Northern Co, Contact: 9705682215
Source
IRES LLC
Last checked Jul 15 2026 at 7:45 PM PDT
Bathroom Details
  • Full Bathrooms: 4
  • 3/4 Bathrooms: 3
Interior Features
  • Eat-In Kitchen
  • Kitchen Island
  • Separate Dining Room
  • Workshop
  • Pantry
  • Wet Bar
  • Steam Shower
  • Beamed Ceilings
  • Two Primary Suites
  • Open Floorplan
  • Walk-In Closet(s)
  • Cathedral Ceiling(s)
  • Washer/Dryer Hookup
  • High Ceilings
  • Theatre Room
Kitchen
  • Disposal
  • Microwave
  • Refrigerator
  • Dishwasher
  • Fire Alarm
  • Dryer
  • Washer
  • Gas Range
  • Double Oven
  • Bar Fridge
Subdivision
  • N/A
Lot Information
  • Abuts Pond/Lake
  • Native Grass
  • Evergreen Trees
  • Deciduous Trees
  • Rolling Lot
  • House Faces West
  • Outbuildings
  • Abuts Stream/Creek/River
  • Abuts Farm Land
  • Meadow
  • Abuts Ditch
  • Level
  • Wooded
  • Mineral Rights Excluded
  • Waterfront
  • Lake Access
  • Lake on Lot
Property Features
  • Fireplace: Gas
  • Fireplace: Living Room
Heating and Cooling
  • Forced Air
  • 2 or More Heat Sources
  • Central Air
  • Ceiling Fan(s)
Basement Information
  • Full
  • Walk-Out Access
  • Daylight
  • Partially Finished
Flooring
  • Wood
Exterior Features
  • Roof: Composition
Utility Information
  • Utilities: Natural Gas Available, Electricity Available
  • Sewer: Septic Tank
  • Energy: Southern Exposure, High Efficiency Furnace, Windows
School Information
  • Elementary School: Letford
  • Middle School: Milliken
  • High School: Roosevelt
Garage
  • Attached
Parking
  • Garage Door Opener
  • Attached
  • Rv Access/Parking
Stories
  • One
Living Area
  • 8,764 sqft
Additional Information: eXp Realty Northern Co | 9705682215
Powered by Walk Score®

Estimated Monthly Mortgage Payment

*Based on Fixed Interest Rate withe a 30 year term, principal and interest only

Listing price
Down payment
%
Interest rate
%
Mortgage calculator estimates are provided by Windermere Real Estate and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: Updated: 7/15/26 12:45 Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES. Terms of Use: Listing 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 deemed reliable but not guaranteed by the MLS.
Based on information submitted to the MLS GRID as of 7/15/2026 12:45. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.