$845,000
SOLD OCT 9, 2025
3 Beds
2.5 Baths
3,215 Sq Ft
11,326 Sq Ft Lot

Recently Sold

$263 Per Sq Ft

1% Below List Price

4 Days on Market

Highlights

  • On Golf Course
  • Home fronts a pond
  • Lake View
  • Black Rock Elementary School Rated A-
  • Located in a master-planned community
  • Open Floorplan

About This Home

As of October 2025

Discover the epitome of "Location, Location, Location" with this stunning home, perfectly situated in the neighborhood's prime spot! The main floor offers a versatile office, expansive living and family rooms, a formal dining area, and a gourmet kitchen that opens to a spacious deck—perfect for entertaining. Revel in breathtaking Rocky Mountain views, with snow-capped peaks in winter and vibrant sunsets every evening. Overlooking a lush golf course and adjacent to a serene greenbelt, this home is nestled in a peaceful cul-de-sac. Upstairs, a grand loft with gleaming hardwood floors, two bedrooms, a full bath, and a luxurious primary suite await. The primary suite features a double-sided fireplace, a cozy sitting room with hardwood floors, a walk-in closet, and a spa-like five-piece bath with an oversized soaking tub. The unfinished walk-out basement offers endless possibilities to customize to your taste. Complete with an oversized three-car garage with backyard access, this rare gem won’t last long. Schedule your showing today and seize this extraordinary opportunity!

Last Agent to Sell the Property

PJ Magin

Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Brighton Brokerage Email: pjmagin@comcast.net,303-921-7944 License #100028175 Listed on: 09/05/2025

Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Brighton

Last Buyer's Agent

Nicole Siklich

RE/MAX of Boulder, Inc License #100102554

RE/MAX of Boulder, Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,978

Year Built

  • Built in 2005

Lot Details

  • 11,412 Sq Ft Lot
  • Home fronts a pond
  • On Golf Course
  • Cul-De-Sac
  • East Facing Home
  • Partially Fenced Property
  • Landscaped
  • Front and Back Yard Sprinklers
  • Many Trees
  • Private Yard
  • Garden

HOA Fees

  • $90 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Exterior Access Door

Property Views

  • Lake
  • Golf Course
  • Mountain

Home Design

  • Contemporary Architecture
  • Fixer Upper
  • Slab Foundation
  • Composition Roof
  • Cement Siding

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wired For Data
  • High Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Window Treatments
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room
  • Dining Room
  • Home Office
  • Loft
  • Fire and Smoke Detector
  • Laundry in unit

Kitchen

  • Eat-In Kitchen
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Soaking Tub

Unfinished Basement

  • Walk-Out Basement
  • Partial Basement
  • Exterior Basement Entry
  • Natural lighting in basement

Eco-Friendly Details

  • Smoke Free Home

Outdoor Features

  • Balcony
  • Deck
  • Covered Patio or Porch

Schools

  • Black Rock Elementary School
  • Erie Middle School
  • Erie High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 220 Volts
  • 110 Volts
  • Natural Gas Connected
  • Gas Water Heater
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Community Details

  • Association fees include trash
  • Msi Association, Phone Number (303) 420-4433
  • Built by D.R. Horton, Inc
  • Vista Ridge Subdivision
  • Located in a master-planned community
  • Greenbelt

Listing and Financial Details

  • Property held in a trust
  • Assessor Parcel Number R2965204

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,978

Year Built

Built in 2005

Lot Details

0.26 Acres

HOA Fees

$90 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2005
  • Above Grade Finished Sq Ft: 3215
  • Below Grade Sq Ft: 1512
  • Exclusions: none
  • Living Area: 3215
  • Property Condition: Fixer
  • SubdivisionName: Vista Ridge
  • Ownership: Corporation/Trust
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 0
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.99412
  • Special Features: VirtualTour

Interior Features

  • Appliances: Dishwasher, Disposal, Gas Water Heater, Microwave, Range, Refrigerator
  • Fireplaces: 2
  • Interior Amenities: Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Smoke Free, Walk-In Closet(s), Wired for Data
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Family Room, Primary Bedroom
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Daylight, Exterior Entry, Partial, Unfinished, Walk-Out Access
  • Basement: Yes
  • Total Bedrooms: 3
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows, Window Coverings

