select * from tour_full where site_id = 2 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 Lodges in Prince Edward Island

Places to stay in Prince Edward Island - Lodges

The Resort at Cavenish Corner
Listed in Cavendish

The Resort at Cavendish Corner offers a wide range of accommodation options including 39 one to three bedroom cottages, a 13 room historic country Inn with a number of luxury suites, and 55 modern motel rooms. The Resort features a wide range of amenities to make your stay enjoyable, from our .....

(+001) 902-963-2251


Dalvay by the Sea
Listed in York

Step back in time to a Victorian summer home where activities include: croquet, tennis court, nature trails, driving range, beach walks and bike rentals. Kayak or canoe across Dalvay Lake, the site of the Duke and Duchess of Cambridge dragon boat race on July 4th, 2011.

(+001) 902-672-2048


Wild Goose Lodge & Retreat
Listed in French River

The peace and serenity of Wild Goose Lodge is the perfect balance to your Prince Edward Island adventure. Famous PEI hospitality plus the beauty of the surroundings, make for great family vacation trips, and unforgettable memories.

(+001) 800-463-4053


Web-Max 2016