Please stand by!
USDAProperties.com is playing suspenseful music......

 

 

 

$7,298,000
Agent Details  share icon     map icon  QR
1880 Mallard Dr
Broomfield, CO 80020
5 bed 7 bath 11,778 SqFt ($619/SqFt)
1.01 acre lot. Built 2010
Listed 2024-01-05, HOA $500, Taxes $18,770
Ⓧ USDA Ineligible
due to price & location

near Broomfield

Latest Value Estimates: $7,225,000 from Collateral Analytics on 2024-04-17. $6,633,288 from Quantarium on 2024-05-01. $7,029,300 from CoreLogic on 2024-04-01. Forecast Estimate Value:$7,313,724 in 2025-02-01 by Collateral Analytics. $6,744,897 in 2025-05-01 by Quantarium. $7,395,527 in 2025-04-01 by CoreLogic.

One of the most incredible properties to ever come on the market in Colorado.

This sprawling 11, 393 square foot home was custom built with every attention to detail imaginable. Every facet and building material of this home are absolutely top-of-the-line luxurious. No expense was spared on the construction for this spectacular location. With unobstructed priceless views of the entire Front Range and Flatirons to the West and a private lake with massive trees to the East, the lot borders the private lake, an old growth forest and a conservation easement located at the end of a private street in one of the most exclusive gated communities around. There are 6 total bedrooms all with their own en-suite full bathroom, 3 additional 1/2 bath powder rooms, 2 levels accessed with a hydraulic driv elevator, a 12 person movie theater, climate controlled wine cellar, full bar with billiard, shuffleboard and poker tables, a gym, 4 laundry centers, indoor-outdoor atrium with a full wall of sliding pocketed doors hermetically sealed from the rest of the home, all surrounded by multiple decks and patios constructed of natural Colorado Buff Sandstone to enjoy the striking views.

The home includes a lock-off cottage with 2 bedrooms and 2 baths, living room, gourmet kitchen and laundry perfect for long term guests or family. The winding circle brick paver driveway includes snow sensors and the drive and decks are all entirely heated with a glycol circulation snow melt system. The stunning stucco and stone exterior features dramatic roof lines with a concrete tile roof and custom copper cutters and caps. There is a 1758 square foot heated 4-car garage, plus an additional 1 car garage for the cottage. Immediately upon entering it is obvious this is not the typical type of property with all solid core 8+ doors, radiant floor heating, gleaming hand-scraped Palo Duro Walnut hard wood floors, 6 Limestone fireplaces and columns, Artisan plaster walls and German style wood windows.


Presented by Dylan Lario at
Coldwell Banker Realty.
Listing Agent Photo

Property MLS #4067223 from REcolorado

Bar Fridge
Dishwasher
Disposal
Double Oven
Dryer
Microwave
Oven
Range
Range Hood
Refrigerator
Tankless Water Heater
Trash Compactor
Warming Drawer
Washer
Wine Cooler
Laundry Features: In Unit

Bedrooms: 5
Bedrooms On Basement Level: 2
Bedrooms On Main Level: 3
Primary Bedroom Dimensions: 18.0 x 24.0
Bedroom 1 Dimensions: 18.0 x 18.0
Bedroom 2 Dimensions: 12.0 x 12.0
Bedroom 3 Dimensions: 18.0 x 19.0
Bedroom 4 Dimensions: 18.0 x 19.0
Primary Bedroom Level: Main
Bedroom 1 Level: Main
Bedroom 2 Level: Main
Bedroom 3 Level: Basement
Bedroom 4 Level: Basement

Total Bathrooms: 7
Full Bathrooms: 5
1/2 Bathrooms: 2
Bathrooms On Main Level: 5
Bathrooms On Basement Level: 2

Audio/Video Controls
Breakfast Nook
Built-in Features
Ceiling Fan(s)
Central Vacuum
Eat-in Kitchen
Elevator
Entrance Foyer
Five Piece Bath
Granite Counters
High Ceilings
In-Law Floor Plan
Jack & Jill Bath
Jet Action Tub
Kitchen Island
Marble Counters
Open Floorplan
Pantry
Primary Suite
Smoke Free
Sound System
Walk-In Closet(s)
Wet Bar
Flooring: Carpet, Stone, Tile, Wood
Window Features: Bay Window(s), Double Pane Windows

