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;

10 Church Street
Stockton Springs, ME 04981

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: --
Baths: --
Status: Active
SqFt: 4471
Agency: The Swan Agency Sotheby's International Realty
Agency Phone: 207-374-2020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Commercial
Year Built: 1855
Notes: THIS OFFERING INCLUDES TWO ADJACENT PROPERTIES: 6 AND 10 CHURCH STREET. 6 Church is a 3 BR 2 BA house currently a single tenant long term rental. See attached tax map and aerial photo. 10 Church is currently The Hichborn Restaurant, with 5 bedrooms, 4 baths, (was previously The Hichborn Inn), and on the first floor are 5 unique dining rooms, a fantastic bar with heated stone bar top and a very efficient chef's kitchen with all necessary equipment. Upstairs, there are 4 bedrooms, 2 with en-suite baths plus a section in the Ell with an additional owner's bedroom with ensuite bath, a small office and a second full bath. The owners could live next door at 6 Church Street, and this could be converted to more rooms to once again become The Hichborn Inn and Restaurant! A curb cut and driveway from Lower Sylvan Street onto either lot can be made to access the property for more parking. The current owner's 'wing' could alternatively be used as staff quarters. The barn is original, currently used for storage, and could be renovated for more dining, events, or rooms for The Hichborn Inn! See attached history for more information.<br /> <br /> 6 & 10 Church in MLS #1571570 (residential)<br /> 6 & 10 Church Street in MLS #1571538 (commercial)<br /> Both being sold together; room count includes both properties. See details. 6 Church sf =1,682; 10 Church sf = 4,300 (excluding the barn)
MlsNumber: 1571538


Listing Provided By: The Swan Agency Sotheby's International Realty, original listing
Name: The Swan Agency Sotheby's International Realty
Phone: (207) 374-2020
Office Name: Swan Agency Real Estate
Office Phone: (207) 288-5818
Agent Name: Dana Moos
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