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!
For sale
$12,850,000
6504 County Road 54, Johnstown, CO 80534
7beds
9,400sqft
:
Get pre-qualified$83,528/mo
Mixed Use
Built in 2024
71 Acres Lot
$-- Zestimate®
$1,367/sqft
$-- HOA
What's special
Sand volleyball courtGated waterfront estateChicken coopPrivate sandy beachTwo detached shopsGolf and hunt simulatorWalk-in secured vault room
- 24 days |
- 2,069 |
- 120 |
Zillow last checked:
Listing updated:
Listed by:
Liz Crews 970-568-2215,
eXp Realty - Northern CO,
Non-IRES Agent 970-593-9002,
Non-IRES
Source: IRES as distributed by MLS GRID,MLS#: 1063603
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 7
- Full bathrooms: 4
- 3/4 bathrooms: 3
- Main level bathrooms: 3
Rooms
- Room types: Media Room
Primary bedroom
- Description: Carpet
- Features: Full Primary Bath, Tub+Shower Primary, Luxury Features Primary Bath, 5 Piece Primary Bath
- Level: Main
- Area: 336 Square Feet
- Dimensions: 16 x 21
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 196 Square Feet
- Dimensions: 14 x 14
Bedroom 3
- Description: Carpet
- Level: Basement
- Area: 252 Square Feet
- Dimensions: 12 x 21
Bedroom 4
- Description: Hardwood
- Level: Additional
- Area: 210 Square Feet
- Dimensions: 14 x 15
Bedroom 5
- Description: Hardwood
- Level: Additional
- Area: 143 Square Feet
- Dimensions: 13 x 11
Bedroom 6
- Description: Hardwood
- Level: Additional
- Area: 156 Square Feet
- Dimensions: 13 x 12
Dining room
- Description: Hardwood
- Level: Main
- Area: 252 Square Feet
- Dimensions: 12 x 21
Kitchen
- Description: Hardwood
- Level: Main
- Area: 480 Square Feet
- Dimensions: 20 x 24
Laundry
- Description: Hardwood
- Level: Main
- Area: 135 Square Feet
- Dimensions: 15 x 9
Living room
- Description: Hardwood
- Level: Main
- Area: 506 Square Feet
- Dimensions: 23 x 22
Recreation room
- Description: Concrete
- Level: Basement
- Area: 2304 Square Feet
- Dimensions: 36 x 64
Study
- Description: Hardwood
- Level: Main
- Area: 270 Square Feet
- Dimensions: 18 x 15
Heating
- Forced Air, 2 or more Heat Sources
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
- Laundry: Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Workshop, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, Theatre Room, Two Primary Suites, Steam Shower, High Ceilings, Beamed Ceilings, In-Law Floorplan
- Flooring: Wood
- Doors: French Doors
- Windows: Window Coverings
- Basement: Full,Partially Finished,Walk-Out Access,Daylight
- Has fireplace: Yes
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 4,826
- Total interior livable area: 9,400 sqft
- Finished area above ground: 4,826
Video & virtual tour
Property
Parking
- Total spaces: 15
- Parking features: Garage Door Opener, RV Access/Parking, Attached, >8' Garage Door, Heated Garage, Oversized, Tandem, Drive Through
- Attached garage spaces: 15
- Details: Attached
Accessibility
- Accessibility features: Level Lot, Level Drive, Low Carpet, No Stairs, Other, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Spa features: Bath
- Fencing: Partial,Fenced,Dog Run/Kennel
- Has view: Yes
- View description: Mountain(s), Hills, Plains View, Water, Panoramic
- Has water view: Yes
- Water view: Water
- Waterfront features: Abuts Pond/Lake, Abuts Stream/Creek/River, Lake Privileges, Waterfront
Lot
- Size: 71 Acres
- Features: Wooded, Evergreen Trees, Deciduous Trees, Native Plants, Level, Rolling Slope, Abuts Ditch, Abuts Farm Land, Meadow, Waterfront, Lake on Lot, Mineral Rights Excluded
Details
- Additional structures: Storage, Outbuilding
- Parcel number: R8955571
- Zoning: Ag
- Special conditions: Private Owner
- Horses can be raised: Yes
- Horse amenities: Horse(s) Allowed, Zoning Appropriate for 1 Horse, Zoning Appropriate for 2 Horses, Zoning Appropriate for 3 Horses, Zoning Appropriate for 4+ Horses, Pasture
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Includes Rental Unit,Contemporary
- Property subtype: Mixed Use
Materials
- Frame, Stone
- Roof: Composition
Condition
- New construction: No
- Year built: 2024
Utilities & green energy
- Electric: PVREA
- Gas: Xcel
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Natural Gas Available, Electricity Available
Green energy
- Energy efficient items: Southern Exposure, Windows, High Efficiency Furnace
Community & HOA
Community
- Security: Fire Alarm
- Subdivision: N/A
HOA
- Has HOA: No
Location
- Region: Johnstown
Financial & listing details
- Price per square foot: $1,367/sqft
- Tax assessed value: $1,366,455
- Annual tax amount: $9,001
- Date on market: 7/8/2026
- Listing terms: Cash,Conventional,1031 Exchange
- Exclusions: Sellers personal property and mineral rights.
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/8/2026 | Listed for sale | $12,850,000$1,367/sqft |
Source:  IRES as distributed by MLS GRID #1063603 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $9,001 +1379.6% | $115,760 -0.9% |
| 2025 | $608 +8.8% | $116,760 +882.8% |
| 2024 | $559 -45.2% | $11,880 -1% |
| 2023 | $1,021 +7805.3% | $12,000 -2.6% |
| 2022 | $13 -78.9% | $12,320 +13588.9% |
| 2021 | $61 | $90 -87.5% |
| 2020 | $61 | $720 |
| 2019 | -- | $720 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 80534
Nearby schools
GreatSchools rating
- 6/10Elwell Elementary SchoolGrades: PK-5Distance: 3.1 mi
- 6/10Milliken Middle SchoolGrades: 6-8Distance: 2.9 mi
- 5/10Roosevelt High SchoolGrades: 9-12Distance: 3.6 mi
Schools provided by the listing agent
- Elementary: Letford
- Middle: Milliken
- High: Roosevelt
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $529,3893 bd3 ba1.8k sqft25808 County Road 13, Johnstown, CO 80534Off Market
- $630,4213 bd3 ba3.4k sqft25808 County Road 13, Johnstown, CO 80534Off Market
- $764,9613 bd2 ba1.9k sqft25808 County Road 13, Johnstown, CO 80534Off Market
- $376,4003 bd1 ba1.4k sqft26135 County Road 15, Loveland, CO 80534Off Market
- $2,056,0006 bd5 ba4.9k sqft7008 County Road 54, Johnstown, CO 80534Off Market
- $1,030,7005 bd3 ba1.8k sqft26500 County Road 13, Johnstown, CO 80534Off Market
- $2,200,0004 bd3 ba4.9k sqft7182 Lakota Lakes Rd, Johnstown, CO 80534For Sale
- $817,4003 bd3 ba2k sqft26360 County Road 15, Johnstown, CO 80534Off Market
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Similar homes
- $7,400,0004 bd8 ba7.5k sqft20360 County Road 3, Berthoud, CO 80513For Sale
MLS ID #1044322, Jim Green, WK Real Estate Longmont. IRES as distributed by MLS GRID - $15,750,0004 bd7 ba8.3k sqft7009 Rozena Dr, Longmont, CO 80503For Sale
MLS ID #1056552, Lucy Conklin, Compass - Boulder. IRES as distributed by MLS GRID - $17,500,0006 bd7 ba10k sqft15383 E County Line Rd, Berthoud, CO 80513For Sale
MLS ID #1058551, Marybeth Emerson, The Agency - Boulder. IRES as distributed by MLS GRID - $9,950,0004 bd6 ba10k sqft12357 N 75th St, Longmont, CO 80503New Construction
MLS ID #1060946, Hunter Jorgensen, Compass - Boulder. IRES as distributed by MLS GRID - $8,450,0004 bd7 ba8.3k sqft7007 Rozena Dr, Longmont, CO 80503For SaleMLS ID #1055899, Lucy Conklin, Compass - Boulder. IRES as distributed by MLS GRID
