Save
Ask
Tour
Hide
Share
$1,899,999
New Listing

964 Saint Andrews Lane
Louisville, CO 80027

For Sale|Single Family Residence|Coming Soon
5
Beds
4
Total Baths
3
Full Baths
1
Partial Bath
3,632
SqFt
$523
/SqFt
2025
Built
Subdivision:
Coal Creek Ranch
County:
Boulder

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: (720) 669-8808
Is this the listing for you? We can help make it yours.
(720) 669-8808
964 Saint Andrews Lane964 Saint Andrews Lane964 Saint Andrews Lane964 Saint Andrews Lane
Save
Ask
Tour
Hide
Share

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, 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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,899,999
Days On Site 
0 Days
Bedrooms 
5
Inside Area (SqFt) 
3,632 sqft
Total Baths 
4
Full Baths 
3
Partial Baths 
1
Lot Size 
0.19 Acres
Year Built 
2025
MLS® Number 
8979532
Status 
Coming Soon
Property Tax 
$6,451
HOA/Condo/Coop Fees 
$61 monthly
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
3 hours agoListing updated with changes from the MLS®
5 hours agoListing first seen on site
General Features
Acres 
0.19
Attached Garage 
Yes
Garage 
Yes
Garage Spaces 
4
Levels 
Two
Parking 
Electric Vehicle Charging Station(s)Attached
Parking Spaces 
4
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
SqFt Above 
2366
SqFt Below 
1266
SqFt Total 
3632
Water Source 
Public
Interior Features
Appliances 
Convection OvenDishwasherDisposalDryerMicrowaveRangeRange HoodRefrigeratorTankless Water HeaterWasher
Basement 
FinishedFullWalk-Out Access
Cooling 
Ceiling Fan(s)Central Air
Fireplace 
Yes
Fireplace Features 
Living Room
Fireplaces 
1
Flooring 
CarpetTileWood
Heating 
Forced Air
Interior 
Ceiling Fan(s)Entrance FoyerHigh CeilingsKitchen IslandOpen FloorplanPantryVaulted Ceiling(s)Walk-In Closet(s)
Laundry Features 
Sink
Bathroom Full 
Level - Upper
Bathroom Half 
Level - Main
Bedroom 
Level - Basement
Family Room 
Level - Basement
Kitchen 
Level - Main
Laundry 
Level - Basement
Living Room 
Level - Main
Office 
Level - Main
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Frame
Fencing 
FencedFull
Lot Features 
LandscapedSprinklers In FrontSprinklers In Rear
Patio And Porch 
CoveredDeckFront PorchPatio
Roof 
Composition
Community Features
Association Amenities 
ClubhouseGolf CoursePoolTennis Court(s)Trail(s)
Association Dues 
61
Financing Terms Available 
CashConventionalVA Loan
HOA Fee Frequency 
Monthly
School District 
Boulder Valley RE 2
Schools
School District
Boulder Valley RE 2
Elementary School
Monarch K-8
Middle School
Monarch K-8
High School
Monarch
Listing courtesy of Rhae Group Realty [email protected]



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 Rhae Group Realty 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.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share