场地及酒店搜索

SELECT DISTINCT CASE mcou.charsetid WHEN 1 THEN companynameen WHEN 2 THEN companynametc ELSE companynamesc END companyname, CASE mcou.charsetid WHEN 1 THEN companyprofileen WHEN 2 THEN companyprofiletc ELSE companyprofilesc END companyprofile, CASE mcou.charsetid WHEN 1 THEN address1en WHEN 2 THEN address1tc ELSE address1sc END address1, CASE mcou.charsetid WHEN 1 THEN address2en WHEN 2 THEN address2tc ELSE address2sc END address2, mloc.text, ci.text, mcou.text, telephone1Country, telephone1area, telephone1, telephone2Country, telephone2area, telephone2, fax1Country, fax1area, fax1, fax2Country, fax2area, fax2, email1, email2, email3, website1, website2, website3, mtr.text, latitude, longitude, orderno, CASE mcou.charsetid WHEN 1 THEN howtogetthereen WHEN 2 THEN howtogettheretc ELSE howtogettheresc END howtogetthere, CASE mcou.charsetid WHEN 1 THEN venuenameen WHEN 2 THEN venuenametc ELSE venuenamesc END venuename, CASE mcou.charsetid WHEN 1 THEN locationen WHEN 2 THEN locationtc ELSE locationsc END location, dimensionlength, dimensionwidth, cap_theatre, cap_classroom, cap_banquet, cap_cocktail, cap_boardroom, ceilingheight FROM v_mehk_company com LEFT JOIN (SELECT * FROM v_mehk_city WHERE charsetid = 3) ci ON (com.citycode = ci.value) LEFT JOIN v_mehk_mtr mtr ON com.nearestmtrcode = mtr.value AND mtr.charsetid = 3 LEFT JOIN v_mehk_country mcou ON com.countrycode = mcou.value AND mcou.charsetid = 3 LEFT JOIN v_mehk_location mloc ON com.locationcode = mloc.value AND mloc.charsetid = 3 where companyid = 77057 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 77057

旭逸酒店 • 铜锣湾

旭逸酒店.铜锣湾位于铜锣湾的心脏地带,距离地铁5分钟路程。在这更可随时走进各大商务区及大型购物中心如时代广场、希慎广场、崇光百货及香港会议展览中心。毗邻更有富旧区情怀的湾仔和星街小区,一切充满动感和惊喜的热点均近在咫尺。
旭逸酒店 • 铜锣湾
基本资料
地址 : 香港香港岛湾仔摩理臣山道39号
电话 : +852 37251588
电邮 : info.hecwb@hotelease.com.hk
网址 : http://www.hotelease.com.hk/causewaybay
最近的港铁站 : 铜锣湾

    点选以下方格,查看附近还有什么:

  • 景点
  • 购物
  • 美食
  • 酒店
SELECT DISTINCT fbo.fboutletid, fbo.outletnameen, fbo.outletnametc, fbo.outletnamesc, fbo.capacity, fbo.remarken, fbo.remarktc, fbo.remarksc FROM v_mehk_fboutlet fbo, v_mehk_fboutletcuisinetype fboct WHERE fbo.fboutletid = fboct.fboutletid AND fbo.companyid = 77057 ORDER BY outletnameen
其他设施

一般设施及客房服务

洗衣服务 , 非吸烟客房 , 24小时客房服务

房内设施

加床​ , 免费WiFi , 干发器 , 电视

设施照片
如何前往

旭逸酒店.铜锣湾位于铜锣湾的心脏地带,距离港铁5分钟路程