NOT LISTED FOR SALE

17 Queen St Aspen, CO 81611

Estimated Value: $7,537,000 - $22,218,918

7 Beds
8 Baths
7,674 Sq Ft
$1,939/Sq Ft Est. Value

Last Sold May 23, 2016

Last sale price $12,140,000 $1,582 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $65,259/month

84 Days on Market

Highlights

  • Spa
  • Green Building
  • Hydromassage or Jetted Bathtub
  • Aspen Middle School Rated A-
  • Maid or Guest Quarters
  • 1-minute walk to Rio Grande Trail

About This Home

As of May 2016

This is one of Aspen’s finest central core residences in a location that is enjoyed all year long. Located across the street from Herron park, one of Aspen’s most enjoyable summertime family river parks as well the beginning of the Rio Grande Trail which accesses the entire Roaring Fork Valley's 42 miles of bike trails and just 6 blocks from the Little Nell Hotel and the Aspen Mountain gondola. This 7 bedroom, 8 bath residence was built in 2006 and is 7,600+ square feet and there is also a separate, 1 bedroom guest house on the property for overflow guests or staff. Exceptional views of Aspen Mountain you can also hear the Roaring Fork river which sits just a few steps from the front door.The gourmet, oversized kitchen and kitchen den, living/great room, dining room as well the master bedroom reside on the upper level. you stroll this residence you appreciate the practical flow from private suites to the numerous gathering/entertaining spaces such as the media room and lower levels which have ample room for family and visiting guests. The gourmet, oversized kitchen and kitchen den, living/great room, dining room as well the master bedroom reside on the upper level. you stroll this residence you appreciate the practical flow from private suites to the numerous gathering/entertaining spaces such as the media room and lower levels which have ample room for family and visiting guests.

Last Agent to Sell the Property

Daniel Becker

Douglas Elliman Real Estate-Hyman Ave Brokerage Phone: (970) 925-8810 License #IA40016718 Listed on: 01/25/2016

Douglas Elliman Real Estate-Hyman Ave

Co-Listed By

Michael Latousek

Douglas Elliman Real Estate-Hyman Ave Brokerage Phone: (970) 925-8810 License #FA40018732

Last Buyer's Agent

Craig Morris

Aspen Snowmass Sotheby's International Realty - Hyman Mall License #EA40009691

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $18,480

Year Built

  • Built in 2007

Lot Details

  • 0.35 Acre Lot
  • Cul-De-Sac
  • Southwest Facing Home
  • Southern Exposure
  • Fenced
  • Corner Lot
  • Sprinkler System
  • Landscaped with Trees
  • Property is in excellent condition

Parking

  • 2 Car Garage

Home Design

  • Frame Construction
  • Wood Siding
  • Stone Siding

Interior Spaces

  • 3-Story Property
  • Elevator
  • Furnished
  • 4 Fireplaces
  • Gas Fireplace
  • Window Treatments
  • Property Views
  • Finished Basement

Kitchen

  • Range
  • Microwave
  • Freezer
  • Dishwasher

Bedrooms and Bathrooms

  • 7 Bedrooms
  • Maid or Guest Quarters
  • Hydromassage or Jetted Bathtub
  • Steam Shower

Laundry

  • Laundry Room
  • Dryer
  • Washer

Outdoor Features

  • Spa
  • Patio
  • Outbuilding

Utilities

  • Forced Air Heating and Cooling System
  • Radiant Heating System
  • Water Softener
  • Cable TV Available

Additional Features

  • Handicap Accessible
  • Green Building
  • Accessory Dwelling Unit (ADU)

Community Details

  • Property has a Home Owners Association
  • Association fees include sewer
  • Property is near a preserve or public land

Listing and Financial Details

  • Assessor Parcel Number 27370738002

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,480

Year Built

Built in 2007

Lot Details

0

Listing Details

  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.35
  • Co List Office Mls Id: DougEll-Hyman
  • Co List Office Phone: 970-925-8810
  • Inclusions: Dryer, Freezer, Refrigerator, Washer, Window Coverings, Water Softener, Range, Microwave, Dishwasher
  • Subdivision Name: None
  • Directions: Head east on Main St. turn left at Neale St. (No Problem Bridge). First house on the right on the corner of Neale and Queen after crossing the river.
  • Above Grade Finished Sq Ft: 5224.0
  • Architectural Style: Other
  • Garage Yn: Yes
  • Master Model: No
  • New Construction: No
  • Year Built: 2007
  • Tax Parcel Letter: R016675
  • Attribution Contact: (970) 925-8810
  • Location Info:Furnished: Yes
  • Keywords Info:Pre-Fabricated Home: No
  • General Info:Zoning2: Residential
  • Laundry Facility:Laundry Room: Yes
  • Listing Info:Short Sale: No
  • Listing Info:REO: No
  • Listing Info:Auction: No
  • Listing Info:Foreclosure: No
  • Gas:Natural Gas2: Yes
  • Listing Info:ADU: Yes
  • General Info:Levels: 3.0
  • General Info:Short Termable: Yes
  • Financing Info:Taxes2: 18480.4
  • Financing Info:Tax Year2: 2015
  • Extras:GuestCaretaker Qtrs: Yes
  • Extras:Hot TubSpa: Yes
  • Extras:PatioDeck: Yes
  • Sanitation:Sewer: Yes
  • Inclusions:Dishwasher: Yes
  • Inclusions:Microwave: Yes
  • Exterior:Stone Siding: Yes
  • Exterior:Wood Siding: Yes
  • Inclusions:Range: Yes
  • Condition:Excellent: Yes
  • Extras:Cable TV: Yes
  • Extras:Lawn Sprinklers: Yes
  • Extras:Fence: Yes
  • Inclusions:Dryer: Yes
  • Inclusions:Washer: Yes
  • Inclusions:Window Coverings: Yes
  • General Info:LvHtSqFt (Abv Grnd): 5224.0
  • Extras:Elevator: Yes
  • General Info:LvHtSqFt (Blw Grnd): 2450.0
  • Inclusions:Water Softener: Yes
  • Unit Faces:South: Yes
  • Unit Faces:West: Yes
  • Substructure:Finished Basement: Yes
  • Cooling:Central AC: Yes
  • Inclusions:Freezer: Yes
  • Extras:Outdoor Hot TubSpa: Yes
  • Extras:Steam Shower: Yes
  • Extras:Handicap Access: Yes
  • Extras:Outbuildings: Yes
  • Extras:Softener: Yes
  • Extras:Indoor Jetted Tub: Yes
  • Financing Info:HOA Dues YN: No
  • Special Features: None

