NOT LISTED FOR SALE

477 Delta Queen Ave Prescott, WI 54021

Estimated Value: $522,000 - $544,559

4 Beds
3 Baths
2,705 Sq Ft
$198/Sq Ft Est. Value

Sale Details

Date Sold: November 15, 2024

Last sale price $552,000 $204 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $3,613 / mo

81 Days on Market

Highlights

  • New Construction
  • 22,651 Sq Ft lot
  • Great Room
  • Malone Elementary School Rated A-
  • Recreation Room
  • Mud Room

About This Home

As of November 2024

WELCOME to the newest rambler model home in Prescott. This home with many upgrades makes this great for your next home and those wanting 1-level living!!! Main level has owner's bedroom with a large walk-in closet & bath. An additional bedroom that could be great for an office for those working from home. Finishing out the main level there is the kitchen with a large island, black stainless steel appliances, large walk-in pantry with lower cabinet/countertop, dining area, great room, laundry room with a laundry tub, large mudroom and foyer areas. The lower level has a spacious family room, 2 additional bedrooms and 3/4 bath that make for great additional areas to entertain. This home will be used for the Fall Parade of Homes. Home can be purchased now for a middle of October or later closing. GREAT BUILDER INCENTIVES AVAILABLE WHEN USING BUILDER'S PREFERRED LENDER!! Don’t pass up this opportunity to view this home or the many other opportunities to build the home of your choice & dreams!! This home INCLUDES passive radon system, air exchanger, 1-2-10 MN equivalent home warranties.

Last Agent to Sell the Property

David Pope

Fieldstone Real Estate Specialists Listed on: 08/07/2024

Fieldstone Real Estate Specialists

Last Buyer's Agent

Angela Thompson

Coldwell Banker River Valley, REALTORS

Coldwell Banker River Valley, REALTORS

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,804

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 22,651 Sq Ft Lot
  • Lot Dimensions are 70x250
  • Irregular Lot
  • Cleared Lot

Parking

  • 3 Car Attached Garage

Home Design

  • Unfinished Walls
  • Insulated Concrete Forms
  • Pitched Roof
  • Shake Siding
  • Vinyl Siding

Interior Spaces

  • 1-Story Property
  • Stone Fireplace
  • Gas Fireplace
  • Mud Room
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • Dining Room
  • Recreation Room

Kitchen

  • Walk-In Pantry
  • Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet

Laundry

  • Laundry Room
  • Washer and Dryer Hookup

Finished Basement

  • Drain
  • Basement Storage
  • Basement Window Egress

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Gas Water Heater

Additional Features

  • Air Exchanger
  • Sod Farm

Community Details

  • No Home Owners Association
  • Built by FIELDSTONE FAMILY HOMES INC
  • Great River Community
  • Great Rivers 2Nd Addition Subdivision

Listing and Financial Details

  • Property Available on 10/14/24
  • Assessor Parcel Number 271011784847

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,804

Year Built

Built in 2024 | New Construction

Lot Details

0.52 Acres

Parking

3

Listing Details

  • Type: Residential
  • Property Subtype 1: Single Family Residence
  • Cooling System: Central Air
  • Garage Spaces: 3
  • Accessibility Features: None
  • Fireplaces: 1
  • Water Source: City Water/Connected
  • Year Built: 2024
  • Above Grade Finished Sq Ft: 1638
  • Unit Levels: One
  • New Construction: Yes
  • FractionalOwnershipYN: No
  • Rental License?: No
  • InternetOptions: Cable,Satellite
  • Special Features: 4098
  • Property Sub Type: Detached

Interior Features

  • Basement: Daylight/Lookout Windows, Drain Tiled, Egress Window(s), Finished, ICFs (Insulated Concrete Forms), Concrete, Storage Space
  • Appliances: Air-To-Air Exchanger, Dishwasher, Disposal, Humidifier, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliances
  • Fireplace Features: Gas, Living Room, Stone
  • Living Area: 2705
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 1067
  • Basement YN: Yes
  • Dining Room Type: Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Family Room, Recreation Room, Foyer, Great Room, Dining Room, Kitchen, Pantry (Walk-In), Primary Bathroom, Walk In Closet, Laundry, Mud Room, Unfinished

