970.232.4844
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Louisville » 80027 » 964 Saint Andrews Ln, Louisville, CO, 80027
$1,899,999

964 Saint Andrews Ln, Louisville, CO, 80027

5 Beds
4 Baths
3,632 Square Feet

Open House

February 27 4:00 pm - 6:00 pm

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.
Offered By
Heather Slump, Rhae Group Realty

Property Details

Property Type Residential
Status Coming Soon
Bedrooms 5
Bathrooms (Full) 3
Property Sub Type Single Family Residence
Square Feet 3,632
MLS # 8979532
Bathrooms (Half) 1

Market Trends

New Properties On Market
39
1200% Increase In New Listings
Average Asking Price
$912,200
$5,867 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$429
$78 Increase In List Price/Sq. Ft.
Average Days On Market
21
41 Day Decrease In Days On Market
Data as of Feb 25, 2026. Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 31, 2026.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance