Single Family for Sale: 6504 County Road 54, Johnstown, CO 80534

7 beds
4 full, 3 three quarter baths
4,826 sqft
mls #1063603
$12,850,000
$12,850,000
6504 County Road 54, Johnstown, CO 80534
7 beds
4 full, 3 three quarter baths
4,826 sqft
mls #1063603
$12,850,000
Remove from
FavoritesAdd to
Favorites		 Add to
Trip Map		 Hide Share or
Email
Price:
$12,850,000
Est. payment: Skip to Mortgage Calculator

Get Pre-Approved

Type Single Family
Style 1 Story
Beds 7
Baths 4 full, 3 three quarter baths
Square Feet 4,826 sqft
Lot Size 71.00 acres
Year Built 2024
City Johnstown
County Weld
Subdivision N/A
MLS 1063603
Status Active
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!

Room Features

Exterior Features Drive Through Garage, >8' Garage Door, Tandem Garage, Heated Garage, Oversized Garage, Sprinkler System
Basement Daylight, Walk-Out Access, Full, Partially Finished

Lot & Building Features

Appliances Bar Fridge, Gas Range, Double Oven, Fire Alarm, Washer, Dryer, Disposal, Microwave, Refrigerator, Dishwasher
Style 1 Story
Heating 2 or more Heat Sources, Forced Air
Cooling Ceiling Fan(s), Central Air
Parking RV Access/Parking, Garage Door Opener, Attached
Sewer Septic Tank
Tax Year 2025
Water Well
Interior Steam Shower, Beamed Ceilings, Theatre Room, Two Primary Suites, Workshop, High Ceilings, Wet Bar, Separate Dining Room, Washer/Dryer Hookup, Cathedral Ceiling(s), Pantry, Kitchen Island, Eat-in Kitchen, Walk-In Closet(s), Open Floorplan
Exterior Drive Through Garage, >8' Garage Door, Tandem Garage, Heated Garage, Oversized Garage, Sprinkler System
Fireplace Gas, Living Room
Lot Lake on Lot, Abuts Farm Land, Waterfront, Lake Access, Abuts Ditch, Abuts Stream/Creek/River, Abuts Pond/Lake, Mineral Rights Excluded, Native Grass, Rolling Lot, Meadow, Evergreen Trees, Wooded, House Faces West, Outbuildings, Deciduous Trees, Level

Community and Schools

Junior High School Milliken

Price History of 6504 County Road 54, Johnstown, CO

Date Name Price Difference
Coming Soon Listing Price $12,850,000 N/A
*Information provided by REWS for your reference only. The accuracy of this information cannot be verified and is not guaranteed.

Open new tab for directions to this property
Map of 6504 County Road 54, Johnstown, CO

Location Map Street View

Inquire About This Property

By providing Grey Rock Realty with your contact information, you acknowledge and agree to our privacy policy and consent to receiving marketing communications, including calls, texts and emails. This consent isn’t necessary for purchasing any products or services and you may opt out at any time. To opt out from texts, you can reply, ‘stop’ at any time, to opt out from emails, you can click on the unsubscribe link in the email. Message and data rates may apply. 

Photo of

By providing Grey Rock Realty with your contact information, you acknowledge and agree to our privacy policy and consent to receiving marketing communications, including calls, texts and emails. This consent isn’t necessary for purchasing any products or services and you may opt out at any time. To opt out from texts, you can reply, ‘stop’ at any time, to opt out from emails, you can click on the unsubscribe link in the email. Message and data rates may apply. 

Listed by eXp Realty - Northern CO, Liz Crews & Non-IRES Agent 970-889-0371
$
20%
0.070046692607004%
6.75%
$
$
$
Monthly Payment
Principal & Interest
Monthly Taxes
Monthly HOA
Monthly Home Ins.
Monthly PMI
Browse By Area

6504 County Road 54 (MLS #1063603) is a includes rental unit, in-law area, contemporary single family home located in Johnstown, CO. This single family home is 4,826 sqft and on a lot of 3,092,760 sqft (or 71.00 acres) with 7 bedrooms and 7 baths. This property was listed on 07/08/2026 and has been priced for sale at $12,850,000.

Nearby zip codes are 80513, 80537, 80538, 80543 and 80550. This property neighbors other cities such as Berthoud, Greeley, Loveland, Milliken and Windsor.

Listing Last updated . Some properties which appear for sale on this web site may subsequently have sold or may no longer be available. Walk Score map and data provided by Walk Score. Google map provided by Google. Bing map provided by Microsoft Corporation.

All information provided is deemed reliable but is not guaranteed and should be independently verified.

Listing information courtesy of: eXp Realty - Northern CO

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES 2026

IRES MLS

Listing data and photos provided IRES and distributed by MLS GRID. Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability. Based on information submitted to the MLS GRID. 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.