1880 Mallard Drive Unit

See all 40 Photos
Virtual Tour Active Broomfield, CO 80020 MLS# 9180995 Listed by Dylan Lario on 08/27/2021
$7,962,000
Email
Facebook
Twitter
Pinterest
WhatsApp
Single Family Property Type
6 Bedroom
9 Bathroom
5 Garage
11778.00 Sq Ft
1.01 Acres
2010 Year Built

Overview

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 & 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 drive 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

New Home Sales Hours

Courtesy Of Coldwell Banker Realty 56
Source: REcolorado

Upcoming Open Houses

    Features

    Leasing Information

    Leasing Details
    • Application Fee $
    • Availability Date
    • Corporate Rental?
    • Deposits Potentially Refundable
    • Existing Lease Type
    • Lease Amount $
    • Lease Description
    • Lease Duration
    • Liability Insurance Required
    • Owner Pays
    • Rent Deposit
    • Rental Application
    • Security Deposit $
    Pet Details
    • Pet Deposit
    • Pet Rent
    • Pets Allowed

    Interior Features

    Summary

    • Year Built Effective
    Basement Details
    • Basement? No
    • Basement Finished,Full
    • Basement Ceiling Height
    Fireplace Detail
    • Fireplace Features Family Room,Gas,Gas Log,Great Room,Living Room,Master Bedroom,Other
    • No. of Fireplaces 6
    Square Foot Details
    • SqFt 11,778
    • Living Area, Finished 10,406
    • Above grade, Finished 6,425
    • Basement, Finished 3,981
    • Basement, Unfinished 1,372
    • PSF Total $676.01
    • PSF Finished $765.14
    • PSF Above Grade $1,239.22
    Use details
    • Leaseable Area
    • Office Area
    • Retail Area
    • Warehouse Area
    Other
    • Accessibility Features
    • Appliances Bar Fridge,Dishwasher,Disposal,Double Oven,Dryer,Microwave,Oven,Range,Range Hood,Refrigerator,Tankless Water Heater,Trash Compactor,Warming Drawer,Washer,Wine Cooler
    • Building Class
    • Building Features
    • Ceiling Height
    • Common Walls
    • Exclusions Sellers Personal Property
    • Flooring Carpet,Stone,Tile,Wood
    • Furnished Negotiable
    • Interior Features 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,Jet Action Tub,Kitchen Island,Master Suite,Open Floorplan,Pantry,Smoke Free,Stone Counters,Utility Sink,Walk-In Closet(s),Wet Bar
    • Laundry Availability
    • Security Features Carbon Monoxide Detector(s),Security Entrance,Smoke Detector(s),Video Doorbell
    • Spa Features
    • Window Features Double Pane Windows

    Room Details

    Bathroom Details Total Bathrooms: 9
    Bathroom Location Details
    Bedroom Location Details Total Bedrooms: 6
    More Room Details

    Unit Information

    Summary

    • Number of Units
    • Number of Units Furnished
    • Number of Units Vacant
    • Unit Features
    Single Unit Details

    Exterior/Lot Features

    Summary

    • Available Elevations
    • Entry Location
    • Faces West
    • Horse Amenities
    • Horse Property
    • Levels Two
    • Stories
    • Structure Type House
    • Unit Floor #
    • View Lake,Mountain(s)
    Builder Details
    • Builder
    •  
    • Completion Time From Groundbreaking
    • Model Type
    Construction details
    • Architecture Mountain Contemporary,Traditional
    • Construction Materials Brick,Stone,Stucco
    • Foundation Details
    • Roof Concrete
    Exterior Details
    • Dock Features
    • Door Features
    • Exterior Features Balcony,Barbecue,Fire Pit,Gas Grill,Private Yard,Rain Gutters,Water Feature
    • Fencing None
    • Number of Docks
    • Number of Doors
    • Number of Storage Units
    • Other Equipment
    • Other Structures
    • Patio And Porch Features Covered,Deck,Front Porch,Patio,Wrap Around
    • Pool Features
    • Ski Features
    Livable Structure Details
    Lot Details​​​​​​​
    • Acres Leased
    • Crop Acres
    • Cultivated Acres
    • Features Cul-De-Sac,Foothills,Irrigated,Landscaped,Level,Many Trees,Open Space,Sprinklers In Front,Sprinklers In Rear
    • Irrigated Acres
    • Lot Number
    • Lot Size Acres 1.01
    • Lot Size Dimensions
    • Lot Size SqFt 44,000
    • Sq Ft
    • Pasture Acres
    • Price Per Acre $7,883,168.32
    • Vegetation
    • Waterfront Features Lake,Waterfront
    Mobile Details
    • Make
    • Model
    • Body Type
    • Exterior Dimensions x
    • Skirt
    Outbuilding details
    Road details
    • Access Private Road
    • Road Responsibility Private Maintained Road
    • Road Surface Paved

    Parking/Garage

    Parking Space Summary

    Parking Features
    Circular Driveway,Driveway-Brick,Driveway-Heated,Dry Walled,Exterior Access Door,Finished,Floor Coating,Heated Garage,Oversized

    • Total Parking Spaces 5
    • Garage Spaces
    • Total Carport Spaces
    • Total Offstreet Spaces 0
    • Total Reserved Spaces 0
    • Total RV Spaces 0
    Parking Space Details

    Utilities & Green Home Features

    Summary

    • Cooling Central Air
    • Green Energy Efficient
    • Heating Forced Air,Radiant Floor
    • HVAC Description
    Green Ratings
    Power Production Details
    Sewer
    • Sewer Public Sewer
    • Sewer Fee
    • Sewer Tap Paid YN
    Utilities details
    • Electric Service 110V,220 Volts
    • Gas Tap Fee
    • Gas Tap Paid YN
    • Utilities
    Water / Well
    • Irrigation Source
    • Issued Well Permit Numbers
    • Water Available 1
    • Water Source Private,Public
    • Well Type
    • Well Usage
    • Water Fees
    • Water Tap Paid?
    • Water/Mineral Rights Water Rights

    Association Information

    HOA Summary

    • Amenities Completed
    • Amenities Opening
    • Association Amenities Gated,Security
    • Association(s) No
    • HOA Fee Includes Irrigation Water,Maintenance Grounds,Security
    • Total Annual HOA Fees $6,000
    1st HOA
    • HOA Whistle Pig
    • Type Self Managed
    • Fee $500.00 Monthly
    • Phone (303) 931-3039
    • Total Annual Fee $6,000.00
    • Website
    2nd HOA
    • HOA
    • Type
    • Fee $
    • Phone
    • Total Annual Fee $0.00
    • Website
    3rd HOA
    • HOA
    • Type
    • Fee $
    • Phone
    • Total Annual Fee $0.00
    • Website
    Restrictions & Covenants
    • Pets Allowed
    • Rentals Allowed
    • Restrictions Other
    • Restrictions Other
    • Restrictions/Covenants? No

    Financial Considerations

    Summary

    • Cap Rate
    • Cap Rate Calculation
    Actual expense details
    • Annual Expenses Benefits
    • Annual Water Expense $
    • Association Fee Annual Expense $
    • Cable TV Expense $
    • CAM Fees $
    • Electric Expense $
    • Gas Expense $
    • Insurance Expense $
    • Internet Annual Expense $
    • Maintenance Expense $
    • Operating Expense $
    • Operating Expense Includes
    • Other Expense
    • Payroll Annual Expense $
    • Personal Property Annual Expense $
    • Phone Annual Expense $
    • Professional Management Expense $
    • Real Estate Taxes $
    • Workmans Compensation Expense
    Commission Information
    • Buyer Agency Compensation 2.80%
    • Transaction Broker Compensation 2%
    • Compensation Offered
    • Dual Variable Compensation No
    • Commission Modified
    • Closing Comments
    Income details
    • Actual Annual Net Income $
    • Gross Income $
    • Income Includes
    • Income Includes Description
    Landleasing details
    • Land Lease Amount
    • Land Lease Amount Frequency
    • Land Lease?
    Projected
    • Other Annual Income $
    • Potential Rental Income Annual $
    • Projected Annual Expense $
    • Projected Annual Net Income $
    • Projected Gross Income $
    • Projected Gross Operating Income $
    • Vacancy Credit Losses
    Tax details
    • Annual Tax $18,285
    • Legal Description SUBD: WHISTLEPIG FILING NO 1 LOT: 8 BLOCK: 1 ADDED OR UPDATED ON 12/28/2001 11:00:11 AM
    • Tax Exemptions
    • Tax ID R8860845
    • Tax Year 2020
    Other
    • Tenant Pays
    • Utilities Metering
    • Utilities Paid By Tenant

    Neighborhood

    Summary

    • Building Name
    • Development Name
    • Park Name
    • Senior Community No
    • Subdivision Whistlepig
    New Home Community
    • Community Description
    • Community MLS #
    • Community Name
    • Community Opening
    • Community Website
    • Current Promotions
    • Development Status
    • Directions from Agent
    • Move In Date
    • New Home Available Options
    • New Home Land MLS #
    • New Home Plan MLS #
    Zoning Details
    • Current Use
    • Incorporated? No
    • Zoning PUD
    • Zoning Jurisdiction

    Other

    Business Details
    • Business Amenities
    • BusinessDescription
    • BusinessType
    • Year Established
    History
    • Original List Price $7,962,000
    Partial Ownership Details
    • Partial Ownership Amount
    • Week Remarks
    • Weeks Available
    Other
    • Home Warranty 0
    • Ownership Individual
    • Possession Negotiable
    • Special Listing Conditions None Known
    • Year Built 2010

    Mortgage Calculator

    School Zone

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

    Area Map

    Walk Score

    Bike Score

    Bike Score

    0 description
    Transit Score

    Transit Score

    0 description summary
    Walk Score

    Walk Score

    0 description
    Back to top
    span widget