Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of Real Broker, LLC DBA Realas Distributed by MLSGrid- MLS# 9381681MLS Provider

945 Saint Andrews LaneLouisville, CO 80027

Single Family · 5 Beds · 3 Full Baths · 2 Three Quarter Baths · 4,871 Sq. ft. | 0.16 Acres
$2,191,450 Active

945 Saint Andrews Lane Overview

Time on Site:
505 days
Visits:
2

Beautiful, bright, & spacious 2-story home w/ a finished basement in Louisville's highly desired Coal Creek Ranch community! 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. Build this stunning new custom home w/ award-winning Sheffield Homes! 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 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. Energy Star 3.2-rated, this home includes upgraded Anderson Fiberglass Double Pane windows, a highly efficient furnace, roof, & insulation that meet Louisville’s net-zero building requirements. 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.

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map

945 Saint Andrews Lane Facts & Features

  • Type Single Family
  • Sq. ft. 4,871
  • Price/Sq.ft. $450
  • Lot 0.16 Acres

Details

General

Association/HOA

  • Association Amenities: Clubhouse,Pool,Tennis Court(s)
  • Association Fee: 519
  • Association Fee Frequency: Annually
  • Association Fee Includes: Reserves,Trash
  • Association Name: Coal Creek Ranch HOA
  • Association: true

Distance to Services

  • Distance To Bus Numeric: 2
  • Distance To Bus Units: Minutes

School Information

  • School District: Boulder Valley RE 2
  • Elementary School: Monarch K-8
  • Middle Or Junior School: Monarch K-8
  • High School: Monarch

Green Features

  • Green Energy Efficient: Appliances,Construction,Doors,HVAC,Insulation,Lighting,Roof,Thermostat,Water Heater,Windows

Building Information

  • Builder Model: Mountain Modern
  • Builder Name: Sheffield Homes
  • Year Built: 2025

Business Information

  • Current Use: Live/Work

Location/Region

  • Country: US
  • County Or Parish: Boulder
  • Subdivision Name: Coal Creek Ranch

Tax Information

  • Tax Annual Amount: 7500
  • Tax Year: 2025

General Information

  • Exclusions: N/A
  • Furnished: Unfurnished
  • Listing Terms: Cash,Conventional,Jumbo,VA Loan
  • Ownership: Builder
  • Parcel Number: R0109248
  • Pets Allowed: Yes
  • Property Condition: Under Construction
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Senior Community: false
  • Special Listing Conditions: None
  • Zoning: RES

Interior

Parking Information

  • Garage Spaces: 3

Beds/Baths

  • Bathrooms Full: 3
  • Bathrooms Half: 0
  • Bathrooms One Quarter: 0
  • Bathrooms Three Quarter: 2
  • Bathrooms Total: 5
  • Bedrooms Total: 5

Building Interior

  • Above Grade Finished Area: 3390
  • Below Grade Finished Area: 1076
  • Building Area Source: Builder
  • Building Area Total: 4871

General Information

  • Appliances: Bar Fridge,Convection Oven,Cooktop,Dishwasher,Disposal,Gas Water Heater,Microwave,Oven,Range Hood,Self Cleaning Oven,Sump Pump,Tankless Water Heater
  • Cooling: Central Air
  • Electric: 220 Volts
  • Entry Location: Ground
  • Fireplace Features: Gas,Gas Log,Great Room
  • Fireplaces Total: 1
  • Flooring: Carpet,Tile,Wood
  • Foundation Details: Slab
  • Heating: Forced Air,Natural Gas
  • Interior Features: Built-in Features,Ceiling Fan(s),Eat-in Kitchen,Entrance Foyer,Five Piece Bath,High Ceilings,Kitchen Island,Open Floorplan,Pantry,Primary Suite,Quartz Counters,Walk-In Closet(s)
  • Laundry Features: In Unit
  • Levels: Two
  • Living Area: 4466
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Window Features: Double Pane Windows,Egress Windows,Window Coverings

Exterior

Parking Information

  • Parking Features: Concrete,Dry Walled,Finished Garage,Insulated Garage,Lighted,Oversized,Oversized Door,Smart Garage Door,Storage
  • Parking Total: 3

Lot Information

  • Lot Size Acres: 0.16
  • Lot Size Area: 7113
  • Lot Size Square Feet: 7113
  • Lot Size Units: Square Feet
  • Road Responsibility: Public Maintained Road
  • Road Surface Type: Paved
  • Water Source: Public

