Mountain Homes Realty
Enter City, Zip or MLS

6504 county road 54

Johnstown, CO 80534

$12,850,000

7 BEDS 7 BATHS
9,400 SQFT71 AC LOT
Residential - Mixed Use
Waterfront
Image 1: The Lake at Big Thompson
Image 2: Luxury home connected to the guest house through the garage
Image 3: Grand entrance, beautiful wood floors throughout!
Image 4: Gourmet chef's kitchen with double island
Bedrooms 7
Total Baths 7
Full Baths 4
Square Feet 9400
Acreage 71
Status Active
MLS # 1063603
County Weld
More Info
Category Residential - Mixed Use
Status Active
Square Feet 9400
Acreage 71
MLS # 1063603
County Weld
Listed By: Listing Agent Liz Crews
eXp Realty - Northern CO - (970) 568-2215
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!
Location not available
Listing
Street
Satellite

Exterior Features

  • Style In-Law Area, Includes Rental Unit, Contemporary
  • Construction Mixed Use
  • Siding Frame, Stone
  • Exterior Sprinkler System, ">8 Garage Door", Heated Garage, Oversized Garage, Tandem Garage, Drive Through Garage
  • Roof Composition
  • Garage Yes
  • Garage Description Garage Door Opener, RV Access/Parking, Attached
  • Water Well
  • Sewer Septic Tank
  • Lot Description Wooded, Evergreen Trees, Deciduous Trees, Native Grass, Level, Rolling Lot, Abuts Ditch, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Meadow, Outbuildings, House Faces West, Lake Access, Waterfront, Lake on Lot, Mineral Rights Excluded

Interior Features

  • Appliances Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal, Fire Alarm
  • Heating Forced Air, 2 or more Heat Sources
  • Cooling Central Air, Ceiling Fan(s)
  • Basement Full, Partially Finished, Walk-Out Access, Daylight
  • Fireplaces Description Gas, Living Room
  • Living Area 9,400 SQFT
  • Year Built 2024
  • Stories One

Neighborhood & Schools

  • Subdivision N/A
  • School Disrict Weld RE-5J
  • Elementary School Letford
  • Middle School Milliken
  • High School Roosevelt

Financial Information

  • Parcel ID R8955571
  • Zoning Ag

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of eXp Realty - Northern CO - (970) 568-2215
Listings provided courtesy of the IRESDS MLS as distributed by MLS GRID.

Information 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 as of 07/27/2026 03:26:58 UTC. 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.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 IRESDS MLS, Inc.
Listing data is current as of 07/27/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.