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

64 Harbor View Drive
Stockton Springs, ME 04981

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2594
Agency: Two Rivers Realty, LLC
Agency Phone: (207) 469-9930

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 64 acre(s)
Property Type: Residential
Year Built: 2004
Notes: OPEN HOUSE - Saturday, April 27th 11:00 a.m. to 1:00 p.m. Welcome to 64 Harbor View Dr.! Located at the very end in The Village of Stockton Harbor, a true ''end unit''. This sun-filled, 4 bedroom, 2 ½ bath condo offers 3 levels of living space and gives you the feeling of privacy and relaxation. This home features open concept dining/living area with a gas fireplace, 1st-floor primary suite, 1st-floor laundry, 1-car attached garage, upper and lower west-facing decks for stunning sunsets and so much more! Entire unit was painted in 2021, brand new blinds and curtains throughout the home and updated light fixtures with fans/lights. Just steps away from the beach, yet nestled among the trees, you get the best of both worlds! The Village at Stockton Harbor offers a community solar heated pool, community garden area for flowers and vegetables, ocean-front walking trails and storage for your canoe/kayak. Enjoy the morning sunshine from your kitchen window and breathtaking sunsets off the back deck. Moor your boat in the protected harbor, enjoy a walk to the waterfront restaurant, swim, picnic or hike at the nearby Fort Point State Park. Stockton Springs is conveniently located for a Day-trip to Acadia National Park, Belfast, Camden or Rockland. The HOA fees cover exterior maintenance, snow plowing, landscaping, and groundskeeping. Most furnishings will convey. Don't wait, set up your showing today!
MlsNumber: 1581932


Listing Provided By: Two Rivers Realty, LLC, original listing
Name: Two Rivers Realty, LLC
Phone: (207) 469-9930
Office Name: Two Rivers Realty, LLC
Office Phone: (207) 469-9930
Agent Name: Jennifer Guay
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