14041 Aspen Street

Broomfield, CO 80020

Residential  $1,250,000  Expired

09-29-2017 02:13pm

Serene country living with city conveniences (city water and sewer). Located between Boulder and Denver in the premier subdivision of Whistlepig. Live in existing home and pamper yourself and your horses with a 12000 sf indoor riding arena, a heated ten horse stall professional barn with bathing stall, tack room, and bathroom room w/ washer and dryer, and several turnout areas, including 1200 feet of riding in the back turn out towards majestic mountain views~ Or build a brand new house and run a horse business with the existing structures. Formerly known as Whistlepig Equestrian Center, this facility is located among higher end homes ranging up to 3 million, with proximity to walking trails, Boulder Valley Schools, Peak To Peak School (US News Voted #1 school in Colorado), Broomfield Commons, and Holy Family High School.

MLS#
3098096
MLS Originator
REcolorado (Denver)
Off Market Date
09-29-2017 12:00am
Original Price
$1,250,000
Live stock
Yes
Nearby Attraction
Adjacent to Open Space, Gated Community, Suitable for Grazing

Property
Residential
Property Subtype
Detached Single Family
Status
Expired
Last Update
09-29-2017 02:13pm
Bedrooms
2
Bathrooms
2
SqFt
1348
Year Built
2004
Der PSF Total
927.30

SqFt Lot
3774.4
SqFt Finished
1348
SqFt Main
1348
SqFt Above
1348

Previous Year Tax
$3,750
HOA Name
Whistlepig
HOA Total Fee
$48
HOA Fee Frequency
Monthly
HOA Management
Self Managed
HOA Phone
716-819-5644
HOA Total Fee
$0
HOA Total Fee
$0
Terms and Conditions
Cash, Conventional, Jumbo
Transaction Type
For Sale

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 Floors
Cooling
Air Conditioning-Central
Heating
Forced Air
Heating Fuel
Gas
Fireplaces
Living Room
Fire Number
1
Fireplaces Features
Gas/Gas Logs

Baths Full
2

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

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

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

PPA
235849.06
Well Type
Not Operational

  Watch Virtual Tour

executed in 0.472 sec.