Broomfield, CO 80023 587 W 174th Ave

OPEN HOUSE Sat, Aug 30 2025 01:00 PM - 03:00 PM
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 $725,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

All Natural Leaf CBD Gummies - Safe Or Real Trustworthy Relief Aches Gummy CBD and Anxiety Joy Organics CBD Product Line Overview Martha Stewart CBD Gummies CBDGUMMIES health CBD Gummies Review - Benefits of Wyld CBD Gummies Cbd Gummies Australia Navigating Australias Cannabis Candy Conundrum Sunnyvale Labs CBD Gummies Oil Reviews 2021 How To Reduce Pain CBD Care Gummies Review Does It Work for Anxiety and Pain Relief Full Honest Review PHENOMAN GUMMIES ALERT - PHENOMAN MALE ENHANCEMENT GUMMIES - PHENOMAN GUMMIES REVIEWS PHENOMAN GUMMIES REVIEWS SHOCKING TRUTH ABOUT PHENOMAN MALE ENHANCEMENT GUMMIES PHENOMAN ME PhenoMAN Male Enhancement Gummies - USA Price Update Elevate Your Sexual Experience OurDoctor - Male Enhancement Treatments 15-Min Workout to Fix Common Pelvic Floor Issues Like Premature Ejaculation and ED Video Shock wave therapy treatment used for erectile dysfunction Her Ex Has Bigger Penis Size Should You Be Worried Welcome To Red Pill Rhino What Is The Best CBD Product For Ed ManUp Gummies MANUP GUMMIES REVIEW - WARNING - MANUP GUMMIES - MANUP MALE ENHANCEMENT GUMMIES Kelly Clarksons Weight Loss Secret Revealed How She Did It weightlosstips shorts Mayo Clinic Minute Weight loss and willpower 7 Tips How To Lose Weight Fast For Teenagers At Home How To Lose Weight Teenagers KETO ACV GUMMIES THE TRUTH Keto ACV Gummies Reviews ACV Keto Gummies Keto acv Gummies Nucentix Keto Gmy Gummies Review NOBODY TELLS THIS Nucentix Keto Gmy Gummies Reviews ANATOMY ONE KETO GUMMIES REVIEWS Does Anatomy One Keto Gummies Work AnatomyOne Keto Gummies Workout belly fat exercise lose weight at Home short reducebellyfat bellyfatloss yoga fatloss Thermo Keto ACV Gummies - Shark Tank 2023Does It Really Work Or Scam BEST Ways to Eat FLAXSEEDS for Weight Loss Skin Hair Recipes and Side Effects Laser Therapy Tools to Stop Smoking for Weight Loss Stress Reduction Speedy Keto ACV Gummies Reviews and Warning - Watch Before Buying Fast Burn Extreme Review Best Diet Pills on Amazon Fast Burn Extreme Ingredients Lumaslim Review Lexapure Weight Loss Diet Pills Honest Reviews - Scam Or Not