Skip main navigation
Active
  • $459,900

    470 Delta Queen Ave, Prescott, WI 54021

    3beds
    1,740sqft
    : 
    Single Family Residence
    Built in 2025
    0.3 Acres Lot
    $-- Zestimate®
    $264/sqft
    $-- HOA

    What's special

    Stainless steel appliancesCovered front porchDurable lvp flooringStained cabinetsPainted-on-site trim
    UNDER CONSTRUCTION! JANUARY 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! JANUARY 2026 COMPLETION!
    61 days
    |
    95
    |
    0
    |

    Zillow last checked: 8 hours ago

    Listing updated: December 01, 2025 at 07:58am

    Listed by:

    Amy Teal 612-382-1378,

    JPW Realty,

    Daniel Hanson 763-439-0868

    Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6802827MLS Logo

    Tour with a local agent

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 1
    • 3/4 bathrooms: 1
    Rooms
    • Room types: Living Room, Dining Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Porch, Walk In Closet, Foyer, Laundry, Pantry (Walk-In), Four Season Porch
    Bedroom 1
    • Level: Main
    • Area: 156 Square Feet
    • Dimensions: 12x13
    Bedroom 2
    • Level: Main
    • Area: 110 Square Feet
    • Dimensions: 11x10
    Bedroom 3
    • Level: Main
    • Area: 110 Square Feet
    • Dimensions: 11x10
    Dining room
    • Level: Main
    • Area: 120 Square Feet
    • Dimensions: 12x10
    Other
    • Level: Main
    • Area: 121 Square Feet
    • Dimensions: 11x11
    Foyer
    • Level: Main
    • Area: 40 Square Feet
    • Dimensions: 5x8
    Kitchen
    • Level: Main
    • Area: 130 Square Feet
    • Dimensions: 13x10
    Laundry
    • Level: Main
    • Area: 56 Square Feet
    • Dimensions: 8x7
    Living room
    • Level: Main
    • Area: 182 Square Feet
    • Dimensions: 14x13
    Other
    • Level: Main
    • Area: 16 Square Feet
    • Dimensions: 4x4
    Porch
    • Level: Main
    • Area: 48 Square Feet
    • Dimensions: 6x8
    Walk in closet
    • Level: Main
    • Area: 63 Square Feet
    • Dimensions: 9x7
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Air-To-Air Exchanger, Dishwasher, Electric Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliance(s)
    Features
    • Basement: None
    • Number of fireplaces: 1
    • Fireplace features: Electric, Living Room
    Interior area
    • Total structure area: 1,740
    • Total interior livable area: 1,740 sqft
    • Finished area above ground: 1,740
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Asphalt, Garage Door Opener
    • Attached garage spaces: 3
    • Has uncovered spaces: Yes
    Accessibility
    • Accessibility features: None
    Features
    • Levels: One
    • Stories: 1
    • Patio & porch: Patio, Porch
    • Pool features: None
    • Fencing: None
    Lot
    • Size: 0.3 Acres
    • Features: Irregular Lot, Sod Included in Price, Wooded
    Details
    • Foundation area: 1740
    • Parcel number: 271011784866
    • Zoning description: Residential-Single Family

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Brick/Stone, Vinyl Siding
    • Roof: Age 8 Years or Less,Asphalt
    Condition
    • Age of Property: 0
    • New construction: Yes
    • Year built: 2025

    Utilities & green energy

    • Gas: Natural Gas
    • Sewer: City Sewer/Connected
    • Water: City Water/Connected

    Community & HOA

    Community
    • Subdivision: Great Rivers
    HOA
    • Has HOA: No
    Location
    • Region: Prescott

    Financial & listing details

    • Price per square foot: $264/sqft
    • Tax assessed value: $91,300
    • Annual tax amount: $1,421
    • Date on market: 10/10/2025
    • Cumulative days on market: 61 days
    • Road surface type: Paved
    Get pre-qualifiedBe ready to make an offer.
    Connect with an agentGet info on this home, tour, and more.
    Calculate monthly paymentSee if you can afford this home.

    Estimated market value

    Not available

    Estimated sales range

    Not available

    Not available

    Price history

    Price history
    DateEventPrice
    10/10/2025Listed for sale$459,900+513.2%$264/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6802827 Report a problem
    9/5/2025Sold$75,000-5.7%$43/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6457425 Report a problem
    7/7/2025Pending sale$79,500$46/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6457425 Report a problem
    11/8/2023Listed for sale$79,500+5.3%$46/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6457425 Report a problem
    11/2/2023Listing removed--
    Source: NorthstarMLS as distributed by MLS GRID #6378908 Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax assessment
    2024$1,421 +2.7%$87,500
    2023$1,384 +13.6%$87,500 +75%
    2022$1,218 $50,000

    Find assessor info on the county website

    BuyAbility℠ payment

    Est. payment
    $2,950/mo
    Principal & interest
    $2222
    Property taxes
    $567
    Home insurance
    $161

      Climate risks

      Neighborhood: 54021

      Nearby schools

      GreatSchools rating

      Similar homes

      Skip to the end of the carouselSkip to the beginning of the carousel
      • Loading
      • Loading