Listed at
$459,900
$264/sqft

Great Rivers

470 Delta Queen Avenue, Prescott, WI, 54021
3  Bedrooms2  Bathrooms1,740  Square Feet0.298  Acres
Days on market353
Year built2025
Garage spaces3
TypeResidential
Est. $10,797buyer credit when you buy with SODL
Interested?

Pick a date to request a showing

Cancel anytime, free.

About this home

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!

Contact us

Home facts

Property typeResidential
Property subtypeSingle Family Residence
Year built2025
LevelsOne
Living area1,740 sqft
Above-grade finished1,740 sqft
Below-grade finished0 sqft
Lot size0.298 acres (Irregular)
Days on market353
ListedOct 10, 2025
New constructionYes
MLS #NST6802827
CountyPierce
SubdivisionGreat Rivers
Parcel #271011784866

Facts & features

Interior

Bedrooms
3
Bathrooms
2
Bath breakdown
1 full / 1 3/4
Heating
Forced Air
Cooling
Central Air
Appliances
Air-To-Air Exchanger, Dishwasher, Electric Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliances

Property

Levels / stories
One
Garage
3 spaces · 758 sqft
Parking features
Attached Garage, Asphalt, Garage Door Opener
Patio & porch
Patio, Porch
Pool
None
Fencing
None

Construction

Property type
Residential
Property subtype
Single Family Residence
Foundation
1,740 sqft
Roof
Age 8 Years or Less, Asphalt
New construction
Yes
Year built
2025

Utilities

Water
City Water/Connected
Sewer
City Sewer/Connected
Fuel
Natural Gas

Community & HOA

Subdivision
Great Rivers
HOA
No HOA
School district
Prescott

Financial & listing details

Annual tax
$0 (2025)
Listed
Oct 10, 2025
Days on market
353
Manufactured home
Yes

Interior details

Total bathrooms2
Full baths1
3/4 baths1
Half baths0
1/4 baths0
BasementNone
HeatingForced Air
CoolingCentral Air
Fireplaces1
LaundryElectric Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
AppliancesAir-To-Air Exchanger, Dishwasher, Electric Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliances
DiningEat In Kitchen, Informal Dining Room, Kitchen/Dining Room
AmenitiesCeiling Fan(s), Kitchen Center Island, Kitchen Window, Primary Bedroom Walk-In Closet, Patio, Porch, In-Ground Sprinkler, Vaulted Ceiling(s), Washer/Dryer Hookup, Walk-In Closet
AccessibilityNone

Exterior & lot

RoofAge 8 Years or Less, Asphalt
Foundation area1,740 sqft
Patio/porchPatio, Porch
Lot featuresIrregular Lot, Sod Included in Price, Tree Coverage - Light
Road frontageCity Street, Paved Streets
ZoningResidential-Single Family

Utilities

Water sourceCity Water/Connected
SewerCity Sewer/Connected
FuelNatural Gas

Parking & garage

ParkingAttached Garage, Asphalt, Garage Door Opener
Garage spaces3
Garage size758 sqft

Financial details

Annual taxes$0
Tax year2025
Taxes w/ assessments0
Assessment pendingUnknown
Down payment resourceYes
Lender ownedNo
Short saleNo
ForeclosureNo

Schools

District number1738
District phone7152625782
High schoolPrescott
SODL flat fee brokerage
$10,797Estimated buyer credit
SODL platform fee $3,000Your buyer credit $10,797

How SODL buyer credits work

When you buy with SODL, the brokerage charges a flat $3,000 platform fee at closing. The remaining buyer-side commission (typically 3% of the purchase price) is credited directly back to you at closing, reducing the cash you bring to the table.

  • Tour homes with SODL’s flexible showing network
  • Submit offers and manage your transaction through the platform
  • Keep more money at closing through transparent flat-fee pricing

A clear, modern way to buy with expert guidance and meaningful savings.

Estimated monthly payment

$3,030/mo
Principal & interest$2,417
Property taxes (est.)$460
Home insurance (est.)$153
%
$91,980
0%50%
Credit score
Loan term

These payment estimates are for illustration purposes only and may vary based on your lender, interest rate, credit profile, down payment, taxes, insurance, and loan terms. For a more accurate monthly payment estimate, speak with your lender or connect with SODL’s preferred lending partner.

Location

470 Delta Queen Avenue, Prescott, WI, 54021

Listing information

MLS #NST6802827
StatusActive
Last updatedFeb 26, 2026, 2:36 PM
Originally listedOct 10, 2025, 2:12 PM
Listing officeJPW Realty
Co-listing officeJPW Realty

Listing information provided courtesy of the MLS. This information is deemed reliable but is not guaranteed.

Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.