Date
Details
Price
Change
Source
7/08/2026
Listed
$12,850,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/50
$12,850,000 New to Website
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/50
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!
Full Property Details
Full Property Details for 6504 Co Rd 54
General
- Price: $12,850,000
- Taxes: $9,001 (2025)
- Status: Active
- Type: Single Family
- Source: IRES
- MLS ID: 1063603
- Updated: 7/9/2026
- Added to Site: 3 day(s) ago
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
- Fireplace: Yes
- Fireplace(s): Gas, Living Room
- Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal, Fire Alarm
- Flooring: Wood
Rooms
Bathrooms
- Total Bathrooms: 7
- Full Bathrooms: 4
- 3/4 Bathrooms: 3
- Main Floor Baths: 3
Bedrooms
- Total Bedrooms: 7
Additional Information
- Spa: Yes
- Spa Description: Bath
Exterior
- Exterior Features: Sprinkler System, Garage Door More Than 8 Feet High, Heated Garage, Oversized Garage, Tandem Garage, Drive Through Garage
- Porch/Patio/Deck: Patio, Deck
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 15
- Parking Features: Garage Door Opener, RV Access/Parking, Attached
- Garage Description: Attached
Location
- Area: Johnstown
- County: Weld
- Subdivision: N/A
- Driving Directions: 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.
School Information
- School District: Weld RE-5J
- Elementary School: Letford
- Middle School: Milliken
- High School: Roosevelt
Heating & Cooling
- Cooling Type: Central Air, Ceiling Fan(s)
- Heating Type: Forced Air, 2 or more Heat Sources
Utilities
- Gas: Yes
- Gas: Xcel
- Sewer: Septic Tank
- Water: Well
- Utility Description: Natural Gas Available, Electricity Available
Structural Information
- Architectural Style: In-Law Area, Includes Rental Unit, Contemporary
- Construction: Frame, Stone
- Exterior Const.: Frame, Stone
- Basement: Yes
- Basement Desc.: Full, Partially Finished, Walk-Out Access, Daylight
- Roof: Composition
- Windows: Window Coverings
- Doors: French Doors
- Square Feet: 9,400
- Sq. Ft. Source: Other
- Living Area: 8,764 Sq. Ft.
- Year Built: 2021
Additional Structures
- Other Structures: Storage
Lot Features
- Property View: Mountain(s), Hills, Plains View, Water, Panoramic
- Mountain views: Yes
- Lot Size (Acres): 71
- Lot Size (Sq. Ft.): 3,092,760
- Frontage: County Maintained
- Fence: Yes
- Lot Features: 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, L
- Potential Use: Single-Family, Multi-Family, Farm, Business, Commercial, Additional Units, Industrial
- Zoning: Ag
- Fencing (Description): Partial, Fenced, Dog Run/Kennel
Horse Property
- Horse Property: Yes
- Horse Facility Desc.: Horse(s) Allowed, Zoning Appropriate for 1 Horse, Zoning Appropriate for 2 Horses, Zoning Appropriate for 3 Horses, Zoning Appropriate for 4+ Horses, Pastu
Water Features
- Water View: Yes
Green Features
- Energy Efficient: Southern Exposure, Windows, High Efficiency Furnace
Financial Considerations
- Tax Amount: $9,001
- Tax Year: 2025
- Terms: Cash, Conventional, 1031 Exchange
Disclosures and Reports
- Special Conditions: Private Owner
- Exclusions: Sellers personal property and mineral rights.
- Property ID: R8955571
Listed by eXp Realty - Northern CO (970) 889-0371 and Non-IRES (970) 593-9002
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 6504 Co Rd 54 —
eXp Realty - Northern CO
970-889-0371
Non-IRES
970-593-9002
9705682215
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 6504 Co Rd 54
School District:Johnstown-Milliken School District Re-5j
| Name | Grades | Distance |
|---|---|---|
Elwell Elementary School 155 Silverbell Drive, Johnstown, CO 80534 | PK-5 | 3.1 mi |
Milliken Middle School 66 South Irene Avenue, Milliken, CO 80543 | 6-8 | 5.3 mi |
Roosevelt High School 616 North 2nd Street, Johnstown, CO 80534 | 9-12 | 2.9 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 6504 Co Rd 54
Estimate the Cost
Estimate the Cost for 6504 Co Rd 54
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 1 day ago
- 2Beds
- 1Total Bath
- 1,900Sq. Ft.
- MLS # 1063493
Listed by Revolve Real Estate, LLC
- Single Family
- Active
- Updated 1 day ago
- 3Beds
- 2Total Baths
- 1,550Sq. Ft.
- MLS # 1063550
Listed by Oneway.realty
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 2Total Baths
- 2,905Sq. Ft.
- MLS # 1063590
Listed by AGPROfessionals, LLC
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 5Total Baths
- 5,372Sq. Ft.
- MLS # 1063505
Listed by RE/MAX Alliance-FTC South
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 3Total Baths
- 3,492Sq. Ft.
- MLS # 1057997
Listed by The Resource Group, LLC
- Single Family
- Active
- Updated 23 hours ago
- 4Beds
- 4Total Baths
- 2,462Sq. Ft.
- MLS # 1046421
Listed by RE/MAX Alliance-Windsor
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 4Total Baths
- 2,862Sq. Ft.
- MLS # 1061576
Listed by Group Harmony
- Single Family
- Active
- Updated 6 days ago
- 3Beds
- 3Total Baths
- 2,329Sq. Ft.
- MLS # 7168766
Listed by Keller Williams Action Realty LLC
6504 County Road 54, Johnstown, CO 80534 (MLS# 1063603) is a Single Family property with 7 bedrooms, 4 full bathrooms and 3 partial bathrooms. 6504 County Road 54 is currently listed for $12,850,000 and was received on July 08, 2026. Want to learn more about 6504 County Road 54? Do you have questions about finding other Single Family real estate for sale in Johnstown? You can browse all Johnstown real estate or contact a Coldwell Banker agent to request more information.