Seth Yarco

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of Y Realty- MLS# 2017991MLS ProviderContact Information: [email protected]

N2348 Trails End RoadLodi, WI 53555

Single Family · 3 Beds · 2 Full Baths · 3,162 Sq. ft. | 0.31 Acres
$1,899,999 Active

N2348 Trails End Road Overview

Time on Site:
113 days
Visits:
101

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.

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map

N2348 Trails End Road Facts & Features

  • Type Single Family
  • Sq. ft. 3,162
  • Price/Sq.ft. $601
  • Lot 0.31 Acres

Details

General

School Information

  • Elementary School: Merrimac
  • Middle Or Junior School: Sauk Prairie
  • High School: Sauk Prairie

Building Information

  • Fuel: Natural gas
  • Year Built: 1974

Location/Region

  • County Or Parish: Columbia
  • Location: WEST POINT - T
  • Postal City: Lodi

Tax Information

  • Tax Annual Amount: $11,519.00
  • Tax Assessed Value: $1,012,000.00
  • Tax Year: 2025

General Information

  • Exclusions: Sellers personal property. Boat lifts and other furniture negotiable
  • Farm: No
  • Inclusions: Refrigerator, dishwasher, disposal, stove, oven, hood, water softener, dishwasher on lower level, wine chiller, thermostat, pier, and electric garage door opener
  • Parcel Number: 11040 843
  • Property Type: Single Family
  • Type: 1 story
  • Zoning: Res

Interior

Building Information

  • Heating/Cooling: Central air, Forced air

Parking Information

  • Garage: 2 car, Attached, Opener
  • Garage Spaces: 2

Beds/Baths

  • 1/2 Baths Main: 0
  • 1/2 Baths Upper: 0
  • Full Baths Upper: 0
  • Full Baths Lower: 0
  • Full Baths Main: 2
  • Bathrooms Full: 2
  • Bathrooms Half: 0
  • Bathrooms Total: 2
  • Bedrooms Total: 3
  • Bedroom 2 Level: M
  • Bedroom 2 Dimension: 14x11
  • Bedroom 3 Level: L
  • Bedroom 3 Dimension: 23x21
  • Above Grade Bedroom Count: 2
  • Primary Bed Bath: Full
  • Primary Bed Dimension: 16x16
  • Primary Bedroom Level: M

Building Interior

  • Above Grade Finished Area: 1704
  • Below Grade Finished Area: 1458
  • Laundry Level: M

General Information

  • Basement: Full, Walkout to yard, Finished, Stubbed for Bathroom, Poured concrete foundatn
  • Fireplace Features: Gas
  • Interior Features: Walk-in closet(s), Great room, Vaulted ceiling, Water softener inc, Split bedrooms, Smart thermostat
  • Living Area: 3162

Room Information

  • Dining Room Dimension: 10x14
  • Dining Room Level: M
  • Family Room Dimension: 23x21
  • Family Room Level: L
  • Kitchen Dimension: 16x13
  • Kitchen Features: Dishwasher, Disposal, Freezer, Kitchen Island, Microwave, Pantry, Range/Oven, Refrigerator
  • Kitchen Level: M
  • Laundry Dimension: 7x8
  • Living/Great Dimension: 13x22
  • Living/Great Room Level: M

Exterior

Lot Information

  • Lot Size Acres: 0.31
  • Lot Size Source: Assessor

Waterfront/View

  • Feet of Water Frontage: 127
  • Water Body Name: Wisconsin
  • Waterfront Features: Boat house, Dock/Pier, Has actual water frontage, Lake, Water ski lake
  • Waterfront: Yes

Building Exterior/Construction

  • Architectural Style: Ranch
  • Construction Materials: Wood

General Information

  • Driveway: Paved
  • Exterior Features: Patio
  • Sewer: Non-Municipal/Prvt dispos, Well

N2348 Trails End Road Neighborhood

Community

53555 (LODI) Demographics

46
Median Age
100
Population Density (per sq. mile)
50%
College Educated
$90,338
Estimated Median Income
2,953
Estimated Total Home Owners
781
Estimated Total Renters
79% / 21%
Estimated Owner / Renter Divide
2
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

N2348 Trails End Road Market Data

Based on the last 30 days in this zip code

$714,033
Average List Price
$280
Average Price per Square Foot
11
Properties Sold
60
Average Days on Market
33
Properties for Sale
Calculations provided by Reliance Network

N2348 Trails End Road History

Date Event Value Agent
6/19/2026Source: South Central Wisconsin MLS Price Reduction
$1,899,999 -5.0%
4/16/2026Source: South Central Wisconsin MLS Price Increase
$1,999,999 0.0%
4/15/2026Source: South Central Wisconsin MLS Price Reduction
$1,999,000 -7.0%
3/8/2026Source: South Central Wisconsin MLS Added to Database
March 08, 2026