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

42 Cyrs Siding Road
Saint Albans, ME 04971

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $295,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 408 Square Feet
Agency: Keller Williams Realty
Agency Phone: (207) 879-9800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Two beautiful off-grid cabins on an 8+ acre parcel to enjoy every aspect of Maine's great outdoors. The perfect place to be in the center of prime ATV, snowmobile, hunting and fishing territory.<br /> <br /> The main cabin is newly built and has an open concept kitchen and living room on the upper level. Large picture windows fill the lofted ceilings with bright daylight. There is one bedroom and a sleeping loft. On the ground floor is a two bay garage perfect for storing all your outdoor adventure toys. The house is plumbed for water that it gets from a water storage tank. There is room on the ground floor perfectly suited for a bathroom with some of the plumbing already started. This cabin is fully wired for electrical and runs off a generator. The home is heated by a simple wall mounted propane heater for the ability to use year round. <br /> <br /> The ''lower'' cabin has all the rustic elements and comfort of a true main camp. Plenty of room for entertaining in the open concept living room with vaulted ceilings and a full bathroom. The second story is a sleeping loft with many options to sleep the whole crew. This cabin is also wired for generator power, heated by a propane monitor, and water is fed from the stream nearby. Along side this cabin is an oversized shed where many card games have been played. <br /> <br /> The grounds have been freshly excavated to optimize drainage prevent erosion. This lot features a large wooden deer hunting blind set up off the ground overlooking a grassy field. The property also houses a pond for hot summer day swims. <br /> <br /> Come check it out to make all your Maine Woods dreams come true!
MlsNumber: --
ListingId: 1589293


Listing Provided By: Keller Williams Realty, original listing
Phone: (207) 314-2112
Office Phone: (207) 879-9800
Agent Name: Emily Weeks
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