Date
Details
Price
Change
Source
6/27/2025
Sold
$1,952,800
—
Public Record
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/48
$1,899,999 Coming Soon
Get directions
View more dates
Join us at 964 Saint Andrews Lane on:
- Open House: 10:00 AM - 1:00 PM
Saturday 2/28 10:00 AM - 1:00 PM
964 Saint Andrews Lane,Louisville, CO 80027964 Saint Andrews LaneLouisvilleCO80027 - Open House: 1:00 PM - 4:00 PM
Sunday 3/1 1:00 PM - 4:00 PM
964 Saint Andrews Lane,Louisville, CO 80027964 Saint Andrews LaneLouisvilleCO80027
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/48
Property Description
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.
Full Property Details
Full Property Details for 964 St Andrews Ln
Sign in to view more details. Local MLS Rules require you to be signed in. Not a member yet? Sign up now.
General
- Price: $1,899,999
- HOA FEE: $61/month
- Taxes: $6,451 (2025)
- Status: Coming Soon
- Type: Single Family
- Source: MetroList_Colorado
- MLS ID: 8979532
- Updated: 2/25/2026
- Added to Site: Today
Interior
- 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)
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Living Room, Living Room, Living Room
- Appliances: Convection Oven, Dishwasher, Disposal, Dryer, Microwave, Range, Range Hood, Refrigerator, Tankless Water Heater, Washer
- Flooring: Carpet, Tile, Wood
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
- Main Floor Baths: 1
- Basement Baths: 1
Bedrooms
- Total Bedrooms: 5
Other Rooms
- Laundry: Sink
Additional Information
- Shared Amenities: Clubhouse, Golf Course, Pool, Tennis Court(s), Trail(s)
Exterior
- Porch/Patio/Deck: Covered, Deck, Front Porch, Patio
Parking
- Garage: Yes
- Garage Spaces: 4
- Total Spaces: 4
- Parking Features: 220 Volts, Electric Vehicle Charging Station(s)
Location
- County: Boulder
- Subdivision: Coal Creek Ranch
School Information
- Elem School District: Boulder Valley RE 2
- Midd School District: Boulder Valley RE 2
- High School District: Boulder Valley RE 2
- Elementary School: Monarch K-8
- Middle School: Monarch K-8
- High School: Monarch
Community
- Association: Yes
- Assoc. Name: Coal Creek Ranch
- Assoc. Fees Include: Reserves, Recycling, Trash
- Pets Allowed: Yes
- Management Type: Professionally Managed
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- Structure Type: House
- Construction: Frame
- Basement: Yes
- Basement Desc.: Finished, Full, Walk-Out Access
- Roof: Composition
- Square Feet: 3,632
- Sq. Ft. Source: Public Records
- Living Area: 3,632 Sq. Ft.
- Year Built: 2025
Lot Features
- Lot Size (Acres): 0.19
- Lot Size (Sq. Ft.): 8,276
- Fence: Yes
- Lot Features: Landscaped, Sprinklers In Front, Sprinklers In Rear
- Fencing (Description): Full
Financial Considerations
- Association Fee: Yes
- Association Fee: $61
- Assoc Fee Freq.: Monthly
- Assoc Fee /Annual: $732
- Tax Amount: $6,451
- Tax Year: 2025
- Terms: Cash, Conventional, Jumbo, VA Loan
Disclosures and Reports
- Ownership: Individual
- Special Conditions: None
- Legal Description: LOT 128 COAL CREEK RANCH FLG 3 REPLAT A
- Exclusions: Staging Items
- Property ID: R0109278
Listed by Rhae Group Realty
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 964 St Andrews Ln —
Rhae Group Realty
Rhae Group Realty
heather@rhaegroup.com,720-390-8705
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 964 St Andrews Ln
School District:Boulder Valley School District Re-2
| Name | Grades | Distance |
|---|---|---|
Monarch K-8 School 263 Campus Drive, Louisville, CO 80027 | 6-8 | 0.4 mi |
Monarch High School 329 Campus Drive, Louisville, CO 80027 | 9-12 | 0.5 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 964 St Andrews Ln
Tax History
Tax History for 964 St Andrews Ln
Year
Property Taxes
Change
Tax Assessment
Change
2025
$6,451
136%
$66,309
118%
2024
$2,728
2%
$30,351
-11%
2023
$2,682
-44%
$34,036
-42%
2021
$4,747
279%
$58,408
349%
2022
$1,251
-74%
$12,997
-75%
2021
$4,747
6%
$51,488
3%
2018
$4,471
-6%
$50,040
-3%
2019
$4,750
8%
$51,488
3%
2017
$4,382
9%
$50,040
10%
2016
$4,018
5%
$45,674
—
2015
$3,809
7%
$45,674
12%
2014
$3,575
2%
$40,907
—
2013
$3,497
—
$40,907
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 964 St Andrews Ln
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 13 days ago
- 5Beds
- 4Total Baths
- 4,188Sq. Ft.
- MLS # 1051467
Listed by CORE Residential
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 4Total Baths
- 3,127Sq. Ft.
- MLS # 1825763
Listed by Compass - Denver
- Single Family
- Active
- Updated 5 days ago
- 6Beds
- 4Total Baths
- 3,414Sq. Ft.
- MLS # 1049750
Listed by Keller Williams-Preferred Rlty
- Single Family
- Active
- 6Beds
- 4Total Baths
- 4,150Sq. Ft.
- MLS # 9932905
Listed by HomeSmart Realty
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 1 day ago
- 2Beds
- 2Total Baths
- 2,080Sq. Ft.
- MLS # 1052242
Listed by Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Boulder
- Office
- Active
- Updated 1 day ago
- MLS # 1052290
Listed by The Colorado Group
- Townhouse
- Active
- Updated 5 days ago
- 3Beds
- 4Total Baths
- 1,568Sq. Ft.
- MLS # 6855989
Listed by Compass - Denver
- Lots/Land
- Active
- Updated 1 day ago
- 0.16Acres
- MLS # 1052244
Listed by Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Boulder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 3Total Baths
- 3,256Sq. Ft.
- MLS # 7163792
Listed by New Door Group (303) 859-6891
- Townhouse
- Active
- Updated 10 hours ago
- 3Beds
- 3Total Baths
- 1,637Sq. Ft.
- MLS # 1049562
Listed by Duane Penny (970) 290-2220
- Single Family
- Active
- Updated 1 day ago
- 3Beds
- 3Total Baths
- 4,343Sq. Ft.
- MLS # 9761284
Listed by Landmark Residential Brokerage
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 5Total Baths
- 4,549Sq. Ft.
- MLS # 3228618
Listed by Landmark Residential Brokerage
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 5Beds
- 3Total Baths
- 4,148Sq. Ft.
- MLS # 1035663
Listed by RE/MAX of Boulder, Inc
- Single Family
- Closed
- 4Beds
- 4Total Baths
- 3,838Sq. Ft.
- MLS # 1032340
Listed by Meade Builder Services, LLC and Compass - Boulder
- Single Family
- Closed
- Updated 12 days ago
- 6Beds
- 6Total Baths
- 7,135Sq. Ft.
- MLS # 1033624
Listed by Staufer Team Real Estate
Sold by Rhae Group Realty
Sold by Rhae Group Realty
- Single Family
- Closed
- Updated 7 days ago
- 4Beds
- 4Total Baths
- 3,769Sq. Ft.
- MLS # 1034187
Listed by RE/MAX Elevate
Sold by Compass - Boulder
Sold by Compass - Boulder
964 Saint Andrews Lane, Louisville, CO 80027 (MLS# 8979532) is a Single Family property with 5 bedrooms, 3 full bathrooms and 1 partial bathroom. 964 Saint Andrews Lane is currently listed for $1,899,999 and was received on February 25, 2026. Want to learn more about 964 Saint Andrews Lane? Do you have questions about finding other Single Family real estate for sale in Louisville? You can browse all Louisville real estate or contact a Coldwell Banker agent to request more information.