New Listing

945 saint andrews ln, Louisville, CO 80027

$2,149,774

5 BEDS 5 BATHS
4,821 SQFT0.15 AC LOT
Residential - Single Family
New Listing
Image 1: Dream Home! Virtually Landscaped
Image 2: Virtually Landscaped
Image 3: Refined living room with floor-to-ceiling fireplace surround.
Image 4: Living room with fireplace and backyard views.
Bedrooms 5
Total Baths 5
Full Baths 3
Square Feet 4821
Acreage 0.16
Status Active
MLS # 6013274
County Boulder
More Info
Category Residential - Single Family
Status Active
Square Feet 4821
Acreage 0.16
MLS # 6013274
County Boulder
Listed By: Listing Agent Amanda DiVito Parle
Real Broker, LLC DBA Real - (303) 565-2399
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 3/4 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, 3/4 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.

Exterior Features

  • Style In-Law Area
  • Construction Single Family Residence
  • Siding Frame, Stone, Composition
  • Exterior Sprinkler System, Balcony, Oversized Garage
  • Roof Composition
  • Garage Yes
  • Garage Description Attached
  • Water Public
  • Sewer Public Sewer
  • Lot Description Level, Abuts Private Open Space, House Faces North, Paved, Gutters

Interior Features

  • Appliances Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal, Fire Alarm
  • Heating Forced Air
  • Cooling Central Air, Ceiling Fan(s)
  • Basement Full, Partially Finished, Slab, Built-In Radon, Sump Pump
  • Fireplaces Description Gas, Gas Log, Living Room, One
  • Living Area 4,821 SQFT
  • Year Built 2026
  • Stories Two

Neighborhood & Schools

  • Subdivision Coal Creek Ranch
  • School Disrict Boulder Valley Dist RE2
  • Elementary School Monarch K-8
  • Middle School Monarch K-8
  • High School Monarch

Financial Information

  • Zoning RES

Listing Information

Listing Provided Courtesy of Real Broker, LLC DBA Real - (303) 565-2399
Listings provided courtesy of the IRESDS MLS as distributed by MLS GRID.

Information is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 09/28/2026 03:27:34 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 IRESDS MLS, Inc.
Listing data is current as of 09/28/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.