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.
Active
$549,900
1047 174th St, Hammond, WI 54015
4beds
3,318sqft
Est.:
Single Family Residence
Built in 2004
2.23 Acres Lot
$550,000 Zestimate®
$166/sqft
$-- HOA
What's special
- 7 days |
- 540 |
- 18 |
Zillow last checked: 8 hours ago
Listing updated: 15 hours ago
Listed by:
Stephanie Lamia 715-972-3770,
EXIT Realty Springside
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6824495
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 3/4 bathrooms: 1
Bedroom
- Level: Main
- Area: 221 Square Feet
- Dimensions: 17x13
Bedroom 2
- Level: Main
- Area: 168 Square Feet
- Dimensions: 14x12
Bedroom 3
- Level: Main
- Area: 210 Square Feet
- Dimensions: 15x14
Bedroom 4
- Level: Lower
- Area: 182 Square Feet
- Dimensions: 14x13
Deck
- Level: Main
- Area: 96 Square Feet
- Dimensions: 6x16
Den
- Level: Main
- Area: 209 Square Feet
- Dimensions: 19x11
Dining room
- Level: Lower
- Area: 160 Square Feet
- Dimensions: 10x16
Family room
- Level: Lower
- Area: 399 Square Feet
- Dimensions: 19x21
Kitchen
- Level: Lower
- Area: 180 Square Feet
- Dimensions: 15x12
Laundry
- Level: Main
- Area: 70 Square Feet
- Dimensions: 14x5
Living room
- Level: Main
- Area: 475 Square Feet
- Dimensions: 25x19
Mud room
- Level: Lower
- Area: 56 Square Feet
- Dimensions: 8x7
Porch
- Level: Main
- Area: 168 Square Feet
- Dimensions: 6x28
Heating
- Boiler, Forced Air, Fireplace(s)
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer, Water Softener Owned
Features
- Basement: Finished,Full,Concrete,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 3,318
- Total interior livable area: 3,318 sqft
- Finished area above ground: 2,043
- Finished area below ground: 1,275
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Asphalt, Garage Door Opener, Heated Garage, Insulated Garage
- Attached garage spaces: 3
- Has uncovered spaces: Yes
- Details: Garage Dimensions (34x22), Garage Door Height (8), Garage Door Width (8)
Accessibility
- Accessibility features: None
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Pool features: None
- Fencing: Invisible
Lot
- Size: 2.23 Acres
- Dimensions: 334' x 440'
- Features: On Golf Course
Details
- Foundation area: 1316
- Parcel number: 018109941000
- Zoning description: Residential-Single Family
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick, Concrete
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Electric: Circuit Breakers
- Gas: Natural Gas
- Sewer: Private Sewer
- Water: Private
Community & HOA
HOA
- Has HOA: No
Location
- Region: Hammond
Financial & listing details
- Price per square foot: $166/sqft
- Tax assessed value: $575,600
- Annual tax amount: $6,227
- Date on market: 12/5/2025
Estimated market value
$550,000
$523,000 - $578,000
$3,134/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/10/2025 | Listed for sale | $549,900-1.8%$166/sqft |
Source:  NorthstarMLS as distributed by MLS GRID #6824495 Report a problem | ||
| 3/2/2025 | Listing removed | $559,900+2.4%$169/sqft |
Source:  WIREX MLS #6103881 Report a problem | ||
| 3/1/2022 | Sold | $547,000-2.3%$165/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6103881 Report a problem | ||
| 1/28/2022 | Pending sale | $559,900$169/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6103881 Report a problem | ||
| 10/18/2021 | Price change | $559,900-2.6%$169/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6103881 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $7,537 -0.9% | $553,600 |
| 2023 | $7,603 +17.5% | $553,600 +55.1% |
| 2022 | $6,468 -0.4% | $356,900 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$3,398/mo
Principal & interest
$2697
Property taxes
$509
Home insurance
$192
Climate risks
Neighborhood: 54015
Nearby schools
GreatSchools rating
- 8/10Saint Croix Central Middle SchoolGrades: 5-8Distance: 2.8 mi
- 4/10Saint Croix Central High SchoolGrades: 9-12Distance: 2.2 mi
- 6/10Saint Croix Central Elementary SchoolGrades: PK-4Distance: 5.4 mi
- Loading
- Loading
