Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1215 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1215 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1215 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

15 Wilson Pond Road
Greenville, ME 04441
Deb Henderson with Maine Outdoor Properties Team at Realty of Maine - Bangor, original listing - (207) 852-7577

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 7
Baths: Full: 7
Status: Active
SqFt: 5925 Square Feet
Agency: Maine Outdoor Properties Team at Realty of Maine - Bangor
Agency Phone: (207) 852-7577

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Commercial Sale-Other
Year Built: --
Notes: Experience year-round outdoor adventures at Lower Wilson Pond in the Moosehead Lake Region. The property consists of seven newly renovated, fully furnished cabins with knotty pine interiors and all the amenities you need to create a comfortable atmosphere during your visit. The housekeeping cabins feature decks and/or screened-in porches, grills, picnic tables, fire pits, and Adirondack chairs. You can rent fishing boats, canoes, kayaks, and paddle boats, or bring your own and enjoy easy access to the boat launch. Nearby, you'll find ATV, snowmobile, and hiking trails, making it a perfect location for winter activities such as snowmobiling, snowshoeing, ice fishing, and cross-country skiing. The owner's home is a post-and-beam open-concept house, which can be used by the owner or rented out for larger groups. An oversized garage for storing equipment and other necessities. The office space is in a separate building for checking in and out. Additionally, there is a common space area with a fire pit and outdoor games for larger gatherings. Lower Wilson Pond spans over 1300 acres with a maximum depth of 106 feet, providing excellent spring-fed fishing for brook trout, salmon, togue, smelts, and cusk. It is located only 3.2 miles from downtown Greenville, where you can enjoy shopping, amenities, and restaurants and less than 30 minutes to Big Moose Mountain Ski Resort. There are several lakes and ponds in the area for recreation, with endless activities to enjoy or simply take a moment to appreciate the natural beauty of the well-maintained property. Wilson Pond Cabins on Lower Wilson Pond offers the opportunity to practice the "art of relaxing" and being "in the moment," it will rekindle your spirit and soothe your soul!
MlsNumber: --
ListingId: 1594534


Listing Provided By: Maine Outdoor Properties Team at Realty of Maine - Bangor, original listing
Office Phone: (207) 852-7577
Agent Name: Deb Henderson
Disclaimer: Copyright © 2024 LandLeader. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App