• Sign Up
  • Log In

New Horizons Real Estate

(720) 432-8695
agent@newhorizonsre.com
  • Search
    • All Homes
    • Featured Listings
  • Communities
    • Frederick
    • Erie
    • Longmont
    • Berthoud
    • Johnstown
    • Niwot
    • Louisville
    • Thornton
  • Buying
    • Buying Process
    • Mortgage Calculator
New Horizons Real Estate
 
  • Selling
    • Selling Process
    • Get A Home Valuation
    • Sold Listings
  • About
    • About New Horizons Real Estate
    • Meet The Team
    • Testimonials
  • Blog
  • Contact
  • New Horizons Real Estate(720) 432-8695
    agent@newhorizonsre.com
    Copy Email
  • 7200 S Alton Way STE B120
    Centennial, CO 80112

Explore

  • Property Search
  • Communities
  • Buying
  • Selling

About

  • Contact Us
  • Testimonials
  • Blog
New Horizons Real Estate - Footer Logo
  • Privacy
  • Terms
  • DMCA
  • Accessibility
  • Fair Housing
©2026 New Horizons Real Estate. All rights reserved.
Website built by CloseHack.
Information and Real Estate Services, LLC

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES. Information deemed reliable but not guaranteed by the MLS. The information being provided is for the consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.

$1,500,000
For Sale

174 S Hoover Avenue

Louisville, CO 80027
2582 sqft | 4 beds | 2.5 baths | 0.18 acres | #4146170
  • Save
  • Contact
  • Share
  • Price Change Alerts
Listing OfficeBerkshire Hathaway HomeServices Colorado Real Estate, LLC - Englewood
174 S Hoover Avenue
50 photos
Type:Purchase
Structure:House
Zone:Residential

Description

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.

  • Property Details
      • SubdivisionCentennial Valley 1 & Amd
      • Sewer InformationCity Sewer, Public Sewer
      • Property SubtypeResidential-Detached
      • Lot DescriptionCorner Lot
      • Utility SourceCity Water
      • Elementary SchoolLouisville
      • Middle SchoolLouisville
      • Property TypePurchase
      • High SchoolMonarch
      • CountyBoulder
      • MLS #4146170
      • Cost1500000
      • MLS #4146170
      • Acres0.18
      • Square Feet2582
      • BasementFull
      • Year Built1982
      • FoundationSlab
      • Bathrooms2.5
      • Bedrooms4
      • Full Baths2
      • Half Baths1
      • Parking Spaces2

Location

Legal

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES. Information deemed reliable but not guaranteed by the MLS. The information being provided is for the consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. 

Last Updated: 02/04/2026 1:11 PM. Source: IRES

Provided By
Listing Agent: Beth Ann Mott (#026797), Phone: (303) 919-6864, Email: bethann@bethannmott.com
Listing Office: Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Englewood (#IRE01)

New Horizons Real EstateOwner
Facebook
Google
OR

Interested in Purchasing 174 S Hoover Avenue?

Get an estimate on monthly payments on this property.

Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

Estimated Monthly Payment
$0.00
Loan Amount
$0.00
$
years

Down Payment

$
%
10.0%

Interest Rate

%
6.0%

Tax Rate

%
2.6%
$
$
annually
$
monthly