Date
Details
Price
Change
Source
12/18/2024
Sold
$415,000
—
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/44
$2,149,774 New to Website
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/44
Property Description
Welcome to an exceptional new-construction residence in Louisville's coveted Coal Creek Ranch, where elevated design, thoughtful craftsmanship, and effortless livability come together. Built by Sheffield Homes in 2026, this striking 5-bedroom, 5-bath home offers 4,466 finished square feet across three beautifully designed levels, with mountain and plains views as a memorable backdrop. The main level makes an immediate impression with wide-plank wood flooring, high ceilings, designer lighting, and an open layout created for sophisticated everyday living and entertaining. At its heart, the gourmet kitchen showcases custom cabinetry, quartz surfaces, a statement range hood, premium appliances, and an oversized waterfall island. The adjoining dining area features custom built-ins and opens through expansive glass doors to the outdoor living space, while the living room is anchored by a dramatic floor-to-ceiling gas fireplace. A main-level bedroom or office and designer ¾ bath add exceptional versatility. Upstairs, the primary suite is a true retreat, complete with a private deck and a spa-inspired five-piece bath featuring dual vanities, an oversized walk-in shower with built-in bench, freestanding soaking tub, and generous closet space. Two additional bedrooms, beautifully finished baths, a versatile loft, and an impressive laundry room with extensive cabinetry and utility sink complete the upper level. The finished basement expands the experience with an oversized recreation room, guest bedroom, ¾ bath, and flexible bonus space. Outside, enjoy covered patio and deck spaces, a private yard, and nearby greenbelt surroundings. The oversized finished 3-car garage includes EV-ready capability. Coal Creek Ranch amenities include a pool, clubhouse, parks, playground, tennis courts, and trails-all moments from the lifestyle and charm of Louisville. A remarkable opportunity to experience brand-new luxury, exceptional design, and Colorado living at its finest.
Full Property Details
Full Property Details for 945 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: $2,149,774
- HOA FEE: $43/month
- HOA FEE FREQ.: Annually
- Taxes: $8,000 (2025)
- Status: Active
- Type: Single Family
- Source: MetroList_Colorado
- MLS ID: 6013274
- Updated: 9/18/2026
- Added to Site: 3 day(s) ago
Interior
- Interior Features: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, High Ceilings, High Speed Internet, In-Law Floorplan, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Smoke Free, Solid Surface Counters, Walk-In Closet(s)
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Gas, Gas Log, Living Room, Gas, Gas Log, Living Room, Gas, Gas Log, Living Room
- Appliances: Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Microwave, Oven, Range Hood, Refrigerator, Self Cleaning Oven, Sump Pump, Washer, Wine Cooler
- Furnishings: Unfurnished
- Flooring: Carpet, Tile, Wood
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 3
- 3/4 Bathrooms: 2
- Main Floor Baths: 1
- Basement Baths: 1
Bedrooms
- Total Bedrooms: 5
- Bedrooms Main: 1
Other Rooms
- Laundry: Sink, Laundry Closet
Additional Information
- Shared Amenities: Clubhouse, Garden Area, Park, Parking, Playground, Pool, Tennis Court(s), Trail(s)
- Security/Safety: Carbon Monoxide Detector(s), Smoke Detector(s)
Exterior
- Exterior Features: Balcony, Lighting, Private Yard, Rain Gutters
- Porch/Patio/Deck: Covered, Deck, Patio
Parking
- Garage: Yes
- Garage Spaces: 3
- Total Spaces: 3
- Parking Features: Concrete, Dry Walled, Electric Vehicle Charging Station(s), Finished Garage, Insulated Garage, Lighted, Oversized, Smart Garage Door, Storage
Location
- County: Boulder
- Subdivision: Coal Creek Ranch
- Direction Faces: North
- Dist. to Public Trans.: 2 Miles
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 HOA
- Assoc. Fees Include: Reserves, Recycling, Trash
- Pets Allowed: Yes
- Management Type: Professionally Managed
Heating & Cooling
- Cooling Type: Central Air, Other
- Heating Type: Forced Air, Natural Gas
Utilities
- Gas: Yes
- Sewer: Public Sewer
- Water: Public
- Utility Description: Cable Available, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available
Structural Information
- Architectural Style: Traditional
- Structure Type: House
- Builder: Sheffield Homes
- Model: 3390
- Construction: Cement Siding, Frame, Stone
- Basement: Yes
- Basement Desc.: Bath/Stubbed, Finished, Full, Interior Entry, Sump Pump
- Roof: Composition
- Windows: Double Pane Windows, Egress Windows, Window Coverings
- Square Feet: 4,821
- Sq. Ft. Source: Builder
- Living Area: 4,466 Sq. Ft.
- Year Built: 2026
- Property Condition: New Construction
Lot Features
- Property View: Mountain(s), Plains
- Mountain views: Yes
- Lot Size (Acres): 0.16
- Lot Size (Sq. Ft.): 7,113
- Frontage: Public
- Street/Road Desc.: Paved
- Road Maintenance: Public Maintained Road
- Fence: Yes
- Lot Features: Foothills, Greenbelt, Irrigated, Landscaped, Level, Master Planned, Near Public Transit, Sprinklers In Front, Sprinklers In Rear
- Trees/Vegetation: Grassed
- Zoning: RES
- Fencing (Description): Partial
Green Features
- Energy Efficient: Construction, Exposure/Shade, Insulation, Roof, Windows
Financial Considerations
- Association Fee: Yes
- Association Fee: $519
- Assoc Fee Freq.: Annually
- Assoc Fee /Annual: $519
- Tax Amount: $8,000
- Tax Year: 2025
- Terms: Cash, Conventional, Jumbo, VA Loan
Disclosures and Reports
- Ownership: Builder
- Special Conditions: None
- Documents Avail.: Building Plans, HOA Docs Available, Legal Description, Soil Report
- Legal Description: LOT 98 COAL CREEK RANCH FLG 3 REPLAT A
- Exclusions: Staging Furniture and accessories
- Property ID: R0109248
Listed by Real Broker, LLC DBA Real
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 945 St Andrews Ln —
Real Broker, LLC DBA Real
Real Broker, LLC DBA Real
amanda@amandadivito.com,303-565-2399
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 945 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.5 mi |
Monarch High School 329 Campus Drive, Louisville, CO 80027 | 9-12 | 0.6 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 945 St Andrews Ln
Tax History
Tax History for 945 St Andrews Ln
Year
Property Taxes
Change
Tax Assessment
Change
2025
$3,116
—
$31,365
-10%
2025
$3,116
38%
$34,850
39%
2024
$2,254
2%
$25,078
-13%
2023
$2,216
81%
$28,763
128%
2022
$1,224
-80%
$12,590
-81%
2021
$5,980
—
$64,571
11%
2021
$5,980
11%
$58,230
—
2019
$5,372
15%
$58,230
12%
2018
$4,664
2%
$52,200
—
2017
$4,571
4%
$52,200
5%
2016
$4,387
6%
$49,862
—
2015
$4,158
11%
$49,862
17%
2014
$3,736
2%
$42,745
—
2013
$3,655
—
$42,745
—
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 945 St Andrews Ln
Home Warranty : Included
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 8 days ago
- 5Beds
- 5Total Baths
- 4,871Sq. Ft.
- MLS # 1063957
Listed by Real
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 5Total Baths
- 4,699Sq. Ft.
- MLS # 1068422
Listed by Westwater Realty
- Single Family
- Active
- 5Beds
- 5Total Baths
- 4,545Sq. Ft.
- MLS # 1061976
Listed by RE/MAX of Boulder, Inc
- Single Family
- Active
- 5Beds
- 5Total Baths
- 4,069Sq. Ft.
- MLS # 1068030
Listed by milehimodern - Boulder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Townhouse
- Active
- Updated 3 days ago
- 3Beds
- 4Total Baths
- 1,963Sq. Ft.
- MLS # 7044324
Listed by New Door Group (303) 859-6891
- Townhouse
- Active
- Updated 3 days ago
- 3Beds
- 4Total Baths
- 2,095Sq. Ft.
- MLS # 6317684
Listed by New Door Group (303) 859-6891
- Townhouse
- Active
- Updated 4 days ago
- 3Beds
- 3Total Baths
- 1,622Sq. Ft.
- MLS # 6805415
Listed by RE/MAX Professionals
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 2Total Baths
- 1,858Sq. Ft.
- MLS # 1068984
Listed by Real Realty Colorado
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
- 2,506Sq. Ft.
- MLS # 1066437
Listed by The Bernardi Group (303) 402-6000
- Townhouse
- Active
- Updated 3 days ago
- 3Beds
- 3Total Baths
- 1,624Sq. Ft.
- MLS # 3088232
Listed by HomeSmart
- Single Family
- Active
- Updated 4 days ago
- 2Beds
- 1Total Bath
- 968Sq. Ft.
- MLS # 1067721
Listed by RE/MAX of Boulder, Inc
- Townhouse
- Active
- Updated 4 days ago
- 2Beds
- 3Total Baths
- 1,480Sq. Ft.
- MLS # 1060416
Listed by Compass - Boulder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 5Beds
- 4Total Baths
- 5,146Sq. Ft.
- MLS # 1054360
Listed by Westwater Realty
- Single Family
- Closed
- 5Beds
- 4Total Baths
- 4,493Sq. Ft.
- MLS # 1053553
Listed by West and Main Homes
- Single Family
- Closed
- 6Beds
- 5Total Baths
- 4,270Sq. Ft.
- MLS # 1053196
Listed by CORE Residential
Sold by CORE Residential
Sold by CORE Residential
- Single Family
- Closed
- 3Beds
- 3Total Baths
- 2,969Sq. Ft.
- MLS # 1047636
Listed by CORE Residential
Sold by RE/MAX Alliance-Boulder
Sold by RE/MAX Alliance-Boulder
945 Saint Andrews Lane, Louisville, CO 80027 (MLS# 6013274) is a Single Family property with 5 bedrooms, 3 full bathrooms and 2 partial bathrooms. 945 Saint Andrews Lane is currently listed for $2,149,774 and was received on September 18, 2026. Want to learn more about 945 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.