场地及酒店搜索

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

莎玛港岛北

北角享有美食天堂及文化荟萃之誉。位处北角与炮台山港铁站中心点的莎玛港岛北提供29套装潢优雅的时尚单位及天台花园,让您感受多样化的便捷城市生活体验。
莎玛港岛北
基本资料
地址 : 香港香港岛北角英皇道310號
电话 : +852 36053088
电邮 : frontoffice.islandnorth@shama.com
网址 : https://www.shama.com/island-north-hong-kong
https://zh.shama.com/island-north-hong-kong
https://cn.shama.com/island-north-hong-kong
最近的港铁站 : 炮台山

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

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

无障碍设施

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

一般设施及客房服务

商务中心 , 转换插头借用 , 家庭客房 / 三人房 / 四人房 , 轿车服务 , 非吸烟客房

房内设施

婴儿床 , 浴缸 , 加床​ , 免费WiFi , 干发器 , 房内保险箱 , 熨斗及熨板 , 房内小厨房 , 茶/咖啡冲泡设备 , 卫浴用品 , 电视

会议展览及宴会设施

宽带上网 , 免费无线上网

康乐设施

健身房

设施照片
Extrance Superior Queen Superior Twin with Work Desk Superior - Bathroom Shama Gym