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

Residence G Hong Kong

Residence G Hong Kong, a vibrant lifestyle hotel in the heart of Tsim Sha Tsui, Kowloon – Hong Kong.

All rooms are fully equipped, combining practicality and in-vogue style. Located just 5 minutes walk from Tsim Sha Tsui MTR station.
Residence G Hong Kong
General Information
Address : 2-2A Austin Avenue,
Tsim Sha Tsui,
Kowloon,
Hong Kong
Tel : +852 23558888
Fax : +852 23558808
Email : info@residenceGhongkong.com
Website : www.residenceghongkong.com
Nearest MTR station : Tsim Sha Tsui

    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 = 24215 ORDER BY outletnameen
Food & Beverage Outlet
Outlet id Outlet Name Capacity Cuisine Type Remarks
6631 SCARLETT 100 SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 1 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 6631 Western , Wine , French WINE BAR
Facilities

Accessible Facilities

Accessible food & beverage outlets

General Amenities and Facilities

Bar & lounge , Electrical adaptor on request , Laundry / Valet , Non-smoking rooms , Restaurants

In-room Amenities and Facilities

Complimentary Refreshments , Extra bed , Free WiFi , Hair dryer , In-Room Safe Deposit Box , Iron & ironing board , Mini-bar , Tea & coffee making facilities , Toiletries , TV

Photo
Greater Room Building Great Room Good Room Lobby
How to Get There

5 minutes walk from Tsim Sha Tsui MTR station