This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
$690,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Full Property Details for 587 W 174th Ave
Sign in to view more details. Local MLS Rules require you to be signed in. Not a member yet? Sign up now.
General
- Sold For: $690,000
- HOA FEE: $65/month
- Taxes: $8,329 (2024)
- Status: Closed
- Type: Single Family
- Source: MetroList_Colorado
- MLS ID: 1895909
- Added to Site: 155 day(s) ago
Interior
- 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)
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Great Room, Great Room, Great Room
- Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Washer
- Flooring: Carpet, Laminate, Tile
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
- Main Floor Baths: 1
- Basement Baths: 1
Bedrooms
- Total Bedrooms: 4
Other Rooms
- Laundry: In Unit
Additional Information
- Security/Safety: Carbon Monoxide Detector(s), Radon Detector, Smart Cameras, Smoke Detector(s), Video Doorbell
Exterior
- Porch/Patio/Deck: Covered, Front Porch, Patio
Parking
- Garage: Yes
- Garage Spaces: 3
- Total Spaces: 3
Location
- County: Broomfield
- Subdivision: Palisade Park
- Driving Directions: From 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!!
School Information
- Elem School District: St. Vrain Valley RE-1J
- Midd School District: St. Vrain Valley RE-1J
- High School District: St. Vrain Valley RE-1J
- Elementary School: Highlands
- Middle School: Soaring Heights
- High School: Erie
Community
- Association: Yes
- Assoc. Name: Advance HOA
- Assoc. Fees Include: Trash
- Pets Allowed: Yes
- Management Type: Professionally Managed
Heating & Cooling
- Cooling Type: Attic Fan, Central Air
- Heating Type: Forced Air
Utilities
- Gas: Yes
- Sewer: Public Sewer
- Water: Public
- Utility Description: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected
Structural Information
- Structure Type: House
- Builder: Taylor Morrison
- Construction: Frame
- Basement: Yes
- Basement Desc.: Finished, Sump Pump
- Roof: Composition
- Windows: Double Pane Windows, Window Coverings
- Square Feet: 3,594
- Sq. Ft. Source: Public Records
- Living Area: 3,205 Sq. Ft.
- Current Bldg. Use: Live/Work
- Year Built: 2019
Lot Features
- Lot Size (Acres): 0.13
- Lot Size (Sq. Ft.): 5,625
- Frontage: Public
- Street/Road Desc.: Paved
- Road Maintenance: Public Maintained Road
- Fence: Yes
- Lot Features: Landscaped, Sprinklers In Front, Sprinklers In Rear
- Zoning: PUD
- Fencing (Description): Full
Financial Considerations
- Association Fee: Yes
- Association Fee: $65
- Assoc Fee Freq.: Monthly
- Assoc Fee /Annual: $785
- Other Fee Freq.: Included in Property Tax
- Tax Amount: $8,329
- Tax Year: 2024
- Terms: Cash, Conventional
Disclosures and Reports
- Ownership: Individual
- Special Conditions: None
- Legal Description: SUBD: PALISADE PARK FILING NO 4 REPLAT A LOT: 19 BLOCK: 1 S: 34 T: 1N R: 68W
- Exclusions: Seller's personal property, refrigerator in garage, projector in basement.
- Property ID: R8873541
Listed by Resident Realty North Metro LLC
Sold by Side, Inc.
Schools serving 587 W 174th Ave
| Name | Grades | Distance |
|---|---|---|
Black Rock Elementary School 2000 Mountain View Boulevard, Erie, CO 80516 | PK-5 | 1.6 mi |
Erie Middle School 650 Main Street, Erie, CO 80516 | 6-8 | 4.4 mi |
Erie High School 3180 County Road 5, Erie, CO 80516 | 9-12 | 2.8 mi |
587 W 174th Avenue, Broomfield, CO 80023 (MLS# 1895909) is a Single Family property that was sold at $690,000 on November 24, 2025. Want to learn more about 587 W 174th Avenue? Do you have questions about finding other Single Family real estate for sale in Broomfield? You can browse all Broomfield real estate or contact a Coldwell Banker agent to request more information.

