Skip To Content

1047 174th Street

Hammond, WI 54015
  • $549,900
  • STATUS: Contingent
  • ON SITE: 45 Days
  • ID#: 6824495
UPDATED: 66 min ago
$549,900
  • 4
    BEDS
  • 2.23
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 3,318
    SQFT
  • $166
    $/SQFT
Type:
Single-Family Home
Built:
2004
County:

School Ratings & Info

School District:
NorthstarMLS] logo Listing courtesy of EXIT Realty Springside.

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 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.

Monthly Payment Calculator



IDX data © 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than The Smith Team - Keller Williams Premier Realty are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. The Smith Team - Keller Williams Premier Realty is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of The Smith Team - Keller Williams Premier Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc. Information deemed reliable but not guaranteed. By viewing the listings on this site, you are agreeing to abide by the RMLS End-User License Agreement. Data last updated 2026-01-20T22:22:55.203.

Click here for Digital Millennium Copyright Act
www.twincitieshomeinfo.com/homes/171167341
Print Image

1047 174th Street Hammond, WI 54015

  • Price: $549,900
  • Status: Contingent
  • On Site: 45 Days
  • Updated: 66 min ago
  • ID#: 6824495
4
Beds
3
Baths
0
½ Baths
2.23
Acres
3,318
SQFT
$166
$/SQFT
2004
Built
County:
St. Croix
School District:
2422 - Saint Croix Central
Property 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 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.
Exterior Features

Construction Materials BrickConcrete Fencing Invisible Foundation Area 1316 Garage Dimensions 34x22 Garage Door Height 8 Garage Door Width 8 Garage Square Feet 748 Levels Two Lot Features On Golf CourseTree Coverage - Medium Lot Size Dimensions 334'x440' Parking Features Attached GarageAsphaltGarage Door OpenerHeated GarageInsulated Garage Road Frontage Type Township Roof Asphalt

Interior Features

Above Grade Finished Area 2043 Amenities Unit BalconyCeiling Fan(s)DeckHardwood FloorsKitchen WindowPrimary Bedroom Walk-In ClosetPatioPorchVaulted Ceiling(s)Walk-In Closet Appliances DishwasherDryerGas Water HeaterMicrowaveRangeRefrigeratorWasherWater Softener Owned Basement FinishedFullConcreteWalkout Bath Desc 3/4 BasementFull PrimaryPrivate PrimaryMain Floor Full BathJetted TubWalk-In Shower Stall Bathrooms One Quarter 0 Below Grade Finished Area 1275 Cooling Central Air Dining Room Description Eat In KitchenSeparate/Formal Dining Room Fireplace Features Family RoomGas Fireplace YN Yes Fireplaces Total 1 Heating BoilerForced AirFireplace(s)In-Floor Heating Rooms Deck (Main Level 6x16) Den (Main Level 19x11) Dining Room (Lower Level 10x16) Family Room (Lower Level 19x21) Bedroom (Main Level 17x13) Bedroom 4 (Lower Level 14x13) Kitchen (Lower Level 15x12) Laundry (Main Level 14x5) Living Room (Main Level 25x19) Mud Room (Lower Level 8x7) Porch (Main Level 6x28) Bedroom 2 (Main Level 14x12) Bedroom 3 (Main Level 15x14) Special Search 3 BR on One LevelMain Floor BedroomMain Floor Laundry

Property Features

Accessibility Features None Additional Parcels YN No Assessment Pending No Association Fee 0 Association YN No Contingency Other Electric Circuit Breakers Foreclosure Status No Fractional Ownership YN No Fuel Natural Gas Land Lease YN No Lender Owned No Manufactured Home N New Construction YN No Pool Features None Postal City Hammond Potential Short Sale No Present Use Yearly Property Attached YN No Property Sub Type Single Family Residence Sewer Private Sewer Tax Annual Amount 6227.62 Tax With Assessments 6227.62 Tax Year 2025 Water Source Private Zoning Description Residential-Single Family

NorthstarMLS] logo © 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.
Listing courtesy of EXIT Realty Springside: . This home sale information is not an appraisal, competitive or comparative market analysis, CMA or home valuation. Listing broker has attempted to offer accurate data, but buyers are advised to confirm all items.


IDX data © 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than The Smith Team - Keller Williams Premier Realty are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. The Smith Team - Keller Williams Premier Realty is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of The Smith Team - Keller Williams Premier Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc. Information deemed reliable but not guaranteed. By viewing the listings on this site, you are agreeing to abide by the RMLS End-User License Agreement. Data last updated 2026-01-20T22:22:55.203.

Click here for Digital Millennium Copyright Act
 
https://bt-photos.global.ssl.fastly.net/northstar/orig_boomver_1_6824495-2.jpg https://bt-photos.global.ssl.fastly.net/northstar/orig_boomver_1_6824495-2.jpg https://bt-photos.global.ssl.fastly.net/northstar/orig_boomver_1_6824495-2.jpg
Logo
The Smith Team - Keller Williams Premier Realty
3555 Willow Lake Blvd #100
Vadnais Heights MN, 55110
NorthstarMLS] logo Listing courtesy of EXIT Realty Springside.