For sale
$1,899,999
5beds
3,632sqft
964 Saint Andrews Lane, Louisville, CO 80027
5beds
3,632sqft
Single family residence
Built in 2025
8,276 sqft
4 Attached garage spaces
$523 price/sqft
$61/mo HOA
What's special
Located in the highly desirable Coal Creek neighborhood, wake up to Foothills and Flatirons views from all three levels in this exceptional luxury home where thoughtful design, sustainability, and the Colorado lifestyle come together. The main level welcomes you with a bright living room, where expansive windows flood the space with ...
- 37 days |
- 1,093 |
- 30 |
Source: REcolorado as distributed by MLS GRID,MLS#: 8979532
Travel times
Living Room
Kitchen
Primary Bedroom
Zillow last checked: 7 hours ago
Listing updated: March 21, 2026 at 02:06pm
Listed by:
Heather Slump 720-390-8705 heather@rhaegroup.com,
Rhae Group Realty,
Rhae Group 720-390-8705,
Rhae Group Realty
Source: REcolorado as distributed by MLS GRID,MLS#: 8979532
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Basement
Bedroom
- Level: Basement
Bathroom
- Level: Upper
Bathroom
- Level: Upper
Bathroom
- Level: Basement
Bathroom
- Level: Main
Family room
- Level: Basement
Kitchen
- Level: Main
Laundry
- Level: Upper
Laundry
- Level: Basement
Living room
- Level: Main
Office
- Level: Main
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, Disposal, Dryer, Microwave, Range, Range Hood, Refrigerator, Tankless Water Heater, Washer
Features
- Ceiling Fan(s), Entrance Foyer, Five Piece Bath, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Radon Mitigation System, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Tile, Wood
- Basement: Finished,Full,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 3,632
- Total interior livable area: 3,632 sqft
- Finished area above ground: 2,366
- Finished area below ground: 1,266
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Electric Vehicle Charging Station(s)
- Attached garage spaces: 4
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Deck, Front Porch, Patio
- Fencing: Full
Lot
- Size: 8,276.4 Square Feet
- Features: Landscaped, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: R0109278
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame
- Roof: Composition
Condition
- Year built: 2025
Utilities & green energy
- Electric: 220 Volts in Garage
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Coal Creek Ranch
HOA
- Has HOA: Yes
- Amenities included: Clubhouse, Golf Course, Pool, Tennis Court(s), Trail(s)
- Services included: Reserve Fund, Recycling, Trash
- HOA fee: $61 monthly
- HOA name: Coal Creek Ranch
- HOA phone: 303-429-2611
Location
- Region: Louisville
Financial & listing details
- Price per square foot: $523/sqft
- Tax assessed value: $1,060,950
- Annual tax amount: $6,451
- Date on market: 2/27/2026
- Listing terms: Cash,Conventional,Jumbo,VA Loan
- Exclusions: Staging Items
- Ownership: Individual
Price history
| Date | Event | Price |
|---|---|---|
| 2/27/2026 | Listed for sale | $1,899,999-2.7%$523/sqft |
Source:  REcolorado as distributed by MLS GRID #8979532 Report a problem | ||
| 6/27/2025 | Sold | $1,952,800-2.3%$538/sqft |
Source: REcolorado as distributed by MLS GRID #IR1034383 Report a problem | ||
| 5/29/2025 | Pending sale | $1,999,000$550/sqft |
Source:  IRES as distributed by MLS GRID #1034383 Report a problem | ||
| 5/17/2025 | Listed for sale | $1,999,0000%$550/sqft |
Source: REcolorado as distributed by MLS GRID #IR1034383 Report a problem | ||
| 5/15/2025 | Listing removed | $1,999,900$551/sqft |
Source: IRES as distributed by MLS GRID #1026810 Report a problem | ||
| 2/21/2025 | Listed for sale | $1,999,900+280.9%$551/sqft |
Source: IRES as distributed by MLS GRID #1026810 Report a problem | ||
| 7/11/2024 | Sold | $525,000+23.5%$145/sqft |
Source: Public Record Report a problem | ||
| 5/31/2000 | Sold | $425,000+52.7%$117/sqft |
Source: Public Record Report a problem | ||
| 12/9/1993 | Sold | $278,388$77/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $2,728 +1.7% | $66,309 +94.8% |
| 2024 | $2,682 +114.4% | $34,036 -1% |
| 2023 | $1,251 -73.7% | $34,366 +164.4% |
| 2022 | $4,747 +14.4% | $12,997 -77.7% |
| 2021 | $4,149 | $58,408 +13.4% |
| 2020 | $4,149 -7.2% | $51,488 |
| 2019 | $4,471 | $51,488 +2.9% |
| 2018 | $4,471 | $50,040 -9.5% |
| 2017 | $4,471 +11.3% | $55,322 +21.1% |
| 2016 | $4,018 +5.5% | $45,674 +11.7% |
| 2015 | $3,809 +8.9% | $40,907 |
| 2014 | $3,497 +2.7% | $40,907 |
| 2013 | $3,404 +0.9% | $40,907 +2.4% |
| 2012 | $3,375 +11.7% | $39,960 |
| 2011 | $3,021 +6.2% | -- |
| 2010 | $2,846 -5% | $36,220 |
| 2009 | $2,997 +2.5% | $36,220 -19% |
| 2008 | $2,924 -2% | $44,690 |
| 2007 | $2,983 +8.4% | $44,690 +0.3% |
| 2006 | $2,751 +1% | $44,560 |
| 2005 | $2,724 +0.5% | $44,560 -0.2% |
| 2004 | $2,711 +3.7% | $44,660 |
| 2003 | $2,615 +9.7% | $44,660 +17% |
| 2002 | $2,383 | $38,160 -90.9% |
| 2001 | -- | $417,100 |
Find assessor info on the county website
Monthly payment
Est. payment
$10,223/mo
Principal & interest
$9323
Property taxes
$839
HOA Fees
$61
More affordability tools
Estimated market value
$1,861,900
$1.77M - $1.95M
$6,664/mo
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.
Neighborhood: Coal Creek
Nearby schools
GreatSchools rating
- 6/10Monarch K-8 SchoolGrades: PK-8Distance: 0.4 mi
- 10/10Monarch High SchoolGrades: 9-12Distance: 0.5 mi
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.
- Colorado
- Boulder County
- Louisville
- 80027
- Coal Creek
- 964 Saint Andrews Lane