
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?
$689,000
Listing Price4beds
3baths
2,498sqft
8,233sqft lot
5812 Queen St, Arvada, CO 80004
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
Home type
Price / sqft
Year built
Home Details
Beautifully Renovated 4-Bedroom in west Arvada! A perfect Single Family Home. or Thinking of a Short Term Rental Property/ AirBNB- Look no further!nnWelcome to this stunning bi-level home in the highly desirable Ralston Hills neighborhoodjust minutes from Olde Town Arvada, shopping, dining, parks, trails, and the I-70 corridor for easy mountain getaways. Stenger Field offers endless indoor and outdoor recreation and Arvadas famous 4th of July Fireworks. Recently has been a successful Short-Term Rental!nnYoull love the open, sun-filled layout featuring a spacious living room with a picture-perfect window and open floor plan. The fully remodeled kitchen boasts Corian countertops, abundant new cabinetry, a stylish tile backsplash, newer appliances, and a long island with seating thats perfect for casual dining and entertaining. The adjoining dining area has a sliding glass door that opens to a multi-level deck overlooking your private backyard with a hot tub, outdoor lighting, and plenty of space for gatherings.nnThe upper level offers three bedrooms and two beautifully updated baths. On the lower level, youll find a generous great room with a cozy sunken sitting area and wood-burning stove, an oversized fourth bedroom, a third bath, a game room, and laundry. The sprawling backyard has room for a fire pit. An oversized attached two-car garage with an interior door offers extra convenience.nUpgrades include a new kitchen, luxury vinyl flooring, updated baths, new fixtures, lighti
Interior Details
2498
4
3
Has Heating:
Yes
Heating Type:
Forced Air With Air Conditioning
Has Cooling:
Yes
Cooling Type:
Central
Has Fuel:
No
Fuel Type:
N/A
Has Basement:
No
Basement Type:
Full, Daylight
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
8233
Yes
Yes
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
2
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Construction Details
Bi-level
N/A
N/A
N/A
N/A
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2019
$2,999
$10,785
$20,718
--%
$31,503
2019
$2,999
$10,785
$20,718
--%
$31,503
2018
$2,718
$6,819
$20,943
--%
$27,762
2017
$2,488
$6,819
$20,943
--%
$27,762
2016
$2,012
$5,803
$15,347
--%
$21,150
2014
$2,016
$4,872
$15,044
--%
$19,916
2013
$2,020
$4,872
$15,044
--%
$19,916
2012
$1,947
$4,929
$14,487
--%
$19,416
Average Home Price in 80004
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$699,000
$699,000
4 Beds
2.5 Baths
2,345 Sqft
7,318 Lot (sqft)
Sold 10/08/2026
$704,528
$704,528
3 Beds
4.25 Baths
2,356 Sqft
7,623 Lot (sqft)
Sold 09/17/2026
$599,900
$599,900
4 Beds
2.75 Baths
2,480 Sqft
8,015 Lot (sqft)
Sold 09/17/2026
$963,145
$963,145
5 Beds
5.25 Baths
2,509 Sqft
9,104 Lot (sqft)
Sold 09/17/2026
$807,680
$807,680
4 Beds
4.25 Baths
2,317 Sqft
7,187 Lot (sqft)
Sold 05/22/2026
$592,500
$592,500
3 Beds
4.5 Baths
2,473 Sqft
7,797 Lot (sqft)
Sold 09/29/2026
$689,000
$689,000
4 Beds
3 Baths
2,498 Sqft
8,233 Lot (sqft)
Sold 09/29/2026
$635,000
$635,000
4 Beds
2 Baths
2,476 Sqft
8,364 Lot (sqft)
Sold 09/29/2026
$616,894
$616,894
4 Beds
4.5 Baths
2,498 Sqft
7,013 Lot (sqft)
Sold 08/25/2026





