5134 Queen Ct Arvada, CO 80002
Appleridge Estates NeighborhoodEstimated payment $5,494/month
Highlights
- Bonus Room
- Home Office
- Cul-De-Sac
- Great Room
- Covered Patio or Porch
- 2 Car Attached Garage
About This Home
Discover this stunning 4-bedroom, 3-bath home in one of Arvada’s most desirable neighborhoods. Thoughtfully designed with modern elegance, the open-concept main level features a gorgeous kitchen space with designer cabinets, stainless steel appliances, and a large quartz island—perfect for entertaining and everyday living. The main floor includes two spacious bedrooms, including a beautiful primary suite with a walk-in closet and a luxurious en-suite bathroom, plus a dedicated home office ideal for remote work or creative projects. The walkout basement offers two additional bedrooms and a generous living area, providing plenty of flexibility for guests, recreation, or multi-generational living. Step outside to a custom landscaped backyard with a covered patio, creating a serene retreat for outdoor dining or relaxation. Combining style, comfort, and an unbeatable location, this Arvada home truly has it all.
Listing Agent
LPT Realty Brokerage Email: boards@lpt.com,877-366-2213 License #100098845 Listed on: 03/27/2026
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,803
Year Built
- Built in 2024 | Remodeled
Lot Details
- 5,200 Sq Ft Lot
- Cul-De-Sac
- Southwest Facing Home
- Landscaped
- Front Yard Sprinklers
HOA Fees
- $47 Monthly HOA Fees
Parking
- 2 Car Attached Garage
Home Design
- Frame Construction
- Shingle Roof
- Composition Roof
Interior Spaces
- 1-Story Property
- Great Room
- Dining Room
- Home Office
- Bonus Room
Bedrooms and Bathrooms
- 4 Bedrooms | 2 Main Level Bedrooms
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump
- 2 Bedrooms in Basement
Schools
- Vanderhoof Elementary School
- Drake Middle School
- Arvada West High School
Additional Features
- Covered Patio or Porch
- Forced Air Heating and Cooling System
Community Details
- Haskins Station Metropolitan District Association, Phone Number (303) 858-1800
- Built by Richmond American Homes
- Haskins Station Subdivision, Avalon/E Floorplan
Listing and Financial Details
- Exclusions: garage shelving and peg boards, tv mounting hardware, in ceiling speakers and amplifiers, Artwork, Sellers personal property
- Assessor Parcel Number 513673
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,006 | $50,380 | $10,683 | $39,697 |
| 2024 | $4,555 | $50,911 | $11,453 | $39,458 |
| 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 |
|---|---|---|---|---|---|
| 04/28/2026 04/28/26 | Price Changed | $870,000 | -1.1% | $250 / Sq Ft | |
| 03/28/2026 03/28/26 | For Sale | $880,000 | +10.0% | $253 / Sq Ft | |
| 02/29/2024 02/29/24 | Sold | $799,950 | 0.0% | $230 / Sq Ft | View Prior Sale |
| 01/16/2024 01/16/24 | Pending | -- | -- | -- | |
| 11/27/2023 11/27/23 | Price Changed | $799,950 | -3.0% | $230 / Sq Ft | |
| 11/17/2023 11/17/23 | Price Changed | $824,950 | -4.0% | $237 / Sq Ft | |
| 10/31/2023 10/31/23 | Price Changed | $858,950 | +1.1% | $247 / Sq Ft | |
| 10/09/2023 10/09/23 | Price Changed | $849,950 | -2.9% | $244 / Sq Ft | |
| 09/22/2023 09/22/23 | Price Changed | $874,950 | -5.4% | $252 / Sq Ft | |
| 09/12/2023 09/12/23 | Price Changed | $924,950 | -2.6% | $266 / Sq Ft | |
| 09/11/2023 09/11/23 | Price Changed | $949,950 | 0.0% | $273 / Sq Ft | |
| 09/11/2023 09/11/23 | For Sale | $949,950 | +4.4% | $273 / Sq Ft | |
| 07/02/2023 07/02/23 | Pending | -- | -- | -- | |
| 06/19/2023 06/19/23 | Price Changed | $909,950 | -2.7% | $262 / Sq Ft | |
| 06/06/2023 06/06/23 | For Sale | $934,950 | -- | $269 / 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 |
|---|---|---|---|
| Special Warranty Deed | $25,000 | 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 | $699,950 | Construction |
Source: REcolorado®
MLS Number: 5849809
APN: 39-163-12-012
- 5188 Rob Way
- 5182 Rob Way
- 11483 W 51st Loop
- 5192 Rob Way
- 5234 Queen Ct
- 11487 W 51st Loop
- 8021 W 52nd Ave
- 5240 Routt Ct Unit B
- 5210 Routt Ct Unit B
- 11232 W 53rd Dr
- 5311 Routt Ct
- 11201 W 53rd Dr
- 4975 Robb St
- 11765 W 53rd Place
- 5148 Taft Ct
- 11890 W 52nd Ave
- 11034 W 54th Ln
- 5414 Oak St
- 12039 W 52nd Place Unit 2
- 5283 Union Ct Unit 8
- 5125 Queen Ct
- 5283 Quail Way
- 10870 W 53rd Ave
- 4700 Tabor St
- 10350 W 55th Ln
- 4685 Robb St
- 11340 W 46th Place
- 10336 W 55th Place
- 10609 W 48th Ave Unit D
- 10605 W 48th Ave Unit A
- 4735 Nelson St
- 5705 Simms St
- 10068 W 52nd Place
- 5458 Lee St
- 12302 W 56th Ln
- 11681 W 44th Ave Unit 3
- 5136 Johnson St
- 9870 W 53rd Ave
- 10625 W 58th Ave Unit A
- 10625 W 58th Ave Unit B
Ask me questions while you tour the home.