select * from tour_full where site_id = 28 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 Newfoundland

Places to stay in Newfoundland - Lodges

Gander River Outfitters
Listed in Gander

Selected one of Canada's 17 "Classic Fishing" lodges, at Gander River Outfitters you can fish for salmon feet from the camp. With growing salmon populations, we attract anglers and adventure vacationers from around the world – for holidays and for business incentive travel. Gander River, .....

(+001) 709-424-1600