Beds/Baths

  • Full Bathrooms: 1
  • Total Bedrooms: 4
  • Three Quarter Bathrooms: 2

Exterior Features

  • Roof: Age 8 Years or Less, Asphalt, Pitched
  • Fencing: None
  • PatioPorchType: Covered,Front Porch

Garage/Parking

  • Parking Features: Attached Garage, Asphalt

Utilities

  • Heating: Forced Air
  • Sewer: City Sewer/Connected
  • Fuel: Natural Gas
  • Power Company: Xcel Energy

Condo/Co-op/Association

  • Association: No
  • Amenities Unit: Cable,Ceiling Fan(s),Kitchen Center Island,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Other,Porch,In-Ground Sprinkler,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet
  • Community Name: Great River

Association/Amenities

  • Builders Association Membership(s): Builders Association of the Twin Cities,St. Croix Valley Home Builders Association

Schools

  • Junior High Dist: Prescott
  • SchoolDistrictPhone: 715-262-5782

Lot Info

  • PropertyAttachedYN: No
  • Lot Size: 70x250
  • Lot Size Sq Ft: 22651.2
  • Land Lease: No
  • Lot Features: Cleared, Irregular Lot, Sod Included in Price
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • AssessmentPending: No
  • Builder License: 070800080
  • Yearly/Seasonal: Yearly

Green Features

  • Green Certified Status: Certified

Building Info

  • Construction Materials: Brick/Stone, Shake Siding, Vinyl Siding

Rental Info

  • Available Date: 2024-10-14

Tax Info

  • Tax Year: 2023
  • Assessor Parcel Number: 271011784847
  • Tax Annual Amount: 1804
  • TaxWithAssessments: 1804.0000

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 7, 2024
Closed on
Nov 15, 2024
Sold by
Fieldstone Family Homes Inc
Bought by
Hamre David
Seller's Agent
David Pope
Fieldstone Real Estate Specialists
Buyer's Agent
Angela Thompson
Coldwell Banker River Valley, REALTORS
List Price
$584,390
Sold Price
$552,000
Premium/Discount to List
-$32,390
-5.54%
Views
35
Current Estimated Value
$536,140

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$15,860
Avg. Annual Appreciation
-1.99%

Purchase Details

Closed on
Mar 22, 2024
Sold by
Oevering Homes Investment Llc
Bought by
Fieldstone Family Homes Inc

Purchase Details

Closed on
Mar 17, 2023
Sold by
Oevering Oranzo J
Bought by
Oevering Homes Investments Llc A Wisco
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Hamre David $552,000 Jessica Wolfe - Bankers Title
Fieldstone Family Homes Inc $80,000 Bankers Title - Jessica Wolfe
Oevering Homes Investments Llc A Wisco $367,400 Loberg Law Office, Llp
Oevering Oranzo J $367,400 Loberg Law Office, Llp
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/15/2024 11/15/24 Sold $552,000 -2.3% $204 / Sq Ft
10/27/2024 10/27/24 Pending -- -- --
09/23/2024 09/23/24 Price Changed $564,890 -3.3% $209 / Sq Ft
08/07/2024 08/07/24 For Sale $584,390 -- $216 / Sq Ft
Source: NorthstarMLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $9,479 $518,900 $114,100 $404,800
2024 $2,017 $114,100 $114,100 $0
2023 $1,954 $114,100 $114,100 $0
2022 $1,585 $65,100 $65,100 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: NorthstarMLS

MLS Number: 6582357

NorthstarMLS

APN: 271-01178-4847

Your Personal Tour Guide

Ask me questions while you tour the home.