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

Rambler Oasis Hotel

Overlooking Rambler Channel, the Rambler Oasis Hotel features excellent amenities and comfortably-appointed guest rooms, as well as convenient shuttle services to the city's major transportation lines. Make exploring the city a breeze with the hotel's free shuttle bus to Tsing Yi MTR station (Maritime Square), from where you can get quick access to Kwai Fong Metro Plaza, Elements, the Hong Kong International Airport, Asia World Expo and beyond.
Rambler Oasis Hotel
General Information
Address : No.1 Tsing Yi Road,
Tsing Yi,
New Territories,
Hong Kong
Tel : +852 21291188
Fax : +852 21291199
Email : enquiry.oasis@ramblerhotels.com
Website : http://www.ramblerhotels.com
Nearest MTR station : Tsing Yi

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

Accessible Facilities

Accessible lobby area / Main entrance , Accessible parking , Accessible public toilet , Lift with audible announcement system / Braille button

General Amenities and Facilities

Business centre , Car park , Conference and meeting facilities , Daily newspapers , Express check-out , Foreign currency exchange , Laundry / Valet , Limousine service , Non-smoking rooms , Regular shuttle bus service , Safe deposit box - Front desk , Wheelchairs on request

In-room Amenities and Facilities

Hair dryer , In-Room Safe Deposit Box , Iron & ironing board , Mini-bar , Tea & coffee making facilities , Toiletries , TV

Recreation Facilities

Fitness room / Gymnasium , Jacuzzi / Whirlpool , Sauna , Steam bath , Swimming pool: Outdoor

Photo