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 = 3136 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 = 3136 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 = 3136 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;

8 Main Street
Eustis, ME 04936

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $339,999
Beds: 5
Baths: 3
Status: Active
SqFt: 1500
Agency: Homes & Harbors Real Estate
Agency Phone: (207) 798-9595

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1972
Notes: A novel recreational property nestled in the breathtaking Western Mountains of Maine, where adventure meets comfort! Located in close proximity to Flagstaff Lake, access to snowmobile and ATV trails, as well as just 7 miles from Sugarloaf. This retreat offers the perfect blend of outdoor excitement and relaxation.<br /> Boasting five spacious bedrooms and 2.5 bathrooms, this charming mountain getaway provides ample space for family gatherings, group vacations, or cozy weekends away with friends. With its open first-floor plan, you'll find a seamless flow between the living, dining, and kitchen areas, creating an inviting atmosphere for entertaining and making memories.<br /> Step into the heart of the home and discover the ultimate entertainment hub - along with a custom vintage wet bar, where you can mix up your favorite cocktails while socializing with loved ones. Whether you're hosting guests or enjoying a quiet night in, this feature adds a touch of comfort to your entertaining experience.<br /> After a day of outdoor adventures, unwind and soothe your muscles in the 8-person hot tub, melt away any tension, leaving you feeling refreshed and rejuvenated.<br /> With its convenient location near snowmobile and ATV trails, outdoor enthusiasts will delight in the endless opportunities for exploration and adventure right at their doorstep. Whether you're hitting the trails or embarking on an adventure, there's something for everyone to enjoy.<br /> This property was once a well-known Bed and Breakfast and still holds a great rental history, nice Main Street frontage with general purpose zoning. Efficient gas heating and custom roofing with electric heat tape are just a couple of the resourceful features.<br /> Don't miss your chance to own your own slice of mountain in Maine's Western Mountains - where adventure and relaxation await at every turn. Come experience the magic and make memories that will last a lifetime.
MlsNumber: 1582479


Listing Provided By: Homes & Harbors Real Estate, original listing
Name: Homes & Harbors Real Estate
Phone: (207) 798-9595
Office Name: Engel & Volkers Casco Bay
Office Phone: (207) 798-9595
Agent Name: Casey Cote
Disclaimer: Copyright © 2024 Maine Real Estate Information System, Inc. 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