Living Room 2 Level: Main
Living Room 2 Width: 15.00
Living Room 2 Length: 12.00
Bathroom (1/2) Level: Main
Bathroom (1/2) Width: 8.00
Bathroom (1/2) Length: 6.00
Dining Room 2 Level: Main
Dining Room 2 Width: 18.00
Dining Room 2 Length: 14.00
Bathroom (1/2) 2 Level: Main
Bathroom (1/2) 2 Width: 7.00
Bathroom (1/2) 2 Length: 5.00
Laundry Level: Main
Laundry Width: 8.00
Laundry Length: 9.00
Bathroom (Full) Level: Main
Bathroom (Full) Width: 9.00
Bathroom (Full) Length: 11.00
Living Room 3 Level: Main
Living Room 3 Width: 17.00
Living Room 3 Length: 12.00
Bathroom (Full) 2 Level: Main
Bathroom (Full) 2 Width: 5.00
Bathroom (Full) 2 Length: 8.00
Laundry 2 Level: Main
Laundry 2 Width: 6.00
Laundry 2 Length: 10.00
Bathroom (Full) 3 Level: Main
Bathroom (Full) 3 Width: 7.00
Bathroom (Full) 3 Length: 9.00
Laundry 3 Level: Basement
Laundry 3 Width: 9.00
Laundry 3 Length: 6.00
Bathroom (Full) 4 Level: Basement
Bathroom (Full) 4 Width: 10.00
Bathroom (Full) 4 Length: 9.00
Gym Level: Basement
Gym Width: 16.00
Gym Length: 13.00
Wine Cellar Level: Basement
Wine Cellar Width: 10.00
Wine Cellar Length: 9.00
Bathroom (Full) 5 Level: Basement
Bathroom (Full) 5 Width: 8.00
Bathroom (Full) 5 Length: 10.00
Workshop Level: Basement
Workshop Width: 42.00
Workshop Length: 28.00
Extra Room-1 Dimensions: 10.0 x 10.0
Extra Room-2 Dimensions: 31.0 x 23.0
Family Room Dimensions: 24.0 x 21.0
Game/Recreation Room Dimensions: 36.0 x 44.0
Great Room Dimensions: 34.0 x 24.0
Living Room Dimensions: 37.0 x 16.0
Media Room Dimensions: 16.0 x 22.0
Office/Study Room Dimensions: 15.0 x 15.0
Extra Room-1 Level: Main
Extra Room-2 Level: Basement
Family Room Level: Basement
Game/Recreation Room Level: Basement
Great Room Level: Main
Living Room Level: Main
Media Room Level: Basement
Office/Study Room Level: Main
Basement Description: Exterior Entry, Finished, Full, Walk-Out Access

Cooling Features: Central Air
Fireplace Features: Bedroom, Family Room, Gas, Gas Log, Great Room, Living Room
Heating Features: Forced Air, Radiant Floor
Number of Fireplaces: 6

Dining Room Dimensions: 12.0 x 22.0
Dining Room Level: Main
Kitchen Dimensions: 18.0 x 24.0
Kitchen Level: Main
2nd Kitchen Dimensions: 15.0 x 18.0
2nd Kitchen Level: Main

Balcony
Barbecue
Fire Pit
Gas Grill
Heated Gutters
Lighting
Private Yard
Rain Gutters
Water Feature
Patio And Porch Features: Covered, Deck, Front Porch, Patio, Wrap Around
Road Frontage Type: Private Road
Road Surface Type: Paved

Lake
Waterfront

Attached Garage: Yes
Garage Spaces: 5
Parking Features: Circular Driveway, Driveway-Brick, Driveway-Heated, Dry Walled, Exterior Access Door, Finished, Floor Coating, Heated Garage, Oversized
Parking Total: 5

Lot Description: Cul-De-Sac, Foothills, Irrigated, Landscaped, Level, Many Trees, Open Space, Secluded, Sprinklers In Front, Sprinklers In Rear
Lot Size Acres: 1.01
Lot Size Square Feet: 44000

View: Lake, Meadow, Mountain(s), Water
Security Features: Carbon Monoxide Detector(s), Security Entrance, Smoke Detector(s), Video Doorbell

Association: Yes
Association Fee: 500
Association Fee Frequency: Monthly
Association Fee Includes: Irrigation Water, Maintenance Grounds, Security
Calculated Total Monthly Association Fees: 500
Association Name: Whistle Pig
Association Phone: 3039313039

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

Aspen Creek K-8 School is a public elementary and middle school located approximately 0.7 miles away.
directions icon Map directions

Broomfield High School is a public high school located approximately 1.8 miles away.
directions icon Map directions

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

Annual Tax Amount: 18771.00
Source Listing Status: Active
County: Broomfield
Tax Year: 2022
Source Property Type: Residential
Exclusions: Sellers Personal Property
Source Neighborhood: Whistlepig
Parcel Number: R8860845
Subdivision: Whistlepig
Zoning: PUD
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$145,510 + $48,650
$194,160
$18,770
2021$149,700 + $50,050
$199,750
$18,675
2020$144,320 + $50,050
$194,370
$18,284
2019$144,320 + $50,050
$194,370
$18,251
2018$138,770 + $51,750
$190,520
$17,983
2017$138,770 + $51,750
$190,520
$17,710
2016$113,320 + $57,210
$170,530
$16,080
2015$113,320 + $57,210
$170,530
$15,526
2014$97,540 + $39,800
$137,340
$12,782
2013$97,540 + $39,800
$137,340
$11,975
2011$101,100 + $39,800
$140,900
$12,195
2010$101,100 + $39,800
$140,900
$4,964
2009$31,540 + $26,490
$58,030
$5
2008$unknown + $10
$10
$5
2007$unknown + $10
$10
$5

Listed 2024-01-05
$7,298,000
REcolorado
Listing removed 2023-11-16
$0
REcolorado
Listed 2023-01-16
$7,802,000
REcolorado
Listing removed 2022-11-16
$0
REcolorado
Listed 2021-08-27
$7,962,000
REcolorado

Total Square Feet Living: 10406
Year Built: 2010
Above Grade Finished Area: 6425
BelowGradeFinishedArea: 3981
Below Grade Unfinished Area: 1372.00
Construction Materials: Brick, Stone, Stucco
Direction Faces: West
Foundation Details: Structural
Levels: One
Property Age: 14
Roof: Concrete
Structure Type: House
Architectural Style: Mountain Contemporary

Electric: 110V, 220 Volts
Sewer: Public Sewer
Water Source: Private

Accessibility Features: Accessible Approach with Ramp
Click Thumbnail Images To View Full Size
unknownunknownunknownliving_roomliving_room
living_roomdining_roomkitchenkitchenliving_room
living_roombathroombedroombedroombedroom
dining_roomliving_roomdining_roomliving_roomdining_room
unknownunknownliving_roomliving_roomliving_room
living_roomunknownhouse_view

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.