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

88 White's Pond Road
Palmyra, ME 04965
Jeffrey England with Coldwell Banker Realty, original listing - (207) 773-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 3328 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (207) 773-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: White's Pond, Palmyra. Very rare opportunity to own, three, all season homes on one deed nestled on a well landscaped 1.98 acres and on a private dead-end road. Easy access, less than 5 miles West of Route I-95 (Newport exit - convenient to major shopping) just two minutes beyond the Palmyra 18-hole championship golf course and full facility campground & RV resort. The ''Peaceful Cottage'' (88 White's Pond Rd.) features 2 bedrooms, 1 bath, currently rented as Air BnB directly on the water with dock, pond access, fire pit, and gorgeous sunsets. The main home (85A White's Pond Rd.) 2 bedroom, 3 baths, 3 bay heated garage and elevated deck(s) with water views and access to White's Pond. The third house (85B White's Pond Rd.) is a separate home, recently completed 1 bedroom, 1.5 baths apartment, 2 bay heated garage and elevated deck also with access to the water for your recreational fishing & boating enjoyment, or ice fishing. Work, Play, Vacation, and Income all year long. You can have it all. 34 miles to coastal Belfast, and 68 miles to Sugarloaf Mountain Ski Area & Resort. Great self-supporting investment income, or multi-generational four-season property to accommodate the whole family and more. All this only 33 minutes to the city of Bangor, or 32 minutes to the city of Waterville. 85B septic is connected to 85A septic system, See HHE 200 in documents (2 BR design).
MlsNumber: --
ListingId: 1589496


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (207) 756-0049
Office Phone: (207) 773-1990
Agent Name: Jeffrey England
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