Stay tuned for more...
USDAProperties.com is running a little warm 🔥...

 

 

 

$939,950
USDAProperties Agent Contact Page  Agent List  share icon     map icon  QR
5184 Queen Ct
Arvada, CO 80002
5 bed 4 bath 4,041 SqFt ($232/SqFt)
4,792SqFt lot. Built 2023
Listed 2023-12-12, HOA $47, Taxes $3,300
Ⓧ USDA Ineligible
due to price & location

near Arvada

Latest Value Estimates: $935,519 from Quantarium on 2024-04-24. $928,500 from CoreLogic on 2024-04-01. $940,000 from Collateral Analytics on 2024-04-17. Forecast Estimate Value:$940,631 in 2025-04-01 by Quantarium. $984,066 in 2025-04-01 by CoreLogic. $958,508 in 2025-02-01 by Collateral Analytics.

!!MOVE-IN READY!!

* No Longer For Sale *
Your browser will attempt to redirect you to the city level in a few seconds.

SPECIAL FINANCING AVAILABLE This Hopwell comes ready to impress with two stories of smartly inspired living spaces and designer finished throughout. Beyond, a charming gourmet kitchen with a quartz island, stainless steel appliances and a pantry flows into the connected sunroom. The expansive exceptional room welcomes you to relax near a fireplace and offers access to the covered patio.

Retreat upstairs to find two generous bedrooms with a shared bath that provide ideal accommodations for family or guests. A comfortable loft and the laundry room rests near the primary suite which showcases a private bath and vast walk-in closet. If that wasn't enough, this home includes a finished basement that boasts a wide-open rec room and a bedroom and a shared bath.


Presented by Matthew Tonge at
Richmond Realty Inc.


Property MLS #7679654 from REcolorado

Bedrooms: 5
Bedrooms On Basement Level: 1
Bedrooms On Main Level: 1
Primary Bedroom Dimensions: 16.0 x 13.0
Bedroom 1 Dimensions: 11.0 x 12.0
Bedroom 2 Dimensions: 13.0 x 12.0
Bedroom 3 Dimensions: 10.0 x 12.0
Bedroom 4 Dimensions: 12.0 x 10.0
Primary Bedroom Level: Upper
Bedroom 1 Level: Main
Bedroom 2 Level: Upper
Bedroom 3 Level: Upper
Bedroom 4 Level: Basement

Total Bathrooms: 4
Full Bathrooms: 4
Bathrooms On Main Level: 1
Bathrooms On Basement Level: 1

Eat-in Kitchen
Five Piece Bath
Kitchen Island
Open Floorplan
Pantry
Primary Suite
Quartz Counters
Radon Mitigation System
Walk-In Closet(s)
Furnished Description: Unfurnished
Flooring: Carpet, Vinyl
Window Features: Double Pane Windows

Cooktop
Dishwasher
Disposal
Microwave
Oven
Range Hood

Bathroom (Full) Level: Main
Sun Room Level: Main
Sun Room Width: 9.00
Sun Room Length: 14.00
Bathroom (Full) 2 Level: Upper
Bathroom (Full) 3 Level: Upper
Laundry Level: Upper
Bathroom (Full) 4 Level: Basement
Extra Room-1 Dimensions: 17.0 x 29.0
Extra Room-2 Dimensions: 10.0 x 13.0
Great Room Dimensions: 17.0 x 17.0
Loft Dimensions: 16.0 x 16.0
Extra Room-1 Level: Basement
Extra Room-2 Level: Basement
Great Room Level: Main
Loft Level: Upper
Mud Room Level: Main
Basement Description: Finished, Sump Pump, Walk-Out Access

Cooling Features: Central Air
Fireplace Features: Gas, Great Room
Heating Features: Forced Air
Number of Fireplaces: 1

Kitchen Dimensions: 19.0 x 12.0
Kitchen Level: Main

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

Patio And Porch Features: Covered, Deck, Front Porch, Patio

Lot Description: Landscaped, Open Space, Sprinklers In Front
Lot Size Acres: 0.11
Lot Size Square Feet: 4792

Association: Yes
Association Fee: 47
Association Fee Frequency: Monthly
Calculated Total Monthly Association Fees: 47
Association Name: White Bear, Ankele Tanaka & Waldron, Attorneys at
Association Phone: 3038581800

Elementary School: Vanderhoof
Elementary School District: Jefferson County R-1
High School: Arvada West
High School District: Jefferson County R-1
Middle School: Drake
Middle or Junior School District: Jefferson County R-1

Vanderhoof Elementary School is a public elementary school located approximately 0.8 miles away.
directions icon Map directions

Drake Junior High School is a public middle school located approximately 0.9 miles away.
directions icon Map directions

Arvada West High School is a public high school located approximately 1.3 miles away.
directions icon Map directions

Alpine Valley School is a private elementary, middle and high school located approximately 0.8 miles away.
directions icon Map directions

Source Listing Status: Closed
County: Jefferson
Directions: I-25 North to 70 west to Ward Rd the take a right on Ridge road
Tax Year: 2023
Ownership: Builder
Source Property Type: Residential
Home Warranty: Yes
Source Neighborhood: Haskins Station
Parcel Number: 513678
Subdivision: Haskins Station
Zoning: Residential
Property Subtype: Single Family Residence
Lot Number: 16
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$unknown + $19,819
$19,819
$3,300
2021$unknown + $13,183
$13,183
$2,253

Sold 2024-04-24
$939,950
REcolorado
Listing removed 2024-03-23
$0
RichmondAmericanHomes
Price Changed 2024-03-19
$939,950
RichmondAmericanHomes
Price Changed 2024-03-18
$939,950
REcolorado
Price Changed 2024-03-08
$949,950
RichmondAmericanHomes
Price Changed 2024-02-20
$949,950
REcolorado
Price Changed 2024-02-18
$953,950
REcolorado
Listed 2023-12-13
$958,950
RichmondAmericanHomes
Listed 2023-12-12
$958,950
REcolorado

Total Square Feet Living: 3906
Year Built: 2023
Above Grade Finished Area: 2833
BelowGradeFinishedArea: 1073
Below Grade Unfinished Area: 135.00
Construction Materials: Frame
Direction Faces: Southwest
Foundation Details: Slab
Levels: Two
Property Age: 1
Property Condition: Under Construction
Roof: Architectural Shingles, Composition
Structure Type: House

Sewer: Public Sewer

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.