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?

$610,000

Listing Price

2beds

3baths

1,840sqft

1,960sqft lot

5195 Queen Ct, Arvada, CO 80002

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

Condo / Townhome

Home type

331.52

Price / sqft

2024

Year built

Home Details

Elevated living in one of Arvada's most sought-after new home communities. This stunning 4-level single family home, built in 2024, offers thoughtful design and jaw-dropping views that rarely come together in one address.nnStep outside to your private rooftop deck and take in panoramic views of downtown Denver and the Rocky Mountains, the perfect backdrop for morning coffee, sunset cocktails, or weekend entertaining under Colorado's famous blue skies.nEach level has a purpose. A dedicated home office sits just off the entrance, ideal for greeting clients or working from home. Upstairs, an open-concept living room, kitchen, and second built-in office create a bright, functional hub, along with a massive walk-in pantry offering rare storage.nnBedrooms enjoy their own private level, separating rest from the rest of the home. Set on a desirable corner lot, this property offers extra outdoor space and enhanced curb appeal.nThis home sits inside the vibrant Haskins Station community, where new construction meets an unbeatable commuter and lifestyle location. Enjoy walking distance to the light rail for an easy commute without fighting Denver traffic, and just 8 miles (about 15 to 20 minutes) to downtown Denver, close enough for city access, far enough to skip the hustle and bustle. Minutes from Olde Town Arvada, you'll find local bars, restaurants, breweries, and shops. I-70 is 3 minutes away for easy mountain getaways, and downtown Golden is under 15 minutes out. Community ameniti

Interior Details

Square Feet
  • 1840

Bedrooms
  • 2

Bathrooms
  • 3

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Forced Air With Air Conditioning

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    No

  • Fuel Type:

    N/A

Basement
  • Has Basement:

    No

  • Basement Type:

    N/A

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 1960

Water
  • No

Sewer
  • No

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    0

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • Yes

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • 3

Style
  • Tri-level

Exterior
  • N/A

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • N/A

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

percent-home-icon

Average Home Price in 80002

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$533,005

2 Beds

1 Baths

1,733 Sqft

1,041 Lot (sqft)

Sold 08/31/2026

$540,048

3 Beds

2 Baths

1,688 Sqft

1,146 Lot (sqft)

Sold 08/31/2026

$544,224

3 Beds

2 Baths

1,688 Sqft

1,041 Lot (sqft)

Sold 08/31/2026

$575,000

3 Beds

3 Baths

1,886 Sqft

2,396 Lot (sqft)

Sold 07/15/2026

$572,197

3 Beds

4 Baths

2,058 Sqft

1,089 Lot (sqft)

Sold 05/29/2026

$560,000

2 Beds

3 Baths

1,811 Sqft

1,176 Lot (sqft)

Sold 10/13/2026

$650,000

3 Beds

3 Baths

1,794 Sqft

1,786 Lot (sqft)

Sold 10/13/2026

$649,500

3 Beds

3 Baths

1,792 Sqft

2,265 Lot (sqft)

Sold 09/29/2026

$649,950

2 Beds

3 Baths

1,794 Sqft

2,265 Lot (sqft)

Sold 10/13/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
610,000
$
Down payment
122,000
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
3,660
$
HOA (Monthly)
0
$
PMI
0
$
$3,949
Your Payment
Total Monthly Payment:$3,949
Percent of Income:68%
Affordable:No

Details for 5195 QUEEN CT

Property Debt

Foreclosure Contact Details