Unobstructed VIEWS of Devil's Thumb unfold from this immaculately maintained Shanahan Ridge/upper Table Mesa home. Tucked into a private lane, this low-maintenance property boasts unparalleled access to open space, trails and parks. Thoughtfully designed for modern living, an open floorplan seamlessly integrates the living room, dining area and kitchen for a harmonious flow. Vaulted ceilings draw the eyes upward as a vast wall of south-facing windows showcase breathtaking views. A fireplace grounds a large living room w/ a wet bar. Sliding glass doors in a dining area open to an expansive deck in a private backyard poised against a backdrop of mountain views. The kitchen is a chef's dream w/ light wood cabinetry and ample counter space. Retreat to a main-floor primary suite boasting a cozy fireplace, walk-in closet and direct access to the deck. The upper level includes an additional room that offers quiet space for a home office/den. Filled w/ natural light, a garden-level basement offers flexible living space w/ a secondary living area. A 2-car attached garage offers additional storage. Highly sought after South Boulder public schools. Open space trails, Viele Lake, Whole foods, Sobo Rec Center. RTD bus route all within walking distance.
Unobstructed VIEWS of Devil's Thumb unfold from this immaculately maintained Shanahan Ridge/upper Table Mesa home. Tucked into a private lane, this low-maintenance property boasts unparalleled access to open space, trails and parks. Thoughtfully designed for modern living, an open floorplan seamlessly integrates the living room, dining area and kitchen for a harmonious flow. Vaulted ceilings draw the eyes upward as a vast wall of south-facing windows showcase breathtaking views. A fireplace grounds a large living room w/ a wet bar. Sliding glass doors in a dining area open to an expansive deck in a private backyard poised against a backdrop of mountain views. The kitchen is a chef's dream w/ light wood cabinetry and ample counter space. Retreat to a main-floor primary suite boasting a cozy fireplace, walk-in closet and direct access to the deck. The upper level includes an additional room that offers quiet space for a home office/den. Filled w/ natural light, a garden-level basement offers flexible living space w/ a secondary living area. A 2-car attached garage offers additional storage. Highly sought after South Boulder public schools. Open space trails, Viele Lake, Whole foods, Sobo Rec Center. RTD bus route all within walking distance.
IRES as Distributed by MLS Grid #521539
Jun 17, 2007
Listing Removed
—
Feb 21, 2007
Listed
$950,000
$319/sq ft
IRES as Distributed by MLS Grid #519366
Feb 21, 2007
Listing Removed
—
Jan 30, 2007
Listed
$982,000
$330/sq ft
IRES as Distributed by MLS Grid #499622
Nov 7, 2006
Listing Removed
—
Jul 6, 2006
Listed
$1,049,900
$353/sq ft
IRES as Distributed by MLS Grid #246596
Feb 16, 2001
Sold
$799,000
$269/sq ft
Jan 10, 2001
Listed
$799,000
$269/sq ft
Public Records
Mar 22, 1989
Sold
$244,100
$82/sq ft
Public Records
Aug 26, 1988
Sold
$60,000
$20/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$10,769 (+2.7%)
$56,438 + $56,500
$112,938
2024
$10,485 (+1.8%)
$56,438 + $56,500
$112,938
2023
$10,303 (+18.4%)
$61,124 + $58,176
$119,300
2022
$8,703 (+4.9%)
$64,809 + $58,176
$122,985
2021
$8,299 (+18.3%)
$49,991 + $43,729
$93,720
2020
$7,015 (+1.6%)
$51,430 + $44,988
$96,418
2019
$6,908 (−2.1%)
$48,978 + $31,617
$80,595
2018
$7,058 (+3.2%)
$48,978 + $31,617
$80,595
2017
$6,837 (−2.3%)
$44,784 + $36,619
$81,403
2016
$6,998 (+5.6%)
$44,784 + $36,619
$81,403
2015
$6,626 (+14.1%)
$39,402 + $41,440
$80,842
2014
$5,809 (+2.2%)
$25,950 + $41,623
$67,573
2013
$5,682 (+5.4%)
$25,950 + $41,623
$67,573
2012
$5,388 (+0.9%)
$25,950 + $41,623
$67,573
2011
$5,341 (−1.3%)
$19,900 + $44,417
$64,317
2010
$5,411 (+7.1%)
$19,900 + $44,417
$64,317
2009
$5,053
$36,460 + $30,490
$66,950
Tax history for 3174 Redstone Rd
Year
Property tax
Land + Additions
Assessment*
2025
$10,769 (+2.7%)
$56,438 + $56,500
$112,938
2024
$10,485 (+1.8%)
$56,438 + $56,500
$112,938
2023
$10,303 (+18.4%)
$61,124 + $58,176
$119,300
2022
$8,703 (+4.9%)
$64,809 + $58,176
$122,985
2021
$8,299 (+18.3%)
$49,991 + $43,729
$93,720
2020
$7,015 (+1.6%)
$51,430 + $44,988
$96,418
2019
$6,908 (−2.1%)
$48,978 + $31,617
$80,595
2018
$7,058 (+3.2%)
$48,978 + $31,617
$80,595
2017
$6,837 (−2.3%)
$44,784 + $36,619
$81,403
2016
$6,998 (+5.6%)
$44,784 + $36,619
$81,403
2015
$6,626 (+14.1%)
$39,402 + $41,440
$80,842
2014
$5,809 (+2.2%)
$25,950 + $41,623
$67,573
2013
$5,682 (+5.4%)
$25,950 + $41,623
$67,573
2012
$5,388 (+0.9%)
$25,950 + $41,623
$67,573
2011
$5,341 (−1.3%)
$19,900 + $44,417
$64,317
2010
$5,411 (+7.1%)
$19,900 + $44,417
$64,317
2009
$5,053
$36,460 + $30,490
$66,950
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
3
Baths
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
7,239 Sq. Ft.
Year renovated
1999
Sq. Ft.
2,974
Year built
1988
Style
Single Family Residential
County
Boulder County
APN
R0105733
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
RL-2
Residential-Low 2 District
Medium density residential areas primarily used for small-lot residential development, including without limitation, duplexes, triplexes, or townhouses, where each unit generally has direct access at ground level.
Permitted uses
Include but are not limited to:
Religious facility
Housing-Single unit
Housing-Multiple units
Educational/school
Recreation
Agriculture-Cropland
Park & open space
May 27, 2028 • Active
Single family detached dwelling - remodel
Remodel
Aug 21, 2024 • Final
Roofing replacement
Roofing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.