$1,931,899
SOLD JAN 16, 2026
6 Beds
8 Baths
8,172 Sq Ft
2.54 Acres

Recently Sold

$236 Per Sq Ft

20% Below List Price

3 Days on Market

Highlights

  • Water Views
  • Sauna
  • Open Floorplan
  • Private Pool
  • 2.54 Acre Lot
  • Deck

About This Home

As of January 2026

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 Agent to Sell the Property

Mirsad Telalbasic

Miro and Co Brokerage Phone: 7203270199 License #40016076 Listed on: 05/20/2025

Last Buyer's Agent

Robert Walkowicz

Group Harmony

Group Harmony

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $19,140

Year Built

  • Built in 2002

Lot Details

  • 2.54 Acre Lot
  • Cul-De-Sac
  • Vinyl Fence

HOA Fees

Parking

  • 7 Car Garage
  • Garage Door Opener

Property Views

  • Water
  • Panoramic
  • City
  • Mountain

Home Design

  • Stucco

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • Cathedral Ceiling
  • Gas Fireplace
  • Window Treatments
  • French Doors
  • Dining Room
  • Sauna
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • Soaking Tub

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Private Pool
  • Deck
  • Patio

Schools

  • Tozer Elementary School
  • Windsor Middle School
  • Windsor High School

Utilities

  • Forced Air Heating and Cooling System
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number R8094999

Community Details

Overview

  • Water Valley Master Associatio Association, Phone Number (303) 482-2213
  • Poudre Tech Metro District Association
  • Hilltop Estates Sub Subdivision

Recreation

  • Community Playground
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$19,140

Year Built

Built in 2002

Lot Details

0

HOA Fees

$50 per month

Parking

7

Listing Details

  • Year Built: 2002
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 2.54
  • Road Frontage Type: City Street
  • Road Surface Type: Asphalt
  • Subdivision Name: Hilltop Estates Sub
  • Architectural Style: Contemporary
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Windows
  • Property Attached Yn: No
  • Attribution Contact: 7203270199
  • Special Features: None

Interior Features

  • Possible Use: Single Family
  • Appliances: Electric Range, Gas Range, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal, Fire Alarm
  • Has Basement: Full, Partially Finished, Slab, Walk-Out Access
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 6
  • Door Features: French Doors
  • Fireplace Features: Gas
  • Interior Amenities: Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Workshop, Pantry, Wood Windows, Walk-In Closet(s), Sauna, Wet Bar, Washer/Dryer Hookup, Kitchen Island, Theatre Room, High Ceilings
  • Dining Room Type: Media Room
  • Window Features: Window Coverings

Exterior Features

  • Roof: Other
  • Fencing: Fenced, Vinyl
  • Lot Features: Cul-De-Sac, Paved
  • Pool Features: Private
  • View: Mountain(s), Hills, Plains View, City, Water, Panoramic
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Stucco
  • Exterior Features: Sprinkler System, Hot Tub, >8' Garage Door, Heated Garage, Oversized Garage
  • Patio And Porch Features: Patio, Deck

Garage/Parking

  • Garage Spaces: 7
  • Parking Features: Garage Door Opener, RV Access/Parking

Utilities

  • Cooling: Central Air
  • Electric: Xcel
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Security: Fire Alarm, Security System
  • Sewer: Septic Tank
  • Water Source: City

Condo/Co-op/Association

  • Community Features: Playground, Park, Trail(s)
  • Association #2 Fee: 450
  • Association #2 Fee Frequency: Annually
  • Association Fee: 140
  • Association Fee Frequency: Annually
  • Association: Poudre Tech Metro District
  • Association Name: Water Valley Master Associatio
  • Association Phone #2: 970-422-5080
  • Phone: 303-482-2213
  • Association: Yes

Schools

  • Elementary School: Tozer
  • HighSchool: Windsor
  • Junior High Dist: Weld RE-4
  • Middle Or Junior School: Windsor

Lot Info

  • Zoning: SFR
  • Horse Amenities: Horse(s) Allowed
  • Parcel #: R8094999
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 19140

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 20, 2025
Closed on
Jan 7, 2026
Sold by
Rudolph Staback and Grace Staback
Bought by
Noble Living Revocable Trust
Seller's Agent
Mirsad Telalbasic
Miro and Co
Buyer's Agent
Robert Walkowicz
Group Harmony
List Price
$2,400,000
Sold Price
$1,931,899
Premium/Discount to List
-$468,101
-19.5%
Views
171

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
472.35%
Original Mortgage
$1,181,898
Outstanding Balance
$1,181,898
Interest Rate
6.22%
Mortgage Type
New Conventional
Estimated Equity
$1,000,937

