Listing provided courtesy of LIV Sotheby's International Realty - MLS# 2782968MLS Provider
Contact Information: G@GwenSnyderRealEstate.com,303-718-1085

15490 Mountain View CircleBroomfield, CO 80023

Single Family · 5 Beds · 4 Full Baths · 4 Partial Baths · 9,481 Sq. ft. | 2.34 Acres

$6,750,000 Active

Overview

Time on Site:
163 days
Visits:
125

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 & RV to a garage that fits 10 cars, or pull in your 7 cars & 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 water pool, an outdoor kitchen w commercial oven & 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, spacious 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 great 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 En-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!

View Map

Facts & Features

  • Type Single Family
  • Sq. ft. 9,481
  • Price/Sq.ft. $711
  • Lot 2.34 Acres

General

Association/HOA
  • Association Fee: 660
  • Association Fee Frequency: Annually
  • Association Fee Includes: Maintenance Grounds
  • Association Name: Spruce Meadows
  • Association: true
School Information
  • School District: Adams 12 5 Star Schl
  • Elementary School: Meridian
  • Middle Or Junior School: Rocky Top
  • High School: Legacy
Listing Information
  • Dual Variable Compensation: false
Building Information
  • Year Built: 2017
Location/Region
  • Country: US
  • County Or Parish: Broomfield
  • Subdivision Name: Spruce Meadows
Tax Information
  • Tax Annual Amount: 31054
  • Tax Year: 2022
General Information
  • Exclusions: Seller's Personal Property, sauna, standing table in wine cellar, taxidermy animals
  • Ownership: Individual
  • Parcel Number: R8862628
  • Pets Allowed: Yes
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Senior Community: false
  • Special Listing Conditions: None
  • Zoning: RE(A)

Interior

Parking Information
  • Garage Spaces: 7
Beds/Baths
  • Bathrooms Full: 4
  • Bathrooms Half: 2
  • Bathrooms One Quarter: 0
  • Bathrooms Three Quarter: 2
  • Bathrooms Total: 8
  • Bedrooms Total: 5
Building Interior
  • Above Grade Finished Area: 5320
  • Below Grade Finished Area: 4161
  • Building Area Source: Public Records
  • Building Area Total: 10938
General Information
  • Appliances: Bar Fridge,Convection Oven,Dishwasher,Disposal,Double Oven,Dryer,Freezer,Microwave,Refrigerator,Self Cleaning Oven,Sump Pump,Warming Drawer,Washer,Water Purifier,Water Softener
  • Cooling: Central Air
  • Electric: 220 Volts
  • Fireplace Features: Gas,Living Room,Other,Outside,Primary Bedroom
  • Fireplaces Total: 4
  • Flooring: Carpet,Tile,Wood
  • Foundation Details: Structural
  • Heating: Forced Air,Radiant Floor
  • Interior Features: 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,Hot Tub,Stone Counters,Utility Sink,Walk-In Closet(s),Wet Bar
  • Levels: One
  • Living Area: 9481
  • Main Level Bathrooms: 5
  • Main Level Bedrooms: 3
  • Security Features: Carbon Monoxide Detector(s),Security System,Smoke Detector(s)
  • Window Features: Window Coverings

Exterior

Parking Information
  • Parking Features: 220 Volts,Circular Driveway,Finished,Floor Coating,Heated Garage,Oversized,Oversized Door,RV Garage,Storage
  • Parking Total: 7
Lot Information
  • Lot Features: Irrigated,Landscaped,Master Planned,Sprinklers In Front,Sprinklers In Rear
  • Lot Size Acres: 2.34
  • Lot Size Area: 101930
  • Lot Size Square Feet: 101930
  • Lot Size Units: Square Feet
  • Road Surface Type: Paved
  • Water Source: Public
Waterfront/View
  • View: City,Mountain(s)
Building Exterior/Construction
  • Architectural Style: Contemporary
  • Attached Garage: true
  • Construction Materials: Frame,Stone,Stucco
  • Patio And Porch Features: Deck,Patio
  • Roof: Cement Shake
  • Structure Type: House
