场地及酒店搜索

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 = 3) ci ON (com.citycode = ci.value) LEFT JOIN v_mehk_mtr mtr ON com.nearestmtrcode = mtr.value AND mtr.charsetid = 3 LEFT JOIN v_mehk_country mcou ON com.countrycode = mcou.value AND mcou.charsetid = 3 LEFT JOIN v_mehk_location mloc ON com.locationcode = mloc.value AND mloc.charsetid = 3 where companyid = 1616 order by orderno, locationenSELECT * FROM v_mehk_contactperson where titleen like '%Sales & Marketing%' AND companyid = 1616

尚豪酒店

Sohotel尚豪酒店是一间拥有36间装修雅致舒适客房的商务精品酒店,规模虽小,但设备及服务非常完善。酒店提供如下五种房间:精致客房(一張小號雙人床),瑰麗豪華雙床客房(雙單人床),瑰麗豪華客房(一張小號雙人床),尊尚客房(一張大號雙人床),及尊尚套房(一張大號雙人床)。
位于香港中上环区的尚豪酒店位置优越,交通便利,步行5-15分钟,便可到达中环的商业区及名店林立的苏豪区,邻近港铁站及巴士站方便往来机场及市内各处,而步行8-10分钟便可到达往来澳门/国内及香港各离岛的渡轮码头,交通优越之处,Sohotel尚豪酒店都是所有商务或旅游顾客的最佳之选。
基本资料
地址 : 香港香港岛上环文咸街 139 号
电话 : +852 28518818
传真 : +852 28519933
电邮 : info@sohotel.com.hk
网址 : http://www.sohotel.com.hk
最近的港铁站 : 上环

    点选以下方格,查看附近还有什么:

  • 景点
  • 购物
  • 美食
  • 酒店
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 = 1616 ORDER BY outletnameen
设施照片