1047 174th St

Hammond, WI 54015

$549,900
Price
4
Beds
3,318 Sq. Ft.
$166 / Sq. Ft.
3,318
Sq. Ft.
$166
per Sq. Ft.
Active Under Contract
Active Under Contract

Description

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...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.
  1. Listed by EXIT Realty Springside • Stephanie Lamia

Property Details for 1047 174th Street

Zoning Jurisdiction
Residential-Single Family
LISTING UPDATED: 12/29/2025 10:46 AM

Property Details for 1047 174th Street

StatusActive Under Contract
MLS #6824495
Days on Compass1
Taxes$6,228 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built2004
Lot Size2.23 AC / 97,138 SF
CountySt. Croix County

Location

Listing Courtesy of EXIT Realty Springside
Add your commute

Building Information for 1047 174th Street

Stories-Year Built2004Building Size-Lot Size2.23 AC / 97,138 SF

Payment Calculator

$3,236 per month

30 year fixed, 6.28% Interest

Principal and Interest

$2,717

Property Taxes

$519

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 1047 174th Street

Summary
Location and General Information
  • City Name: Hammond
  • County Or Parish: St. Croix
  • County: St. Croix-WI
  • Directions: I 94 to Exit 10 to Roberts. Go north on 65. Right on Hwy 12. Left on 170th St, Right on 100th Ave, Left onto 174th St. Home is at the end of the road.
  • Latitude: 45.0135882163
  • Longitude: -92.4502588447
  • Map Coordinate: 999-A1
  • City and Location: Hammond
  • City and Location Text: Hammond(WI)
  • Postal Code: 54015
  • State Or Province: WI
  • Public Survey Township: 29N
Taxes and HOA Information
  • Additional Parcels: No
  • Association Fee: $.00
  • Association: No
  • Parcel Number: 018109941000
  • Tax Annual Amount: $6,227.62
  • Tax Legal Description: SEC 09 T29N R17W PT NE SW & PT SE SW PHEASANT RIDGE 1ST LOT 41 (2.430AC)
  • Tax Other Annual Assessment Amount: $.00
  • Tax Year: 2025
  • Tax With Assessments: 6227.62
School Information
  • High School District: 1145 - Saint Croix Central
  • School District Number: 1145
  • School District Phone: 7157962256
Property
Lot Information
  • Above Grade Fin SQFT: 2043.0
  • Below Grade Fin SQFT: 1275.0
  • SQFT Total: 3318.0
  • Lot Features: On Golf Course, Tree Coverage - Medium
  • Lot Size Area: 2.23
  • Lot Size Dimensions: 334'x440'
  • Lot Size Units: Acres
  • Present Use: Yearly
  • Property Attached: No
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • SQFT Main Total: 2043
  • Above Grade SqFt Total: 2043
  • Below Grade SqFt Total: 1316
Utilities
  • Electric: Circuit Breakers
  • Sewer: Private Sewer
  • Water Source: Private
Interior and Exterior Features
Exterior Features
  • Accessibility Features: None
  • Fencing: Invisible
  • Foundation Area: 1316.0
  • Fuel: Natural Gas
  • Pool Features: None
  • Road Frontage Type: Township
  • Roof: Asphalt
  • Patio Porch Type: Patio
Interior Features
  • Appliances: Dishwasher, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer, Water Softener Owned
  • Basement Type: Finished, Full, Concrete, Walkout
  • Amenities Unit: Balcony,Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Primary Bedroom Walk-In Closet,Patio,Porch,Vaulted Ceiling(s),Walk-In Closet
  • Bath Desc: 3/4 Basement,Full Primary,Private Primary,Main Floor Full Bath,Jetted Tub,Walk-In Shower Stall
  • Bathrooms Full: 2
  • Bathrooms Half: 0
  • Bathrooms One Quarter: 0
  • Bathrooms Three Quarter: 1
  • Bathrooms Total Count: 3
  • Bedrooms Total: 4
  • Fireplace Features: Family Room, Gas
  • Fireplaces Total: 1
  • FireplaceYN: Yes
  • Cooling: Central Air
  • Dining Room Description: Eat In Kitchen,Separate/Formal Dining Room
  • DP Resource: Yes
  • Garage Dimensions: 34x22
  • Garage Door Height: 8
  • Garage Door Width: 8
  • Garage Square Feet: 748
  • Heating: Boiler, Forced Air, Fireplace(s), In-Floor Heating
  • Levels: Two
  • Room List: Deck, Den, Dining Room, Family Room, Bedroom, Bedroom 4, Kitchen, Laundry, Living Room, Mud Room, Porch, Bedroom 2, Bedroom 3
  • Basement YN: Yes
