Title Page Background
DEBUG FN args: Array ( [0] => 1210 [1] => [2] => [3] => agent ) BEFORE: Site: 1210 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1210 Igate: njhud LocID: 1210 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1210 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1210 [1] => [2] => [3] => lender ) BEFORE: Site: 1210 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1210 Igate: njhud LocID: 1210 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1210 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1210 [1] => [2] => [3] => other ) BEFORE: Site: 1210 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1210 Igate: njhud LocID: 1210 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1210 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

Lot 1 Kayla Drive
Winthrop, ME 04364

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Vallee Harwood & Blouin Real Estate
Agency Phone: (207) 557-1123

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Nestled in the picturesque town of Winthrop, this extraordinary 6.981acre parcel of land offers a unique opportunity to create a dream retreat on the shores of the stunning Annabessacook Lake. Boasting an impressive 232 feet of waterfrontage, this expansive property provides an idyllic setting for a large private reserve.<br /> <br /> Annabessacook Lake, with its sprawling 1,400 acres, is a true gem for outdoor enthusiasts. The clear waters beckon with possibilities for great bass fishing, leisurely swimming, and exhilarating boating adventures. Imagine waking up to the serene views of the lake.<br /> <br /> Adding to the allure of this parcel is the ownership of the roadway leading to the property. A well-maintained road already exists, ensuring convenient access wherever you need to be. The highway is less than 10 miles away. The town of Winthrop, with its charming amenities and services, is just a short 5-minute drive, offering the perfect balance between seclusion and convenience.<br /> <br /> Beyond the immediate vicinity, the location of this parcel is strategically positioned for diverse experiences. The coast is less than an hour away, allowing for day trips to sandy beaches and coastal attractions. For those seeking adventure in the mountains, the western mountain range is a mere hour and a half drive, providing access to hiking trails, skiing, and other outdoor pursuits.<br /> <br /> Whether you envision a private family haven or a vast retreat surrounded by the beauty of nature, this 6-acre parcel in Winthrop offers an unparalleled canvas for crafting your ideal sanctuary. Embrace the tranquility of lakefront living, the convenience of nearby amenities, and the limitless possibilities that come with owning a piece of this remarkable landscape.
MlsNumber: --
ListingId: 1579943


Listing Provided By: Vallee Harwood & Blouin Real Estate, original listing
Phone: (207) 557-1123
Office Phone: (207) 557-1123
Agent Name: John Blouin
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