Exterior Features

  • Direction Faces: East
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Cement Siding
  • View: Golf Course, Lake, Mountain(s)
  • Exterior Features: Balcony, Garden, Private Yard
  • Patio and Porch Features: Covered, Deck, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Waterfront Features: Pond

Garage/Parking

  • Parking Features: Concrete, Exterior Access Door, Oversized
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Electric: 110V, 220 Volts
  • Laundry Features: In Unit
  • Security: Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Trash
  • Association Name: MSI
  • Association Fee Frequency: Monthly
  • Association Fee: 90
  • Phone: 303-420-4433
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1080.00
  • REC_AssociationFeeTotalAnnual: 1080.00
  • REC_AssociationManagementType: Professionally Managed

Schools

  • Middle Or Junior School: Erie

Lot Info

  • Parcel Number: R2965204
  • Lot Size Acres: 0.26
  • Fencing: Partial
  • Building Area Total: 4727
  • Lot Features: Cul-De-Sac, Greenbelt, Landscaped, Many Trees, Master Planned, On Golf Course, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 11412

Building Info

  • Builder Name: D.R. Horton, Inc

Rental Info

  • Furnished: Unfurnished

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 7978

MLS Schools

  • Elementary School: Black Rock
  • High School: Erie

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 5, 2025
Closed on
Oct 6, 2025
Sold by
Dennis A Haubert Sr Revocable Trust
Bought by
Clarke Steven and Edwardson Aaluk
Seller's Agent
PJ Magin
Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Brighton
Buyer's Agent
Nicole Siklich
RE/MAX of Boulder, Inc
List Price
$850,000
Sold Price
$845,000
Premium/Discount to List
-$5,000
-0.59%
Views
14
Current Estimated Value
$844,318

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$682
Avg. Annual Appreciation
1.71%
Original Mortgage
$633,750
Outstanding Balance
$632,042
Interest Rate
6.56%
Mortgage Type
New Conventional
Estimated Equity
$219,709

Purchase Details

Closed on
Dec 4, 2020
Sold by
Hubert Dennis A
Bought by
The Dennis A Haubert Sr Revocable Trust

Purchase Details

Closed on
Sep 1, 2011
Sold by
Haubert Dennis A and Rusk Rhonda
Bought by
Haubert Dennis A

Purchase Details

Closed on
May 31, 2005
Sold by
D R Horton Inc
Bought by
Haubert Dennis A and Rusk Rhonda

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$105,446
Interest Rate
5.79%
Mortgage Type
Stand Alone Second
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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
Warranty Deed $845,000 Homestead Title
Bargain Sale Deed -- None Available
Interfamily Deed Transfer -- None Available
Special Warranty Deed $488,725 Land Title Guarantee Company
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $633,750 New Conventional
Previous Owner $105,446 Stand Alone Second
Previous Owner $359,650 Fannie Mae Freddie Mac
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/09/2025 10/09/25 Sold $845,000 -0.6% $263 / Sq Ft
09/05/2025 09/05/25 For Sale $850,000 -- $264 / Sq Ft
Source: REcolorado®

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 $7,978 $57,280 $11,330 $45,950
2024 $7,978 $57,280 $11,330 $45,950
2023 $7,779 $62,810 $12,260 $50,550
2022 $5,964 $45,490 $8,690 $36,800
2021 $6,139 $46,800 $8,940 $37,860
2020 $5,359 $41,930 $7,600 $34,330
2019 $5,393 $41,930 $7,600 $34,330
2018 $5,214 $40,820 $5,850 $34,970
2017 $5,117 $40,820 $5,850 $34,970
2016 $5,439 $41,710 $5,970 $35,740
2015 $6,673 $41,710 $5,970 $35,740
2014 $5,836 $36,320 $6,470 $29,850
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 2251506

REcolorado®

APN: R2965204

Your Personal Tour Guide

Ask me questions while you tour the home.