5234 Queen Ct Arvada, CO 80002
Appleridge Estates NeighborhoodEstimated payment $5,116/month
Highlights
- Primary Bedroom Suite
- Open Floorplan
- Contemporary Architecture
- City View
- Deck
- Property is near public transit
About This Home
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!!
Listing Agent
Coldwell Banker Realty 24 Brokerage Email: 5280homesbybobby@gmail.com,303-779-9501 License #100039134 Listed on: 06/26/2026
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $9,885
Year Built
- Built in 2024
Lot Details
- 5,184 Sq Ft Lot
- Open Space
- West Facing Home
- Property is Fully Fenced
- Sloped Lot
- Front and Back Yard Sprinklers
- Irrigation
- Private Yard
- Garden
HOA Fees
- $47 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Electric Vehicle Home Charger
- Insulated Garage
- Lighted Parking
Property Views
- City
- Mountain
- Meadow
Home Design
- Contemporary Architecture
- Frame Construction
- Composition Roof
Interior Spaces
- 1-Story Property
- Open Floorplan
- Wet Bar
- High Ceiling
- Ceiling Fan
- Gas Fireplace
- Double Pane Windows
- Window Treatments
- Family Room
- Living Room with Fireplace
- Dining Room
- Bonus Room
- Game Room
- Finished Basement
- 2 Bedrooms in Basement
Kitchen
- Breakfast Area or Nook
- Oven
- Down Draft Cooktop
- Range Hood
- Microwave
- Dishwasher
- Kitchen Island
- Quartz Countertops
Flooring
- Carpet
- Laminate
Bedrooms and Bathrooms
- 4 Bedrooms | 2 Main Level Bedrooms
- Primary Bedroom Suite
- En-Suite Bathroom
- Walk-In Closet
Laundry
- Laundry Room
- Dryer
- Washer
Home Security
- Smart Thermostat
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Eco-Friendly Details
- Energy-Efficient Appliances
- Energy-Efficient Windows
- Energy-Efficient Construction
- Energy-Efficient HVAC
- Energy-Efficient Lighting
- Energy-Efficient Insulation
- Energy-Efficient Doors
- Energy-Efficient Thermostat
- Smoke Free Home
Outdoor Features
- Deck
- Covered Patio or Porch
- Rain Gutters
Location
- Property is near public transit
Schools
- Warder Elementary School
- Drake Middle School
- Arvada West High School
Utilities
- Forced Air Heating and Cooling System
- High-Efficiency Water Heater
Listing and Financial Details
- Exclusions: Seller's Personal Property
- Assessor Parcel Number 513682
Community Details
Overview
- Haskins Station Metropolitan District Association, Phone Number (303) 265-7875
- Haskins Station Subdivision
- Greenbelt
Recreation
- Community Playground
- Trails
Map
Home Values in the Area
Average Home Value in this Area
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $9,885 | $55,301 | $10,683 | $44,618 |
| 2024 | $4,555 | $12,541 | $11,453 | $1,088 |
| 2023 | $4,555 | $26,149 | $26,149 | $0 |
| 2022 | $3,301 | $19,819 | $19,819 | $0 |
| 2021 | $2,254 | $13,183 | $13,183 | $0 |
| 2020 | $1,537 | $9,084 | $9,084 | $0 |
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/24/2026 07/24/26 | Price Changed | $799,900 | -4.8% | $217 / Sq Ft | |
| 07/09/2026 07/09/26 | Price Changed | $839,900 | -1.2% | $228 / Sq Ft | |
| 06/26/2026 06/26/26 | For Sale | $849,900 | +6.2% | $231 / Sq Ft | |
| 06/06/2024 06/06/24 | Sold | $799,950 | 0.0% | $249 / Sq Ft | View Prior Sale |
| 04/27/2024 04/27/24 | Pending | -- | -- | -- | |
| 04/22/2024 04/22/24 | Price Changed | $799,950 | -2.4% | $249 / Sq Ft | |
| 04/08/2024 04/08/24 | Price Changed | $819,950 | -1.2% | $256 / Sq Ft | |
| 04/01/2024 04/01/24 | Price Changed | $829,950 | -1.2% | $259 / Sq Ft | |
| 03/25/2024 03/25/24 | Price Changed | $839,950 | -1.2% | $262 / Sq Ft | |
| 03/18/2024 03/18/24 | Price Changed | $849,950 | -2.9% | $265 / Sq Ft | |
| 02/20/2024 02/20/24 | Price Changed | $874,950 | -1.0% | $273 / Sq Ft | |
| 01/16/2024 01/16/24 | For Sale | $883,950 | -- | $276 / Sq Ft |
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Quit Claim Deed | -- | None Listed On Document | |
| Quit Claim Deed | -- | None Listed On Document | |
| Special Warranty Deed | $800,000 | None Listed On Document |
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $639,960 | New Conventional |
Source: REcolorado®
MLS Number: 6927393
APN: 39-162-15-007
- 5195 Queen Ct
- 11483 W 51st Loop
- 11487 W 51st Loop
- 8021 W 52nd Ave
- 11232 W 53rd Dr
- 5240 Routt Ct Unit B
- 5348 Routt St Unit B
- 5210 Routt Ct Unit B
- 5392 Quail St
- 5160 Simms Place
- 11074 W 54th Ln
- 11842 W 52nd Ave
- 10974 W 54th Ln
- 4975 Robb St
- 5148 Taft Ct
- 5323 Nelson St
- 11702 W 56th Cir
- 11237 W 55th Ln
- 5283 Union Ct Unit 5
- 5283 Union Ct Unit 8
- 10870 W 53rd Ave
- 5110 Swadley St Unit D
- 4700 Tabor St
- 10350 W 55th Ln
- 5534 Lewis St Unit 101
- 5705 Simms St
- 5112 Ward Rd
- 11579 W 58th Ave
- 10605 W 48th Ave Unit A
- 5458 Lee St
- 10068 W 52nd Place
- 4735 Nelson St
- 5677 Vivian St
- 12326 W 56th Ln
- 11600 W 46th Ave
- 12155 W 58th Place
- 11681 W 44th Ave Unit 3
- 9700 W 51st Place
- 5405 Jellison St
- 5615 Jellison St
Ask me questions while you tour the home.