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

157 Elm Street
Milo, ME 04463

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: NextHome NorthEast Realty
Agency Phone: (207) 838-7773

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Step into a gorgeous turnkey business opportunity with Three Rivers, a fully equipped and operational restaurant and brewery located in the heart of Milo, Maine. This ready-to-operate property, which seats 85 patrons inside and 55 outside, is perfect for entrepreneurs looking to dive into the culinary and brewing industry without the hassle of starting from scratch. With its unique features and well-established customer base, this property offers immediate revenue potential. Looking to relocate? The house next door at 153 Elm Street is also FOR SALE! The house is the perfect space for owner's or staff quarters! Key Features: Fully Equipped Kitchen: The property comes with a state-of-the-art kitchen, allowing you to start operations immediately. From cold storage to high-end kitchen appliances, everything you need is already in place. Unique Brewing Facility: A beer lover's dream! The thoughtfully-constructed brewery was built to focus on mixed-fermentation beers, wood aging, and spontaneous fermentation. The facility boasts rare and unique features such as an open fermentation room - 1 of 3 in the state! - that allows you to not only brew beer efficiently, but creatively. Only interested in the restaurant operation? Lease the brewing space! Spacious & Trendy Dining Area: The 85-seat restaurant boasts a warm and inviting dining area that can accommodate a large number of guests, creating a cozy atmosphere for patrons. The farmhouse-style layout is designed to maximize comfort and efficiency, ensuring a pleasant and trendy dining experience. Outdoor Seating & Concert Space: Enjoy the scenic beauty of Milo with a charming 55-seat outdoor seating area - complete with a refurbished 1920s caboose! - is perfect for al fresco dining. This space also includes plastic enclosures to extend the outdoor dining season and provide additional guest space into the colder months. Additionally, the outdoor concert space is perfect for hosting live music events.
MlsNumber: --
ListingId: 1601000


Listing Provided By: NextHome NorthEast Realty, original listing
Phone: (207) 838-7773
Office Phone: (207) 838-7773
Agent Name: Richard Yost
Disclaimer: Copyright © 2024 NextHome, 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