Skip main navigation
Sold for $1,575,000
  • $1,575,000

    804 Spyglass Circle, Louisville, CO 80027

    3beds
    4,316sqft
    Single Family Residence
    Built in 2025
    9,062 Square Feet Lot
    $-- Zestimate®
    $365/sqft
    $4,337 Estimated rent

    Home value

    Not available

    Estimated sales range

    Not available

    $4,337/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,337/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,337/mo

    Rent Zestimate®

    Refinance and save

    $7,418/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $7,418/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Fully fenced backyardLuxurious modern finishesWhite oak hardwood floorsPrimary suiteLandscaped yardLarge elevated deckCustom closets
    Stunning, Energy-Efficient Home with Luxury Finishes. Prime location! This gorgeous, high-performance new home offers the perfect blend of modern design, energy efficiency, and luxury living in the sought-after Coal Creek neighborhood. Featuring a spacious open floor plan, high-end finishes & abundant natural light, this home is designed for both comfort & sustainability. Inside, White Oak hardwood floors throughout the entire house, where a bright and airy living space flows seamlessly into a gourmet kitchen equipped w/ premium Bosch appliances, an induction range & sleek modern cabinetry. A dedicated office provides a quiet retreat for work or study. On the main floor, the primary suite is a true sanctuary, featuring a walk-in closet and a spa-like 5-piece luxury bath. 2 additional bedrms w/ custom closets, a 2nd full bathrm, complete the upper level. Basement expands your living space, offering the possibility of 2 additional bedrms, a full bathrm, and a LG recreation rm—perfect for a home theater, gym, or playroom. Designed for ultimate comfort and efficiency, this home is equipped with a dual-zone heat pump, a high-efficiency gas furnace for backup heating. Outside, the landscaped yard is both beautiful & low maintenance, featuring a mix of natural & artificial turf. Backyard opens directly to scenic open space and the Coal Creek Trail System, ideal for nature lovers & outdoor enthusiasts. If you prefer a more social setting, enjoy exclusive access to the community pool, clubhouse, and tennis courts. For golf lovers, this sunny southwest-facing home backs directly onto an open space green area, offering breathtaking foothill & mountain views. Large, elevated deck provides the perfect space for entertaining, while the fully fenced backyard ensures privacy. 3-car garage and luxurious modern finishes throughout. Dont miss this rare opportunity to own a thoughtfully designed, energy-efficient dream home in one of the areas most desirable locations!

    Zillow last checked:

    Listing updated:

    Listed by:

    Deni Niethammer 828-450-8248 HybridMLSListings@Gmail.com,

    The Resource Group LLC

    Bought with:

    Alicia Miller

    RE/MAX of Boulder, Inc

    Source: REcolorado as distributed by MLS GRID,MLS#: 1787975MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    • Main level bathrooms: 2
    • Main level bedrooms: 1
    Primary bedroom
    • Level: Main
    • Area: 221 Square Feet
    • Dimensions: 17 x 13
    Bedroom
    • Level: Upper
    • Area: 182 Square Feet
    • Dimensions: 13 x 14
    Bedroom
    • Level: Upper
    • Area: 220 Square Feet
    • Dimensions: 10 x 22
    Primary bathroom
    • Level: Main
    • Area: 120 Square Feet
    • Dimensions: 12 x 10
    Bathroom
    • Level: Upper
    • Area: 77 Square Feet
    • Dimensions: 7 x 11
    Bathroom
    • Level: Main
    Laundry
    • Level: Main
    • Area: 56 Square Feet
    • Dimensions: 8 x 7
    Heating
    • Forced Air, Heat Pump, Natural Gas
    Cooling
    • None
    Appliances
    • Included: Convection Oven, Dryer, Gas Water Heater, Microwave, Refrigerator, Tankless Water Heater, Washer
    Features
    • Eat-in Kitchen, Five Piece Bath, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s)
    • Flooring: Laminate, Tile
    • Windows: Double Pane Windows
    • Basement: Partial,Unfinished
    • Has fireplace: Yes
    • Fireplace features: Gas, Great Room
    Interior area
    • Total structure area: 4,316
    • Total interior livable area: 4,316 sqft
    • Finished area above ground: 2,534
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 3
    • Parking features: Concrete, Dry Walled, Electric Vehicle Charging Station(s), Exterior Access Door, Guest, Heated Garage, Insulated Garage, Lighted, Oversized, Oversized Door, Garage Door Opener
    • Attached garage spaces: 3
    Features
    • Levels: Two
    • Stories: 2
    • Entry location: Exterior Access
    • Patio & porch: Covered, Deck, Front Porch
    • Exterior features: Dog Run, Private Yard
    • Has private pool: Yes
    • Pool features: Private
    • Fencing: Full
    • Has view: Yes
    • View description: Golf Course, Mountain(s)
    Lot
    • Size: 9,062 Square Feet
    • Features: Cul-De-Sac, Greenbelt
    Details
    • Parcel number: R0113965
    • Zoning: RES
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary
    • Property subtype: Single Family Residence
    Materials
    • Cedar, Cement Siding, Concrete, Stone, Steel Siding, Stucco
    • Foundation: Concrete Perimeter, Structural
    Condition
    • New Construction
    • New construction: Yes
    • Year built: 2025

    Utilities & green energy

    • Electric: 110V, 220 Volts, 220 Volts in Garage
    • Water: Public
    • Utilities for property: Cable Available, Electricity Connected, Phone Available
    Green energy
    • Energy efficient items: Appliances, Construction, HVAC, Insulation, Lighting, Roof, Thermostat, Water Heater, Windows

    Community & HOA

    Community
    • Security: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)
    • Subdivision: Coal Creek Ranch
    HOA
    • Has HOA: Yes
    • Amenities included: Clubhouse, Parking, Playground, Pool, Tennis Court(s)
    • Services included: Maintenance Grounds
    • HOA fee: $64 monthly
    • HOA name: Coal Mine Ranch Master
    • HOA phone: 303-429-2611
    Location
    • Region: Louisville

    Financial & listing details

    • Price per square foot: $365/sqft
    • Tax assessed value: $1,218,525
    • Annual tax amount: $3,742
    • Date on market: 5/1/2025
    • Listing terms: Cash,Conventional
    • Exclusions: None
    • Ownership: Individual
    • Electric utility on property: Yes
    • Road surface type: Paved

    Price history

    DateEventPrice
    6/25/2025Sold$1,575,000-1.3%$365/sqft
    Source: REcolorado as distributed by MLS GRID #1787975 Report a problem
    6/1/2025Pending sale$1,595,000$370/sqft
    Source: REcolorado as distributed by MLS GRID #1787975 Report a problem
    5/30/2025Price change$1,595,000-3.3%$370/sqft
    Source: REcolorado as distributed by MLS GRID #1787975 Report a problem
    5/20/2025Price change$1,649,000-2.9%$382/sqft
    Source: REcolorado as distributed by MLS GRID #1787975 Report a problem
    5/7/2025Price change$1,699,000-4.3%$394/sqft
    Source: REcolorado as distributed by MLS GRID #1787975 Report a problem
    5/1/2025Price change$1,775,000-5.3%$411/sqft
    Source: REcolorado as distributed by MLS GRID #1787975 Report a problem
    3/12/2025Listed for sale$1,875,000+686.5%$434/sqft
    Source: Owner Report a problem
    1/14/1994Sold$238,392$55/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$3,742 +23%$76,158 +46.4%
    2024$3,042 +118%$52,022 +35.2%
    2023$1,396 -75.9%$38,486 +165.4%
    2022$5,799 +13.2%$14,501 -76.8%
    2021$5,122 $62,613 +14.4%
    2020$5,122 +9.4%$54,727
    2019$4,681 $54,727 +4.5%
    2018$4,681 $52,394 -9.5%
    2017$4,681 +8%$57,925 +17.6%
    2016$4,333 +5.5%$49,249 +15.4%
    2015$4,107 +12.6%$42,673
    2014$3,648 +1.5%$42,673
    2013$3,594 +0.9%$42,673 +1.1%
    2012$3,563 +2.4%$42,188
    2011$3,479 +6.1%--
    2010$3,277 +14.3%$41,710
    2009$2,866 +2.5%$41,710 -2.4%
    2008$2,796 +1.3%$42,730
    2007$2,760 +8.4%$42,730 +3.7%
    2006$2,545 +5.3%$41,220
    2005$2,416 +0.5%$41,220 +4.1%
    2004$2,404 +7.9%$39,610
    2003$2,229 +9.7%$39,610 +21.8%
    2002$2,031 $32,530 -90.8%
    2001-- $355,500
    Find assessor info on the county website

    Neighborhood: Coal Creek

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Monarch K-8
    • Middle: Monarch K-8
    • High: Monarch
    • District: Boulder Valley RE 2

    Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.