Skip main navigation
New construction
  • Price cut: $100K (6/17)
    $1,700,000

    953 Saint Andrews Ln, Louisville, CO 80027

    6beds
    4,041sqft
    : 
    $9,006/mo
    Get pre-qualified
    Single Family Residence
    Built in 2026
    7,130 Square Feet Lot
    $1,672,100 Zestimate®
    $421/sqft
    $67/mo HOA

    What's special

    Walk-in pantryUpper-level laundry center
    Welcome to this exquisite custom-built home nestled in the heart of Boulder County! A luxurious residence offers 6 spacious (or 4 BRs/2 offices), 4 baths, & a generous 4041 sq ft of stunning living space! Experience the unobstructed views of Flatirons from the covered patio spanning 45 ft! (outdoor oasis--900 sq ft +/- of covered private patio space---combined is almost 5,000 sq ft--all tucked in a private enclave, surrounded by lush landscaping!) Open & airy design w/ heightened ceilings up to 11 ft high---most rooms! High-end finished basement has a huge rec room, a bar area with a separate wine and beverage cooler, a large bedroom, and a bath. The neighborhood, Coal Creek Ranch, has tennis courts/pool/community park- find instant friends!! MORE features: Chef's kitchen includes: 9-foot quartz island w/ seating for 5+; Additional 17 ft of quartz countertops with under-cabinet lighting; Walk-in pantry: High-efficiency/high-end stainless-steel appliances including induction stove w/ instant heating--air fryer, convection, steam or self-cleaning (gas line pre-plumbed); Versatile living space--main level office or 5th BR and plenty of space in finished area in bsmt (handsome 6th BR) plus 2nd level that has 4 BRs. Luxurious bathroom in primary BR-dual vanities, private commode area, oversized shower w/ bench, spacious walk-in closet, & freestanding soaking tub; has upper-level laundry center; Spacious mudroom/drop zone w/ shelves & hooks at garage entrance; Private patios feature rich-wood ceilings w/ recessed lighting; exterior has Durable James Hardie Board siding (low-maintenance, pest- and fire-resistant, weather-tough); exterior lighting is programmable for ambiance & security. Has a SimpliSafe Security System-monitors activity on main floor & detects pets. Also--a Smart Water Detection System (sump pump & water heater), a Smart Smoke Alarm & Carbon Monoxide Detection & Smart Remote Thermostat & Smart Door Lock System
    163 days
    |
    816
    |
    28
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Cynthia Arey 303-581-0606,

    Living N Colorado

    Source: IRES as distributed by MLS GRID,MLS#: 1053158MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 4
      • Full bathrooms: 2
      • 3/4 bathrooms: 2
      • Main level bathrooms: 1
      Primary bedroom
      • Description: Carpet
      • Features: Tub+Shower Primary
      • Level: Upper
      • Area: 270 Square Feet
      • Dimensions: 15 x 18
      Bedroom 2
      • Description: Carpet
      • Level: Upper
      • Area: 144 Square Feet
      • Dimensions: 12 x 12
      Bedroom 3
      • Description: Carpet
      • Level: Upper
      • Area: 165 Square Feet
      • Dimensions: 11 x 15
      Bedroom 4
      • Description: Carpet
      • Level: Upper
      • Area: 195 Square Feet
      • Dimensions: 15 x 13
      Bedroom 5
      • Description: Engineered Hardwood
      • Level: Main
      • Area: 176 Square Feet
      • Dimensions: 11 x 16
      Bedroom 6
      • Description: Carpet
      • Level: Basement
      • Area: 143 Square Feet
      • Dimensions: 11 x 13
      Dining room
      • Description: Engineered Hardwood
      • Level: Main
      • Area: 120 Square Feet
      • Dimensions: 8 x 15
      Great room
      • Description: Engineered Hardwood
      • Level: Main
      • Area: 483 Square Feet
      • Dimensions: 21 x 23
      Kitchen
      • Description: Engineered Hardwood
      • Level: Main
      • Area: 210 Square Feet
      • Dimensions: 14 x 15
      Laundry
      • Description: Tile
      • Level: Upper
      • Area: 30 Square Feet
      • Dimensions: 6 x 5
      Recreation room
      • Level: Basement
      • Area: 540 Square Feet
      • Dimensions: 20 x 27
      Study
      • Description: Engineered Hardwood
      • Level: Main
      • Area: 176 Square Feet
      • Dimensions: 11 x 16
      Heating
      • Heat Pump
      Cooling
      • Central Air
      Appliances
      • Included: Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
      Features
      • Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar
      • Flooring: Wood
      • Windows: Window Coverings
      • Basement: Full,Partially Finished,Built-In Radon,Sump Pump
      • Has fireplace: Yes
      • Fireplace features: Gas, Great Room
      Interior area
      • Total structure area: 2,984
      • Total interior livable area: 4,041 sqft
      • Finished area above ground: 2,984

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage Door Opener, Attached
      • Attached garage spaces: 2
      • Details: Attached
      Accessibility
      • Accessibility features: Main Floor Bath, Accessible Bedroom, Stall Shower
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Patio, Deck
      • Exterior features: Sprinkler System, Balcony
      • Fencing: Fenced,Other
      • Has view: Yes
      • View description: Mountain(s), Hills, Plains View, City
      Lot
      • Size: 7,130 Square Feet
      • Features: Level, Abuts Private Open Space, Meadow, Paved, Sidewalks, Fire Hydrant within 500 Feet
      Details
      • Parcel number: R0109252
      • Zoning: RES
      • Special conditions: Private Owner

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence
      Materials
      • Frame
      • Roof: Composition
      Condition
      • New construction: Yes
      • Year built: 2026
      Details
      • Builder model: Custom-Private Seller
      • Builder name: Ascent Builders, Inc.

      Utilities & green energy

      • Electric: Xcel
      • Gas: Xcel
      • Sewer: Public Sewer
      • Water: City
      • Utilities for property: Natural Gas Available, Electricity Available, Cable Available, High Speed Avail
      Green energy
      • Energy efficient items: Southern Exposure, Windows, Energy Rated

      Community & HOA

      Community
      • Features: Tennis Court(s), Pool, Playground, Park
      • Security: Security System, Fire Alarm
      • Subdivision: Coal Creek Ranch Flg 3
      HOA
      • Has HOA: Yes
      • Services included: Common Amenities, Trash, Management
      • HOA fee: $67 monthly
      • HOA name: Coal Creek Ranch
      • HOA phone: 303-429-2611
      Location
      • Region: Louisville

      Financial & listing details

      • Price per square foot: $421/sqft
      • Tax assessed value: $495,200
      • Annual tax amount: $3,011
      • Date on market: 3/6/2026
      • Listing terms: Cash,Conventional
      • Electric utility on property: Yes
      • Road surface type: Concrete

        Estimated market value

        $1,672,100

        $1.59M - $1.76M

        $5,207/mo

        Price history

        DateEventPrice
        6/17/2026Price change$1,700,000-5.6%$421/sqft
        Source: IRES as distributed by MLS GRID #1053158 Report a problem
        6/10/2026Price change$1,800,000-3.5%$445/sqft
        Source: IRES as distributed by MLS GRID #1053158 Report a problem
        6/3/2026Price change$1,865,000-0.3%$462/sqft
        Source: IRES as distributed by MLS GRID #1053158 Report a problem
        5/31/2026Price change$1,870,000-0.3%$463/sqft
        Source: IRES as distributed by MLS GRID #1053158 Report a problem
        3/12/2026Listed for sale$1,875,000$464/sqft
        Source: IRES as distributed by MLS GRID #1053158 Report a problem
        1/13/2026Listing removed$1,875,000$464/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        1/13/2026Price change$1,875,000+4.2%$464/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        11/19/2025Price change$1,800,000-2.7%$445/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        10/27/2025Price change$1,850,000-2.6%$458/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        10/21/2025Price change$1,900,000-5%$470/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        9/17/2025Price change$2,000,000-9.1%$495/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        9/11/2025Listed for sale$2,200,000+337.4%$544/sqft
        Source: IRES as distributed by MLS GRID #1043375 Report a problem
        8/24/2011Sold$503,000-1.4%$124/sqft
        Source: Public Record Report a problem
        7/7/2011Listed for sale$510,000+121.8%$126/sqft
        Source: Fuller Sotheby's International Realty #659973 Report a problem
        5/18/1994Sold$229,900$57/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$1,500 +1.7%$30,950 +51.9%
        2024$1,475 +25.3%$20,379 -37%
        2023$1,177 -79.1%$32,337 +164.4%
        2022$5,630 +10.6%$12,229 -79.9%
        2021$5,089 $60,789 +11.8%
        2020$5,089 +12.1%$54,376
        2019$4,541 $54,376 +7%
        2018$4,541 $50,825 -9.5%
        2017$4,541 +8.4%$56,190 +18.1%
        2016$4,187 +5.5%$47,593 +17.7%
        2015$3,969 +14.8%$40,437
        2014$3,457 +9.2%$40,437 -5.1%
        2013$3,167 +0.9%$42,626 +14.7%
        2012$3,139 +4.1%$37,173
        2011$3,017 +6.1%--
        2010$2,842 -0.9%$36,170
        2009$2,867 +2.5%$36,170 -15.4%
        2008$2,797 +7.9%$42,740
        2007$2,592 +8.4%$42,740 +10.4%
        2006$2,390 -5.7%$38,700
        2005$2,535 +0.5%$38,700 -6.9%
        2004$2,522 +6.3%$41,560
        2003$2,373 +9.7%$41,560 +20%
        2002$2,162 $34,640 -90.9%
        2001-- $378,600
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Coal Creek

        Getting around

        10 / 100
        Car-Dependent
        53 / 100
        Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Monarch
        • Middle: Monarch
        • High: Monarch

        Source: IRES 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.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes