Enjoy breathtaking panoramic views of Lake Wisconsin, with stunning sunrises and sunsets and scenic views of Devil?s Head Ski Resort. This fully remodeled waterfront home is ideal as a primary residence or luxury retreat. Interior highlights include a gourmet kitchen with solid surface countertops and premium appliances, multiple fireplaces, and expansive lake views from the living room, primary suite, lower-level family room with wet bar, and four-season room. Outdoor features include a private pier, boathouse with rooftop deck, and beautifully maintained spaces perfect for entertaining or relaxing. Conveniently located near popular waterfront dining accessible by boat or car.
Active
Price cut: $150K (4/16)
$1,999,999
N2348 Trails End Road, Lodi, WI 53555
3beds
3,162sqft
Est.: Get pre-qualified
Single Family Residence
Built in 1974
0.31 Acres Lot
$1,899,000 Zestimate®
$633/sqft
$-- HOA
What's special
Stunning sunrises and sunsetsPrivate pierMultiple fireplacesPremium appliancesBoathouse with rooftop deck
- 84 days |
- 728 |
- 8 |
Zillow last checked:
Listing updated:
Listed by:
Kyle Broom 262-370-3244,
Y Realty Wisconsin
Source: WIREX MLS,MLS#: 2017991
Originating MLS: South Central Wisconsin MLS
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bedrooms: 2
Rooms
- Room types: Great Room
Primary bedroom
- Level: Main
- Area: 256
- Dimensions: 16 x 16
Bedroom 2
- Level: Main
- Area: 154
- Dimensions: 14 x 11
Bedroom 3
- Level: Lower
- Area: 483
- Dimensions: 23 x 21
Bathroom
- Features: Stubbed For Bathroom on Lower, Master Bedroom Bath: Full, Master Bedroom Bath
Dining room
- Level: Main
- Area: 140
- Dimensions: 10 x 14
Family room
- Level: Lower
- Area: 483
- Dimensions: 23 x 21
Kitchen
- Level: Main
- Area: 208
- Dimensions: 16 x 13
Living room
- Level: Main
- Area: 286
- Dimensions: 13 x 22
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Range/Oven, Refrigerator, Dishwasher, Microwave, Freezer, Disposal, Water Softener
Features
- Walk-In Closet(s), Cathedral/vaulted ceiling, Pantry, Kitchen Island
- Basement: Full,Walk-Out Access,Finished,Concrete
Interior area
- Total structure area: 3,162
- Total interior livable area: 3,162 sqft
- Finished area above ground: 1,704
- Finished area below ground: 1,458
Property
Parking
- Total spaces: 2
- Parking features: 2 Car, Attached, Garage Door Opener
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio
- On waterfront: Yes
- Waterfront features: Waterfront, Lake, Dock/Pier, Water Ski Lake
Lot
- Size: 0.31 Acres
Details
- Additional structures: Boat House
- Parcel number: 11040 843
- Zoning: Res
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Wood Siding
Condition
- 21+ Years
- New construction: No
- Year built: 1974
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
Location
- Region: Lodi
- Municipality: West Point
Financial & listing details
- Price per square foot: $633/sqft
- Tax assessed value: $1,012,000
- Annual tax amount: $11,519
- Date on market: 3/8/2026
- Inclusions: Refrigerator, Dishwasher, Disposal, Stove, Oven, Hood, Water Softener, Dishwasher On Lower Level, Wine Chiller, Thermostat, Pier, And Electric Garage Door Opener
- Exclusions: Sellers Personal Property. Boat Lifts And Other Furniture Negotiable
Estimated market value
$1,899,000
$1.80M - $1.99M
$2,804/mo
Price history
| Date | Event | Price |
|---|---|---|
| 4/16/2026 | Price change | $1,999,999-7%$633/sqft |
Source: | ||
| 3/8/2026 | Listed for sale | $2,150,000-6.3%$680/sqft |
Source: | ||
| 3/6/2026 | Listing removed | $2,295,000$726/sqft |
Source: | ||
| 3/11/2025 | Listed for sale | $2,295,000$726/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $11,335 -4.9% | $1,012,000 |
| 2023 | $11,924 +33.6% | $1,012,000 +106.7% |
| 2022 | $8,926 +4.1% | $489,600 |
| 2021 | $8,574 +30.9% | $489,600 +25.8% |
| 2020 | $6,551 -0.1% | $389,300 |
| 2019 | $6,558 -7.5% | $389,300 -8.9% |
| 2018 | $7,092 +1% | $427,100 |
| 2017 | $7,019 +2.7% | $427,100 |
| 2016 | $6,832 -3.1% | $427,100 |
| 2015 | $7,049 +1.8% | $427,100 |
| 2014 | $6,923 -1% | $427,100 |
| 2013 | $6,994 -1.2% | $427,100 |
| 2012 | $7,076 -4.2% | $427,100 -10.1% |
| 2010 | $7,387 | $475,000 |
| 2009 | -- | $475,000 |
| 2008 | -- | $475,000 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 53555
Nearby schools
GreatSchools rating
- 6/10Grand Avenue Elementary SchoolGrades: 3-5Distance: 6.3 mi
- 4/10Sauk Prairie Middle SchoolGrades: 6-8Distance: 6.8 mi
- 7/10Sauk Prairie High SchoolGrades: 9-12Distance: 6.7 mi
Schools provided by the listing agent
- Elementary: Merrimac,merrimac
- Middle: Sauk Prairie
- High: Sauk Prairie
- District: Sauk Prairie
Source: WIREX MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Wisconsin
- Columbia County
- Lodi
- 53555
- N2348 Trails End Road




