- 5 beds
- 4 baths
- 14,020 sqft
- ~5 acre lot
- $196 per sqft
- 2018 build
- – on site
MOTIVATED SELLER AND rezoning has just been approved by Larimer Co Board and will be done in August with the Board of Commissioners, changed to mixed-use Rural Commercial Zoning (from RR2), making this property ideal for a variety of business uses or a work from home setup. Attached to a luxurious 4500 sq ft home is a nearly 10,000 sq ft shop, showroom, and loft. Spanning two lots and 4.6 acres, the property includes a beautiful 3/4-acre stocked pond with a dock and sandy beach. The perfectly engineered slopes and underground drainage from the structures feed the pond during rainfall. The lower lot has a new 40x60 insulated shop with 3 overhead doors and a large concrete pad. The primary shop, over 7,700 sq ft, includes 4 14x14 doors, 220 power, an 8X7 pass-through from shop to showroom, and multiple outlets, including exterior outlets on the eaves for added security. The fully finished interior uses hybrid insulation combining bats over spray foam for efficiency. A 1700 sq ft loft with a separate entrance can serve as office space, a suite, or be rented independently. The residence offers 5 beds, 4 baths, stunning tilework, an outdoor entertaining area wired for TV, hot tub, and firepit, along with an upgraded kitchen featuring a large island and Jenn Air appliances. The property includes 27 sprinkler zones, over 80 new trees alongside mature trees, and a private well. Encircled by 4 rail vinyl fencing on three sides, an entry gate and backing to a tree-lined ditch, the property ensures privacy and protection. The sale includes 0.5 share of Lake Canal water rights. Located close to local amenities and top-rated schools. This meticulously designed and maintained property in Northern Colorado is a rare opportunity!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 23, 2025
•
MLS# 1037469 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:2018
-
New Construction:false
-
Construction Materials:Wood/Frame
-
Architectural Style:Ranch
-
Total SqFt:14,020 Sqft
-
Building Area Total:11782
-
Roof:Metal
-
Levels:One
-
Basement:Full
-
Stories:1
-
Window Features:Window Coverings
-
Patio And Porch Features:Patio
-
Accessibility Features:Level Lot
-
Above Grade Finished Area:11782
-
Below Grade Finished Area:2238
Interior
-
Interior Features:Satellite Avail
-
Fireplace:true
-
Fireplace Features:Living Room
-
Living Room Level:Main
-
Living Room Features:Other Floor
-
Kitchen Level:Main
-
Kitchen Features:Other Floor
-
Laundry Features:Sink
Room Dimensions
-
Living Area:14020
-
Living Area Units:Square Feet
-
Living Area Source:Plans
-
Main Floor SqFt:9998
-
Living Room Area:552
-
Living Room Length:23
-
Living Room Width:24
-
Kitchen Length:16
-
Kitchen Area:384
-
Kitchen Width:24
-
Master Bedroom Area:255
-
Master Bedroom Width:17
-
Master Bedroom Length:15
-
Bedroom 2 Area:156
-
Bedroom 2 Length:12
-
Bedroom 3 Length:13
-
Bedroom 2 Width:13
-
Bedroom 4 Length:14
-
Bedroom 3 Area:169
-
Bedroom 3 Width:13
-
Bedroom 5 Length:20
-
Bedroom 4 Area:182
-
Bedroom 4 Width:13
-
Bedroom 5 Area:260
-
Bedroom 5 Width:13
Financial & Terms
-
Listing Terms:Cash
Location
-
Coordinates:-104.99421, 40.53948
-
Latitude:40.53948
-
Longitude:-104.99421
The Property
-
Property Type:Residential
-
Property Subtype:Residential-Detached
-
Parcel Number:R1631322
-
Lot Features:Lawn Sprinkler System
-
Lot Size Acres:4.6
-
Lot Size SqFt:200,376 Sqft
-
Lot Size Area:200376
-
Lot Size Units:Square Feet
-
Zoning:See remark
-
View:Foothills View
-
Current Use:Horses
-
Possible Use:Single Family
-
Exclusions:All Seller personal property from the home and business unless noted in inclusions
-
Horse:true
-
Fencing:Vinyl
-
Other Structures:Storage
-
Waterfront:false
-
Has Water Rights:No
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$20,311.45
Beds
-
Bedrooms Total:5
-
Bedroom 2 Level:Main
-
Bedroom 2 Features:Carpet
-
Bedroom 3 Level:Main
-
Bedroom 3 Features:Carpet
-
Bedroom 4 Level:Basement
-
Bedroom 4 Features:Carpet
-
Bedroom 5 Level:Basement
-
Bedroom 5 Features:Carpet
-
Master Bedroom Level:Main
-
Master Bedroom Features:Carpet
Baths
-
Total Baths:4
-
Three Quarter Baths:2
-
Full Baths:2
-
Master Bath Features:3/4 Primary Bath
The Listing
-
Special Listing Conditions:Private Owner
Heating & Cooling
-
Heating:Forced Air
-
Heating:true
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Utilities:Natural Gas Available
-
Gas:Natural Gas, Xcel
-
Electric:Electric, Xcel
-
Sewer:Septic
-
Water Source:Well, Well
Appliances
-
Appliances:Gas Range/Oven
Schools
-
Elementary School:Timnath
-
Middle School:Timnath Middle-High School
-
High School:Timnath Middle-High School
-
High School District:Poudre
The Community
-
Association:false
-
Subdivision Name:Miller Sub
-
Spa:false
-
Senior Community:false
Parking
-
Parking Features:Garage Door Opener
-
Garage Spaces:20
-
Garage:true
-
Garage SqFt:5,973 Sqft
-
Garage Type:Attached
-
Attached Garage:true
-
Covered Spaces:20
Monthly cost estimate

Asking price
$2,750,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$14,725
|
Taxes | $1,692 |
Insurance | $756 |
Utilities | $286 See report |
Total | $17,459/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/23/25
Jun 23, 2025
|
Listed / Active | IRES | $2,750,000 |