场地及酒店搜索

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

救世军卜维廉宾馆

救世军卜维廉宾馆从一九八五年开业以来,全由专科酒店人员操作营运。为来自世界各地商旅,提供理想居停和服务。宾馆座落于油麻地区,地铁、巴士皆可直达,交通便利。
基本资料
地址 : 香港九龙油麻地永星里11号
电话 : +852 27719266
传真 : +852 23851140
电邮 : boothlodge@salvation.org.hk
网址 : https://www.salvationarmy.org.hk/en/services/booth
https://www.salvationarmy.org.hk/hk/services/booth
https://www.salvationarmy.org.hk/cn/services/booth
最近的港铁站 : 油麻地

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

  • 景点
  • 购物
  • 美食
  • 酒店
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 = 82 ORDER BY outletnameen
餐饮场所
场所编号 场所名称 容纳人数 美食种类 备注
190 Coffee Shop 120 SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 3 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 190 咖啡店
其他设施

一般设施及客房服务

机场穿梭巴士 , 咖啡室 , 相连房间 , 报刊 , 外币找换 , 洗衣服务 , 非吸烟客房 , 接待处保险箱 , 旅游柜台 , 轮椅借用

房内设施

免费WiFi , 干发器 , 迷你酒吧 , 卫浴用品

设施照片