- 6 beds
- 8 baths
- 8,172 sqft
- ~3 acre lot
- $293 per sqft
- 2002 build
- – on site
Custom Home on 2.54-acre lot with the full Mountain Ranges & Tri-Cities views! Over 8,100 sf, 6 bedrooms, 8 baths, 6 car attached garage & heated large, detached RV Garage & workshop * MAIN FLOOR: Large private deck, Living room with Marble floors & cathedral ceilings, with wall of windows to enjoy the views & modern fireplace, next to gourmet Kitchen & formal dining room. Primary room with 2 separate walk-in dressing room closets, spa like bathroom, and hot tub on the deck. Sprawling living space with another fireplace, 2 bedrooms & laundry room. Take the stairs or elevator to the lower level, walk-out basement * LOWER LEVEL: family room next to the second spacious kitchen with beer-kegerator, set up for entertainment to accommodate a large party for grilling in a resort style, and walk out to the swimming pool with the outside shower and integrated soaking tub, surrounded by the professionally landscaped yard with mature trees, or step into fully equipped Theater room. 2 additional bedrooms, fitness room & climate-controlled wine cellar. Take your health to the next level with the included Dry–Sauna or connect with your family and friends around the 2 fire pits * Above the 6-car garage is the separate 2000 sf private guest apartment suite with complete kitchen and 360-degree views * 2 nearby golf courses accessible by the included with the sale brand new Golf Cart: Pelican Golf & Resort, andRaindance National Golf * Property also offers allowed access to the RainDance River Resort pool and amenities. Explore activities on the Poudre River Trails for hiking and biking *
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 May 27, 2025
•
MLS# 1941616 —
This home is listed in more than one place. See it here, and here, and here.
The Building
-
Year Built:2002
-
Construction Materials:Stucco
-
Building Area Total:8172
-
Building Area Source:Public Records
-
Structure Type:House
-
Roof:Unknown
-
Foundation Details:Slab
-
Levels:One
-
Basement:true
-
Architectural Style:Contemporary
-
Exterior Features:Fire Pit, Gas Grill, Private Yard, Spa/Hot Tub, Water Feature
-
Patio And Porch Features:Deck, Patio
-
Window Features:Bay Window(s), Double Pane Windows, Egress Windows, Window Coverings
-
Green Energy Efficient:Windows
-
Above Grade Finished Area:4086
-
Below Grade Finished Area:4086
-
Property Attached:false
Interior
-
Interior Features:Breakfast Bar, Built-in Features, Elevator, Five Piece Bath, Granite Counters, High Ceilings, In-Law Floorplan, Kitchen Island, Open Floorplan, Sauna, Smart Thermostat, Walk-In Closet(s)
-
Flooring:Carpet, Tile, Wood
-
Fireplaces Total:2
-
Fireplace Features:Gas, Living Room
Room Dimensions
-
Living Area:8172
Financial & Terms
-
Ownership:Individual
-
Possession:Closing/DOD
Location
-
Latitude:40.44992712
-
Longitude:-104.9254643
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Parcel Number:R8094999
-
Property Condition:Model
-
Lot Features:Cul-De-Sac
-
Lot Size Area:2.54
-
Lot Size Acres:2.54
-
Lot Size SqFt:110,642 Sqft
-
Lot Size Units:Acres
-
Exclusions:None;
-
View:City, Mountain(s), Plains
-
Fencing:Full
-
Road Responsibility:Public Maintained Road
-
Road Frontage Type:Public
-
Road Surface Type:Paved
Listing Agent
- Contact info:
- Agent phone:
- (720) 327-0199
- Office phone:
- (720) 327-0199
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$19,140
Beds
-
Bedrooms Total:6
-
Main Level Bedrooms:3
-
Basement Level Bedrooms:3
Baths
-
Total Baths:8
-
Full Baths:4
-
Three Quarter Baths:2
-
Half Baths:2
-
Main Level Baths:5
-
Basement Level Baths:3
Heating & Cooling
-
Heating:Forced Air
-
Cooling:Central Air
Utilities
-
Utilities:Electricity Connected, Natural Gas Connected, Phone Available
-
Electric:110V, 220 Volts
-
Sewer:Septic Tank
-
Water Included:Yes
-
Water Source:Public
Appliances
-
Appliances:Bar Fridge, Dishwasher, Disposal, Microwave, Oven, Range, Range Hood, Refrigerator
Schools
-
Elementary School:Tozer
-
Elementary School District:Weld RE-4
-
Middle Or Junior School:Windsor
-
Middle Or Junior School District:Weld RE-4
-
High School:Windsor
-
High School District:Weld RE-4
The Community
-
Subdivision Name:Hilltop Estates
-
Association:true
-
Association Name:Advance Hoa Mngmt
-
Association Fee:$140
-
Association Fee Frequency:Annually
-
Association Fee Annual:$140
-
Association Fee Total Annual:$590
-
Association Fee 2:$450
-
Association Fee 2 Frequency:Annually
-
Association Fee 2 Annual:$450
-
Senior Community:false
-
Pool Features:Outdoor Pool
Parking
-
Parking Total:7
-
Attached Garage:true
-
Garage Spaces:7
Monthly cost estimate

Asking price
$2,400,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. |
$12,851
|
Taxes | $1,595 |
Insurance | $660 |
HOA fees | $12 |
Utilities | $233 See report |
Total | $15,351/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.