BuySellBlogBrowse Listings

587 W 174th AvenueBroomfield, CO 80023

For Sale

$715,000

Smart Buyer Rebate $7,150

Welcome to your next home -- a well kept, turnkey 2-story gem offering the perfect blend of comfort, functionality and thoughtful improvements throughout! This is a beautiful home in an ideal location!! Storage galore including huge linen closet in basement bathroom; broom closet and mudroom on main level and linen closet on upper floor. Benefit from numerous updates that include a finished basement with gorgeous bathroom and comfortable bedroom. The main floor has a nicely renovated fireplace surround. The upper level includes a renovated walk-in closet in the primary suite and a stunning laundry room, both professionally done by Closets by Design. In the backyard are garden boxes with a convenient drip line. The home has an attic fan in addition to the central A/C; smart irrigation system (B-hyve) and the 3-car tandem garage features built-in shelves. This 4 bedroom, 4 bathroom home with a spacious office is appealing and comfortable, and is conveniently situated near I25, the Orchard Town Center, restaurants, Children's Hospital, schools, restaurants and more, and Hearthstone Park is just steps away!

Listed by Susan McBride

·

License #55046398

·

Resident Realty North Metro LLC

·

303-519-7809

Last updated September 04, 2025

·

Source: REcolorado #1895909

Listing Facts

  • TypeSingle-family
  • NeighborhoodNorth Broomfield
  • Bedrooms4
  • Bathrooms4
  • Days on Prevu26
  • HOA/Maint. Fees$65.39/month
  • Taxes$8,329/year
  • Size3,205 sqft
  • Price per sqft$223

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Washer/Dryer
  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

09/05/2025
Price Decreased
$715,000
08/14/2025
Listed by Resident Realty North Metro LLC
$725,000

Property Details for 587 W 174th Avenue

Association

Fees

  • Association Fee: $65.39 Monthly
  • Association Fee Includes: Trash

General

  • Association Name: Advance HOA

Exterior

Construction

  • Roof: Composition
  • Structure Type: House
  • Window Features: Double Pane Windows, Window Coverings
  • Year Built: 2019
  • Builder Name: Taylor Morrison
  • Construction Materials: Frame

Features

  • Fencing: Full
  • Patio And Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public

Measurements

  • Building Area Total: 3,594
  • Lot Features: Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Acres: 0.13
  • Lot Size Area: 5,625
  • Lot Size Square Feet: 5,625
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: R8873541
  • Tax Annual Amount: $8,329.00
  • Tax Year: 2024

Interior

Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Washer
  • Fireplace Features: Great Room
  • Fireplaces Total: 1
  • Flooring: Carpet, Laminate, Tile
  • Interior Features: Ceiling Fan(s), Five Piece Bath, Granite Counters, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Radon Mitigation System, Smoke Free, Walk-In Closet(s)

Measurements

  • Living Area: 3,205

Rooms

  • Basement: Finished, Sump Pump
  • Has Basement: Yes
  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 4
  • Main Level Bathrooms: 1

Other

General

  • Exclusions: Seller's personal property, refrigerator in garage, projector in basement.

Location

  • Subdivision Name: Palisade Park

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Parking Total: 3

Schools

Elementary School

  • Elementary School: Highlands
  • Elementary School District: St. Vrain Valley RE-1J

High School

  • High School: Erie
  • High School District: St. Vrain Valley RE-1J

Middle or Junior School

  • Middle Or Junior School: Soaring Heights
  • Middle Or Junior School District: St. Vrain Valley RE-1J

Utilities

Equipment

  • Cooling: Attic Fan, Central Air
  • Heating: Forced Air
  • Laundry Features: In Unit
  • Sewer: Public Sewer
  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected
  • Water Source: Public

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 Prevu 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.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.