470 Delta Queen Avenue, Prescott, WI 54021

$459,900
Property Type: Residential Bedrooms: 3 Baths: 2 Square Footage: 1,740 Lot Size (sq. ft.): 12,632 Status: Pending
Current Price: $459,900 List Date: 2/28/2026 Last Modified: 4/08/2026

Overview

Description

UNDER CONSTRUCTION! APRIL 2026 COMPLETION! JP Brooks proudly presents the Madison Villa on a slab-on-grade lot in the highly sought-after Great Rivers Community in Prescott. The Great Rivers is community is just minutes from the Mississippi River in charming Prescott, WI. Enjoy peaceful living with access to scenic trails, nature parks, and small-town charm—just a short drive from the Twin Cities. This thoughtfully designed home boasts an electric fireplace with a stone surround, a step vault ceiling in the living room and primary suite, and stylish quartz countertops in the kitchen and bathrooms. You'll love the stained cabinets, stainless steel appliances, and painted-on-site trim. Durable LVP flooring runs throughout the main areas, while a covered front porch, and a full yard with irrigation and sod completes the exterior. Pictures, photographs, colors, features, and sizes are for illustration purposes only and may vary from the home that is built. UNDER CONSTRUCTION! APRIL 2026 COMPLETION!

Listing Details MLS# 7027097

General Property Information

Common Wall
No
Lot Measurement
Acres
Manufactured Home?
No
Multiple PIDs?
No
New Development
No
Number of Fireplaces
Yes
Projected Completion Date
2026-04-30
Waterfront Present
No
Year Built
2025
Yearly/Seasonal
Yearly
Zoning
Residential-Single Family
Bath Full
Yes
Bath Three Quarters
Yes
Main Floor Total SqFt
1740
Above Grd Total SqFt
1740
Total SqFt
1740
Total Finished Sqft
1740.00
FireplaceYN
Yes
Style
(SF) Single Family
Foundation Size
1740
Garage Stalls
3
Lot Dimensions
Irregular
Acres
0.29
Assessment Pending
Unknown
Bath Half
0
Bath Quarter
0
Below Grd Total SqFt
0
Association Fee
0

Property Features

Accessible: None Air Conditioning: Central Air Amenities Unit: Ceiling Fan(s); In-Ground Sprinkler; Kitchen Center Island; Kitchen Window; Patio; Porch; Primary Bedroom Walk-In Closet; Vaulted Ceiling(s); Walk-In Closet; Washer/Dryer Hookup Appliances: Dishwasher; Microwave; Range; Refrigerator Basement: None Bath Description: Main Floor 3/4 Bath; Main Floor Full Bath; 3/4 Primary; Private Primary Builder Information: Builders Association of the Twin Cities Construction Status: Under Construc/Spec Homes Dining Room Description: Eat In Kitchen; Informal Dining Room; Kitchen/Dining Room Exterior: Brick/Stone; Vinyl Fencing: None Fireplace Characteristics: Electric; Living Room Foundation: 8 ft+ Pour Fuel: Natural Gas Heating: Forced Air Laundry: Electric Dryer Hookup; Laundry Room; Main Level; Sink; Washer Hookup Lot Description: Irregular Lot; Sod Included in Price; Tree Coverage - Light Parking Characteristics: Garage Door Opener Pool Description: None Road Frontage: City Street; Paved Streets Roof: Age 8 Years or Less; Asphalt Shingles Sellers Terms: Cash; Conventional; FHA; VA Sewer: City Sewer/Connected Stories: One Water: City Water/Connected

Contract Information

Off Market Date
2026-04-02
Contingency
None
Original List Price
459900
ListPrice
459900
Owner is an Agent?
Yes
Auction?
No

Location Tax and Other Information

House Number
470
Street Name
Delta Queen
Street Suffix
Avenue
Postal City
Prescott
County
Pierce
State
WI
Zip Code
54021
Complex/Dev/Subdivision
Great Rivers

Building Information

Finished SqFt Above Ground
1740

Lease Details

Land Leased
Not Applicable

More Information

Miscellaneous Information

Community Name
Great Rivers
DP Resource
Yes
Homestead
No

Ownership

Fractional Ownership
No

Parking Characteristics

Garage Square Feet
758
Garage Door Opener
Yes

Public Survey Info

Range#
27

Office/Member Info

Association
MAAR

Location, Tax and Other Information

