string(521) "select A.hotelId,A.hotelName,A.picUrl,A.hotelNameCn,A.typeId,A.intro,B.destId,B.destName,B.depth,C.destId as parentId,C.destName as parentName,D.destId as rootId,D.destName as rootName FROM ((hotel as A left join dest as B on A.destId=B.destId) left join dest as C on B.parentId=C.destId ) left join dest as D on B.rootId=D.destId LEFT JOIN hotel_brand E ON A.brandId = E.brandId LEFT JOIN hotel_group F ON E.groupId = F.groupId where A.picUrl is not null AND A.inland=2 AND E.groupId<>6 order by A.hezuo desc limit 0,10"
Popa Falls Lodge
With its perennial rivers, magnificent indigenous riverine forests, expansive floodplains and reed-lined channels, Popa Falls Lodge is the ideal destination from which to explore the Bwabwatanational Park, comprised of the former Caprivi, Kwando, Buffalo and Mahango core areas.
Over 450 bird species and a wide variety of wildlife species- including elephant, hippo, water buffalo, crocodile, red lechwe, reedbuck, roan and sable antelope and the e…
Dolomite Camp is located in western Etosha National Park, near the Dolomietpunt waterhole. Guests can now stopover here which will break up their journey through the park. It is set on a large ridge which offers superb views of the going's on of the plains below. It was the first camp to be built on this side of Etosha, opening up a section of the park previously not accessible to mainstream tourists.
Wildlife here includes Hartmann's zebra wh…
With views of the Tuileries Garden, Le Meurice has been ranked among the most elegant hotels in the world
Combining exceptional 18th century opulence with contemporary chic, including eye-catching interiors by Philippe Starck, Le Meurice embodies the perfect French palace hotel.Located between Place de la Concorde and the Louvre, Le Meurice is ideally situated for visiting the finest art that Paris has to offer. Salvador Dalí was a regular visi…
从您看见 Coworth Park（珂沃庄园酒店）风景如画的花园开始，便已踏上放松休闲的旅程
The Capital's Finest Address An icon of restored elegance where glamour meets tradition. Desirably located just two blocks north of the White House the gracefully reimagined St. Regis Washington, D.C. is the hotel of choice for royalty, presidents, and prime ministers in the nation's capital. …
圣路易斯拱门凯悦酒店地处市中心，地理位置得天独厚，是探索这座城市的理想下榻之所。 博物馆、商店、圣路易斯赌场、安豪泽布施公司和该市著名的拱门均距酒店几步之遥，而 Lambert Field 国际机场距酒店也仅 24 公里。…
索诺玛葡萄园凯悦酒店及水疗中心是一家地中海风情的豪华酒店，就坐落在圣罗莎 (Santa Rosa) 的 Historic Railroad 广场，距 Charles Shulz Memorial 公园和各种室外活动场所仅几步之遥， 附近四周还分布有古董店、商城、博物馆及 200 多家酿酒厂。…
The Carlyle, A Rosewood Hotel
The Carlyle, A Rosewood Hotel is a timeless classic. This New York luxury hotel showcases refined taste and creates a true Manhattan experience for sophisticated travelers.
With 193 lavish rooms and suites, The Carlyle offers the exclusive ambiance of an Upper East Side pied-à-terre. Exquisitely decorated by legendary designers such as Dorothy Draper, Mark Hampton, Alexandra Champalimaud and Thierry Despont, this New York luxury hotel is a wonderful example of elegance and comfort.…