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

20 Estes Avenue
Palmyra, ME 04965
Roland Littlefield with United Realty, original listing - (207) 323-7000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: --
Baths: --
Status: Active
SqFt: 2640 Square Feet
Agency: United Realty
Agency Phone: (207) 323-7000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Commercial Sale-Other
Year Built: 1970
Notes: FIRST TIME OFFERED FOR SALE! Prime location featuring a 40' x 66' commercial building, established and previously operated as a very successful automobile dealership. The front showroom measures 20' x 34', with glass showroom doors opening to allow your classic car display. Showroom and lounge area are warmed with wood stove and forced hot air. Although no longer a going concern, this could easily become your automobile dealership. The uses are endless with this building. Completing the front section of the building, measuring 20' x 32', are offices, coffee room and bathrooms. The rear section measuring 20' x 66' consists of 3 bays of heated workspace, including an automotive lift, compressor and other automotive service related equipment. Metal roof and siding; cold storage shed; 200 amp electrical service with 3 Phase Power at street. Oil, wood and electric heat. If your use involves retail or other occupations, this is the property for you. Situated on a perfectly level, 3.3 Acres with approximately 150' paved frontage on Route 152, aka Estes Avenue. This site offers a drilled well, septic system and 300+/-' frontage on Rt. 152. Located only 4 miles to Main Street in Pittsfield, 6 miles to Newport, 7 miles to Canaan and 17 miles to Skowhegan. Additional, abutting land available with the purchase of this property, located at the corner of Rt. 2 and Rt. 152. Combining these properties together may allow an abundant of uses. Contact us for details.
MlsNumber: --
ListingId: 1588781


Listing Provided By: United Realty, original listing
Phone: (207) 323-7000
Office Phone: (207) 323-7000
Agent Name: Roland Littlefield
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