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

Concerto Inn

Concerto Inn
General Information
Address : 28 Hung Shing Yeh Beach, Yung Shue Wan,
Lamma Island,
Outlying Islands,
Hong Kong
Tel : +852 29821668
+852 28363388
Fax : +852 29820022
+852 28363311
Email : booking@concertoinn.com.hk
Website : www.concertoinn.com.hk

    Select what you would like to see on the map:

  • Attractions
  • Shopping
  • Dining
  • Hotels
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 = 4482 ORDER BY outletnameen
Facilities

General Amenities and Facilities

Laundry / Valet , Restaurants

In-room Amenities and Facilities

Hair dryer , Mini-bar , Tea & coffee making facilities

Photo
General - Double Room General - Guest Room General - Double Room General - Double Room General - Restaurant General - Twin Room
How to Get There

From Airport: Take AEL to Hong Kong Station {Exit A2}, then walk to Central Ferry Pier no. 4 and take ferry to Lamma Island (Yung Shue Wan), and then walk towards Hung Shing Yeh Beach for 20-30mins.