Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

$709,999

Listing Price

4beds

4baths

3,205sqft

5,625sqft lot

587 W 174th Ave, Broomfield, CO 80023

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

For Sale

Off Market

Single Family

Home type

215.77

Price / sqft

2019

Year built

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, Childrens Hospital, schools, restaurants and more, and Hearthstone Park is just steps away!

Interior Details

Square Feet
  • 3205

Bedrooms
  • 4

Bathrooms
  • 4

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Forced Air With Air Conditioning

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    Yes

  • Fuel Type:

    Gas

Basement
  • Has Basement:

    No

  • Basement Type:

    Partial

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 5625

Water
  • No

Sewer
  • No

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    3

Deck
  • N/A

Patio
  • N/A

Fence
  • N/A

Pool
  • N/A

Porch
  • N/A

Stoop
  • N/A

Breezeway
  • N/A

Construction Details

Number of Stories
  • 2

Style
  • Bi-level

Exterior
  • Brick

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • Asphalt

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

2019

$1,751

$7,510

$28,660

--%

$36,170

2019

$1,751

$7,510

$2,870

--%

$10,380

2018

$1,603

$9,580

$0

--%

$9,580

2017

$6

$10

$0

--%

$10

percent-home-icon

Average Home Price in 80023

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$916,834

4 Beds

3 Baths

2,774 Sqft

6,677 Lot (sqft)

Sold 09/29/2026

$945,505

4 Beds

3 Baths

2,774 Sqft

6,677 Lot (sqft)

Sold 09/29/2026

$720,000

4 Beds

3 Baths

2,996 Sqft

5,750 Lot (sqft)

Sold 09/29/2026

$765,000

5 Beds

3 Baths

2,808 Sqft

6,089 Lot (sqft)

Sold 10/05/2026

$715,000

5 Beds

4 Baths

2,808 Sqft

5,625 Lot (sqft)

Sold 09/29/2026

$920,633

4 Beds

2.5 Baths

2,997 Sqft

7,747 Lot (sqft)

Sold 09/29/2026

$719,900

5 Beds

3.5 Baths

2,808 Sqft

5,625 Lot (sqft)

Sold 08/31/2026

$780,464

5 Beds

3.5 Baths

2,808 Sqft

6,200 Lot (sqft)

Sold 09/29/2026

$718,043

5 Beds

3.5 Baths

2,808 Sqft

5,625 Lot (sqft)

Sold 10/06/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
709,999
$
Down payment
141,999.80
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
4,259.99
$
HOA (Monthly)
0
$
PMI
0
$
$4,596
Your Payment
Total Monthly Payment:$4,596
Percent of Income:79%
Affordable:No

Details for 587 W 174TH AVE

Property Debt

Foreclosure Contact Details