Built by award-winning Sheffield Homes! Professionally designed by Godden Sudik Architect and Kunze Design CO. Beautiful, bright, & spacious 2-story home w/ a finished basement in Louisville's highly desired Coal Creek Ranch! Sitting atop a quiet drive, this home boasts a private yard w/ beautiful views. A mix of stone/wood/metal adds dimension, creating a home that feels cozy & inviting w/ a sense of calm sophistication. The open floor plan features soaring entryways, hardwood floors throughout the main level, & loads of natural light. The large chef's kitchen offers quartz countertops, stainless JennAir appliances, a gas cooktop w/ hood, micro/oven combo, huge walk-in pantry, & a massive island w/ an eat-up bar. A mudroom w/ a bag drop connects to the oversized fully finished 3-car garage, including 1 EV-ready side & another EV capable. The sunny family room, w/ large windows & a modern gas fireplace, opens to kitchen, offering informal & formal dining options. The design direction embodies a moody, organic modern aesthetic rooted in simplicity & layered w/ natural materials that bring soft contrast, texture, & warmth. The main level also features a 3/4 bath & a home office/playroom. Upstairs, find 3 spacious bedrooms, a loft, upper-level laundry, & a luxurious primary suite w/ dual vanities, large shower, & a walk-in closet. The finished basement offers great potential; a fourth bedroom, a 3/4 bath, & great room w/ lots of space for entertaining, as well as abundant amount of storage. Pre-plumbed for wet bar. Energy Star 3.2-rated, this home includes upgraded Anderson Fiberglass Double Pane windows, a highly efficient furnace, roof, & insulation. Whisper-quiet garage door opener, w/ an estimated 3rd Quarter 2026 completion date estimated. Landscaping is optional. Taxes are estimated. The outstanding community includes a pool, clubhouse, parks, trails, & more. This home offers the best of Louisville's small-town charm with easy access to Boulder, Denver, & Golden.
New construction
Price increase: $10K (7/29)
$2,199,900
945 Saint Andrews Ln, Louisville, CO 80027
5beds
4,871sqft
:
Get pre-qualified$11,610/mo
Single Family Residence
Built in 2026
7,113 Square Feet Lot
$-- Zestimate®
$452/sqft
$43/mo HOA
What's special
Finished basementUpper-level laundryHuge walk-in pantryStainless jennair appliancesWhisper-quiet garage door openerQuartz countertopsLoads of natural light
- 32 days |
- 887 |
- 36 |
Zillow last checked:
Listing updated:
Listed by:
Amanda DiVito Parle 303-877-7371,
Real
Source: IRES as distributed by MLS GRID,MLS#: 1063957
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 3
- 3/4 bathrooms: 2
- Main level bathrooms: 1
Rooms
- Room types: Loft
Primary bedroom
- Description: Carpet
- Features: Full Primary Bath
- Level: Upper
- Area: 192 Square Feet
- Dimensions: 12 x 16
Bedroom 2
- Description: Carpet
- Level: Main
Bedroom 3
- Description: Carpet
- Level: Upper
Bedroom 4
- Description: Carpet
- Level: Upper
Bedroom 5
- Description: Carpet
- Level: Basement
Dining room
- Description: Hardwood
- Level: Main
- Area: 266 Square Feet
- Dimensions: 14 x 19
Kitchen
- Description: Hardwood
- Level: Main
- Area: 247 Square Feet
- Dimensions: 13 x 19
Laundry
- Level: Upper
- Area: 117 Square Feet
- Dimensions: 9 x 13
Living room
- Description: Hardwood
- Level: Main
- Area: 342 Square Feet
- Dimensions: 18 x 19
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range, Self Cleaning Oven, Dishwasher, Microwave, Disposal
Features
- Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full
- Has fireplace: Yes
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 3,390
- Total interior livable area: 4,871 sqft
- Finished area above ground: 3,390
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Oversized
- Attached garage spaces: 3
- Details: Attached
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Enclosed
Lot
- Size: 7,113 Square Feet
Details
- Parcel number: R0109248
- Zoning: Res
- Special conditions: Builder
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2026
Utilities & green energy
- Water: City
- Utilities for property: Natural Gas Available
Community & HOA
Community
- Features: Clubhouse, Tennis Court(s), Pool
- Subdivision: Coal Creek Ranch Flg 3
HOA
- Has HOA: Yes
- Services included: Trash
- HOA fee: $519 annually
- HOA name: Coal Creek Ranch HOA
- HOA phone: 303-429-2611
Location
- Region: Louisville
Financial & listing details
- Price per square foot: $452/sqft
- Tax assessed value: $512,500
- Annual tax amount: $3,116
- Date on market: 7/10/2026
- Listing terms: Cash,Conventional,VA Loan
- Exclusions: Staging furniture and accessories
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/29/2026 | Price change | $2,199,900+0.5%$452/sqft |
Source:  IRES as distributed by MLS GRID #1063957 Report a problem | ||
| 7/10/2026 | Listed for sale | $2,189,900+427.7%$450/sqft |
Source:  REcolorado as distributed by MLS GRID #IR1063957 Report a problem | ||
| 12/18/2024 | Sold | $415,000-4.6%$85/sqft |
Source: IRES as distributed by MLS GRID #1023606 Report a problem | ||
| 3/20/2023 | Listing removed | -- |
Source:  RE/MAX International Report a problem | ||
| 1/20/2023 | Listed for sale | $435,000-54.2%$89/sqft |
Source: IRES as distributed by MLS GRID #980887 Report a problem | ||
| 1/1/2022 | Listing removed | -- |
Source: Zillow Rental Manager Report a problem | ||
| 10/25/2021 | Price change | $6,500+62.5%$1/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 10/15/2021 | Price change | $4,000-35.5%$1/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 10/12/2021 | Price change | $6,200-10.8%$1/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 10/1/2021 | Price change | $6,950-7.3%$1/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 9/16/2021 | Price change | $7,500-9.1%$2/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 7/20/2021 | Listed for rent | $8,250+18.7%$2/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 3/18/2021 | Listing removed | -- |
Source: Zillow Rental Manager Report a problem | ||
| 2/8/2021 | Listed for rent | $6,950+39%$1/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 10/1/2020 | Listing removed | $950,000$195/sqft |
Source: RE/MAX Alliance-Boulder #925245 Report a problem | ||
| 9/29/2020 | Listed for sale | $950,000$195/sqft |
Source: RE/MAX Alliance-Boulder #925245 Report a problem | ||
| 7/24/2020 | Listing removed | $950,000$195/sqft |
Source: Porchlight RE Group-Boulder #914167 Report a problem | ||
| 6/5/2020 | Listed for sale | $950,000+13.8%$195/sqft |
Source: Porchlight RE Group-Boulder #914167 Report a problem | ||
| 4/15/2020 | Listing removed | $5,000$1/sqft |
Source: Attitude Homes Report a problem | ||
| 4/7/2020 | Listed for rent | $5,000+25%$1/sqft |
Source: Attitude Homes Report a problem | ||
| 12/5/2019 | Listing removed | $4,000$1/sqft |
Source: Housing Helpers of Colorado, LLC Report a problem | ||
| 9/27/2019 | Price change | $4,000-11.1%$1/sqft |
Source: Housing Helpers of Colorado, LLC Report a problem | ||
| 9/13/2019 | Price change | $4,500-30.8%$1/sqft |
Source: Housing Helpers of Colorado, LLC Report a problem | ||
| 8/7/2019 | Listed for rent | $6,500$1/sqft |
Source: Attitude Homes Report a problem | ||
| 7/29/2019 | Listing removed | $835,000$171/sqft |
Source: Attitude Homes LLC #6729972 Report a problem | ||
| 7/24/2019 | Listed for sale | $835,000+28.4%$171/sqft |
Source: Attitude Homes LLC #6729972 Report a problem | ||
| 6/6/2018 | Sold | $650,267+40.8%$133/sqft |
Source: IRES as distributed by MLS GRID #850277 Report a problem | ||
| 6/27/2002 | Sold | $462,000+94.1%$95/sqft |
Source: Public Record Report a problem | ||
| 5/24/1994 | Sold | $238,000$49/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $2,254 +1.7% | $32,031 +11.4% |
| 2024 | $2,216 +82.9% | $28,763 -13.9% |
| 2023 | $1,212 -79.7% | $33,412 +165.4% |
| 2022 | $5,980 +9.7% | $12,590 -80.5% |
| 2021 | $5,449 | $64,571 +10.9% |
| 2020 | $5,449 +16.9% | $58,230 |
| 2019 | $4,664 | $58,230 +11.6% |
| 2018 | $4,664 | $52,200 -9.5% |
| 2017 | $4,664 +6.3% | $57,710 +15.7% |
| 2016 | $4,387 +5.5% | $49,862 +16.6% |
| 2015 | $4,158 +13.8% | $42,745 |
| 2014 | $3,655 +3% | $42,745 |
| 2013 | $3,546 +0.9% | $42,745 +2.7% |
| 2012 | $3,516 +2.9% | $41,631 |
| 2011 | $3,415 +6.2% | -- |
| 2010 | $3,217 -7.5% | $40,950 |
| 2009 | $3,479 +2.5% | $40,950 -21.1% |
| 2008 | $3,395 +1.1% | $51,870 |
| 2007 | $3,359 +8.4% | $51,870 +3.4% |
| 2006 | $3,098 +6.7% | $50,170 |
| 2005 | $2,903 +0.5% | $50,170 +5.4% |
| 2004 | $2,889 +39.4% | $47,600 |
| 2003 | $2,072 +9.7% | $47,600 +57.4% |
| 2002 | $1,888 | $30,240 -90.9% |
| 2001 | -- | $330,500 |
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.Climate risks
Neighborhood: Coal Creek
Nearby schools
GreatSchools rating
- 6/10Monarch K-8 SchoolGrades: PK-8Distance: 0.5 mi
- 10/10Monarch High SchoolGrades: 9-12Distance: 0.6 mi
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.
- $1,160,7005 bd3 ba2.9k sqft943 Saint Andrews Ln, Louisville, CO 80027Off Market
- $445,0008,060 sqft947 Saint Andrews Ln, Louisville, CO 80027Sold
- $300,0006,098 sqft941 Saint Andrews Ln #96, Louisville, CO 80027Sold
- $300,0006,187 sqft941 Saint Andrews Ln, Louisville, CO 80027Sold
- $1,544,5004 bd3 ba3.2k sqft949 Saint Andrews Ln, Louisville, CO 80027Off Market
- $1,451,0004 bd4 ba3.6k sqft946 Saint Andrews Ln, Louisville, CO 80027Off Market
- $1,545,0004 bd5 ba3.7k sqft944 Saint Andrews Ln, Louisville, CO 80027Sold
- $480,3004 bd3 ba3.1k sqft942 Saint Andrews Ln, Louisville, CO 80027Off Market
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.
Similar homes
- $2,100,0004 bd4 ba3.9k sqft1017 Turnberry Circle, Louisville, CO 80027For Sale
MLS ID #9067385, Connor O'Halloran, Real Broker, LLC DBA Real. REcolorado as distributed by MLS GRID - $2,500,0005 bd6 ba6.5k sqft977 Saint Andrews Ln, Louisville, CO 80027New Construction
MLS ID #1051828, Steven Carter, RE/MAX of Boulder, Inc. IRES as distributed by MLS GRID - $2,495,0005 bd5 ba4.4k sqft312 W Charles Street, Superior, CO 80027For Sale
MLS ID #5487245, Meredith Richardson, 8z Real Estate. REcolorado as distributed by MLS GRID - $1,650,0004 bd6 ba4.6k sqft218 6th Ave, Superior, CO 80027For Sale
MLS ID #1066030, Patrick Dolan, RE/MAX of Boulder, Inc. IRES as distributed by MLS GRID - $1,700,0006 bd4 ba4k sqft953 Saint Andrews Ln, Louisville, CO 80027New ConstructionMLS ID #1053158, Cynthia Arey, Living N Colorado. IRES as distributed by MLS GRID
- $2,200,0004 bd3 ba4.1k sqft635 Ord Dr, Boulder, CO 80303For SaleMLS ID #1063598, Nick Rota, Live West Realty. IRES as distributed by MLS GRID
- $1,925,0005 bd4 ba6.4k sqft2470 Red Hawk Pl, Broomfield, CO 80023For SaleMLS ID #1066160, Sage Swink, Berkshire Hathaway HomeServices Colorado Real Estate Erie. IRES as distributed by MLS GRID
- $1,750,0004 bd4 ba4.3k sqft2911 Calmante Ave #A, Superior, CO 80027For SaleMLS ID #1060985, The Bernardi Group, Coldwell Banker Realty-Boulder. IRES as distributed by MLS GRID
- $2,795,0005 bd5 ba6k sqft402 S 3rd Ave, Superior, CO 80027New ConstructionMLS ID #1063655, Tom Studebaker, CORE Residential. IRES as distributed by MLS GRID
- $1,299,0004 bd5 ba3.6k sqft2340 Miner Lane, Louisville, CO 80027For SaleMLS ID #3983671, Geoffrey Braden, First Summit Realty. REcolorado as distributed by MLS GRID
- $1,399,0005 bd5 ba4k sqft900 Eldorado Lane, Louisville, CO 80027New ConstructionMLS ID #2068498, Adam Sloat, Westwater Realty. REcolorado as distributed by MLS GRID
- $1,275,0003 bd4 ba3k sqft510 Superior Drive, Louisville, CO 80027For SaleMLS ID #5123297, Megan Denham, Resident Realty North Metro LLC. REcolorado as distributed by MLS GRID
- $1,450,0004 bd4 ba3.1k sqft917 Arapahoe Cir, Louisville, CO 80027For SaleMLS ID #1060862, Courtney Wentworth, milehimodern - Boulder. IRES as distributed by MLS GRID
- $1,499,0005 bd4 ba5.2k sqft4464 Fairway Ln, Broomfield, CO 80023For SaleMLS ID #1065840, Lysa Johnson, Compass - Boulder. IRES as distributed by MLS GRID
- $1,998,5005 bd5 ba5.9k sqft3305 W 155th Ave, Broomfield, CO 80023For SaleMLS ID #1057447, The Bernardi Group, Coldwell Banker Realty-Boulder. IRES as distributed by MLS GRID
- $2,850,0005 bd5 ba4.8k sqft1563 Spring Creek Xing, Lafayette, CO 80026For SaleMLS ID #1064868, Kristin Kalush, Compass - Boulder. IRES as distributed by MLS GRID
- $2,250,0006 bd5 ba5.4k sqft7237 Spring Creek Cir, Niwot, CO 80503For SaleMLS ID #1060286, Sharyn Breslin, RE/MAX Alliance-Wadsworth. IRES as distributed by MLS GRID
- $1,324,9903 bd4 ba3.9k sqft208 6th Ave, Superior, CO 80027For SaleMLS ID #1057211, Nathan Freeman, CORE Residential. IRES as distributed by MLS GRID
- $1,999,5004 bd4 ba3.6k sqft1400 Lodge Lane, Boulder, CO 80303For SaleMLS ID #4269162, Slava Bakhour, A Step Above Realty. REcolorado as distributed by MLS GRID
- $2,049,9994 bd3 ba3.6k sqft8675 Summerlin Pl, Longmont, CO 80503New ConstructionMLS ID #1063292, Angela Moss, 8z Real Estate. IRES as distributed by MLS GRID