General Information
  • Carport Spaces: 0
  • Exterior Features: Balcony,Barbecue,Fire Pit,Garden,Gas Grill,Lighting,Private Yard,Rain Gutters,Spa/Hot Tub,Water Feature
  • Fencing: Full
  • Pool Features: Outdoor Pool,Private
  • Road Frontage Type: Public
  • Sewer: Septic Tank
  • Utilities: Electricity Connected,Internet Access (Wired),Natural Gas Connected

Room Information

Room: Bathroom (1/2)
  • Level: Basement
Room: Bathroom (3/4)
  • Level: Basement
Room: Bathroom (Full)
  • Level: Basement
Room: Bedroom
  • Level: Basement
  • Lengthe: 14
  • Width: 13
Room: Bedroom
  • Level: Basement
  • Lengthe: 18
  • Width: 13
Room: Family Room
  • Level: Basement
  • Lengthe: 26
  • Width: 19
Room: Game Room
  • Level: Basement
  • Lengthe: 21
  • Width: 19
Room: Great Room
  • Level: Basement
  • Lengthe: 25
  • Width: 17
Room: Bathroom (1/2)
  • Level: Main
Room: Bathroom (3/4)
  • Level: Main
Room: Bathroom (Full)
  • Level: Main
Room: Bathroom (Full)
  • Level: Main
  • Description: Bonus full bath next to sun room
Room: Bedroom
  • Level: Main
  • Lengthe: 19
  • Width: 14
Room: Bedroom
  • Level: Main
  • Lengthe: 17
  • Width: 14
Room: Dining Room
  • Level: Main
  • Lengthe: 19
  • Width: 13
Room: Kitchen
  • Level: Main
  • Lengthe: 18
  • Width: 18
Room: Laundry
  • Level: Main
  • Lengthe: 14
  • Width: 11
Room: Living Room
  • Level: Main
  • Lengthe: 23
  • Width: 18
Room: Office
  • Level: Main
  • Lengthe: 20
  • Width: 16
Room: Primary Bathroom (Full)
  • Level: Main
Room: Primary Bedroom
  • Level: Main
  • Lengthe: 19
  • Width: 17

Neighborhood

Community

80023 (Broomfield) Demographics
42
Median Age
1,251
Population Density (per sq. mile)
72%
College Educated
$127,234
Estimated Median Income
6,825
Estimated Total Home Owners
1,444
Estimated Total Renters
83% / 17%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

Elementary Schools
4
Public
Prospect Ridge Academy
  • Grades: KG - 12
  • Enrollment: 1,392
5
Public
Stargate Charter School
  • Grades: KG - 12
  • Enrollment: 1,421
5
Public
Thunder Vista P-8
  • Grades: PK - 8
  • Enrollment: 747
Middle Schools
4
Public
Prospect Ridge Academy
  • Grades: KG - 12 /
  • Enrollment: 1,392
5
Public
Stargate Charter School
  • Grades: KG - 12 /
  • Enrollment: 1,421
5
Public
Thunder Vista P-8
  • Grades: PK - 8 /
  • Enrollment: 747
High Schools
4
Public
Prospect Ridge Academy
  • Grades: KG - 12 /
  • Enrollment: 1,392
5
Public
Stargate Charter School
  • Grades: KG - 12 /
  • Enrollment: 1,421
School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

Monthly Cost

$
$ %
%
$
$
* Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.

Market Data

Based on the last 30 days in this zip code

$1,049,119
Median Sales Price
$358
Median Price per Square Foot
0
Properties Sold
151
New on Market
54
Average Days on Market
331
Properties for Sale
Calculations provided by Reliance Network

History

Date Event Value Agent
3/7/2024Source: Information Real Estate Services Price Reduction
$6,750,000 -3.6%
3/7/2024Source: Information Real Estate Services Price Reduction
$6,750,000 -3.6%
3/7/2024Source: REColorado MLS Price Reduction
$6,750,000 -3.6%
1/6/2024Source: Information Real Estate Services Price Reduction
$7,000,000 -1.4%
1/6/2024Source: Information Real Estate Services Price Reduction
$7,000,000 -1.4%
1/6/2024Source: REColorado MLS Price Reduction
$7,000,000 -1.4%