Prevu by reAlpha
BuySellBlogBrowse Listings

5195 Queen CourtArvada, CO 80002

For Sale

$615,000

Smart Buyer Rebate $6,150

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.

Step 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.
Each 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.

Bedrooms 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.
This 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 amenities include walking trails, parks, and playgrounds with sweeping views of the Flatirons.
Whether commuting downtown, working from home, or unwinding on your rooftop deck, this Haskins Station gem offers the best of Colorado living in one exceptional new home.

Listed by Veronica Trotta

·

License #155064589

·

Real Broker, LLC DBA Real

·

954-681-3755

Listed by Carin Nguyen Team

·

License #64616T

·

Real Broker, LLC DBA Real

Last updated July 22, 2026

·

Source: REcolorado #5679645

Listing Facts

  • TypeSingle-family
  • NeighborhoodAppleridge Estates
  • Bedrooms2
  • Bathrooms3
  • Days on Prevu21
  • HOA/Maint. Fees$53/month
  • Taxes$6,403/year
  • Size1,840 sqft
  • Price per sqft$334

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Washer/Dryer
  • Pets Allowed
  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

07/22/2026
Price Decreased
$615,000
07/10/2026
Listed by Real Broker, LLC DBA Real
$630,000

Property Details for 5195 Queen Court

Association

Amenities

  • Association Amenities: Park, Playground, Trail(s)
  • Pets Allowed: Yes

Fees

  • Association Fee: $53.00 Monthly
  • Association Fee 2: $141.00 Monthly
  • Association Fee Includes: Maintenance Grounds, Snow Removal

General

  • Association Name: Service Plus Community Management

Exterior

Construction

  • Roof: Shingle, Composition
  • Structure Type: House
  • Window Features: Double Pane Windows, Window Coverings
  • Year Built: 2024
  • Builder Name: Richmond American Homes
  • Construction Materials: Frame
  • Entry Location: Ground
  • Exterior Features: Balcony, Barbecue, Gas Grill, Gas Valve, Lighting

Features

  • Direction Faces: East
  • Patio And Porch Features: Covered, Front Porch, Patio, Rooftop
  • View: City, Mountain(s)

Measurements

  • Building Area Total: 1,840
  • Lot Features: Corner Lot, Landscaped, Sprinklers In Front
  • Lot Size Acres: 0.04
  • Lot Size Area: 1,960
  • Lot Size Square Feet: 1,960
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 513653
  • Tax Annual Amount: $6,403.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Range Hood, Refrigerator, Smart Appliance(s), Tankless Water Heater, Washer
  • Flooring: Carpet, Vinyl
  • Interior Features: Ceiling Fan(s), Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Smart Thermostat, Smart Window Coverings, Walk-In Closet(s)

Measurements

  • Living Area: 1,840

Rooms

  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 2
  • Main Level Bathrooms: 1

Other

General

  • Exclusions: Seller's Personal Property

Location

  • Subdivision Name: Haskins Station

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Parking Total: 2

Schools

Elementary School

  • Elementary School: Vanderhoof
  • Elementary School District: Jefferson County R-1

High School

  • High School: Arvada West
  • High School District: Jefferson County R-1

Middle or Junior School

  • Middle Or Junior School: Drake
  • Middle Or Junior School District: Jefferson County R-1

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Forced Air
  • Laundry Features: In Unit
  • Sewer: Public Sewer
  • Utilities: Cable Available, Electricity Available, Internet Access (Wired), Phone Available
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 2 bedrooms and 3 bathrooms in this single-family home at 5195 Queen Court.

What schools are nearby to 5195 Queen Court?

Nearby schools include the Vanderhoof Elementary School, Drake Middle School, and Arvada West High School.

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 5195 Queen Court.

What are the annual taxes for 5195 Queen Court?

Annual taxes for this single-family home are estimated at $6,403.

How does 5195 Queen Court compare to other single-family homes in Appleridge Estates?

This single-family home is listed 32% below the average price for single-family homes in Appleridge Estates and has been on the market for 32 less days than the typical home in this area.

What building or home owners association is the single-family home part of?

This single-family home is part of the Service Plus Community Management home owners association.

What is the square footage on this single-family home?

According to the MLS, this listing is 1,840 sqft.

5195 Queen Court is a 2-bedroom, 3-bath single-family home for sale in Arvada CO 80002. Available on Prevu for 21 days at $615,000. This includes a recent price decrease of $15,000. This residence features 1,840 square feet of living space, located in Appleridge Estates. The median listing price for single-family homes in this area is $599,950. Nearby schools include Vanderhoof Elementary School, Drake Middle School, and Arvada West High School. The home offers private outdoor space, dishwasher, pets allowed, air conditioning, parking, and washer/dryer. Browse more single-family home listings in Jefferson County.

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 Prevu 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.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.