Beautiful waterfront retreat on Quill Lake! Situated on 9.1 wooded acres with 486' of frontage, this stunning log-sided home offers the perfect Northwoods escape with exceptional privacy and endless outdoor recreation. Featuring 3 bedrooms, 2 full baths, open-concept living spaces, updated kitchen and baths, finished walkout lower level, screen porch, and expansive lake views throughout. Extensive updates since 2020 include new roof, windows, on demand well, lighting, smart home features, fresh paint, storage shed and more. Outdoor features include a refinished deck, brand new lakeside deck, mini sand beach, firepit area, volleyball court, cleared section for gun range, ATV trails, boat house, and custom log railing to the lake. Heated detached 58x42 garage with powersport lifts includes full bath and large loft that has wet bar, kitchenette, family room & game area. A truly rare opportunity to own an incredible waterfront property in the heart of the Northwoods! Septic is sized for 2 bedrooms.
For sale
$949,900
15740 Tree Farm Rd, Mountain, WI 54149
3beds
1,800sqft
Est.:
Single Family Residence
Built in 1990
9.1 Acres Lot
$-- Zestimate®
$528/sqft
$-- HOA
What's special
Stunning log-sided homeFinished walkout lower levelAtv trailsMini sand beachVolleyball courtBrand new lakeside deckRefinished deck
- 2 hours |
- 110 |
- 12 |
Zillow last checked:
Listing updated:
Listed by:
HEIDI RUID 920-591-0135,
SIGNATURE REALTY, INC.
Source: GNMLS,MLS#: 216977
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: First
- Dimensions: 9x14
Bedroom
- Level: Basement
- Dimensions: 16x11
Bedroom
- Level: First
- Dimensions: 9x12
Bathroom
- Level: Basement
Bathroom
- Level: First
Family room
- Level: Basement
- Dimensions: 14x10
Kitchen
- Level: First
- Dimensions: 11x13
Laundry
- Level: Basement
- Dimensions: 7x6
Living room
- Level: First
- Dimensions: 17x13
Office
- Level: Basement
- Dimensions: 10x12
Screened porch
- Level: Basement
- Dimensions: 15x9
Other
- Level: First
- Dimensions: 15x9
Heating
- Baseboard, Propane, Radiant
Appliances
- Included: Dryer, Dishwasher, Electric Oven, Electric Range, Microwave, Range, Refrigerator, Washer
- Laundry: Washer Hookup, In Basement
Features
- Additional Living Quarters, Wet Bar
- Doors: French Doors
- Basement: Daylight,Exterior Entry,Egress Windows,Full,Finished,Walk-Out Access
- Has fireplace: No
- Fireplace features: Free Standing, Wood Burning
Interior area
- Total structure area: 1,800
- Total interior livable area: 1,800 sqft
- Finished area above ground: 900
- Finished area below ground: 900
Property
Parking
- Total spaces: 4
- Parking features: Detached, Four Car Garage, Four or more Spaces, Garage, Heated Garage
- Garage spaces: 4
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck, Open
- Exterior features: Dock, Landscaping, Other, Shed, Propane Tank - Leased
- On waterfront: Yes
- Waterfront features: Shoreline - Sand
- Body of water: QUILL (Porcupine, Pickerel)
- Frontage length: 486,486
Lot
- Size: 9.1 Acres
- Features: Adjacent To Public Land, Private, Secluded, Wooded
Details
- Additional structures: Shed(s)
- Parcel number: 014311301133
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: One Story
- Property subtype: Single Family Residence
Materials
- Log Siding
- Foundation: Block
Condition
- Year built: 1990
Utilities & green energy
- Sewer: Conventional Sewer
- Water: Drilled Well
Community & HOA
Location
- Region: Mountain
Financial & listing details
- Price per square foot: $528/sqft
- Tax assessed value: $476,200
- Annual tax amount: $4,287
- Date on market: 5/11/2026
- Ownership: Trust
- Road surface type: Paved
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/11/2026 | Listed for sale | $949,900+131.7%$528/sqft |
Source: | ||
| 11/13/2020 | Sold | $410,000-3.5%$228/sqft |
Source: RANW as distributed by MLS GRID #50226410 Report a problem | ||
| 11/12/2020 | Pending sale | $424,900$236/sqft |
Source: Shorewest, Realtors-Northern R #50226410 Report a problem | ||
| 7/30/2020 | Listed for sale | $424,900+120.7%$236/sqft |
Source: Shorewest, Realtors-Northern R #50226410 Report a problem | ||
| 5/31/2008 | Sold | $192,500$107/sqft |
Source: RANW as distributed by MLS GRID #10712800 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $4,269 +17% | $257,500 |
| 2023 | $3,650 +3.3% | $257,500 |
| 2022 | $3,533 -5.2% | $257,500 |
| 2021 | $3,725 +0.3% | $257,500 +0.8% |
| 2020 | $3,714 +4.1% | $255,400 +3.5% |
| 2019 | $3,567 +0.2% | $246,700 |
| 2018 | $3,559 +5.7% | $246,700 |
| 2017 | $3,368 -0.8% | $246,700 |
| 2016 | $3,396 +0.6% | $246,700 |
| 2015 | $3,376 +27.6% | $246,700 +36.1% |
| 2013 | $2,646 | $181,300 |
| 2011 | $2,646 -3.6% | $181,300 |
| 2010 | $2,745 +1.8% | $181,300 |
| 2009 | $2,697 | $181,300 |
Find assessor info on the county website
Monthly payment
Est. payment
$5,597/mo
Principal & interest
$4608
Property taxes
$989
More affordability tools
Climate risks
Neighborhood: 54149
Nearby schools
GreatSchools rating
- 4/10Suring Elementary SchoolGrades: PK-8Distance: 19.9 mi
- 6/10Suring High SchoolGrades: 9-12Distance: 19.9 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Wisconsin
- Oconto County
- Mountain
- 54149
- 15740 Tree Farm Rd



