Skip main navigation
For sale
    • Price cut: $100K (6/19)
    $1,899,999

    N2348 Trails End Rd, Lodi, WI 53555

    3beds
    3,162sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1974
    0.31 Acres Lot
    $1,813,200 Zestimate®
    $601/sqft
    $-- HOA

    What's special

    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.
    40 days
    |
    935
    |
    11
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Kyle J Broom,

    Y Realty

    Source: SCWMLS,MLS#: 2017991

    Loading...

      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: 6/5/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,813,200

        $1.72M - $1.90M

        $2,813/mo

        Price history

        DateEventPrice
        6/19/2026Price change$1,899,999-5%$601/sqft
        Source: SCWMLS #2017991 Report a problem
        4/16/2026Price change$1,999,999-7%$633/sqft
        Source: WIREX MLS #2017991 Report a problem
        3/8/2026Listed for sale$2,150,000-6.3%$680/sqft
        Source: WIREX MLS #2017991 Report a problem
        3/6/2026Listing removed$2,295,000$726/sqft
        Source: WIREX MLS #1994958 Report a problem
        3/11/2025Listed for sale$2,295,000$726/sqft
        Source: WIREX MLS #1994958 Report a problem

        Public tax history

        YearProperty taxesTax 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.
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: 53555

        Getting around

        0 / 100
        Car-Dependent
        19 / 100
        Somewhat Bikeable

        Nearby schools

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

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Lodi Topics

                Search
                Updates
                Favorites
                Plan
                Inbox