$1,999,000

3 Beds 2 Baths 3,162 Sqft

N2348 Trails End Road, Lodi, WI 53555

Property Type: Single-Family
Building Type: 1 Story
Time on Market: 38 days
Price per Sqft: $632
Waterfront: Y
Garage: 2 Car
Total Taxes: $11,519
Est. Age: 21+ Years

Description

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.

Property Details

Interior

Appliances:
  • Range/Oven, Refrigerator, Dishwasher, Microwave, Freezer, Disposal
Basement:
  • Full, Walk Out/Outer Door, Finished, Poured Concrete
Baths:
  • Full Baths: 2
  • Bath Descriptions: Stubbed For Bathroom on Lower,Master Bedroom Bath: Full,Master Bedroom Bath
Heating/Cooling:
  • Forced Air, Central Air
Heat Fuel:
  • Natural Gas
Interior Features:
  • Walk-in closet(s), Great Room, Cathedral/vaulted ceiling, Water Softener, Some Smart Home Features
Sqft:
  • Total Sqft: 3,162
  • Lot Sqft Source: Assessor/Public Record
  • Estimated Sqft Range: 3001-3500

Rooms

Room Basement Level Lower Level Main Level Upper Level
Master Bedroom 16x16
Bedroom 2 14x11
Bedroom 3 23x21
Dining Room 10x14
Family Room 23x21
Kitchen 16x13
Living Room 13x22

Exterior

Acreage:
  • Source: Assessor/Public Record
Exterior:
  • Wood
Exterior Features:
  • Patio
Garage:
  • Details: 2 Car, Attached, Opener Included
  • Spaces: 2.0
Style:
  • Ranch
Water:
  • Features: Waterfrontage on Lot, Lake, Dock/Pier, Water Ski Lake, Boat House
  • Waterfront: Y
Water/Waste:
  • Well, Private Septic System

Misc.

New Construction:
  • N
Postal:
  • Code: 53555
  • Zip+4: 0000
Street:
  • Name: Trails End Road
  • Suffix: ROAD
Tax Year:
  • 2025
Zoning:
  • Res

Map

Listing Agent-Provided Directions:
  • From I39 take exit to Wis-60 toward Lodi. Cont on Wis-60. R on Main street. Left on CTH-J. L on WIS -188. R on Smith Park. L on Trails End Dr

Monthly Payment Calculator

$
$
%
%
Est.
0.00
/month
Principal & Interest
$
Property Taxes
$
Home Insurance
$
Mortgage Insurance
$
HOA Fees
$
Utilities
$

Schools and Neighborhood

Elementary School:
  • Merrimac,merrimac
Middle School:
  • Sauk Prairie
High School:
  • Sauk Prairie
School District:
  • Sauk Prairie
Postal City:
  • Lodi
Municipality:
  • Name: WEST POINT
  • Type: Town
County:
  • COLUMBIA

Market Comparison

How this property compares to local market averages — calculated 4/17/2026

This Property
Lodi Single Family Home Avg
Columbia County Single Family Home Avg
List Price
$1,999,000
$688,893
$506,496
Median Price
—
$497,450
$399,900
Price / Sq Ft
$632
$310
$240
Days on Market
38 days
51 days
73 days
Total Listings
—
16
172

Listing Information

  • Time on Market: 38 days
  • Place Perfect Last Updated: 2026-04-15 16:29:21
  • MLS Number: 2017991
  • Subsystem Locale: WIREX_SCW
  • Listing Office: Y Realty Wisconsin
  • Listing Agent: Kyle Broom

Homes with 3 bedrooms

Explore nearby homes with 3 bedrooms

Lodi Homes

Explore homes in Lodi, Wisconsin

WIREX Logo

This information is provided by WIREX via the REALTORS Association of Northeast Wisconsin multiple listing service and is exclusively for consumers’ personal, non-commercial use. Information is deemed reliable but not guaranteed.

© 2026 WIREX-Wisconsin Real Estate Exchange – All Rights Reserved