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

ALVA HOTEL BY ROYAL (Opening in the second half of 2019)

Opening in the second half of 2019, ALVA HOTEL BY ROYAL is a new premium hotel with 618 rooms. It is highly accessible and within a 30 to 40-minute drive of Tsim Sha Tsui, Central and Hong Kong International Airport. The hotel offers guest-centric technology, innovative dining and accessible luxury with a modern lifestyle hospitality concept designed specifically for city-explorers.
General Information
Address : 1 Yuen Hong Street,
Sha Tin,
New Territories,
Hong Kong
Tel : +852 26600789
Fax : +852 34285524
Email : dorischan@alva.com.hk
Website : www.alva.com.hk
Nearest MTR station : Shek Mun

    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 = 72459 ORDER BY outletnameen
Facilities

Accessible Facilities

Accessible Food & Beverage Outlets , Accessible Lobby Area / Main Entrance , Accessible Meeting and Conference Area , Accessible Parking , Accessible Public Toilet , Accessible Rooms , Lift with Audible Announcement System / Braille Button

General Amenities and Facilities

Audio Visual Equipment , Banquet Facilities , Bar & Lounge , Broadband Internet Access , Car Park , Coffee Shop , Conference and Meeting Facilities , Connecting Room , Doctor Services , Electrical Transformer on request , Express Check-out , Foreign Currency and Exchange , Laundry / Valet , Limousine Service , Non-smoking Dining Rooms , Non-smoking Floors , Non-smoking Rooms , Regular Shuttle Bus Service , Restaurants , Wheelchairs on Request

In-room Amenities and Facilities

Alarm Clock , Bathrobes , Extra Bed , Free WiFi Access , Hair Dryer , In-room Safe Deposit Box , Mini-bar in Room , Shampoo , Shower Cap , Slippers , Tea & Coffee Making Facilities , Tooth Brush , TV with Cable Network , TV with Satellite Channels , Voice Mail

MICE Amenities and Facilities

AV Capabilities , Complimentary Wi-Fi , Conference and Meeting Facilities , Connecting Room , LCD projector , Onsite catering

Recreation Facilities

Gymnasium , Swimming Pool: Outdoor

How to Get There

Complimentary hotel shuttle bus service will be available once the Hotel opens with the following stops (tentative) on a first-come, first-served basis. MTR stations – Shek Mun, Shatin, Kowloon Major shopping centres - New Town Plaza, Elements Hong Kong Science Park Royal Park Hotel near Shatin MTR Station