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 = 1208 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1208 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1208 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

2203 Harpswell Islands Road
Harpswell, ME 04003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,598,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1440
Agency: Keller Williams Realty
Agency Phone: (207) 879-9800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1990
Notes: Perched high above Pebbly Beach, this year round, 3 bedroom, waterfront, Bailey Island home enjoys ocean views like no other. Be the envy of your friends when they come to visit. Watch how they smile and the cares of the day float away as they soak in the vast ocean views all the way to the horizon where the sea meets the sky, you'll swear on the clearest of days to be able to see the curvature of the earth! Sea View Cottage also offers views into Mackerel Cove, the inner Casco Bay islands, westerly all the way to the snow capped peaks of NH's White Mountains. Indulge in breathtaking sunrises and moonrises from the comfort of your own retreat. There's magic in witnessing the full moon ascend from the ocean, illuminating the night sky. Take delight in watching lobstermen and pleasure boaters navigate Harpswell Sound, creating a picturesque scene that unfolds before your eyes and that others rarely see. Sea View Cottage has undergone recent enhancements by its dedicated owners, including fresh paint, granite countertops, a luxurious tiled shower, maintenance-free decks, newer roof shingles, and more. This thoughtfully updated haven invites you to simply relax and immerse yourself in the epitome of coastal living, where every detail has been carefully curated to provide an unparalleled experience. Sea View Cottage invites you to savor the essence of Harpswell while enjoying the comforts of a well maintained and upgraded retreat. Your seaside sanctuary awaits, experience the allure of Sea View Cottage.
MlsNumber: 1583970


Listing Provided By: Keller Williams Realty, original listing
Name: Keller Williams Realty
Phone: (207) 879-9800
Office Name: Keller Williams Realty
Office Phone: (207) 729-2134
Agent Name: Ronald Hutchins
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