NOT LISTED FOR SALE

Estimated Value: $1,987,000 - $2,476,000

4 Beds
3.5 Baths
4,072 Sq Ft
$556/Sq Ft Est. Value

Sale Details

Date Sold: December 10, 2024

Last sale price $2,300,000 $565 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $13,462 / mo

90 Days on Market

Highlights

  • Barn or Stable
  • City View
  • A-Frame Home
  • Spa
  • Open Floorplan
  • Fireplace in Primary Bedroom

About This Home

As of December 2024

Move-in ready mountain luxury awaits in this extensively updated custom 3BD/3.5BA featuring gorgeous interiors, generous storage and 3.26 wooded acres on Flagstaff Mountain, adjacent to Walker Ranch. Built in 2002 and renovated in 2023, this 4,072SF showplace delivers a contemporary take on rustic style with wood and stone throughout. Beamed ceilings soar up to 19 feet over refinished floors, new Berber carpeting, custom built-ins and walls of windows. The gracious foyer is flanked by a study and a formal living room. Ahead, the dramatic great room invites you to relax alongside a stacked stone gas fireplace and mountain vistas, or head out to the expansive patio and irrigated yard for seamless indoor-outdoor living. Step up to the formal dining area and enjoy an all-new gourmet kitchen filled with Shaker cabinetry, a pantry, a breakfast bar, and new Wolf and Sub-Zero appliances. A powder room and the first of three en suite bedrooms complete the level. Upstairs, discover the private owner's retreat, featuring a mezzanine loft area and a vaulted king-size bedroom with a large window and window seat flanked by treetop vistas. A two-sided fireplace is shared with the updated spa bathroom, where a freestanding tub, glass rain shower, water closet and double vanity are surrounded by new tile, cabinetry and radiant heat floors. The adjacent walk-in closet includes a washer-dryer. On the lower level, you'll find generous storage and an oversized bedroom suite with a second washer-dryer. Extensive upgrades include a newer roof, ultraviolet water purification filter system, new water heaters, completely updated bathrooms, and fresh paint inside and out. An attached three-car garage, detached workshop, barn and pasture provide plenty of space for vehicles, hobbies and animals in this move-in ready sanctuary surrounded by world-class trails, fishing streams and Walker Ranch open space. This fantastic Flagstaff haven is 15 minutes from Boulder and an hour from Denver and DIA

Last Agent to Sell the Property

Miles Kunkel

Compass - Boulder License #100004878 Listed on: 09/11/2024

Compass - Boulder

Last Buyer's Agent

Christy Hepp

eXp Realty, LLC

eXp Realty, LLC

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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $13,757

Year Built

  • Built in 2002

Lot Details

  • 3.26 Acre Lot
  • Open Space
  • Unincorporated Location
  • Southern Exposure
  • Wood Fence
  • Rock Outcropping
  • Lot Has A Rolling Slope
  • Sprinkler System
  • Wooded Lot

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • A-Frame Home
  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Wood Siding
  • Stone

Interior Spaces

  • 4,072 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Bar Fridge
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Multiple Fireplaces
  • Double Pane Windows
  • Window Treatments
  • Wood Frame Window
  • Family Room
  • Dining Room
  • Home Office
  • Recreation Room with Fireplace
  • Loft
  • City Views
  • Radon Detector

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Oven or Range
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Painted or Stained Flooring
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Partial Basement
  • Crawl Space

Outdoor Features

  • Spa
  • Balcony
  • Deck
  • Patio
  • Separate Outdoor Workshop
  • Outdoor Storage

Schools

  • Flatirons Elementary School
  • Manhattan Middle School
  • Boulder High School

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Tack Room
  • Barn or Stable
  • Riding Trail

Utilities

  • Humidity Control
  • Forced Air Heating and Cooling System
  • Propane
  • Water Purifier is Owned
  • Septic System
  • Satellite Dish
  • Cable TV Available

Additional Features

  • Energy-Efficient Thermostat
  • Pasture

Community Details

  • No Home Owners Association
  • Pine Needle Notch Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0026011

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,757

Year Built

Built in 2002

Lot Details

3.26 Acres

Parking

3

