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;

774 Shore Road
Northport, ME 04849

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,399,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2432
Agency: CoastWise Realty LLC
Agency Phone: (207) 338-6005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: With spectacular views of Penobscot Bay and gentle steps to 90 feet of shorefront, this beautiful, newly rebuilt oceanfront home was made for entertaining your family and friends. Just a short walk from historic Bayside Village and its deepwater dock, yacht club and golf course, this 4-bedroom, 3-bath year-round home offers two levels of easy living, each filled with natural light thanks to the many windows that frame the amazing water views. The first floor features a custom ''cook's kitchen'' with quartz counters and Café designer appliances, a dining area that leads to a full-length ocean-view deck, a living room with a soaring cathedral ceiling and a free-standing gas fireplace, a bedroom suite with doors to the deck, a full bath with a custom shower, double vanities, a walk-in closet and a laundry area and a second bedroom and full bath for guests. The ground level offers ocean-view guest quarters with a spacious living room that opens onto a charming waterside patio, two bedrooms, a kitchenette, a full bath, a laundry area and a large storage room. Energy efficient and easy to maintain, this home has heat pumps for heating and cooling, radiant heat on the main floor, two gas stoves, a new Bosh direct-vent boiler and a Rinnai on-demand water heater. Exterior features and amenities include a new, standing seam metal roof, handsome and indestructible Celect composite siding, a new composite deck, a Koehler on-demand, whole-house generator, a garden shed and retractable stairs to the beach. Convenient to Belfast, with its restaurants, farmer's market and shops, and close to Lincolnville Beach and Camden, this amazing home is in move-in condition and comes tastefully furnished and completely equipped with housewares and linens. All deck furniture, an outdoor fire pit table and a pellet grill/smoker are also included. The perfect coastal Maine four-season retreat or a highly desirable vacation rental, this is a must-see property!
MlsNumber: 1583185


Listing Provided By: CoastWise Realty LLC, original listing
Name: CoastWise Realty LLC
Phone: (207) 338-6005
Office Name: CoastWise Realty
Office Phone: (207) 338-6005
Agent Name: Marjorie Crowley
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