Prevu by reAlpha
BuySellBlogBrowse Listings

964 Saint Andrews LaneLouisville, CO 80027

For Sale

$1,899,999

Smart Buyer Rebate $19,000

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 natural light and frame sweeping mountain vistas. White oak flooring spans the level, complemented by designer lighting, custom blinds, and a striking gas fireplace. Eco-conscious features include owned solar panels with a microgrid system for backup power, high-efficiency HVAC, R23 insulation, an instant hot water heater, and a fresh-air HRV system.
At the heart of the home is the gourmet kitchen with high-end appliances including a built-in Sub-Zero refrigerator, 42-inch custom cabinetry, a walk-in pantry, and a spacious center island. Entertaining flows seamlessly onto the oversized deck with breathtaking views.
Just off the main living space is a private office with french doors, a half bath, and a mudroom connecting to the oversized 4-car garage.
The upper level features a stunning primary suite with incredible views, dual closets, and a luxurious five-piece bath with heated floors, plus direct access to the laundry room. Two additional bedrooms and a full hall bath complete this level.
The walk-out basement is filled with natural light and features a spacious family room perfect for movie nights, game days, or multi-generational living. This level also includes two additional bedrooms, a full bath, and extra laundry hookups, offering flexible living options.
Outside, enjoy a landscaped and fenced backyard with grassy areas, a large deck, and a patio perfect for outdoor living. Residents also enjoy access to community amenities including an outdoor pool, clubhouse, tennis courts, and scenic community trails. Close proximity to highway 36 with easy access to Boulder, Denver and DIA

Listed by Heather Slump

·

License #065463

·

Rhae Group Realty

·

720-390-8705

Listed by Rhae Group

·

License #65463T

·

Rhae Group Realty

Last updated March 15, 2026

·

Source: REcolorado #8979532

Listing Facts

  • TypeSingle-family
  • NeighborhoodCoal Creek
  • Bedrooms5
  • Bathrooms4
  • Days on Prevu17
  • HOA/Maint. Fees$61/month
  • Taxes$6,451/year
  • Size3,632 sqft
  • Price per sqft$523

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Washer/Dryer
  • Air Conditioning
  • Parking
  • Swimming Pool

Location

Mortgage Calculator

Listing History

02/27/2026
Listed by Rhae Group Realty
$1,899,999

Property Details for 964 Saint Andrews Lane

Association

Amenities

  • Association Amenities: Clubhouse, Golf Course, Pool, Tennis Court(s), Trail(s)

Fees

  • Association Fee: $61.00 Monthly
  • Association Fee Includes: Reserves, Recycling, Trash

General

  • Association Name: Coal Creek Ranch

Exterior

Construction

  • Roof: Composition
  • Structure Type: House
  • Year Built: 2025
  • Construction Materials: Frame

Features

  • Fencing: Full
  • Patio And Porch Features: Covered, Deck, Front Porch, Patio

Measurements

  • Building Area Total: 3,632
  • Lot Features: Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Acres: 0.19
  • Lot Size Area: 0
  • Lot Size Square Feet: 8,276
  • Lot Size Units: Acres

Financial

Taxes

  • Parcel Number: R0109278
  • Tax Annual Amount: $6,451.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Convection Oven, Dishwasher, Disposal, Dryer, Microwave, Range, Range Hood, Refrigerator, Tankless Water Heater, Washer
  • Fireplace Features: Living Room
  • Fireplaces Total: 1
  • Flooring: Carpet, Tile, Wood
  • Interior 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)

Measurements

  • Living Area: 3,632

Rooms

  • Basement: Finished, Full, Walk-Out Access
  • Has Basement: Yes
  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 5
  • Main Level Bathrooms: 1

Other

General

  • Exclusions: Staging Items

Location

  • Subdivision Name: Coal Creek Ranch

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 4
  • Parking Features: 220 Volts, Electric Vehicle Charging Station(s)
  • Parking Total: 4

Schools

Elementary School

  • Elementary School: Monarch K-8
  • Elementary School District: Boulder Valley RE 2

High School

  • High School: Monarch
  • High School District: Boulder Valley RE 2

Middle or Junior School

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

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Forced Air
  • Laundry Features: Sink
  • Sewer: Public Sewer
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 5 bedrooms and 4 bathrooms in this single-family home at 964 Saint Andrews Lane.

What schools are nearby to 964 Saint Andrews Lane?

Nearby schools include the Monarch K-8 Elementary School, Monarch K-8 Middle School, and Monarch High School.

Does this single-family home have parking?

Yes, there are 4 parking spaces available for 964 Saint Andrews Lane.

What are the annual taxes for 964 Saint Andrews Lane?

Annual taxes for this single-family home are estimated at $6,451.

How does 964 Saint Andrews Lane compare to other single-family homes in Coal Creek?

This single-family home is listed 17% above the average price for single-family homes in Coal Creek and has been on the market for 57 less days than the typical home in this area.

What building or home owners association is the single-family home part of?

This single-family home is part of the Coal Creek Ranch home owners association.

What is the square footage on this single-family home?

According to the MLS, this listing is 3,632 sqft.

964 Saint Andrews Lane is a 5-bedroom, 4-bath single-family home for sale in Louisville CO 80027. Listed on Prevu for 17 days at $1,899,999. This property features 3,632 square feet of living space, located in Coal Creek. The median listing price for single-family homes in this area is $1,595,900. Nearby schools include Monarch K-8 Elementary School, Monarch K-8 Middle School, and Monarch High School. The home offers private outdoor space, dishwasher, air conditioning, parking, swimming pool, and washer/dryer. Browse more single-family home listings in Louisville.

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Prevu are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.