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

One-Eight-One Hotel & Serviced Residences

Situated in the historic yet fashionable Western District of Hong Kong Island, One-Eight-One Hotel & Serviced Residences boasts spectacular panoramic views of Victoria Harbour. Just steps away from the MTR HKU Station, airport bus and tram stops, the boutique Hotel offers 183 spacious and contemporary guest rooms elegantly designed for discerning business and leisure travellers.
One-Eight-One Hotel & Serviced Residences
General Information
Address : 181 Connaught Road West,
Western District,
Hong Kong Island,
Hong Kong
Tel : +852 31811688
Email : enquiries@one-eight-one.com
Website : http://www.one-eight-one.com/
Nearest MTR station : HKU
Meeting, Exhibition and Banquet Facilities
Venue Name Location Dimension(m) TA CR BQ CT BR Ceiling Height
The Space I 2/F 6 X 5.2 10 3.1
The Space II 2/F 5.8 X 5.2 10 3.1
The Space III 5/F 9.7 X 11.7 54 39 50 18 3.5
The Space IV 5/F 9.2 X 3.6 18 2.6
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 = 67288 ORDER BY outletnameen
Food & Beverage Outlet
Outlet id Outlet Name Capacity Cuisine Type Remarks
13827 The Common Room 120 SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 1 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 13827 Cocktails & Snacks , Continental / European , Wine Private Room
13826 The Tea Room 104 SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 1 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 13826 Chinese (Hong Kong Style) , Chinese (Cantonese)
Facilities

In-room Amenities and Facilities

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

Photo
Hotel Lobby Luxe Harbour Room The Space I The Space II The Space III_U shape The Space IV