Prevu by reAlpha
BuySellBlogBrowse Listings

5234 Queen CourtArvada, CO 80002

For Sale

$799,900

Smart Buyer Rebate $7,999

This home is centrally located close to downtown Denver and Golden, and all the amenities of Old Town Arvada with easy access to Broomfield and Boulder. Backing to an open space you get easy access to trails that connect you to the Apex center. As you enter the home you will be welcomed by 10 foot ceilings with 8 foot doors on the main level. There is 1 guest room with a full bathroom plus the primary bedroom with unobstructed views of the open space, generous walk-in closet and 4 piece ensuite bathroom. Included on the main floor is the great room with living room, breakfast nook, gourmet kitchen with a pantry and access to the back patio for outdoor entertainment. There is also a large laundry room off the spacious 2 car garage and a bonus room that could be an office or formal dining room. The lower level is flooded with natural light thanks to the garden level window that looks out on the open space and the 9 foot ceilings. There is a bar, room for a theater, family room, plus 2 guest rooms with large closets, ample storage, and an additional bathroom. All of this and low HOA, come see this home before it gone!!

Listed by Bobby Dusbabek

·

License #39134N

·

Coldwell Banker Realty 24

·

303-779-9501

Last updated July 24, 2026

·

Source: REcolorado #6927393

Listing Facts

  • TypeSingle-family
  • NeighborhoodAppleridge Estates
  • Bedrooms4
  • Bathrooms3
  • Days on Prevu36
  • HOA/Maint. Fees$142/quarter
  • Taxes$9,885/year
  • Size3,682 sqft
  • Price per sqft$217

Amenities

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

Location

Mortgage Calculator

Listing History

07/24/2026
Price Decreased
$799,900
07/09/2026
Price Decreased
$839,900
06/26/2026
Listed by Coldwell Banker Realty 24
$849,900

Property Details for 5234 Queen Court

Association

Amenities

  • Association Amenities: Playground, Trail(s)

Fees

  • Association Fee: $142.00 Quarterly

General

  • Association Name: Haskins Station Metropolitan District

Exterior

Construction

  • Roof: Composition
  • Structure Type: House
  • Window Features: Double Pane Windows, Window Coverings, Window Treatments
  • Year Built: 2024
  • Architectural Style: Contemporary
  • Construction Materials: Frame
  • Exterior Features: Garden, Private Yard, Rain Gutters

Features

  • Direction Faces: West
  • Fencing: Full
  • Patio And Porch Features: Covered, Deck, Front Porch, Patio
  • Road Frontage Type: Public
  • View: City, Meadow, Mountain(s)

Measurements

  • Building Area Total: 3,682
  • Lot Features: Greenbelt, Irrigated, Near Public Transit, Open Space, Sloped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Acres: 0.12
  • Lot Size Area: 5,184
  • Lot Size Square Feet: 5,184
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 513682
  • Tax Annual Amount: $9,885.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Cooktop, Dishwasher, Down Draft, Dryer, Microwave, Oven, Range, Range Hood, Refrigerator, Washer
  • Fireplace Features: Gas, Living Room
  • Fireplaces Total: 1
  • Flooring: Carpet, Laminate
  • Interior Features: Ceiling Fan(s), High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Smoke Free, Walk-In Closet(s), Wet Bar

Measurements

  • Living Area: 3,682

Rooms

  • Basement: Finished
  • Has Basement: Yes
  • Bathrooms Full: 2
  • Bathrooms Three Quarter: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 4
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 2

Other

Environmental

  • Green Energy Efficient: Appliances, Construction, Doors, HVAC, Insulation, Lighting, Thermostat, Water Heater, Windows

General

  • Exclusions: Seller's Personal Property

Location

  • Subdivision Name: Haskins Station

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Parking Features: Concrete, Electric Vehicle Charging Station(s), Insulated Garage, Lighted
  • Parking Total: 2

Schools

Elementary School

  • Elementary School: Warder
  • 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
  • Water Source: Public

Frequently Asked Questions

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

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

What schools are nearby to 5234 Queen Court?

Nearby schools include the Warder 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 5234 Queen Court.

What are the annual taxes for 5234 Queen Court?

Annual taxes for this single-family home are estimated at $9,885.

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

This single-family home is listed 11% below the average price for single-family homes in Appleridge Estates and has been on the market for 17 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 Haskins Station Metropolitan District home owners association.

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

According to the MLS, this listing is 3,682 sqft.

5234 Queen Court is a 4-bedroom, 3-bath single-family home for sale in Arvada CO 80002. Available on Prevu for 36 days at $799,900. This includes a recent price decrease of $40,000. This property features 3,682 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 Warder Elementary School, Drake Middle School, and Arvada West High School. The home offers private outdoor space, dishwasher, 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.