Waterfront/View

  • View: Mountain(s)

Building Exterior/Construction

  • Architectural Style: Mid-Century Modern
  • Attached Garage: true
  • Construction Materials: Frame,Stone,Wood Siding
  • Direction Faces: West
  • Patio And Porch Features: Covered,Deck,Front Porch,Patio
  • Roof: Shingle
  • Structure Type: House

General Information

  • Carport Spaces: 0
  • Exterior Features: Lighting,Private Yard,Rain Gutters
  • Road Frontage Type: Public
  • Sewer: Public Sewer
  • Utilities: Cable Available,Electricity Available,Electricity Connected,Natural Gas Available,Natural Gas Connected,Phone Available

Room Information

Room: Bathroom Three Quarter

  • Level: Basement
  • Description: Bathroom 5, Standing shower, sink, toilet

Room: Bedroom

  • Level: Basement
  • Description: Bedroom 4, Walk-in closet

Room: Bonus Room

  • Level: Basement
  • Description: Spacious living area

Room: Game Room

  • Level: Basement
  • Description: Game room, adjacent to wet bar

Room: Kitchen

  • Level: Basement
  • Description: Beautifully designed wet bar, perfect for entertaining

Room: Media Room

  • Level: Basement
  • Description: Game room, adjacent to wet bar

Room: Utility Room

  • Level: Basement
  • Description: Unfinished mechanical room

Room: Utility Room

  • Level: Basement
  • Description: Unfinished storage

Room: Bathroom Full

  • Level: Main
  • Description: Bathroom 4, Standing shower, sink, toilet

Room: Bedroom

  • Level: Main
  • Description: Bedroom 5 or flex office space, walk-in closet

Room: Dining Room

  • Level: Main
  • Description: Great natural lighting, adjacent to back covered patio

Room: Great Room

  • Level: Main
  • Description: Beautiful great room, high ceilings, fireplace

Room: Kitchen

  • Level: Main
  • Description: Extra large pantry, island, oven/microwave combo, stainless JennAir appliances, quartz countertops

Room: Mud Room

  • Level: Main
  • Description: Access from garage, mud room, bag drop, bench, hooks and closet

  • Level: Upper
  • Description: Spacious, Ensuite bathroom, walk-in closet, private balcony, connected to laundry

  • Level: Upper
  • Description: Tile floors, double vanity, free standing tub, shower enclosure, toilet

Room: Bathroom Full

  • Level: Upper
  • Description: Bathroom 3, Tub/shower combo, sink, toilet

Room: Bathroom Three Quarter

  • Level: Upper
  • Description: Bathroom 2, Standing shower, sink, toilet

Room: Bedroom

  • Level: Upper
  • Description: Bedroom 3, Standard closet

Room: Bedroom

  • Level: Upper
  • Description: Bedroom 2, Walk-in closet with ensuite bathroom

Room: Laundry

  • Level: Upper
  • Description: Convenient upper level laundry room, wash sink, connected to primary bedroom

Room: Loft

  • Level: Upper
  • Description: Open concept loft with front balcony. GREAT VIEWS!

945 Saint Andrews Lane Neighborhood

Community

80027 (SUPERIOR) Demographics

39
Median Age
1,666
Population Density (per sq. mile)
78%
College Educated
$117,618
Estimated Median Income
8,111
Estimated Total Home Owners
3,833
Estimated Total Renters
68% / 32%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

945 Saint Andrews Lane Monthly Cost

$
$ %
%
$
$
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

945 Saint Andrews Lane Market Data

Based on the last 30 days in this zip code

$1,023,768
Average List Price
$383
Average Price per Square Foot
46
Properties Sold
95
Average Days on Market
208
Properties for Sale
Calculations provided by Reliance Network

945 Saint Andrews Lane History

Date Event Value Agent
7/31/2025Source: REColorado MLS Price Increase
$2,099,999 15.1%
7/31/2025Source: REColorado MLS Price Increase
$2,191,450 4.4%
4/7/2025Source: REColorado MLS Price Reduction
$1,825,000 -1.4%
2/10/2025Source: REColorado MLS Added to Database
February 10, 2025
12/19/2024Source: REColorado MLS Added to Database
December 19, 2024