NOT LISTED FOR SALE

3172 Redstone Rd Boulder, CO 80305

Table Mesa Neighborhood

Estimated Value: $1,948,468 - $2,332,000

4 Beds
4 Baths
3,740 Sq Ft
$551/Sq Ft Est. Value

Sale Details

Date Sold: October 31, 2012

Last sale price $758,900 $203 Per Sq Ft

Est. 172% increase in value since last sale

Current estimated payment $12,134 / mo

4 Days on Market

Highlights

  • Spa
  • Open Floorplan
  • Multiple Fireplaces
  • Mesa Elementary School Rated A
  • Deck
  • Cathedral Ceiling

About This Home

As of October 2012

VIEWS ARE BREATHTAKING! DEVIL'S THUMB UP CLOSE! Modern, bright, open, custom hm w/architectural pizzaz! Coveted S/W Boulder where trails abound! Great schools are very close. Lush mature landscaping/colorful gardens surround decks, patio & walkways making this home feel private. Study/5th BR has views, closet, 3/4 bath nearby. Luxury Mstr w/fireplace, sitting area, & balcony. Jack&Jill bath for 2ndry BR'S. Professionally finished bsmt. New roof & furnace 2010. Priced well, there's no comparison!

Last Agent to Sell the Property

Linda Whittle

RE/MAX Alliance-Boulder Listed on: 09/27/2012

Last Buyer's Agent

Christine Myers

First Summit Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,404

Year Built

  • Built in 1993

Lot Details

  • 7,789 Sq Ft Lot
  • Wood Fence
  • Level Lot
  • Sprinkler System

HOA Fees

  • $29 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Wood Siding
  • Stucco

Interior Spaces

  • 3,740 Sq Ft Home
  • 3-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Multiple Fireplaces
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Wood Frame Window
  • Family Room
  • Dining Room
  • Home Office
  • Finished Basement
  • Sump Pump

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Jack-and-Jill Bathroom
  • Bidet
  • Bathtub and Shower Combination in Primary Bathroom
  • Spa Bath

Laundry

  • Laundry on upper level
  • Washer and Dryer Hookup

Eco-Friendly Details

  • Energy-Efficient HVAC

Outdoor Features

  • Spa
  • Balcony
  • Deck
  • Patio

Schools

  • Mesa Elementary School
  • Southern Hills Middle School
  • Fairview High School

Utilities

  • Evaporated cooling system
  • Forced Air Heating System
  • High Speed Internet

Community Details

  • Association fees include snow removal, utilities
  • Built by Scott Dale
  • Devil's Thumb Shanahan Ridge Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0092043

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,404

Year Built

Built in 1993

Lot Details

7,789 Sq Ft Lot

HOA Fees

$29 per month

Parking

3

Listing Details

  • Year Built: 1993
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.18
  • Road Surface Type: Paved
  • Subdivision Name: Devil's Thumb-Shanahan Ridge
  • Directions: From Broadway go west on Table Mesa, left on Lehigh, left on Cripple Creek Trl, immediately turn left into private driveway-Redstone. You may wish to park on Cripple Creek Trail at the corner before turning left into Redstone.
  • Garage Yn: Yes
  • Unit Levels: Three Or More
  • New Construction: No
  • Efficiency: HVAC
  • Building Stories: 3
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3740
  • Special Features: None
  • Stories: 3

Interior Features

  • Possible Use: Single Family
  • Spa Features: Bath
  • Private Spa: Yes
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Microwave, Disposal
  • Has Basement: 90%+ Finished Basement, Sump Pump
  • Full Bathrooms: 3
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: 2+ Fireplaces, Gas
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Jack & Jill Bathroom
  • Window Features: Window Coverings, Wood Frames, Skylight(s), Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Basement
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Family Room Level: Lower
  • Room Kitchen Features: Wood Floor
  • Family Room Features: Carpet
  • Living Room Features: Carpet
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath, Tub+Shower Primary, Luxury Features Primary Bath, 5 Piece Primary Bath, Bidet
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Builder Name: Scott Dale
  • Fencing: Fenced, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Level, Within City Limits
  • View: Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame, Stucco, Wood Siding
  • Exterior Features: Balcony
  • 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
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Evaporative Cooling, Ceiling Fan(s)
  • Electric: Electric, Xcel
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Boudler
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • HOA Fee Includes: Snow Removal, Utilities
  • Senior Community: No
  • Association Fee: 350
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Mesa
  • HighSchool: Fairview
  • Junior High Dist: Boulder Valley Dist RE2
  • Middle Or Junior School: Southern Hills

Lot Info

  • Zoning: Res
  • Lot Size Sq Ft: 7789
  • Parcel #: R0092043
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2011
  • Tax Annual Amount: 5404

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 27, 2012
Closed on
Oct 31, 2012
Sold by
Bought by
Seller's Agent
Linda Whittle
RE/MAX Alliance-Boulder
Buyer's Agent
Christine Myers
First Summit Realty
List Price
$759,900
Sold Price
$758,900
Premium/Discount to List
-$1,000
-0.13%
Current Estimated Value
$2,060,617

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,301,717
Avg. Annual Appreciation
7.59%
Original Mortgage
$444,900
Outstanding Balance
$52,740
Interest Rate
3.52%
Mortgage Type
New Conventional
Estimated Equity
$2,007,877

Purchase Details

Closed on
May 31, 1995
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
$200,000
Interest Rate
8.18%

Purchase Details

Closed on
May 4, 1993
Bought by

Purchase Details

Closed on
Nov 24, 1989
Bought by

Purchase Details

Closed on
Dec 19, 1988
Bought by
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

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
$758,900 First Colorado Title
$434,000 --
$379,000 --
$61,000 --
$60,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 $444,900
Previous Owner $200,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
01/28/2019 01/28/19 Off Market $758,900 -- --
10/31/2012 10/31/12 Sold $758,900 -0.1% $203 / Sq Ft
10/01/2012 10/01/12 Pending -- -- --
09/27/2012 09/27/12 For Sale $759,900 -- $203 / 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 $11,968 $136,558 $63,682 $72,876
2025 $11,968 $136,558 $63,682 $72,876
2024 $11,632 $125,512 $58,531 $66,981
2023 $11,430 $132,352 $67,214 $68,822
2022 $9,536 $102,686 $51,854 $50,832
2021 $9,093 $105,641 $53,346 $52,295
2020 $7,711 $88,589 $50,765 $37,824
2019 $7,593 $88,589 $50,765 $37,824
2018 $7,681 $88,596 $46,440 $42,156
2017 $7,441 $97,948 $51,342 $46,606
2016 $7,226 $83,469 $40,835 $42,634
2015 $6,842 $60,098 $23,880 $36,218
2014 $5,053 $60,098 $23,880 $36,218
Source: Public Records

Agents Affiliated with this Home

  • L

    Seller's Agent in 2012

    Linda Whittle

    RE/MAX

  • C

    Buyer's Agent in 2012

    Christine Myers

    First Summit Realty

    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE692055

IRES MLS

APN: 1577172-30-001

Colorado Boulder County Boulder 80305 Table Mesa

3172 Redstone Rd, Boulder, CO

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information deemed reliable but not guaranteed by the MLS.
Based on information submitted to the MLS GRID
Listings courtesy of IRES MLS as distributed by MLS GRID

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.