$1,899,999

964 Saint Andrews Ln, Louisville, CO 80027

  • 5 beds |
  • 4 baths |
  • 3,632 sqft
  • Property Icon Single-Family Home
  • Property Year Built Icon Built in 2025
  • Property Lot Size Icon8,276sqft lot
  • Property Parking Icon 4 car garage
  • Property Price Per Square Feet Icon $523/sqft
  • Property List Date Icon Listed 8 days ago

Property Description

Located in the highly desirable Coal Creek neighborhood, 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. Close proximity to highway 36 with easy access to Boulder, Denver and DIA

Listing Status:
Active
Data Last Updated:
March 7, 2026 at 6:22AM
Listing Office:
Rhae Group Realty : heather@rhaegroup.com,720-390-8705
Listing Agent:
Heather Slump : 720-390-8705
MLS ID:
8979532
  • General: Cathedral Ceiling(s)Open FloorplanPantryWalk-In Closet(s)Kitchen Island
  • Appliances: DishwasherRefrigeratorWasherDryerMicrowaveDisposal
  • Basement: FullPartially FinishedWalk-Out AccessBuilt-In Radon
  • A/C: Central AirCeiling Fan(s)
  • Heating: Forced Air
  • Fireplace: Living RoomOne
  • General: Sprinkler System
  • Other Structures: DeckPatio
  • Parking: Attached
  • Roofing: Composition
  • General: FrameTwo
  • HOA Amenities: ClubhouseTennis Court(s)PoolTrail(s)Trash61.0Monthly
  • Originating MLS: ires
  • School District: Boulder Valley Dist RE2
  • County: Boulder
  • Fencing: Fenced
  • Water: City
  • Sewer: Public Sewer
  • Source: ires
  • Exclusions: Staging Items

This listing courtesy of Heather Slump , Rhae Group Realty

Monthly Payment

$Est. Payment
  • Principal & Interest $
  • Property Taxes $
  • Home Insurance $
  • VA Funding Fee $

Ready to Start a VA Loan?

Get Started Veterans United Home LoansNMLS #1907  †
Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

M

Monarch PK-8 School

263 Campus Dr, Louisville, CO, 80027

Grades PK-8

0.41 miles away

M

Monarch PK-8 School

263 Campus Dr, Louisville, CO, 80027

Grades PK-8

0.41 miles away

M

Monarch High School

329 Campus Dr, Louisville, CO, 80027

Grades 9-12

0.51 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.

Similar Listings Nearby