This Poplar plan is fully finished with 5 BD, 3 BA, 3 GAR. The upper level has a sun-filled & spacious great room, kitchen spacious with island, dining area, owner’s suite (with private bath & closet), additional 2 bedrooms & additional 1-full bathroom. In the lower level, you will find a large family room, 2-bedrooms, 3/4 bath and laundry. Best of all, only minutes away from the Prescott downtown, Mississippi River and St. Croix River. Photo is of similar home from different development. GREAT BUILDER & LENDER INCENTIVES AVAILABLE WHEN USING BUILDER'S PREFERRED LENDER!!
Closed
$471,952
457 Delta Queen Ave, Prescott, WI 54021
5beds
2,734sqft
Single Family Residence
Built in 2025
0.27 Square Feet Lot
$483,300 Zestimate®
$173/sqft
$3,401 Estimated rent
Home value
$483,300
$362,000 - $643,000
$3,401/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: August 25, 2025 at 09:57am
Listed by:
David J Pope 651-249-7150,
Fieldstone Real Estate Specialists
Bought with:
Non-MLS
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6707715
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 2
Bedroom 1
- Level: Main
- Area: 203 Square Feet
- Dimensions: 14x14.5
Bedroom 2
- Level: Main
- Area: 120.75 Square Feet
- Dimensions: 11.5x10.5
Bedroom 3
- Level: Main
- Area: 115.5 Square Feet
- Dimensions: 11x10.5
Bedroom 4
- Level: Lower
- Area: 196 Square Feet
- Dimensions: 14x14
Bedroom 5
- Level: Lower
- Area: 144 Square Feet
- Dimensions: 12x12
Primary bathroom
- Level: Main
- Area: 72 Square Feet
- Dimensions: 8x9
Bathroom
- Level: Main
- Area: 60 Square Feet
- Dimensions: 10x6
Bathroom
- Level: Lower
- Area: 66 Square Feet
- Dimensions: 6x11
Dining room
- Level: Main
- Area: 123.5 Square Feet
- Dimensions: 9.5x13
Family room
- Level: Lower
- Area: 512 Square Feet
- Dimensions: 32x16
Foyer
- Level: Main
- Area: 64 Square Feet
- Dimensions: 8x8
Kitchen
- Level: Main
- Area: 123.5 Square Feet
- Dimensions: 9.5x13
Laundry
- Level: Lower
- Area: 110 Square Feet
- Dimensions: 10x11
Living room
- Level: Main
- Area: 270 Square Feet
- Dimensions: 15x18
Utility room
- Level: Lower
- Area: 108.5 Square Feet
- Dimensions: 7x15.5
Walk in closet
- Level: Main
- Area: 40 Square Feet
- Dimensions: 8x5
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Air-To-Air Exchanger, Dishwasher, Disposal, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliance(s)
Features
- Basement: Daylight,Drain Tiled,Drainage System,Finished,Concrete,Sump Pump
Interior area
- Total structure area: 2,734
- Total interior livable area: 2,734 sqft
- Finished area above ground: 1,374
- Finished area below ground: 1,099
Property
Parking
- Total spaces: 3
- Parking features: Attached, Asphalt
- Attached garage spaces: 3
- Details: Garage Dimensions (28X22), Garage Door Height (7), Garage Door Width (16)
Accessibility
- Accessibility features: None
Features
- Levels: Multi/Split
Lot
- Size: 0.27 sqft
- Dimensions: 90 x 140
- Features: Cleared
Details
- Foundation area: 1360
- Parcel number: 271011784852
- Zoning description: Residential-Single Family
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick/Stone, Shake Siding, Vinyl Siding, Concrete, Frame
- Roof: Age 8 Years or Less
Condition
- Age of Property: 0
- New construction: Yes
- Year built: 2025
Details
- Builder name: FIELDSTONE FAMILY HOMES INC
Utilities & green energy
- Electric: Circuit Breakers, 200+ Amp Service
- Gas: Natural Gas
- Sewer: City Sewer/Connected
- Water: City Water/Connected
Community & neighborhood
Location
- Region: Prescott
- Subdivision: Great Rivers Second Addition
HOA & financial
HOA
- Has HOA: No
Other
Other facts
- Available date: 08/05/2025
Price history
| Date | Event | Price |
|---|---|---|
| 7/30/2025 | Sold | $471,952+0.1%$173/sqft |
Source:  NorthstarMLS as distributed by MLS GRID #6707715 | ||
| 4/24/2025 | Pending sale | $471,592+454.8%$172/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6707715 | ||
| 7/20/2024 | Listing removed | $85,000$31/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6571945 | ||
| 7/18/2024 | Listed for sale | $85,000+6.3%$31/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6571945 | ||
| 7/6/2024 | Listing removed | -- |
Source:  WIREX MLS #6141402 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $1,388 +2.7% | $85,500 |
| 2023 | $1,352 +13.8% | $85,500 +75.2% |
| 2022 | $1,188 | $48,800 |
Find assessor info on the county website
Neighborhood: 54021
Nearby schools
GreatSchools rating
- 9/10Malone Elementary SchoolGrades: PK-5Distance: 1.1 mi
- 9/10Prescott Middle SchoolGrades: 6-8Distance: 1.4 mi
- 7/10Prescott High SchoolGrades: 9-12Distance: 0.9 mi
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$483,300
2% more+ $9,666
With Zillow Showcase(estimated)
$492,966