174 S Hoover Avenue, Louisville, CO 80027 (MLS # 4146170)
|
Discover a beautifully reimagined contemporary home in one of Louisville's most desirable locations "” less than one mile to Old Town, with convenient access to community parks and nearby trails. A two-year-new exterior and stamped concrete, west facing driveway create standout curb appeal, setting the tone for the quality found throughout. Inside, maple hardwood floors, raised ceilings, and an open floor plan create a light-filled and welcoming layout. Level 5 smooth wall finishes provide a sleek, modern aesthetic, while the marble tetris stone fireplace in the living room offers warmth and architectural elegance. Custom railings and a floating staircase lead to a statement kitchen featuring Bosch appliances, a Verona 36-inch stove and spacious island plus dining area with a deck. The lower level family room features built-in cabinetry, and a stylish bar area with a secondary electric fireplace and tile surround. The home blends luxury with function, including a washer and dryer with custom cabinetry and quartz countertops, newer black-on-black Pella windows and exterior doors(except for the slider), an energy-efficient furnace, A/C, and tankless water heater, upgraded electrical panel, and a spacious utility room perfect for storage or a potential workshop. The oversized two-car garage includes Bluetooth-enabled doors, a professionally coated garage floor and EV charging outlet. Roof warranty bonus "” approximately three years remain on a five-year Roof Maxx coating warranty. Outdoor spaces are equally impressive with professional landscaping, irrigation system, backyard artificial turf, a fenced yard, backyard awning, front porch stonework and fence. Additional updates include removal of the cast-iron sewer line, leaf guards on gutters, and a retiled primary shower floor. This thoughtfully curated property blends craftsmanship, design, and convenience in an exceptional Louisville setting "” a truly rare offering.
| DAYS ON MARKET | 1 | LAST UPDATED | 1/9/2026 |
|---|---|---|---|
| TRACT | Centennial Valley 1 & Amd | YEAR BUILT | 1982 |
| GARAGE SPACES | 2.0 | COUNTY | Boulder |
| STATUS | Active | PROPERTY TYPE(S) | Single Family |
| Elementary School | Louisville |
|---|---|
| Jr. High School | Louisville |
| High School | Monarch |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Cooktop, Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator, Self Cleaning Oven |
| BASEMENT | Full, Yes |
| CONSTRUCTION | Frame, Stucco |
| EXTERIOR | Private Yard |
| GARAGE | Yes |
| HEAT | Forced Air |
| INTERIOR | Breakfast Bar |
| LOT | 7841 sq ft |
| LOT DESCRIPTION | Corner Lot |
| PARKING | Concrete, Attached |
| SEWER | Public Sewer |
| STORIES | Split/Multi Level |
| STYLE | Contemporary |
| SUBDIVISION | Centennial Valley 1 & Amd |
| TAXES | 5468 |
| WATER | Public |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Tower
Team to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Beth Ann Mott, Berkshire Hathaway HomeServices Colorado Real Estate, LLC
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Compass are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
© 2011-2026 REcolorado® - All Rights Reserved. Disclaimer
© 2011-2026 REcolorado® - All Rights Reserved. Disclaimer
This IDX solution is (c) Diverse Solutions 2026.
