Skip main navigation
For sale
  • $949,900

    15740 Tree Farm Rd, Mountain, WI 54149

    3beds
    1,800sqft
    : 
    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
    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.
    2 hours
    |
    110
    |
    12
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    HEIDI RUID 920-591-0135,

    SIGNATURE REALTY, INC.

    Source: GNMLS,MLS#: 216977MLS Logo

    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
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        5/11/2026Listed for sale$949,900+131.7%$528/sqft
        Source: GNMLS #216977 Report a problem
        11/13/2020Sold$410,000-3.5%$228/sqft
        Source: RANW as distributed by MLS GRID #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
        5/31/2008Sold$192,500$107/sqft
        Source: RANW as distributed by MLS GRID #10712800 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

        Monthly payment

        Est. payment
        $5,597/mo
        Principal & interest
        $4608
        Property taxes
        $989
        More affordability tools

          Climate risks

          Neighborhood: 54149

          Getting around

          0 / 100
          Car-Dependent
          27 / 100
          Somewhat Bikeable

          Nearby schools

          GreatSchools rating

          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.

          Browse local experts

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel