587 W 174th Avenue

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!

Listing Office: Resident Realty North Metro LLC

Essential Information

MLS® #1895909
Price$725,000
Bedrooms4
Bathrooms4.00
Full Baths3
Half Baths1
Square Footage3,205
Acres0.13
Year Built2019
TypeResidential
Sub-TypeSingle Family Residence
StatusActive

Community Information

Address587 W 174th Avenue
SubdivisionPalisade Park
CityBroomfield
CountyBroomfield
StateCO
Zip Code80023

Amenities

Parking Spaces3
# of Garages3

Utilities

Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected

Interior

HeatingForced Air
CoolingAttic Fan, Central Air
FireplaceYes
# of Fireplaces1
FireplacesGreat Room
StoriesTwo

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)

Appliances

Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Washer

Exterior

RoofComposition
FoundationConcrete Perimeter

Lot Description

Landscaped, Sprinklers In Front, Sprinklers In Rear

Windows

Double Pane Windows, Window Coverings

School Information

DistrictSt. Vrain Valley RE-1J
ElementaryHighlands
MiddleSoaring Heights
HighErie

Additional Information

Date ListedAugust 14th, 2025
ZoningPUD

Listing Details

Resident Realty North Metro LLC

Ask About this Property
Request a Showing

Terms and Conditions: 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 RE/MAX Professionals 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.

Listing information last updated on August 15th, 2025 at 4:48am MDT.

Find us on...

Dashboard

587 W 174th Avenue, Broomfield, CO – $725,000

New Search X