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

Harbour Bay Hotel

Harbour Bay Hotel is a boutique hotel in Tsim Sha Tsui, Hong Kong. Our rooms are exquisitely appointed with modern decor, offering guests a touch of Asian Hospitality. Our concept is about being stylish, and as comfortable as you want to be. Not only with MTR Stations are moments away but also just walking distance to the trendy dining, nightlife and entertainment areas. Hotel is close to the nearby premier offices, international banks, designer shopping and Michelin Restaurants in Tsim Sha Tsui, perfect for both business and leisure stay.
Harbour Bay Hotel
General Information
Address : 1 Minden Avenue,
Tsim Sha Tsui,
Kowloon,
Hong Kong
Tel : +852 21547933
Fax : +852 21547988
Email : info@harbourbayhotel.com
Website : http://www.harbourbayhotel.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 = 63602 ORDER BY outletnameen
Facilities

Accessible Facilities

Accessible lobby area / Main entrance , Accessible public toilet , Accessible rooms

General Amenities and Facilities

Conference and meeting facilities , Non-smoking rooms , Room service (24 hours)

In-room Amenities and Facilities

Complimentary Refreshments , Extra bed , Free WiFi , Hair dryer , Mini-bar , Toiletries

Photo
How to Get There

Hong Kong International Airport, Take Route 8 to Lin Cheung Road in Kowloon. Take exit 2 from W Kowloon Hwy/Route 3(31.8 km), Take D1A(N) Rd, Canton Road, Austin Road and Nathan Road to Minden Avenue(2.7 km).