$545,000
SOLD FEB 27, 2026

1047 174th St Hammond, WI 54015

4 Beds
3 Baths
3,318 Sq Ft
97,139 Sq Ft Lot

Recently Sold

$164 Per Sq Ft

1% Below List Price

78 Days on Market

Highlights

  • On Golf Course
  • No HOA
  • 3 Car Attached Garage
  • Heated Floors
  • The kitchen features windows
  • Eat-In Kitchen

About This Home

As of February 2026

Welcome Home for the Holidays! Discover comfort, style, and breathtaking scenery in this beautifully appointed home along the fairways of Pheasant Hills Golf Course. Warm, inviting, and move-in ready, it shines even brighter at Christmastime. Inside, enjoy in-floor heat and a cozy fireplace that create the perfect winter atmosphere. The modern kitchen features stainless steel appliances, granite counters, and an open layout ideal for cooking and entertaining. Large windows frame picturesque views of rolling greens and snow-dusted landscapes, offering a serene backdrop from nearly every room. Whether you’re hosting gatherings or enjoying a quiet evening by the fire, this home delivers the ideal setting. Outside, take advantage of direct golf course access and peaceful surroundings. With thoughtful upgrades, new carpet, and an unbeatable location, this home is the perfect place to celebrate the holidays—and every season. Your new home awaits.

Last Agent to Sell the Property

Stephanie Lamia

EXIT Realty Springside Brokerage Email: stephaniel@exitspringside.com Listed on: 12/05/2025

EXIT Realty Springside

Last Buyer's Agent

Jesse Penman

eXp Realty

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,228

Year Built

  • Built in 2004

Lot Details

  • Lot Dimensions are 334'x440'
  • On Golf Course
  • Property has an invisible fence for dogs
  • Few Trees

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Insulated Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction

Interior Spaces

  • 2-Story Property
  • Gas Fireplace
  • Family Room with Fireplace
  • Heated Floors

Kitchen

  • Eat-In Kitchen
  • Range
  • Microwave
  • Dishwasher
  • The kitchen features windows

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Boiler Heating System
  • Private Water Source
  • Gas Water Heater
  • Water Softener is Owned

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 018109941000

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,228

Year Built

Built in 2004

Lot Details

2.23 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: Private
  • Year Built: 2004
  • Above Grade Finished Sq Ft: 2043
  • Unit Levels: Two
  • New Construction: No
  • FractionalOwnershipYN: No
  • Attribution Contact: stephaniel@exitspringside.com
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Basement: Finished, Full, Concrete, Walkout
  • Appliances: Dishwasher, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer, Water Softener Owned
  • Fireplace Features: Family Room, Gas
  • Living Area: 3318
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 1275
  • Basement YN: Yes

Beds/Baths

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

Exterior Features

  • Roof: Asphalt
  • PoolFeatures: None
  • Fencing: Invisible
  • PatioPorchType: Patio

Garage/Parking

  • Parking Features: Attached Garage, Asphalt, Garage Door Opener, Heated Garage, Insulated Garage

Utilities

  • Heating: Boiler, Forced Air, Fireplace(s), In-Floor Heating
  • Sewer: Private Sewer
  • Electric: Circuit Breakers
  • Fuel: Natural Gas

Condo/Co-op/Association

  • Association: No
  • Amenities Unit: Balcony, Ceiling Fan(s), Deck, Hardwood Floors, Kitchen Window, Primary Bedroom Walk-In Closet, Patio, Porch, Vaulted Ceiling(s), Walk-In Closet

Schools

  • Junior High Dist: Saint Croix Central
  • SchoolDistrictPhone: 7157962256

Lot Info

  • PropertyAttachedYN: No
  • Lot Size: 334'x440'
  • Land Lease: No
  • Lot Features: On Golf Course, Tree Coverage - Medium
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • AssessmentPending: No
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick, Concrete

Tax Info

  • Tax Year: 2025
  • Assessor Parcel Number: 018109941000
  • Tax Annual Amount: 6227.62
  • TaxWithAssessments: 6227.62

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 24, 2022
Sold by
Mishler Lee L and Mishler Jessica M
Bought by
Mclaren Matt and Mclaren Melissa

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$437,600
Outstanding Balance
$407,118
Interest Rate
3.55%
Mortgage Type
New Conventional
Estimated Equity
$145,775
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 Type Sale Price Title Company
Warranty Deed $547,000 Realty Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $437,600 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/27/2026 02/27/26 Sold $545,000 -0.9% $164 / Sq Ft
12/10/2025 12/10/25 For Sale $549,900 -- $166 / 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 $6,602 $553,600 $64,500 $489,100
2024 $62 $553,600 $64,500 $489,100
2023 $6,528 $553,600 $64,500 $489,100
2022 $6,555 $356,900 $64,800 $292,100
2021 $6,177 $356,900 $64,800 $292,100
2020 $5,741 $356,900 $64,800 $292,100
2019 $5,428 $356,900 $64,800 $292,100
2018 $5,440 $356,900 $64,800 $292,100
2017 $5,450 $356,900 $64,800 $292,100
2016 $5,450 $356,900 $64,800 $292,100
2015 $5,217 $356,900 $64,800 $292,100
2014 $5,082 $356,900 $64,800 $292,100
2013 $4,648 $356,900 $64,800 $292,100
Source: Public Records

Agents Affiliated with this Home

  • Stephanie Lamia

    Seller's Agent in 2026

    Stephanie Lamia

    EXIT Realty Springside

    (715) 441-8827

    8 in this area

    46 Total Sales

    Stephanie Lamia
    Section Image
  • Jesse Penman

    Buyer's Agent in 2026

    Jesse Penman

    eXp Realty

    (651) 336-4835

    19 in this area

    253 Total Sales

    Jesse Penman
    Section Image
See All Agents

Map

Source: NorthstarMLS

MLS Number: 6824495

NorthstarMLS

APN: 018-1099-41-000

Wisconsin St Croix County Hammond 54015

1047 174th St, Hammond, WI

Sold

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

NorthstarMLS 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. Some IDX listings have been excluded from this website.
Based on information submitted to the MLS GRID

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.