Home 香港优势 企业会议及奖励旅游 会议 展览 旅游产品及优惠 您的筹划助手 昔日及当前活动

首页 >您的筹划助手 >场地及酒店搜索

场地及酒店搜索

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

V Causeway Bay Hotel

享负盛名的V系列旗舰酒店耸立闹市间，提供超过40种不同房间类型，不论是亲密无间的客房，还是顶级豪华套房，都让您宾至如归。V Causeway Bay Hotel曾于2009年获得美国建筑师学会设计奖。
V Causeway Bay Hotel
基本资料
地址 : 香港香港岛铜锣湾怡和街9号
电话 : +852 36022388
电邮 : reservation@thev.hk
网址 : www.thevhotels.com
最近的港铁站 : 铜锣湾

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

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