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;

41 Harbor View Drive
Stockton Springs, ME 04981

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $565,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2607
Agency: Sell 207
Agency Phone: (207) 461-4740

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 64 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Discover coastal living at its finest at 41 Harbor View Drive, your waterfront haven on the enchanting Coast of Maine. Imagine waking up in your oceanfront condo to a sunlit kitchen, brewing coffee, and embracing the day from your expansive, private, ocean view deck.<br /> Journey to the private beach along scenic water-side trails, capturing moments of serenity or bird watching from a bench. Launch a kayak to explore the harbor or venture to Sears Island, a 960-acre conservation haven. Enjoy locally sourced delights from the community vegetable garden, nearby seafood markets, adding culinary magic to your day.<br /> Cool off with a dip in the solar-heated pool before indulging in a lobster roll from Stockton Harbor's daily catch. Need a break from the sun but still want to enjoy the ocean breeze? Simply employ the 2 motorized awnings on your upper deck. While this unit offers the ease and convenience of a main floor primary suite, you can entertain effortlessly in this spacious, open floor plan, offering two bedrooms and a large full bath on the upper level.<br /> The lower level's completely finished, daylight walkout basement boasts its own covered deck that transforms this space into an ideal rec room with a separate room for a home office, hobbies/crafts, or even a third guest bedroom. <br /> This popular light-filled, corner unit layout also features an attached garage, full size washer/dryer, AC/Heat pumps and WiFi thermostats, newer Stainless Steel Appliances and custom cabinet organizers in the kitchen. Furnishings are negotiable if you're looking for complete turnkey living or a second home.<br /> The HOA tends to exterior maintenance, snow plowing, landscaping, and groundskeeping, offering a 'lock and leave' lifestyle for seasonal dwellers or frequent travelers. Take the immersive 3D tour and schedule a showing today.
MlsNumber: 1580595


Listing Provided By: Sell 207, original listing
Name: Sell 207
Phone: (207) 461-4740
Office Name: Sell 207
Office Phone: (207) 461-4740
Agent Name: Monet Yarnell
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