Enjoy serene lake life in this beautifully updated home just across from Lake Poygan, where breathtaking views greet you from the front lawn or through the patio doors. Perfectly situated near a public access boat landing and less than a mile from Pony Creek Park, this property offers easy access to over 14,000 acres of water known for Northern Pike, Bluegill, and Sturgeon. Inside, you'll find generous living spaces with thoughtful updates throughout, every system, from electrical and plumbing to HVAC, insulation, and the full foundation, has been replaced in the last five years. Highlights include a stunning new kitchen and baths, rebuilt porches, a new garage, and a new roof. Fenced-in side yard. Move right in and start enjoying comfort, style, and the charm of lakeside living
Closed
$342,000
W197 Main STREET, Fremont, WI 54940
3beds
2,300sqft
Single Family Residence
Built in 1900
0.3 Acres Lot
$344,900 Zestimate®
$149/sqft
$1,827 Estimated rent
Home value
$344,900
Estimated sales range
Not available
$1,827/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: December 27, 2025 at 11:56pm
Listed by:
Daniel Wilde 414-617-5998,
Keller Williams-MNS Wauwatosa
Bought with:
Tara L Sherman
Source: WIREX MLS,MLS#: 1931276
Originating MLS: Metro MLS
Originating MLS: Metro MLSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bedrooms: 1
Primary bedroom
- Level: Upper
- Area: 221
- Dimensions: 13 x 17
Bedroom 2
- Level: Upper
- Area: 108
- Dimensions: 12 x 9
Bedroom 3
- Level: Main
- Area: 234
- Dimensions: 18 x 13
Bathroom
- Features: Tub Only, Shower Stall
Dining room
- Level: Main
- Area: 156
- Dimensions: 12 x 13
Family room
- Level: Main
- Area: 132
- Dimensions: 11 x 12
Kitchen
- Level: Main
- Area: 396
- Dimensions: 22 x 18
Living room
- Level: Main
- Area: 378
- Dimensions: 21 x 18
Heating
- Propane, Forced Air, Zoned
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Oven, Refrigerator, Washer
Features
- Pantry, Walk-In Closet(s), Kitchen Island
- Flooring: Wood
- Basement: Block,Crawl Space
Interior area
- Total structure area: 2,300
- Total interior livable area: 2,300 sqft
Property
Parking
- Total spaces: 1
- Parking features: Garage Door Opener, Detached, 1 Car, 1 Space
- Garage spaces: 1
Features
- Levels: Two
- Stories: 2
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Lake
Lot
- Size: 0.30 Acres
Details
- Parcel number: 004036717900
- Zoning: Residential
- Special conditions: Arms Length
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Bungalow
- Property subtype: Single Family Residence
Materials
- Wood Siding
Condition
- 21+ Years
- New construction: No
- Year built: 1900
Utilities & green energy
- Sewer: Public Sewer
- Water: Well
Community & neighborhood
Location
- Region: Fremont
- Municipality: Fremont
Price history
| Date | Event | Price |
|---|---|---|
| 12/23/2025 | Sold | $342,000-2.3%$149/sqft |
Source:  WIREX MLS #1931276 Report a problem | ||
| 11/10/2025 | Contingent | $349,900$152/sqft |
Source: WIREX MLS #1931276 Report a problem | ||
| 9/22/2025 | Price change | $349,900-4.1%$152/sqft |
Source: WIREX MLS #1931276 Report a problem | ||
| 8/20/2025 | Listed for sale | $365,000+644.9%$159/sqft |
Source: WIREX MLS #1931276 Report a problem | ||
| 7/25/2019 | Listing removed | $49,000$21/sqft |
Source: Rieckmann Real Estate Group, Inc #50201360 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $4,200 +2.1% | $285,600 |
| 2023 | $4,113 +69.8% | $285,600 +145.6% |
| 2022 | $2,423 +8.7% | $116,300 +2.3% |
Find assessor info on the county website
Neighborhood: Tustin
Nearby schools
GreatSchools rating
- 9/10Fremont Elementary SchoolGrades: K-5Distance: 7 mi
- 9/10Weyauwega Middle SchoolGrades: 6-8Distance: 11.4 mi
- 3/10Weyauwega High SchoolGrades: 9-12Distance: 11.3 mi
Schools provided by the listing agent
- Middle: Weyauwega
- District: Weyauwega-Fremont
Source: WIREX MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.