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

Comfort Lodge, Hong Kong

Comfort Lodge offers affordable prices, quality accommodation and friendly services. Conveniently located in the centre of shopping, commercial and entertainment area of Jordan. Close to different kinds of transport lines - Jordan MTR, airport bus A21 & A22 and free shuttle bus K1 to Kowloon Station for airport express train. Walking distance to Temple Street Night Market, Jade Market, Kowloon Park, HK & China Ferry Terminal, Guangdong & Hong Kong Cross Boundary Bus Terminus, Hung Hom Kowloon-Canton Railway Terminus, etc.
General Information
Address : Flat A, 2nd Floor Knight Garden,
7-8 Tak Hing Street,
Jordan,
Kowloon,
Hong Kong
Tel : +852 23148068
Fax : +852 23663588
Email : info@comfortlodge.com
Website : www.comfortlodge.com
Nearest MTR station : Jordan
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 = 521 ORDER BY outletnameen
Facilities

General Amenities and Facilities

Business centre , Foreign currency exchange , Laundry / Valet , Room service (24 hours)

In-room Amenities and Facilities

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

How to Get There

(1)Take the airport express train, alight in Kowloon Station, take a taxi to our place (about HK$25). (2) Take the airport bus No.A21, alight at 9th bus stop, Prudential Shopping Centre. Walk through the shopping mall, that is our street.