Archer Mountain Properties

Save
Ask
Tour
Hide
Share
$1,999,000
3 Days On Site

964 Saint Andrews Ln
Louisville, CO 80027

For Sale|Single Family Residence|Active
4
Beds
3
Full Baths
1
Partial Bath
3,464
SqFt
$577
/SqFt
2025
Built
Subdivision:
Coal Creek Ranch Flg 3
County:
Boulder
Call Now: 720.523.3624
Is this the home for you? We can help make it yours.
720.523.3624
964 Saint Andrews Ln964 Saint Andrews Ln964 Saint Andrews Ln964 Saint Andrews Ln
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$9,120
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

Easy access to Boulder or Denver, and most importantly, just a quick bike ride to some of Louisville's favorite eateries like Bao for sushi, or Taco Lu for patio fun. This luxury NET ZERO home is thoughtfully designed with an open concept and five spacious bedrooms plus four luxurious bathrooms. Step inside to discover a bright and airy Great Room, accentuated by large windows that flood the home with natural light and frame the views of the Foothills. You'll appreciate the eco-friendly components, including owned SOLAR PANELS, a high efficiency HVAC system, R23 insulation, an instant hot water heater, and a fresh-air HRV system - just a few of the features that help this home exceed the 2021 energy standards. With 3/4" White Oak flooring on the entire main level, designer lighting throughout, and a beautiful gas fireplace, you'll love the flow that leads to the heart of the home, the gourmet kitchen! This chef's delight features high-end stainless steel Kitchen Aid appliances, 42" custom cabinetry, a walk-in pantry, and a spacious center island that makes this space perfect for entertaining. Gatherings will flow over onto the large deck where you can gaze at the Flatirons. The main level includes an office with French doors, a large half-bathroom and a "mud room" space off the garage, which happens to be one of the largest in this neighborhood! The walk-out basement includes two additional bedrooms, a full bathroom and offers a large finished space for a recreation room, home theater, or exercise area. Outside, the property boasts a fenced backyard with grassy areas and the property is fully landscaped. Enjoy access to community amenities, including an outdoor pool, Clubhouse, tennis courts and access to community trails, perfect for enjoying Colorado's beautiful weather. We can't say enough great things about this home and we have several houses to choose from!

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,999,000
Days On Site 
3 Days
Bedrooms 
4
Inside Area (SqFt) 
3,464 sqft
Total Baths 
4
Full Baths 
3
Partial Baths 
1
Lot Size 
0.18 Acres
Year Built 
2025
MLS® Number 
1034383
Status 
Active
Property Tax 
$2,728
HOA/Condo/Coop Fees 
$59.92 monthly
Sq Ft Source 
Plans
Friends & Family
Recent Activity
yesterdayListing updated with changes from the MLS®
3 days agoListing first seen on site
General Features
Acres 
0.18
Additional Property Use 
Single Family
Attached Garage 
Yes
Direction Faces 
South
Garage 
Yes
Garage Spaces 
3
Green Energy Efficient 
HVACThermostat
Number Of Stories 
2
Parking 
Garage Door OpenerOversizedAttached
Property Condition 
New Construction
Property Sub Type 
Single Family Residence
Security 
Smoke Detector(s)
SqFt Above 
2333
SqFt Below 
1269
SqFt Total 
2333
Stories 
Two
Style 
Contemporary/Modern
Utilities 
Natural Gas AvailableElectricity AvailableCable Available
Water Source 
PublicCistern
Zoning 
R
Interior Features
Appliances 
Double OvenDishwasherDisposalOven
Basement 
Partially FinishedWalk-Out AccessDaylightSump Pump
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
GasLiving Room
Heating 
Forced Air
Interior 
High Speed InternetEat-in KitchenOpen FloorplanPantryWalk-In Closet(s)Kitchen IslandHigh CeilingsCathedral Ceiling(s)
Laundry Features 
Upper Level
Window Features 
Double Pane Windows
Bedroom 2 
Dimensions - 13x13Level - UpperArea - 169Description - Carpet
Bedroom 3 
Dimensions - 11x14Level - UpperArea - 154Description - Carpet
Bedroom 4 
Dimensions - 11x13Level - BasementArea - 143Description - Carpet
Bedroom 5 
Dimensions - 11x13Level - BasementArea - 143Description - Carpet
Dining Room 
Dimensions - 20x12Level - MainArea - 240Description - Hardwood
Great Room 
Dimensions - 20x20Level - MainDescription - Hardwood
Kitchen 
Dimensions - 13x20Level - MainArea - 260Description - Hardwood
Laundry 
Dimensions - 6x9Description - Tile
Master Bathroom 
Description - Full Primary Bath,Tub+Shower Primary,Luxury Features Primary Bath,5 Piece Primary Bath
Master Bedroom 
Dimensions - 19x13Level - UpperArea - 247Description - Hardwood
RecRoom 
Dimensions - 16x31Level - BasementDescription - Carpet
Study 
Dimensions - 11x13Level - Main
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Stone
Exterior 
LightingBalcony
Fencing 
FencedWood
Lot Features 
Sloped
Patio And Porch 
PatioDeck
Road Frontage 
City Street
Roof 
Composition
View 
Mountain(s)
Waterview 
Mountain(s)
Windows/Doors 
Double Pane Windows
Community Features
Association Dues 
719
Community Features 
ClubhouseTennis Court(s)Pool
Financing Terms Available 
CashConventional
HOA Fee Frequency 
Annually
MLS Area 
Louisville
Roads 
PavedAsphalt
School District 
Boulder Valley Dist RE2
Schools
School District
Boulder Valley Dist RE2
Elementary School
Monarch
Middle School
Monarch
High School
Monarch
Listing courtesy of Meade Builder Services, LLC


Compensation information displayed on listing details is only applicable to other participants and subscribers of the source MLS.

Information source: Information and Real Estate Services, LLC. Information deemed reliable but not guaranteed by the MLS. Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Provided for limited non-commercial use only under IRES Rules © Copyright IRES. Digital Millenium Copyright Act

Last checked 2025-05-20 01:24 PM MST.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share