Recently Listed Open House 2/27 4pm - 6pm
964 Saint Andrews Lane
Louisville, CO, 80027 $ 1,899,999
Bedrooms5 Baths3.1 Sq 3,632 Monthly Estimate*
$ 11,699
Listed by Rhae Group Realty
for $1,899,999 with 5 bedrooms and 3 full baths, 1 half bath. This 3,632 square foot home was built in 2025 on a lot size of 0.19.
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.
See more
Open House
2/27/2026 4:00 PM - 6:00 PM
2/28/2026 10:00 AM - 1:00 PM
3/1/2026 1:00 PM - 4:00 PM
964 Saint Andrews Lane Louisville, CO
* Some states or local ordinances may prohibit Open Houses at this time, please confirm with your Weichert agent or local rep to confirm
FeaturesInteriorInterior Amenities 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)
Basement Finished Full Walk-Out Access
Flooring Carpet Tile Wood
Total Fireplaces 1
Fireplace Features Living Room
Basement (Y/N) Y
Above Grade Finished Area 2366
Half Baths 1
1/4 Baths 0
3/4 Baths 0
Laundry Features Sink
Total Bedrooms 5
Below Grade Finished Area 1266
Main Level Bedrooms 0
Main Level Bathrooms 1
Total Baths 4
See more
GeneralSewer Public Sewer
Heating Forced Air
Cooling Central Air
Possession Negotiable
Roof Composition
Appliances Convection Oven Dishwasher Disposal Dryer Microwave Range Range Hood Refrigerator Tankless Water Heater Washer
HOA Fee 61
Garage Spaces 4
Association Fee Includes Reserves Recycling Trash
Patio/Porch Features Covered Deck Front Porch Patio
Construction Materials Frame
Exclusions Staging Items
Year Built 2025
Levels Two
Property Subtype Single Family Residence
Tax Year 2025
Ownership Individual
Assoc Fee Paid Per Monthly
County Boulder
Property Type Residential
Association Amenities Clubhouse Golf Course Pool Tennis Court(s) Trail(s)
HOA Y
Attached Garage Y
Subdivision Name Coal Creek Ranch
Full Baths 3
Status Active
High School Monarch
City Louisville
Association Name Coal Creek Ranch
Senior Community Y/N N
High School District Boulder Valley RE 2
Lot Size Units Acres
Lot Size Square Feet 8276.4
Carport Spaces 0
Listing Terms Cash Conventional Jumbo VA Loan
Elementary School Monarch K-8
Tax Annual Amount 6451
Middle/Junior High School Monarch K-8
Virtual Tour https://mediahaus.aryeo.com/videos/019c8fe9-147b-72cc-96f9-7db34602e69d
Structure Type House
Standard Status Active
Occupancy Type Owner
Middle/Junior School District Boulder Valley RE 2
Elementary School District Boulder Valley RE 2
See more
ExteriorFencing Full
Parking Features 220 Volts Electric Vehicle Charging Station(s)
Lot Features Landscaped Sprinklers In Front Sprinklers In Rear
Water Source Public
Total Parking 4
Lot Size Area 0.19
Building Area Total 3632
Lot Size Acres 0.19
See more
* Excluded FeaturesAffordability Calculator
- Monthly Principal & Interest
- $11,699
- Monthly Property Taxes
- $538
- Monthly Home Insurance
- --
Default based on a 30-year fixed rate of 6.25% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save NearbySingle family listings in Louisville, CO
Average List Price $1,374,873
Percent of Sale Price 28%
About Louisville, CO 20,896 Population
9% Since 2002
$ 100,104 Median Income
43.5 Median Age
33% Households with Children
Trends Information provided by ATTOM Data Solutions.
3043378 Elementary School
1956482 Middle School
Monarch High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 2/25/2026 | $1,899,999 | | Listed Price |