场地及酒店搜索

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 = 75674 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 75674

辉豪酒店

辉豪酒店是坐落于西环的新形精品酒店, 地理位置优越, 距离坚尼地城地铁站只有3分钟路程, 而距离中环闹市亦只需要15分钟。酒店及房间设计舒适简洁, 绝对配合各类顾客的需要。
辉豪酒店
基本资料
地址 : 香港香港岛坚尼地城厚和街2~4号
电话 : +852 37522988
电邮 : info@miacasa.com.hk
网址 : https://www.miacasa.com.hk/
https://zh.miacasa.com.hk/
最近的港铁站 : 坚尼地城

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

  • 景点
  • 购物
  • 美食
  • 酒店
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 = 75674 ORDER BY outletnameen
其他设施

无障碍设施

设有无障碍通道的大堂或主要入口 , 无障碍客房

房内设施

免费WiFi , 干发器 , 房内保险箱 , 熨斗及熨板 , 卫浴用品 , 电视

设施照片
如何前往

乘地铁MTR:坚尼地城站C出口步行3分钟