Room Information
Room 1
  • Room Dimensions: 6x16
  • Room Level: Main
  • Room Type: Deck
Room 2
  • Room Dimensions: 19x11
  • Room Level: Main
  • Room Type: Den
Room 3
  • Room Dimensions: 10x16
  • Room Level: Lower
  • Room Type: Dining Room
Room 4
  • Room Dimensions: 19x21
  • Room Level: Lower
  • Room Type: Family Room
Room 5
  • Room Dimensions: 17x13
  • Room Level: Main
  • Room Type: Bedroom
Room 6
  • Room Dimensions: 14x13
  • Room Level: Lower
  • Room Type: Bedroom 4
Room 7
  • Room Dimensions: 15x12
  • Room Level: Lower
  • Room Type: Kitchen
Room 8
  • Room Dimensions: 14x5
  • Room Level: Main
  • Room Type: Laundry
Room 9
  • Room Dimensions: 25x19
  • Room Level: Main
  • Room Type: Living Room
Room 10
  • Room Dimensions: 8x7
  • Room Level: Lower
  • Room Type: Mud Room
Room 11
  • Room Dimensions: 6x28
  • Room Level: Main
  • Room Type: Porch
Room 12
  • Room Dimensions: 14x12
  • Room Level: Main
  • Room Type: Bedroom 2
Room 13
  • Room Dimensions: 15x14
  • Room Level: Main
  • Room Type: Bedroom 3

Property History for 1047 174th Street

DateEvent & SourcePriceAppreciation
Dec 29, 2025

In Contract

NorthStar #6824495

—
Dec 10, 2025

Listed (Active)

NorthStar #6824495

—
Mar 1, 2022

Sold

NorthStar #6103881

$547,000—
Feb 24, 2022

Sold (Public Record)

Public Record #1485381648

$547,000—
Jan 28, 2022

Pending

NorthStar #6103881

—
Sep 22, 2021

Listed (Active)

NorthStar #6103881

$595,000—
DateEvent & SourcePrice
12/29/2025

In Contract

NorthStar #6824495

—
12/10/2025

Listed (Active)

NorthStar #6824495

—
03/01/2022

Sold

NorthStar #6103881

$547,000
02/24/2022

Sold (Public Record)

Public Record #1485381648

$547,000
01/28/2022

Pending

NorthStar #6103881

—
09/22/2021

Listed (Active)

NorthStar #6103881

$595,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 1047 174th Street

Taxable ValueLand$64,500Additions$489,100Total$553,600
Tax Record2024$6,228 ($519 / month)
Home Facts
Beds0Lot Size105,851 SqFtStyleSingle Family ResidenceCountyST. CROIXAPN018-1099-41-000

Schools near 1047 174th Street

This home is within Saint Croix Central School District.
Rating
School
Type
Grades
Distance
Saint Croix Central Elementary School
Public - PK to 4
Saint Croix Central Middle School
Public - 5 to 8
Saint Croix Central High School
Public - 9 to 12
Saint Croix Academy Of Virtual Ed
Charter - PK to 12
Rating
School
Distance
Saint Croix Central Elementary School
PublicPK to 4

Saint Croix Central Middle School
Public5 to 8

Saint Croix Central High School
Public9 to 12

Saint Croix Academy Of Virtual Ed
CharterPK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of EXIT Realty Springside

Properties displayed may be listed or sold by various participants in the MLS. Based on information submitted to the MLS GRID as of 01/03/2026 02:28 PM. All data is obtained from various sources and may not have been verified by broker orMLS GRID. Supplied Open House Information is subject to change without notice. All informationshould be independently reviewed and verified for accuracy. Properties may or may not be listed bythe office/agent presenting the information.