Purchase Details

Listed on
Mar 11, 2020
Closed on
Dec 16, 2020
Sold by
Staback Robert Eric and Staback Leanne E
Bought by
Staback Robert Eric and Rudolph Staback
Seller's Agent
Charlene Rosenblatt
Coldwell Banker Realty-Boulder
Buyer's Agent
Mary Rosinski
Keller Williams-Advantage Rlty
List Price
$2,300,000
Sold Price
$2,200,000
Premium/Discount to List
-$100,000
-4.35%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-2.47%
Original Mortgage
$1,450,000
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Mar 11, 2020
Closed on
Nov 6, 2020
Sold by
Sherif Ahmed M and Haderi Rabia A
Bought by
Staback Robert Eric and Staback Leanne E
Seller's Agent
Charlene Rosenblatt
Coldwell Banker Realty-Boulder
Buyer's Agent
Mary Rosinski
Keller Williams-Advantage Rlty
List Price
$2,300,000
Sold Price
$2,200,000
Premium/Discount to List
-$100,000
-4.35%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,450,000
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Mar 11, 2020
Closed on
Oct 9, 2020
Sold by
Demaske Jeff L and Demaske Jann M
Bought by
Sherif Ahmed H and Haderi Rabia A
Seller's Agent
Charlene Rosenblatt
Coldwell Banker Realty-Boulder
Buyer's Agent
Mary Rosinski
Keller Williams-Advantage Rlty
List Price
$2,300,000
Sold Price
$2,200,000
Premium/Discount to List
-$100,000
-4.35%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,450,000
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jun 1, 2016
Closed on
May 18, 2017
Sold by
Demaske Je Ff L and Demaske Jann M
Bought by
Sherif Ahmed M and Haderi Rabia A
Seller's Agent
Melissa Golba
Golba Group Real Estate LLC
Buyer's Agent
Annabelle Canzona
New Horizons & Associates
List Price
$2,195,000
Sold Price
$1,775,000
Premium/Discount to List
-$420,000
-19.13%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.38%

Purchase Details

Closed on
Feb 28, 2002
Sold by
Pavistma Inc
Bought by
Demaske Jeff L and Demaske Jann M
Source: Public Records
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed $1,931,898 First American Title
Interfamily Deed Transfer -- None Available
Warranty Deed $2,200,000 Guardian Title
Warranty Deed -- Guardian Title
Special Warranty Deed $1,700,000 Heritage Title Co
Warranty Deed $250,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,181,898 New Conventional
Previous Owner $1,450,000 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/16/2026 01/16/26 Sold $1,931,899 -7.7% $236 / Sq Ft
08/28/2025 08/28/25 Price Changed $2,092,500 -7.0% $256 / Sq Ft
07/18/2025 07/18/25 Price Changed $2,250,000 -6.3% $275 / Sq Ft
05/27/2025 05/27/25 For Sale $2,400,000 +9.1% $294 / Sq Ft
02/04/2022 02/04/22 Off Market $2,200,000 -- --
11/06/2020 11/06/20 Sold $2,200,000 0.0% $217 / Sq Ft View Prior Sale
07/25/2020 07/25/20 Price Changed $2,199,999 -4.3% $217 / Sq Ft
03/11/2020 03/11/20 For Sale $2,300,000 +29.6% $227 / Sq Ft
01/28/2019 01/28/19 Off Market $1,775,000 -- --
05/18/2017 05/18/17 Sold $1,775,000 -19.1% $175 / Sq Ft View Prior Sale
04/18/2017 04/18/17 Pending -- -- --
06/01/2016 06/01/16 For Sale $2,195,000 -- $216 / Sq Ft
Source: IRES MLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $19,140 $153,780 $24,060 $129,720
2024 $19,140 $153,780 $24,060 $129,720
2023 $17,644 $144,970 $21,990 $122,980
2022 $13,433 $95,780 $17,380 $78,400
2021 $12,836 $98,530 $17,880 $80,650
2020 $12,587 $97,890 $17,990 $79,900
2019 $12,512 $97,890 $17,990 $79,900
2018 $12,704 $96,340 $16,160 $80,180
2017 $13,008 $96,340 $16,160 $80,180
2016 $10,139 $75,620 $17,910 $57,710
2015 $9,638 $75,620 $17,910 $57,710
2014 $9,563 $71,730 $10,350 $61,380
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE1034547

IRES MLS

APN: R8094999