AssocFeeYN
No
Legal Description
Lot 66, Add 2 - Great Rivers - Pierce
Listing City
Prescott
Map Page
167
Municipality
Prescott
School District
Prescott
School District Phone
715-262-5782
Property ID Number
271011784866
Tax Year
2026
Tax Amount
0
In Foreclosure?
No
Potential Short Sale?
No
Lender Owned?
No

Directions & Remarks

Public Remarks
UNDER CONSTRUCTION! APRIL 2026 COMPLETION! JP Brooks proudly presents the Madison Villa on a slab-on-grade lot in the highly sought-after Great Rivers Community in Prescott. The Great Rivers is community is just minutes from the Mississippi River in charming Prescott, WI. Enjoy peaceful living with access to scenic trails, nature parks, and small-town charm—just a short drive from the Twin Cities. This thoughtfully designed home boasts an electric fireplace with a stone surround, a step vault ceiling in the living room and primary suite, and stylish quartz countertops in the kitchen and bathrooms. You'll love the stained cabinets, stainless steel appliances, and painted-on-site trim. Durable LVP flooring runs throughout the main areas, while a covered front porch, and a full yard with irrigation and sod completes the exterior. Pictures, photographs, colors, features, and sizes are for illustration purposes only and may vary from the home that is built. UNDER CONSTRUCTION! APRIL 2026 COMPLETION!
Directions
From Hwy 35, turn E on Hollister Ave, then N on Sea Wing Blvd to enter the Great Rivers Community. Take a left onto Delta Queen Ave to property and the home is on the left.

Accessible

None
Yes

Air Conditioning

Central Air
Yes

Amenities Unit

Ceiling Fan(s)
Yes
In-Ground Sprinkler
Yes
Kitchen Center Island
Yes
Kitchen Window
Yes
Patio
Yes
Porch
Yes
Primary Bedroom Walk-In Closet
Yes
Vaulted Ceiling(s)
Yes
Walk-In Closet
Yes
Washer/Dryer Hookup
Yes

Appliances

Dishwasher
Yes
Microwave
Yes
Range
Yes
Refrigerator
Yes

Assessments

Assessment Balance
0
Tax With Assessments
0

Basement

None
Yes

Bath Description

Main Floor 3/4 Bath
Yes
Main Floor Full Bath
Yes
3/4 Primary
Yes
Private Primary
Yes

Builder Information

Builders Association of the Twin Cities
Yes

Construction Status

Under Construc/Spec Homes
Yes

Dining Room Description

Eat In Kitchen
Yes
Informal Dining Room
Yes
Kitchen/Dining Room
Yes

Exterior

Brick/Stone
Yes
Vinyl
Yes

Fencing

None
Yes

Fireplace Characteristics

Electric
Yes
Living Room
Yes

Foundation

8 ft+ Pour
Yes

Fuel

Natural Gas
Yes

Heating

Forced Air
Yes

Insurance Fee

Insurance Fee
0

Laundry

Electric Dryer Hookup
Yes
Laundry Room
Yes
Main Level
Yes
Sink
Yes
Washer Hookup
Yes

Lot Description

Irregular Lot
Yes
Sod Included in Price
Yes
Tree Coverage - Light
Yes

Patio, Porch and Deck Features

Patio
Yes
Porch
Yes

Pool Description

None
Yes

Road Frontage

City Street
Yes
Paved Streets
Yes

Roof

Age 8 Years or Less
Yes
Asphalt Shingles
Yes

Sellers Terms

Cash
Yes
Conventional
Yes
FHA
Yes
VA
Yes

Sewer

City Sewer/Connected
Yes

Stories

One
Yes

Water

City Water/Connected
Yes

Room Information

Dining Room Dimensions: 12x10 Level: Main First (1st) Bedroom Dimensions: 12x13 Level: Main Four Season Porch Dimensions: 11x11 Level: Main Foyer Dimensions: 5x8 Level: Main Kitchen Dimensions: 13x10 Level: Main Laundry Dimensions: 8x7 Level: Main Living Room Dimensions: 14x13 Level: Main Pantry (Walk-In) Dimensions: 4x4 Level: Main Porch Dimensions: 6x8 Level: Main Second (2nd) Bedroom Dimensions: 11x10 Level: Main Third (3rd) Bedroom Dimensions: 11x10 Level: Main
Listing Office: JPW Realty
IDX
Last Updated: April - 08 - 2026
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity SM Program of the Regional Multiple Listing Service of Minnesota, Inc. The information provided is deemed reliable but not guaranteed. Properties subject to prior sale, change or withdrawal. ©2024 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.