Skip main navigation
Sold for $860,000
  • $860,000

    15740 Tree Farm Rd, Mountain, WI 54149

    3beds
    1,800sqft
    Single Family Residence
    Built in 1990
    9.1 Acres Lot
    $860,700 Zestimate®
    $478/sqft
    $2,418 Estimated rent

    Home value

    $860,700

    Estimated sales range

    Not available

    $2,418/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,418/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,418/mo

    Rent Zestimate®

    Refinance and save

    $5,545/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $5,545/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Stunning log-sided homeFinished walkout lower levelAtv trailsMini sand beachVolleyball courtBrand new lakeside deckRefinished deck
    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!

    Zillow last checked:

    Listing updated:

    Listed by:

    HEIDI RUID 920-591-0135,

    SIGNATURE REALTY, INC.

    Bought with:

    NON NON MEMBER

    NON-MEMBER

    Source: GNMLS,MLS#: 216977MLS Logo

    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: $478/sqft
    • Tax assessed value: $476,200
    • Annual tax amount: $4,287
    • Date on market: 5/11/2026
    • Ownership: Trust
    • Road surface type: Paved

    Price history

    DateEventPrice
    7/13/2026Pending sale$849,900-1.2%$472/sqft
    Source: WIREX MLS #50325172 Report a problem
    7/9/2026Sold$860,000+1.2%$478/sqft
    Source: GNMLS #216977 Report a problem
    6/17/2026Contingent$849,900$472/sqft
    Source: GNMLS #216977 Report a problem
    6/8/2026Price change$849,900-10.5%$472/sqft
    Source: GNMLS #216977 Report a problem
    5/11/2026Listed for sale$949,900+123.6%$528/sqft
    Source: GNMLS #216977 Report a problem
    11/16/2020Listing removed$424,900$236/sqft
    Source: Shorewest, Realtors-Northern R #50226410 Report a problem
    11/12/2020Pending sale$424,900$236/sqft
    Source: Shorewest, Realtors-Northern R #50226410 Report a problem
    7/30/2020Listed for sale$424,900+120.7%$236/sqft
    Source: Shorewest, Realtors-Northern R #50226410 Report a problem
    6/2/2008Sold$192,500$107/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax 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

    Neighborhood: 54149

    Nearby schools

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