Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Bartels Real Estate, Inc.
Property view
Listing view 2
Listing view 3

15740 TREE FARM ROAD, 
Mountain, WI 54149

$949,900

3

Beds

2

Baths

1,800

Sq Ft

Single Family

Active

Listed by

Heidi Ruid

Signature Realty, Inc.

715-276-2866

Last updated:

June 4, 2026, 03:17 PM

MLS#

50325172

Source:

Metro MLS

About This Home

15740 TREE FARM ROAD

Beautiful waterfront retreat on Quill Lake! 9.1 wooded acres w/486' of frontage, this log-sided home offers perfect Northwoods escape w/ exceptional privacy. 3 bdms, 2 full baths, open-concept living spaces, updated kitchen & baths, finished walkout LL, screen porch, & expansive lake views throughout. Extensive updates since 2020 include new roof, windows, on demand well, lighting, smart home features, fresh paint, storage shed & more. Outdoor features include a refinished deck, new lakeside deck, mini sand beach, volleyball court, cleared section for gun range, ATV trails, boat house, and custom log railing to the lake. Heated detached 58x42 gar w powersport lifts, full bath, large loft w/wet bar, kitchenette, full bath, large loft w/ wet bar, kitchenette, family room & game area & more!

Home Facts

Single Family

2 Baths

3 Bedrooms

Built in 1990

Price Summary

949,900

$527 per Sq. Ft.

MLS #:

50325172

Last Updated:

June 4, 2026, 03:17 PM

Added:

a month ago

Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

2

Interior

Living Area:

1,800 Sq. Ft.

Structure

Structure

Architectural Style:

Ranch

Building Area:

1,800 Sq. Ft.

Year Built:

1990

Lot

Lot Size (Sq. Ft):

396,396

Finances & Disclosures

Finances

Price:

$949,900

Price per Sq. Ft:

$527 per Sq. Ft.

Source:Metro MLS
The information being provided by Wisconsin Real Estate Exchange is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is supplied by seller and other third parties and has not been verified. 2026 Wisconsin Real Estate Exchange All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.