场地及酒店搜索

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

8th Estate 酿酒庄, 香港

8th Estate 酿酒庄是香港第一个专业酿酒庄。我们的理念就是从世界各地入口严选葡萄,酿出最佳品质的葡萄酒。8th Estate 酿酒庄是唯一一个在亚洲位于城市中的酿酒庄,让每一个访客在品嚐由本地出品的美酒之时,也能亲目并了解做酒的细节,使访客更享受每一口的优质佳酿,亦能感受到香港人生活的态度及独特品味。
基本资料
地址 : 香港香港岛鸭脷洲利兴街10号港湾工贸中心3楼302室
电话 : +852 25180922
电邮 : 8@the8estatewinery.com
网址 : www.the8estatewinery.com
最近的港铁站 : 金钟

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

  • 景点
  • 购物
  • 美食
  • 酒店
会议,展览及宴会设施
场地名称 位置 尺寸(米) TA CR BQ CT BR 天花高度
酒庄主酒桶室 23 X 20 40 40 100 40 10
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 = 1874 ORDER BY outletnameen
设施照片
酒桶 室外露天花园(高处视角) 主酒桶室