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.
Closed
$545,000
1047 174th St, Hammond, WI 54015
4beds
3,359sqft
Single Family Residence
Built in 2004
2.23 Acres Lot
$546,000 Zestimate®
$162/sqft
$2,997 Estimated rent
Home value
$546,000
$519,000 - $579,000
$2,997/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$2,997/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$2,997/mo
Rent Zestimate®
Refinance and save
$2,817/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$2,817/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 9 hours ago
Listing updated: March 11, 2026 at 06:15pm
Listed by:
Stephanie Lamia 715-972-3770,
EXIT Realty Springside
Bought with:
Jesse Penman
eXp Realty
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6824495
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), In-Floor Heating
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,359
- Total interior livable area: 3,359 sqft
- Finished area above ground: 2,043
- Finished area below ground: 1,275
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, Tree Coverage - Medium
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 & neighborhood
Location
- Region: Hammond
HOA & financial
HOA
- Has HOA: No
Price history
| Date | Event | Price |
|---|---|---|
| 3/12/2026 | Listing removed | $549,900$164/sqft |
Source: EXIT Realty broker feed #6824495 Report a problem | ||
| 3/12/2026 | Pending sale | $549,900+0.9%$164/sqft |
Source:  NorthstarMLS as distributed by MLS GRID #6824495 Report a problem | ||
| 2/27/2026 | Sold | $545,000-0.9%$162/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6824495 Report a problem | ||
| 12/10/2025 | Listed for sale | $549,900-1.8%$164/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6824495 Report a problem | ||
| 3/2/2025 | Listing removed | $559,900+2.4%$167/sqft |
Source:  WIREX MLS #6103881 Report a problem | ||
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
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
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$546,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$546,000
- Wisconsin
- Saint Croix County
- Hammond
- 54015
- 1047 174th St