Venue & Hotel Search

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 = 1) ci ON (com.citycode = ci.value) LEFT JOIN v_mehk_mtr mtr ON com.nearestmtrcode = mtr.value AND mtr.charsetid = 1 LEFT JOIN v_mehk_country mcou ON com.countrycode = mcou.value AND mcou.charsetid = 1 LEFT JOIN v_mehk_location mloc ON com.locationcode = mloc.value AND mloc.charsetid = 1 where companyid = 82102 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 82102

Shama Island North

North Point is renowned as a food paradise and a culturally rich district. Located right between North Point and Fortress Hill MTR stations with 29 contemporary apartments and a tropical rooftop garden, Shama Island North revives the most intriguing city living in the area.
Shama Island North
General Information
Address : 310 King's Road,
North Point,
Hong Kong Island,
Hong Kong
Tel : +852 36053088
Email : frontoffice.islandnorth@shama.com
Website : https://www.shama.com/island-north-hong-kong
https://zh.shama.com/island-north-hong-kong
https://cn.shama.com/island-north-hong-kong
Nearest MTR station : Fortress Hill

    Select what you would like to see on the map:

  • Attractions
  • Shopping
  • Dining
  • Hotels
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
Facilities

Accessible Facilities

Accessible lobby area / Main entrance , Accessible rooms

General Amenities and Facilities

Business centre , Electrical adaptor on request , Family rooms / Triple / Quad , Limousine service , Non-smoking rooms

In-room Amenities and Facilities

Baby cribs / Infant beds , Bath tub , Extra bed , Free WiFi , Hair dryer , In-Room Safe Deposit Box , Iron & ironing board , Kitchenette , Tea & coffee making facilities , Toiletries , TV

MICE Amenities and Facilities

Broadband connectivity , Complimentary Wi-Fi

Recreation Facilities

Fitness room / Gymnasium

Photo
Extrance Superior Queen Superior Twin with Work Desk Superior - Bathroom Shama Gym