14041 Aspen Street

Broomfield, CO 80020

Residential  $975,000  Active

02-21-2019 11:28am

Property Description

Instant equity, profitable business, or tranquil and luxurious living: 12000 sf indoor arena~10 stall professional horse barn with watering boxes, tack room, bathroom, utility room, washer/dryer for blankets, and bathing stall~charming home w/ wood beams in ceiling, gas fireplace, granite counter tops, jetted tub, sliding barn door~2 car detached garage~2 additional buildings equipped with electricity and lighting~three turnout areas~all on 5.3 acres in Broomfield's premier Whistlepig subdivision b/t Boulder and Denver~city water and city sewer~property abuts county open space w/ mountain views~Surrounding homes range from $700K to $6million. Incredible value! (from ILC or aerial view, LOT 14 is lot being sold. Lot 13 with big stoned house belongs to neighbors). THE BUILDING OF ANOTHER SINGLE FAMILY HOME and THE OPERATION OF A HORSE BUSINESS IS PERMITTED BY CITY/COUNTY OF BROOMFIELD and WHISTLEPIG HOA!!!

Listing Details

MLS#
9169377
MLS Originator
REcolorado (Denver)
Original Price
$975,000
Live stock
Yes
Nearby Attraction
Adjacent to Open Space, Gated Community, Suitable for Grazing

Property Details

Property
Residential
Property Subtype
Detached Single Family
Status
Active
Last Update
02-21-2019 11:28am
Bedrooms
2
Bathrooms
2
SqFt
1348
Year Built
2004
Der PSF Total
723.29

Map

Property Level and Sizes

SqFt Lot
230868.00
SqFt Finished
1348
SqFt Above
1348

Financial Details

Previous Year Tax
$3,754
HOA Name
Whistlepig Home Owners Association
HOA Total Fee
$48
HOA Fee Frequency
Monthly
HOA Management
Self Managed
HOA Phone
7168195644
HOA Total Fee
$0
HOA Total Fee
$0
Terms and Conditions
Cash, Conventional, Jumbo
Transaction Type
For Sale

Interior Details

Interior Features
Breakfast Nook, Double Pane Windows, Jack & Jill Bath, Jet Action Tub, Master Bath, Master Suite
Appliances
Dishwasher, Disposal, Microwave Oven, Refrigerator (Kitchen), Stove/Range/Oven
Flooring
Carpet, Tile Floor, Wood
Cooling
Air Conditioning-Central
Heating
Forced Air
Heating Fuel
Gas
Fireplaces
Living Room
Fire Number
1
Fireplaces Features
Gas/Gas Logs

Room Details

Baths Full
2
Laundry Availability
Closet

Exterior Details

General
Adjacent to Open Space, Gated Community, Suitable for Grazing
Features
Balcony, Fenced Pasture
Base Floor Plan
Structural
Base Size
None
Parking Spaces
1
Parking Features
Driveway-Gravel
Vehicle Spaces
2
Type
# of Space
L x W
Description
Garage (Detached)
2
-
Lot View
Mountain View
Horse
Yes
Horse Count
4
Horse Features
Fenced, Outdoor Arena, Pasture, Tack Room
Type SqFt Floor
# Stalls
Stall Flooring
Features Description
240
0
storage
480
0
storage
Indoor Arena 12075
0
Electrical
Stable 3192 Concrete
10
Matting Electrical, Heated, Heated Water
Water
Public
Sewer
Public

Exterior Construction

Structure
Ranch/1 Story
Roof
Composition Shingles
Construction
Wood Siding
Exterior Features
Balcony, Fenced Pasture
Construction Method
Frame
Builder Source
County Records

Schools

School District
Boulder Valley RE 2
Elementary School
Aspen Creek K-8
Middle School
Aspen Creek K-8
High School
Broomfield

Land Details

Access
Public Road
PPA
183962.26
Maintain By
City
Well Type
Not Operational
Road Surface
Paved Road
Land Topography
Flat

Listing Media

  Watch Virtual Tour

Average Values based on MLS data (realtime)

The following Average Values are calculated based on the following property information
- Property Address: 14041 Aspen Street, Broomfield, CO 80020
- Property Type: Residential, 2 beds, 2 baths, 1348 SqFT
- Selling Price: $975,000
 
Average Price (Cumulative Number of Properties)
 
Last 3 months
Last 6 months
Last 9 months
Last 12 months
Area 1 (< 1 mile)
$975,000 (1)
$975,000 (1)
$975,000 (1)
$975,000 (1)
Area 2 (1-2 miles)
$433,878 (9)
$396,225 (12)
$381,300 (19)
$373,608 (24)
Area 3 (2-3 miles)
$455,436 (11)
$418,543 (14)
$397,600 (21)
$387,365 (26)
Area 4 (3-5 miles)
$458,330 (27)
$437,147 (45)
$412,101 (67)
$410,032 (79)

Similar Properties

Contact Agent

executed in 15.738 sec.