Please stand by!
USDAProperties.com is recovering from the party last night...

 

 

 

$6,200,000
Agent Details  share icon     map icon  QR
15490 Mountain View Cir
Broomfield, CO 80023
5 bed 8 bath 10,938 SqFt ($566/SqFt)
2.34 acre lot. Built 2017
Listed 2023-05-13, HOA $55, Taxes $31,054
Ⓧ USDA Ineligible
due to price & location

near Broomfield

Latest Value Estimates: $4,034,272 from Quantarium on 2024-04-24. $3,610,000 from Collateral Analytics on 2024-04-17. $6,493,100 from CoreLogic on 2024-04-01. Forecast Estimate Value:$4,199,287 in 2025-04-01 by Quantarium. $3,642,822 in 2025-02-01 by Collateral Analytics. $6,860,954 in 2025-04-01 by CoreLogic.

One of a kind contemporary custom home w/ stunning mountain views and sleek designer elements situated on 2.34 acres.

A slice of heaven with every amenity imaginable! This thoughtfully designed lifestyle compound is the ultimate of exclusivity and luxurious living. Bring your toys, cars and RV to a garage that fits 10 cars or pull in your 7 cars and RV w its own 50-amp breaker and RV dump. Step inside through the front door or elevator from your garage. This home stands out in quality construction w an unmatched outdoor space including a year-round salt watr pool, an outdoor kitchen w commercial oven and cooktop & ice maker, stone counters & heaters, retracting nano doors in the sun room that disappear into the walls and a cozy fireplace for year-round enjoyment. Walk the path to a private sitting area as you pass above bed gardens to plant vegetables in, head up to sit around your custom fire pit w spectacular views that have to be seen.

The incredible finished basement is equipped with a shooting range target system, concrete path to a ventilated steel bullet trap, a temperature-controlled wine room, golf simulator, vast custom bar w ice maker, fun entertainment area, a private gym, laundry room and a billiards room. A large patio presents itself as you walk through the stately front door leading into the exceptional room, w vaulted beamed ceilings, rock fireplace, tons of natural light leading into the gourmet kitchen. Your kitchen is equipped with side-by-side Sub-Zero refrigerator, 2 ovens, 2 dishwashers, ice maker, separate appliance closet, walk-in pantry, separate butler's pantry w additional fridge & built in coffee maker & main floor mudroom/laundry rm. The primary suite is located on the main floor w a huge walk-in closet, private laundry, oversized walk in steam shower & separate tub. 2 main fl E-suites w a formal dual office that has built-ins & a fireplace. Solar feature w 76 solar panels paid for. This house is truly a turn key home & no detail was spared!


Presented by Gwenivere Snyder at
LIV Sotheby's International Realty.
Listing Agent Photo

Property MLS #2782968 from REcolorado

Bar Fridge
Convection Oven
Dishwasher
Disposal
Double Oven
Dryer
Freezer
Microwave
Refrigerator
Self Cleaning Oven
Sump Pump
Warming Drawer
Washer
Water Purifier
Water Softener

Bedrooms: 5
Bedrooms On Basement Level: 2
Bedrooms On Main Level: 3
Primary Bedroom Dimensions: 17.0 x 19.0
Bedroom 1 Dimensions: 14.0 x 19.0
Bedroom 2 Dimensions: 14.0 x 17.0
Bedroom 3 Dimensions: 13.0 x 14.0
Bedroom 4 Dimensions: 13.0 x 18.0
Primary Bedroom Level: Main
Bedroom 1 Level: Main
Bedroom 2 Level: Main
Bedroom 3 Level: Basement
Bedroom 4 Level: Basement

Total Bathrooms: 8
Full Bathrooms: 4
1/2 Bathrooms: 2
3/4 Bathrooms: 2
Bathrooms On Main Level: 5
Bathrooms On Basement Level: 3

Audio/Video Controls
Breakfast Nook
Built-in Features
Ceiling Fan(s)
Central Vacuum
Eat-in Kitchen
Elevator
Five Piece Bath
High Ceilings
High Speed Internet
In-Law Floor Plan
Kitchen Island
Marble Counters
Open Floorplan
Pantry
Primary Suite
Quartz Counters
Smart Thermostat
Spa/Hot Tub
Stone Counters
Utility Sink
Walk-In Closet(s)
Wet Bar
Flooring: Carpet, Tile, Wood
Window Features: Window Coverings

Laundry Level: Main
Laundry Width: 11.00
Laundry Length: 14.00
Primary Bathroom (Full) Level: Main
Bathroom (Full) Level: Main
Bathroom (3/4) Level: Main
Bathroom (1/2) Level: Main
Bathroom (Full) 2 Level: Basement
Bathroom (3/4) 2 Level: Basement
Bathroom (1/2) 2 Level: Basement
Bathroom (Full) 3 Level: Main
Family Room Dimensions: 19.0 x 26.0
Game/Recreation Room Dimensions: 19.0 x 21.0
Great Room Dimensions: 17.0 x 25.0
Living Room Dimensions: 18.0 x 23.0
Office/Study Room Dimensions: 16.0 x 20.0
Family Room Level: Basement
Game/Recreation Room Level: Basement
Great Room Level: Basement
Living Room Level: Main
Office/Study Room Level: Main
Basement Description: Finished, Full, Sump Pump, Walk-Out Access