Listing Details

  • Year Built: 2002
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 3.26
  • Subdivision Name: Pine Needle Notch
  • Directions: West on Baseline Rd from Broadway up Flag Mtn ~ 9 miles to Pika Rd, first house on right. *Second driveway will take you to the stables/pastures with a turn around.
  • Architectural Style: A-Frame, Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: Southern Exposure, Thermostat
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 4072
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Water Purifier Owned, Disposal
  • Has Basement: Partial, Crawl Space, Walk-Out Access, Built-In Radon
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: 2+ Fireplaces, Family/Recreation Room Fireplace, Primary Bedroom
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Satellite Avail, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Loft, Kitchen Island, 9ft+ Ceilings, Beamed Ceilings
  • Window Features: Window Coverings, Wood Frames, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Hardwood
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Lower
  • Living Room Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Main
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Family Room Level: Main
  • Room Kitchen Features: Hardwood
  • Family Room Features: Hardwood
  • Living Room Features: Hardwood
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Wood
  • Lot Features: Lawn Sprinkler System, Wooded, Rolling Slope, Rock Outcropping, Abuts Public Open Space, Unincorporated
  • View: Foothills View, Plains View, City
  • Waterfront: No
  • Construction Type: Wood/Frame, Stone, Wood Siding, Painted/Stained
  • Exterior Features: Balcony, Hot Tub Included
  • Other Structures: Workshop, Storage
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, United Power
  • Heating: Forced Air, Humidity Control
  • Utilities: Electricity Available, Propane, Cable Available
  • Laundry Features: Washer/Dryer Hookups
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Septic
  • Water Source: Well

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Flatirons
  • HighSchool: Boulder
  • Junior High Dist: Boulder Valley Dist RE2
  • Middle Or Junior School: Manhattan

Lot Info

  • Zoning: RES
  • Current Use: Horses, Zoning Appropriate for 4+ Horses
  • Horse Amenities: Barn with 1-2 Stalls, Pasture, Tack Room, Riding Trail
  • Lot Size Sq Ft: 141954
  • Parcel #: R0026011
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 13757

Multi Family

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
Sep 11, 2024
Closed on
Dec 10, 2024
Sold by
Bought by
Seller's Agent
Miles Kunkel
Compass - Boulder
Buyer's Agent
Christy Hepp
eXp Realty, LLC
List Price
$2,600,000
Sold Price
$2,300,000
Premium/Discount to List
-$300,000
-11.54%
Views
55
Current Estimated Value
$2,265,107

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$34,893
Avg. Annual Appreciation
-0.91%

Purchase Details

Listed on
May 31, 2018
Closed on
Oct 29, 2018
Sold by
Bought by
Seller's Agent
Miles Kunkel
Compass - Boulder
Buyer's Agent
Miles Kunkel
Compass - Boulder
List Price
$1,599,900
Sold Price
$1,500,000
Premium/Discount to List
-$99,900
-6.24%

Home Financials for this Owner

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

Purchase Details

Listed on
May 31, 2018
Closed on
Oct 20, 2018
Sold by
Bought by
Seller's Agent
Miles Kunkel
Compass - Boulder
Buyer's Agent
Miles Kunkel
Compass - Boulder
List Price
$1,599,900
Sold Price
$1,500,000
Premium/Discount to List
-$99,900
-6.24%

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 26, 2013
Sold by
Bought by

Home Financials for this Owner

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

Purchase Details

Closed on
May 25, 2007
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,040,000
Interest Rate
6.12%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jun 29, 2001
Sold by
Bought by

Purchase Details

Closed on
Sep 16, 1997
Sold by
Bought by

Purchase Details

Closed on
Dec 15, 1992
Bought by

Purchase Details

Closed on
Aug 4, 1982
Bought by
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
$2,300,000 Land Title
$1,500,000 Land Title Guarntee Co
-- Land Title Guarntee Co
-- None Available
$1,415,000 Fahtco
-- None Available
$185,000 Land Title
$98,000 --
$42,500 --
$18,300 --
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
Previous Owner $1,200,000
Previous Owner $1,000,000
Previous Owner $1,040,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
12/10/2024 12/10/24 Sold $2,300,000 -11.5% $565 / Sq Ft
09/11/2024 09/11/24 For Sale $2,600,000 +73.3% $639 / Sq Ft
01/27/2020 01/27/20 Off Market $1,500,000 -- --
10/29/2018 10/29/18 Sold $1,500,000 -6.2% $368 / Sq Ft View Prior Sale
05/31/2018 05/31/18 For Sale $1,599,900 -- $393 / 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 $12,149 $139,433 $7,745 $131,688
2025 $12,149 $139,433 $7,745 $131,688
2024 $14,010 $150,057 $7,119 $142,938
2023 $13,757 $166,127 $9,682 $160,130
2022 $10,682 $119,597 $6,026 $113,571
2021 $10,113 $123,038 $6,199 $116,839
2020 $8,360 $100,529 $9,724 $90,805
2019 $8,226 $100,529 $9,724 $90,805
2018 $8,209 $98,907 $9,576 $89,331
2017 $7,963 $109,346 $10,587 $98,759
2016 $7,979 $96,102 $12,020 $84,082
2015 $7,538 $111,918 $51,740 $60,178
2014 $8,785 $111,918 $51,740 $60,178
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE1018371

IRES MLS

APN: 1579220-04-001

Your Personal Tour Guide

Ask me questions while you tour the home.