Broomfield, CO 80023 587 W 174th Ave

587 W 174th Ave Broomfield, CO - Image 1587 W 174th Ave Broomfield, CO - Image 2587 W 174th Ave Broomfield, CO - Image 3
45 more
587 W 174th Ave Broomfield, CO - Image 4587 W 174th Ave Broomfield, CO - Image 5587 W 174th Ave Broomfield, CO - Image 6587 W 174th Ave Broomfield, CO - Image 7587 W 174th Ave Broomfield, CO - Image 8587 W 174th Ave Broomfield, CO - Image 9587 W 174th Ave Broomfield, CO - Image 10587 W 174th Ave Broomfield, CO - Image 11587 W 174th Ave Broomfield, CO - Image 12587 W 174th Ave Broomfield, CO - Image 13587 W 174th Ave Broomfield, CO - Image 14587 W 174th Ave Broomfield, CO - Image 15587 W 174th Ave Broomfield, CO - Image 16587 W 174th Ave Broomfield, CO - Image 17587 W 174th Ave Broomfield, CO - Image 18587 W 174th Ave Broomfield, CO - Image 19587 W 174th Ave Broomfield, CO - Image 20587 W 174th Ave Broomfield, CO - Image 21587 W 174th Ave Broomfield, CO - Image 22587 W 174th Ave Broomfield, CO - Image 23587 W 174th Ave Broomfield, CO - Image 24587 W 174th Ave Broomfield, CO - Image 25587 W 174th Ave Broomfield, CO - Image 26587 W 174th Ave Broomfield, CO - Image 27587 W 174th Ave Broomfield, CO - Image 28587 W 174th Ave Broomfield, CO - Image 29587 W 174th Ave Broomfield, CO - Image 30587 W 174th Ave Broomfield, CO - Image 31587 W 174th Ave Broomfield, CO - Image 32587 W 174th Ave Broomfield, CO - Image 33587 W 174th Ave Broomfield, CO - Image 34587 W 174th Ave Broomfield, CO - Image 35587 W 174th Ave Broomfield, CO - Image 36587 W 174th Ave Broomfield, CO - Image 37587 W 174th Ave Broomfield, CO - Image 38587 W 174th Ave Broomfield, CO - Image 39587 W 174th Ave Broomfield, CO - Image 40587 W 174th Ave Broomfield, CO - Image 41587 W 174th Ave Broomfield, CO - Image 42587 W 174th Ave Broomfield, CO - Image 43587 W 174th Ave Broomfield, CO - Image 44587 W 174th Ave Broomfield, CO - Image 45587 W 174th Ave Broomfield, CO - Image 46587 W 174th Ave Broomfield, CO - Image 47587 W 174th Ave Broomfield, CO - Image 48587 W 174th Ave Broomfield, CO - Image 49
Presented By: Resident Realty North Metro LLC; susan@susanmcbridehomes.com,303-519-7809
  • MLS# 1895909
  • 08/14/2025
  • Request Tour
  • Request Info
  • Beds • 4
  • Full/Half Baths • 3 / 1
  • SQFT • 3,594
  • Garage • 3

Home Details

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!
Presented By: Resident Realty North Metro LLC; susan@susanmcbridehomes.com,303-519-7809

Interior Features for 587 W 174th Ave

Bedrooms

Bedroom 3 LevelUpper
Bedroom 4 LevelBasement
Second Bedroom LevelUpper
Total Bedrooms4

Bathrooms

3/4 Baths0
Half Baths1
Primary Bathroom FeaturesFull Primary Bath, 5 Piece Primary Bath
Total Baths4

Kitchen

Kitchen LevelMain

Other Interior Features

LivingAreaSourceAssessor
Above Grade Finished Area2455
Air Conditioning Y/NYes
BasementPartially Finished, Built-In Radon, Radon Test Available, Sump Pump
Below Grade Finished Area1139
Fireplace FeaturesGreat Room, Single Fireplace
Fireplace Y/NYes
Heating Y/NYes
Interior AmenitiesStudy Area, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Kitchen Island
Laundry FeaturesUpper Level
Window FeaturesWindow Coverings, Double Pane Windows

Other Rooms

Kitchen LevelMain

General for 587 W 174th Ave

AppliancesDishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
Assoc Fee Paid PerMonthly
Association Fee IncludesTrash
Attached Garage Yes
Builder NameTaylor Morrison
CityBroomfield
Construction MaterialsWood/Frame, Concrete
CoolingCentral Air, Ceiling Fan(s), Attic Fan
CountyBroomfield
DirectionsFrom I 25, go west on Highway 7 (Exit 229). Turn right on Huron St., left on Skyline Dr., left on Olive St. and a quick right on W. 174th Ave. Third house on the right just past Hearthstone Park!!
ElectricElectric
Elementary SchoolHighlands
ExclusionsSeller's personal property, refrigerator in garage, projector in basement.
Full Baths3
Garage Spaces3
Garage Y/NYes
HOAYes
HOA Fee$65.39
HeatingForced Air
High SchoolErie
High School DistrictSt. Vrain Valley RE-1J
Land Lease Y/NNo
LevelsTwo
Living Area UnitsSquare Feet
Lot Size Square Feet5625
Lot Size UnitsSquare Feet
MLS AreaBroomfield
Middle/Junior High SchoolSoaring Heights
New ConstructionNo
Patio/Porch FeaturesPatio
Possible UseCommercial
Primary Bedroom LevelUpper
Property Attached Y/NNo
Property ConditionNot New, Previously Owned
Property SubtypeResidential-Detached
Property TypeResidential
RoofComposition
Senior Community Y/NNo
SewerCity Sewer, Public Sewer
Standard StatusActive
StatusActive
Stories Count2
Subdivision NamePalisade Park
Tax Annual Amount8329
Tax Year2024
UtilitiesElectricity Available, Cable Available
Year Built2019
ZoningPUD

Exterior for 587 W 174th Ave

Building Area Total2455
Covered Spaces3
FencingFenced
Horse Y/NNo
Lot FeaturesLawn Sprinkler System
Lot Size Acres0.13
Lot Size Area5625
Road Surface TypePaved
SpaNo
Water SourceCity Water
Waterfront Y/NNo

Additional Details

Price History

Schools

Middle School Soaring Heights Middle School
High School Erie High School
Elementary School Highlands Elementary School

Jon Holsten

Price $699,000
MLS#1895909
List Date 08/14/2025
Property Type Single Family
Phone 970.237.2752
Request Tour
Request Info
Visit My Website

Similar Properties to 587 W 174th Ave

AZ CBD Source - CBD for gastrointestinal GI issues and Irritable Bowel Syndrome Vidapur CBD Gummies Voted 1 CBD Gummies Get It NOW KEONI CBD GUMMIES REVIEWS DO THEY WORK FOR RELIEF PAIN Cbd Gummies Australia Navigating Australias Cannabis Candy Conundrum canapa canapalight cbd Best CBD For Pain 2021 DA BALM by Higher Hemp Rx Best CBD Cream for Back Pain Sheer Testosterone Booster For Men Supplement Review Are male enhancement supplements effective Penis Enlargement Pills - Ready To Be Noticeably Thicker LongerPenis Enlargement Pills Vibrboost Male Enhancement CBD Gummies Alpha Male Enhancement Gummies Alpha Ignite Male Enhancement Gummies ALERT Alpha Ignite Male Enhancement Gummies Where To Buy Truman CBD Gummies Best Male Enhancement Gummies for Men in USA srsmedicare ANIMALE MALE ENHANCEMENT GUMMIES AVIS ANIMALE ME GUMMIES O ACHETER ANIMALE ME GUMMIES REVUE ALPHABITES REVIEW BEWARE ALPHA BITES MALE ENHANCEMENT GUMMIES - ALPHABITES Scientifically Proven Ways to Last Longer in Bed Premature Ejaculation Erectile Dysfunction Caused by Diabetes How to Treat It MFine Erectile Dysfunction Treatment All you need to know Budweiser Grand Prix of Watkins Glen Round 7 S1 Champ Car Viagra World Series Erectify Ultra Male Enhancement US Review Maca Root supplement that helps increase libido and reduce erectile dysfunction supplements Do statins improve erectile dysfunction erectile dysfunction ed medicine PHENOMAN GUMMIES REVIEWS SHOCKING TRUTH ABOUT PHENOMAN MALE ENHANCEMENT GUMMIES PHENOMAN ME TruGenix Male Enhancement Gummies - TruGenix Gummies Does it Really Work - TruGenix Gummies X10 Boost Keto Gummies X10 Boost Keto ACV Gummies MY ALERT USA Mediterranean Style Keto Diet - What to Eat What to Avoid THE BENEFITS OF GOLI APPLE CIDER VINEGAR GUMMIES Lose Weight Fast Fat Burner Binaural Beats Healing Frequency Music Complete Life Supplements - 100 Certified Organic Diet Pills Weight Loss Supplements Low calorie diet plan for Weight Loss Joaquin Phoenix Is So Over Dramatic Weight Loss For Roles How To Lose Weight Fast and Safe Lost 18 pounds in 2 weeks Weight Loss Update Phentermine PURADROP GUMMIES WORTH IT WEIGHT LOSS GUMMIES REVIEW PURADROP REVIEW