NOT LISTED FOR SALE

15740 Tree Farm Rd Mountain, WI 54149

Estimated Value: $422,000 - $609,000

3 Beds
2 Baths
1,800 Sq Ft
$293/Sq Ft Est. Value

Sale Details

Date Sold: November 13, 2020

Last sale price $410,000 $228 Per Sq Ft

Est. 29% increase in value since last sale

Current estimated payment $3,155 / mo

101 Days on Market

Highlights

  • Boathouse
  • Docks
  • 396,396 Sq Ft lot
  • Lake Front
  • Indoor Spa
  • Deck

About This Home

As of November 2020

Waterfront estate with 9.1 acres overlooking beautiful spring fed Quill Lake. Expansive views to pristine, sparkling waters and the beautiful Chequamagon-Nicolet NF. Hand-hewn log sided home with many outdoor living options. A sunny deck and 3 season room off the main floor, and screen porch off LL. Open concept living room, kitchen, dining, 3 BR 2 BA. LL features a family room, large BR and den/office. 58x42 garage with finished loft studio. The 486' shoreline has a swim area, dock and boathouse. This is an amazing opportunity near Maiden Lake.

Last Agent to Sell the Property

JAMEE PETERS

SHOREWEST REALTORS - NORTHERN REALTY & LAND Listed on: 07/29/2020

SHOREWEST REALTORS - NORTHERN REALTY & LAND

Last Buyer's Agent

NON NON MEMBER

NON-MEMBER

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,567

Year Built

  • Built in 1990

Lot Details

  • 9.1 Acre Lot
  • Lake Front
  • Rural Setting
  • Landscaped
  • Private Lot
  • Secluded Lot
  • Sloped Lot

Home Design

  • Block Foundation
  • Frame Construction
  • Shingle Roof
  • Composition Roof
  • Log Siding

Interior Spaces

  • 1-Story Property
  • Ceiling Fan
  • Wood Burning Stove
  • Free Standing Fireplace
  • Indoor Spa
  • Property Views

Kitchen

  • Electric Oven
  • Electric Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry
  • Laundry in Basement

Parking

  • Detached Garage
  • Heated Garage
  • Gravel Driveway

Outdoor Features

  • Boathouse
  • Docks
  • Deck
  • Open Patio
  • Outbuilding
  • Playground

Utilities

  • Heating System Uses Propane
  • Baseboard Heating
  • Underground Utilities
  • Well
  • Electric Water Heater

Listing and Financial Details

  • Assessor Parcel Number 014-31-13-011-33

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,567

Year Built

Built in 1990

Lot Details

9.1 Acres

Listing Details

  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Road Frontage Type: Lakefront
  • Road Frontage Type: Town Road
  • Water Body Name: QUILL (Porcupine, Pickerel)
  • Ownership: Fee Simple
  • Directions: From Mountain: Turn left onto WI-32 N/WI-64 W,Turn left onto Island Lake Rd,Turn right onto National Forest Rd 2295/Tree Farm Rd, property on left,
  • Above Grade Finished Sq Ft: 900.0
  • Architectural Style: One Story
  • Garage Yn: Yes
  • Unit Levels: One
  • Property Attached Yn: No
  • Building Stories: 1
  • Year Built: 1990
  • Property Sub Type Additional: Single Family Residence
  • Special Features: None
  • Stories: 1

Interior Features

  • Spa Features: Hot Tub
  • Private Spa: Yes
  • Appliances: Dryer, Dishwasher, Electric Oven, Electric Range, Electric Water Heater, Microwave, Refrigerator, Washer
  • Has Basement: Exterior Entry, Full, Finished, Interior Entry, Walk-Out Access
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 900.0
  • Fireplace Features: Free Standing, Wood Burning
  • Fireplace: Yes
  • Flooring: Mixed
  • Interior Amenities: Additional Living Quarters, Ceiling Fan(s), Hot Tub/Spa

Exterior Features

  • Lot Features: Lake Front, Private, Rural Lot, Secluded, Sloped
  • View: Yes
  • Waterfront Features: Shoreline - Sand, Shoreline - Fisherman/Weeds, Shoreline - Gravel, Lake Front
  • Waterfront: Yes
  • Construction Type: Frame, Log Siding
  • Exterior Features: Dock, Landscaping, Out Building(s), Playground, Gravel Driveway, Propane Tank - Leased
  • Foundation Details: Block
  • Other Structures: Boat House, Outbuilding
  • Patio And Porch Features: Deck, Open
  • Roof: Composition, Shingle

Garage/Parking

  • Attached Garage: No
  • Parking Features: Detached, Four Car Garage, Four or more Spaces, Garage, Heated Garage, Driveway

Utilities

  • Laundry Features: Washer Hookup, In Basement
  • Heating: Baseboard, Electric, Propane
  • Heating Yn: Yes
  • Sewer: Conventional Sewer
  • Utilities: Underground Utilities
  • Water Source: Driven Well, Well

Lot Info

  • Lot Size Sq Ft: 396396.0
  • Parcel #: 014-31-13-011-33
  • Zoning Description: Residential

Tax Info

  • Tax Annual Amount: 3567.0
  • Tax Year: 2019

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 29, 2020
Closed on
Jan 11, 2021
Sold by
Esposito Michael J
Bought by
The Michael & Shannon Esposito Trust
Seller's Agent
JAMEE PETERS
SHOREWEST REALTORS - NORTHERN REALTY & LAND
Buyer's Agent
NON NON MEMBER
NON-MEMBER
List Price
$424,900
Sold Price
$410,000
Premium/Discount to List
-$14,900
-3.51%
Current Estimated Value
$527,782

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$117,782
Avg. Annual Appreciation
4.72%
Interest Rate
2.77%

Purchase Details

Listed on
Jul 29, 2020
Closed on
Nov 13, 2020
Sold by
Sep 12 Lawrence J Mitsch Dated
Bought by
Esposito Michael J
Seller's Agent
JAMEE PETERS
SHOREWEST REALTORS - NORTHERN REALTY & LAND
Buyer's Agent
NON NON MEMBER
NON-MEMBER
List Price
$424,900
Sold Price
$410,000
Premium/Discount to List
-$14,900
-3.51%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
The Michael & Shannon Esposito Trust $255,400 --
The Michael & Shannon Esposito Trust $255,400 --
Esposito Michael J $410,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed The Michael & Shannon Esposito Trust --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/13/2020 11/13/20 Sold $410,000 -3.5% $228 / Sq Ft
11/09/2020 11/09/20 Pending -- -- --
07/30/2020 07/30/20 For Sale $424,900 -- $236 / Sq Ft
Source: Greater Northwoods MLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $4,287 $257,500 $83,000 $174,500
2024 $43 $257,500 $83,000 $174,500
2023 $3,650 $257,500 $83,000 $174,500
2022 $3,533 $257,500 $83,000 $174,500
2021 $3,725 $257,500 $83,000 $174,500
2020 $3,714 $255,400 $83,000 $172,400
2019 $3,567 $246,700 $83,000 $163,700
2018 $3,559 $246,700 $83,000 $163,700
2017 $3,368 $246,700 $83,000 $163,700
2016 $3,396 $246,700 $83,000 $163,700
2015 $3,376 $246,700 $83,000 $163,700
2013 $2,646 $181,300 $83,000 $98,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Greater Northwoods MLS

MLS Number: 186321

Greater Northwoods MLS

APN: 014-31-13-011-33

Your Personal Tour Guide

Ask me questions while you tour the home.