Virtual Tour Active Broomfield, CO 80020 MLS# 6333158 Listed by Clare Day on 11/23/2022
$5,500,000
Email
Facebook
Twitter
Pinterest
WhatsApp
Single Family Property Type
5 Bedroom
7 Bathroom
6 Garage
10507.00 Sq Ft
1.01 Acres
1986 Year Built

Overview

On the shores of a private lake, with majestic views of the Rocky Mountains and iconic Flatirons, this waterfront family retreat is ideal for the discerning buyer searching for a legacy home. Located in a small, gated enclave, it is only a thirty-minute drive to DIA, Boulder, the Tech Center and Denver. Create a lifetime of memories fishing, boating, swimming, and relaxing on the private dock. The luxurious interior features an open floorplan, a gourmet kitchen, a main floor primary suite, office, sound room and gym. Relax around one of the many fireplaces, while hosting friends and family in any of the expansive entertainment areas. Enjoy sunrise reflections off the lake and start each day in serenity.

New Home Sales Hours

Courtesy Of LIV Sothebys International Realty- Breckenridge
Source: REcolorado

View On 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 Cats OK,Dogs OK

    Interior Features

    Summary

    • Year Built Effective
    Basement Details
    • Basement? Yes
    • Basement Finished,Walk-Out Access
    • Basement Ceiling Height
    Fireplace Detail
    • Fireplace Features Dining Room,Family Room,Gas,Living Room,Primary Bedroom,Wood Burning
    • No. of Fireplaces 3
    Square Foot Details
    • SqFt 10,507
    • Living Area, Finished 9,118
    • Above grade, Finished 6,544
    • Basement, Finished 2,574
    • Basement, Unfinished 1,389
    • PSF Total $523.46
    • PSF Finished $603.20
    • PSF Above Grade $840.46
    Use details
    • Leaseable Area
    • Office Area
    • Retail Area
    • Warehouse Area
    Other
    • Accessibility Features
    • Appliances Bar Fridge,Convection Oven,Cooktop,Dishwasher,Disposal,Double Oven,Dryer,Gas Water Heater,Microwave,Range Hood,Self Cleaning Oven,Washer
    • Building Class
    • Building Features
    • Ceiling Height
    • Common Walls
    • Exclusions Seller's Personal Property
    • Flooring
    • Furnished Unfurnished
    • Interior Features
    • Laundry Availability
    • Security Features
    • Spa Features
    • Window Features

    Room Details

    Bathroom Details Total Bathrooms: 7
    Bathroom Location Details
    Bedroom Location Details Total Bedrooms: 5
    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 0
    • Levels Two
    • Stories
    • Structure Type House
    • Unit Floor #
    • View Lake,Mountain(s),Water
    Builder Details
    • Builder
    •  
    • Completion Time From Groundbreaking
    • Model Type
    Construction details
    • Architecture Contemporary
    • Construction Materials Brick,Frame
    • Foundation Details
    • Roof Concrete
    Exterior Details
    • Dock Features
    • Door Features
    • Exterior Features Balcony,Lighting,Water Feature
    • Fencing
    • Number of Docks
    • Number of Doors
    • Number of Storage Units
    • Other Equipment
    • Other Structures
    • Patio And Porch Features Covered,Deck,Patio
    • Pool Features
    • Ski Features
    Livable Structure Details
    Lot Details​​​​​​​
    • Acres Leased
    • Crop Acres
    • Cultivated Acres
    • Features Cul-De-Sac,Landscaped,Level,Open Space,Sprinklers In Front,Sprinklers In Rear
    • Irrigated Acres
    • Lot Number
    • Lot Size Acres 1.01
    • Lot Size Dimensions
    • Lot Size SqFt 43,995.60
    • Sq Ft
    • Pasture Acres
    • Price Per Acre $5,445,544.55
    • Vegetation
    • Waterfront Features Lake,Waterfront
    Mobile Details
    • Make
    • Model
    • Body Type
    • Exterior Dimensions x
    • Skirt
    Outbuilding details
    Road details
    • Access Private Road,Shared
    • Road Responsibility Private Maintained Road
    • Road Surface Paved

    Parking/Garage

    Parking Space Summary

    • Parking Features 220 Volts,Circular Driveway,Concrete,Finished,Floor Coating,Heated Garage,Insulated,Oversized
    • Total Parking Spaces 6
    • 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
    • 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 Electricity Connected,Internet Access (Wired),Natural Gas Connected,Phone Connected
    Water / Well
    • Irrigation Source
    • Issued Well Permit Numbers
    • Water Available 1
    • Water Source Public
    • Well Type
    • Well Usage
    • Water Fees
    • Water Tap Paid?
    • Water/Mineral Rights

    Association Information

    HOA Summary

    • Amenities Completed
    • Amenities Opening
    • Association Amenities Gated,Trail(s)
    • Association(s) Yes
    • HOA Fee Includes Capital Reserves,Irrigation Water,Maintenance Grounds,Security,Snow Removal
    • Total Annual HOA Fees $6,000
    1st HOA
    • HOA Whistlepig Owners Association
    • Type Self Managed
    • Fee $500.00 Monthly
    • Phone (630) 659-5555
    • 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 Cats OK,Dogs OK
    • Rentals Allowed
    • Restrictions Other
    • Restrictions Other
    • Restrictions/Covenants? Yes

    Financial Considerations

    Summary

    • Cap Rate
    • Cap Rate Calculation
    Actual expense details
      Commission Information
      • Buyer Agency Compensation 2.80%
      • 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 $
      • Projected Gross Scheduled Income $
      • Vacancy Credit Losses
      Tax details
      • Annual Tax $12,014
      • Legal Description SUBD: WHISTLEPIG FILING NO 1 LOT: 1 BLOCK: 1
      • Tax Exemptions
      • Tax ID R1104650
      • Tax Year 2021
      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 GPS
      • 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 $5,500,000
      Partial Ownership Details
      • Partial Ownership Amount
      • Week Remarks
      • Weeks Available
      Other
      • Home Warranty
      • Ownership Individual
      • Possession Negotiable
      • Special Listing Conditions None Known
      • Year Built 1986

      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