REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Kevin Schumacher

kevin@kevinsellsco.com +1(970) 396-7248

$ 12,850,000

Est. payment -/mo

Save Virtual Tour

New

6504 County Road 54 Johnstown, CO 80534

7 Beds

7 Baths

9,400 SqFt

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Mixed Use

Listing Status Active

Purchase Type For Sale

Square Footage 9,400 sqft

MLS Listing ID IRE1063603

Style In-Law Area,Includes Rental Unit,Contemporary

Bedrooms 7

Full Baths 4

Three Quarter Bath 3

HOA Y/N No

Year Built 2024

Annual Tax Amount $9,001

Tax Year 2025

Lot Size 71.000 Acres

Acres 71.0

Property Sub-Type Mixed Use

Source ires

Property 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!

Location

State CO

County Weld

Area Greeley/Weld

Zoning Ag

Direction 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.

Rooms

Basement Full, Partially Finished, Walk-Out Access, Daylight

Interior

Interior Features Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Workshop, Pantry, Walk-In Closet(s), Wet Bar, Washer/Dryer Hookup, Kitchen Island, Theatre Room, Two Primary Suites, Steam Shower, High Ceilings, Beamed Ceilings

Heating Forced Air, 2 or more Heat Sources

Cooling Central Air, Ceiling Fan(s)

Flooring Wood

Fireplaces Type Gas, Living Room

Appliance Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal, Fire Alarm

Exterior

Exterior Feature Sprinkler System, >8' Garage Door, Heated Garage, Oversized Garage, Tandem Garage, Drive Through Garage

Parking Features Garage Door Opener, RV Access/Parking, Attached

Garage Spaces 15.0

Fence Partial, Fenced, Dog Run/Kennel

Utilities Available Natural Gas Available, Electricity Available

View Y/N Yes

View Mountain(s), Hills, Plains View, Water, Panoramic

Roof Type Composition

Improvements No

Porch Patio, Deck

Garage Yes

Building

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

Sewer Septic Tank

Water Well

Architectural Style In-Law Area, Includes Rental Unit, Contemporary

Level or Stories One

Structure Type Frame,Stone

New Construction false

Schools

Elementary Schools Letford

Middle Schools Milliken

High Schools Weld Re-5J

School District Weld Re-5J

Others

Acceptable Financing Cash, Conventional, 1031 Exchange

Horse Property Horse(s) Allowed, Zoning Appropriate for 1 Horse, Zoning Appropriate for 2 Horses, Zoning Appropriate for 3 Horses, Zoning Appropriate for 4+ Horses, Pasture

Listing Terms Cash, Conventional, 1031 Exchange

Special Listing Condition Private Owner

Virtual Tour https://thelakeatbigthompson.com/

Information and Real Estate Services (IRES)

Listed by Liz Crews

Nearby Locations

GET MORE INFORMATION

Kevin Schumacher

+1(970) 396-7248

kevin@kevinsellsco.com

Kevin Schumacher

6504 County Road 54 Johnstown, CO 80534

Key Details

Location

Rooms

Interior

Exterior

Building

Schools

Others

Nearby Locations

GET MORE INFORMATION

Go tour this home

6504 County Road 54