Interior Features

  • Furnished: Furnished
  • Has Basement: Finished
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Total Bedrooms: 7
  • Below Grade Sq Ft: 2450.0
  • Fireplace Features: Gas
  • Fireplaces: 4
  • Fireplace: Yes
  • Interior Amenities: Elevator
  • Living Area: 7674.0
  • Fireplace:Gas: Yes
  • Style Other: Yes

Exterior Features

  • Fencing: Fenced
  • Lot Features: Cul-De-Sac, Corner Lot
  • Construction Type: Wood Siding, Stone Veneer, Frame
  • Other Structures: Outbuilding
  • Property Condition: Excellent
  • Construction:Frame: Yes

Garage/Parking

  • Keywords Info:Garage: 2 Car
  • General Info:Garage SqFt: 473.0

Utilities

  • Laundry Features: Inside
  • Building Features: Yes
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Radiant, Forced Air
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available
  • Water Source: Public
  • Heating:Radiant: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: Yes

Association/Amenities

  • Listing Info:Member Association: Aspen Association
  • Location Amenities:Views: Yes
  • Location Amenities:Corner Lot: Yes
  • Location Amenities:Exposure Southern: Yes
  • Location Amenities:Trees: Yes
  • Location Amenities:Cul-de-Sac: Yes
  • Location Amenities:Borders Public Land: Yes

Fee Information

  • Association Fee Includes: Sewer

Lot Info

  • Lot Size Sq Ft: 15160.0
  • Parcel #: 27370738002
  • Zoning: Residential
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 18480.4
  • Tax Year: 2015

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 25, 2016
Closed on
May 23, 2016
Sold by
Brien Alice
Bought by
17Queen Llc
Seller's Agent
Daniel Becker
Douglas Elliman Real Estate-Hyman Ave
Buyer's Agent
Craig Morris
Aspen Snowmass Sotheby's International Realty - Hyman Mall
List Price
$13,250,000
Sold Price
$12,140,000
Premium/Discount to List
-$1,110,000
-8.38%
Current Estimated Value
$11,629,678

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 3, 2007
Sold by
Brien Alice M
Bought by
Brien Alice

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 26, 2007
Sold by
Neale/Queen Llc
Bought by
Brien Alice M

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 28, 2005
Sold by
Brien Alice M
Bought by
Neale/Queen Llc

Purchase Details

Closed on
Apr 22, 2004
Sold by
Trettin Henry and Trettin Lana
Bought by
Brien Alice M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,800,000
Interest Rate
5.42%
Mortgage Type
Purchase Money Mortgage
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 Buyer Sale Price Title Company
17Queen Llc $12,140,000 Attorneys Title Agency Aspen
Brien Alice -- Pct
Brien Alice M -- None Available
Neale/Queen Llc -- None Available
Brien Alice M $2,400,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Brien Alice $4,500,000
Previous Owner Brien Alice M $1,800,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/23/2016 05/23/16 Sold $12,140,000 -8.4% $1,582 / Sq Ft
04/18/2016 04/18/16 Pending -- -- --
01/25/2016 01/25/16 For Sale $13,250,000 -- $1,727 / Sq Ft
Source: Aspen Glenwood MLS

Tax History Compared to Growth

Source: Public Records

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
2024 $58,422 $1,777,100 $501,460 $1,275,640
2023 $58,422 $1,797,050 $507,090 $1,289,960
2022 $41,171 $1,122,990 $437,850 $685,140
2021 $40,994 $1,155,310 $450,450 $704,860
2020 $35,271 $987,240 $407,550 $579,690
2019 $35,271 $987,240 $407,550 $579,690
2018 $29,674 $994,150 $410,400 $583,750
2017 $26,183 $823,200 $396,000 $427,200
2016 $18,722 $576,540 $278,600 $297,940
2015 $18,480 $576,540 $278,600 $297,940
2014 $16,247 $484,390 $302,480 $181,910
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Aspen Glenwood MLS

MLS Number: 142445

Aspen Glenwood MLS

APN: R016675