Cooling Features: Central Air
Fireplace Features: Gas, Living Room, Outside, Primary Bedroom
Heating Features: Forced Air, Radiant Floor
Number of Fireplaces: 4

Dining Room Dimensions: 13.0 x 19.0
Dining Room Level: Main
Kitchen Dimensions: 18.0 x 18.0
Kitchen Level: Main

Balcony
Barbecue
Fire Pit
Garden
Gas Grill
Lighting
Private Yard
Rain Gutters
Spa/Hot Tub
Water Feature
Fencing: Full
Patio And Porch Features: Deck, Patio
Road Frontage Type: Public Road
Road Surface Type: Paved

Pool Features: Outdoor Pool, Private
Pool Private: Yes

Attached Garage: Yes
Garage Spaces: 7
Parking Features: 220 Volts, Circular Driveway, Finished, Floor Coating, Heated Garage, Oversized, Oversized Door, RV Garage, Storage
Parking Total: 7

Lot Description: Irrigated, Landscaped, Master Planned, Sprinklers In Front, Sprinklers In Rear
Lot Size Acres: 2.34
Lot Size Square Feet: 101930

View: City, Mountain(s)
Security Features: Carbon Monoxide Detector(s), Security System, Smoke Detector(s)

Association: Yes
Association Fee: 660
Association Fee Frequency: Annually
Association Fee Includes: Maintenance Grounds
Calculated Total Monthly Association Fees: 55
Association Name: Spruce Meadows
Association Phone: 3034292611
Pets Allowed: Yes

Elementary School: Meridian
Elementary School District: Adams 12 5 Star Schl
High School: Legacy
High School District: Adams 12 5 Star Schl
Middle School: Rocky Top
Middle or Junior School District: Adams 12 5 Star Schl

Meridian Elementary School is a public elementary school located approximately 1.5 miles away.
directions icon Map directions

Legacy High School is a public high school located approximately 2.2 miles away.
directions icon Map directions

Rocky Top Middle School is a public middle school located approximately 3.9 miles away.
directions icon Map directions

Holy Family High School is a private high school located approximately 1.8 miles away.
directions icon Map directions

Annual Tax Amount: 31054.00
Source Listing Status: Active
County: Broomfield
Tax Year: 2022
Source Property Type: Residential
Exclusions: Seller's Personal Property, sauna, standing table in wine cellar, taxidermy animals
Source Neighborhood: Spruce Meadows
Parcel Number: R8862628
Subdivision: Spruce Meadows
Zoning: RE(A)
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$188,520 + $30,410
$218,930
$31,054
2021$193,950 + $31,280
$225,230
$31,983
2020$184,140 + $31,280
$215,420
$31,203
2019$185,430 + $31,500
$216,930
$31,218
2018$173,560 + $21,020
$194,580
$29,940
2017$131,620 + $21,020
$152,640
$22,980
2016$32,880 + $23,230
$56,110
$8,738
2015$unknown + $72,500
$72,500
$11,299
2014$unknown + $54,120
$54,120
$8,723
2013$unknown + $51,300
$51,300
$8,098
2011$unknown + $39,300
$39,300
$6,261
2010$unknown + $39,300
$39,300
$11
2009$unknown + $40
$40
$11
2008$unknown + $40
$40
$11
2007$unknown + $40
$40
$11

Price Changed 2024-04-25
$6,200,000
REcolorado
Listing removed 2024-03-15
$0
REcolorado
Listed 2024-03-07
$6,750,000
REcolorado
Price Changed 2024-03-07
$6,750,000
REcolorado
Listing removed 2024-01-09
$8,750,000
IRES
Price Changed 2024-01-06
$7,000,000
REcolorado
Listing removed 2023-08-25
$0
IRES
Price Changed 2023-08-25
$7,100,000
REcolorado
Listed 2023-05-15
$7,600,000
IRES
Listed 2023-05-13
$7,600,000
REcolorado
Listing removed 2022-11-29
$0
REcolorado
Listed 2022-05-06
$8,750,000
REcolorado
Sold 2015-03-03
$315,600
Public Record
Sold 2012-11-16
$232,000
Public Record
Sold 2008-04-10
$339,000
Public Record

Total Square Feet Living: 9481
Year Built: 2017
Above Grade Finished Area: 5320
BelowGradeFinishedArea: 4161
Below Grade Unfinished Area: 1457.00
Construction Materials: Frame, Stone, Stucco
Foundation Details: Structural
Levels: One
Property Age: 7
Roof: Cement Shake
Structure Type: House
Architectural Style: Contemporary

Electric: 220 Volts
Sewer: Septic Tank
Electricity Connected
Internet Access (Wired)
Natural Gas Connected
Water Source: Public
Click Thumbnail Images To View Full Size
unknownhouse_viewliving_roomdining_roomliving_room
porchunknownbedroombathroomlaundry_room
living_roomkitchendining_roomkitchenunknown
unknowndining_roombathroomporchkitchen
unknownunknownunknownunknownporch
porchunknownliving_roomkitchenunknown
house_viewbedroombedroombedroombathroom
bedroombathroombedroomhouse_viewunknown

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.