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: $100K (6/19)
$1,899,999
N2348 Trails End Rd, Lodi, WI 53555
3beds
3,162sqft
Single Family Residence
Built in 1974
0.31 Acres Lot
$1,822,000 Zestimate®
$601/sqft
$-- HOA
What's special
- --
- on Zillow
- 551
- views
- 13
- saves
Zillow last checked:
Listing updated:
Listed by:
Kyle J Broom,
Y Realty
Source: SCWMLS,MLS#: 2017991
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
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
Dining room
- Level: Main
- Area: 140
- Dimensions: 10 x 14
Family room
- Area: 483
- Dimensions: 23 x 21
Kitchen
- Features: Dishwasher, Disposal, Freezer, Kitchen Island, Microwave, Pantry, Range/Oven, Refrigerator
- Level: Main
- Area: 208
- Dimensions: 16 x 13
Living room
- Level: Main
- Area: 286
- Dimensions: 13 x 22
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Water Softener Included
- Laundry: Main Level
Features
- Walk-In Closet(s), Great room, Vaulted Ceiling(s), Split bedrooms, Smart Thermostat
- Basement: Finished,Full,Bath/Stubbed,Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 3,162
- Total interior livable area: 3,162 sqft
- Finished area above ground: 1,704
Property
Parking
- Total spaces: 2
- Parking features: 2 car, Attached, Garage Door Opener
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio
- On waterfront: Yes
- Waterfront features: Boat house, Dock/Pier, Waterfront, Lake Front, Water ski lake
- Body of water: Wisconsin
- Frontage length: Waterfront: 127
Lot
- Size: 0.31 Acres
Details
- Parcel number: 11040 843
- Zoning: Res
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Poured concrete foundatn
Condition
- Year built: 1974
Utilities & green energy
- Sewer: Non-Municipal/Prvt dispos
- Water: Well
Community & HOA
Location
- Region: Lodi
Financial & listing details
- Price per square foot: $601/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,822,000
$1.73M - $1.91M
$2,374/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/19/2026 | Price change | $1,899,999-5%$601/sqft |
Source: SCWMLS #2017991 Report a problem | ||
| 4/16/2026 | Price change | $1,999,999-7%$633/sqft |
Source:  WIREX MLS #2017991 Report a problem | ||
| 3/8/2026 | Listed for sale | $2,150,000-6.3%$680/sqft |
Source: WIREX MLS #2017991 Report a problem | ||
| 3/6/2026 | Listing removed | $2,295,000$726/sqft |
Source: WIREX MLS #1994958 Report a problem | ||
| 3/11/2025 | Listed for sale | $2,295,000$726/sqft |
Source: WIREX MLS #1994958 Report a problem | ||
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
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 53555
Nearby schools
Schools provided by the listing agent
- Elementary: Merrimac
- Middle: Sauk Prairie
- High: Sauk Prairie
- District: Sauk Prairie
Source: SCWMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $1,420,0003 bd4 ba3.8k sqftW12684 State Highway 188, Lodi, WI 53555For Sale
MLS ID #2025640, Matt Winzenried Real Estate Team. SCWMLS - $999,9994 bd3 ba2.2k sqftW11296 Red Cedar Dr, Lodi, WI 53555For Sale
MLS ID #2019865, Bart Baker. SCWMLS - $1,399,0003 bd3 ba2.4k sqftW12035 Baltic Ave, Merrimac, WI 53561For Sale
MLS ID #2029876, Tammy Young. SCWMLS - $1,860,0004 bd2 ba1.7k sqftS7604c Dischler, North Freedom, WI 53951For Sale
MLS ID #2030344, Nancy Zingsheim. SCWMLS
