select * from tour_full where site_id = 121 and (flag&1)>0 and class = 3 and type=39 order by length(COALESCE(alt_details,''))* length(COALESCE(photo,'') ) desc,type=7 asc, length(COALESCE(alt_details,'')) desc Showcasing the best Lodges in Maine

Places to stay in Maine - Lodges

The Bethel Inn Resort
Listed in Bethel

The Bethel Inn Resort combines the charm and hospitality of a classic turnof the century New England resort with the most modern guest amenities and recreational facilities. Our resort has been serving the vacationing public since 1913 and has dedicated itself to providing exceptional vacation .....

(+001) 207-824-2175

Web-Max 2016