NOT LISTED FOR SALE

Estimated Value: $1,916,000 - $2,259,226

6 Beds
8 Baths
8,172 Sq Ft
$253/Sq Ft Est. Value

Sale Details

Date Sold: January 16, 2026

Last sale price $1,931,899 $236 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $13,050 / mo

3 Days on Market

Highlights

  • Water Views
  • Home Theater
  • Sauna
  • Horses Allowed On Property
  • Private Pool
  • RV Access or Parking

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 & 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
  • Paved or Partially Paved Lot
  • Sprinkler System

HOA Fees

Parking

  • 7 Car Detached Garage
  • Heated Garage
  • Garage Door Opener
  • RV Access or Parking

Property Views

  • Water
  • Panoramic
  • City
  • Mountain
  • Hills

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Stucco

Interior Spaces

  • 8,172 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • Cathedral Ceiling
  • Gas Fireplace
  • Window Treatments
  • French Doors
  • Dining Room
  • Home Theater
  • Media Room
  • Workshop
  • Sauna

Kitchen

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

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Soaking Tub

Laundry

  • Laundry Room
  • Washer and Dryer Hookup

Basement

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

Home Security

  • Home Security System
  • Fire and Smoke Detector

Pool

  • Private Pool
  • Spa

Outdoor Features

  • Deck
  • Patio

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Septic Tank

Additional Features

  • Energy-Efficient Windows
  • Horses Allowed On Property

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
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$19,140

Year Built

Built in 2002

Lot Details

2.54 Acres

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
  • RoomFeatures: Full Primary Bath, Luxury Features Primary Bath, 5 Piece Primary Bath
  • IRE_AssociationFeeYN: Yes
  • IRE_AssociationYN2: 1
  • IRE_HasWaterRights: No
  • IRE_TotalSqFt: 8172
  • IRE_NewConstructionStatus: Not New, Previously Owned
  • IRE_AssociationFee2YN: Yes
  • IRE_HasFamilyRoom: 0
  • 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
  • IRE_GarageType: Detached

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
May 20, 2025
Closed on
Jan 7, 2026
Sold by
Bought by
Seller's Agent
Mirsad Telalbasic
Miro & 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
174
Current Estimated Value
$2,071,075

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$139,176
Avg. Annual Appreciation
17.56%
Original Mortgage
$1,181,898
Outstanding Balance
$1,177,351
Interest Rate
6.22%
Mortgage Type
New Conventional
Estimated Equity
$893,724

Purchase Details

Listed on
Mar 11, 2020
Closed on
Dec 16, 2020
Sold by
Bought by
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
Bought by
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
Bought by
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
Bought by
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
Bought by
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$1,931,898 First American Title
-- None Available
$2,200,000 Guardian Title
-- Guardian Title
$1,700,000 Heritage Title Co
$250,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $21,758 $162,560 $25,440 $137,120
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

Your Personal Tour Guide

Ask me questions while you tour the home.