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

Sohotel

We are a modern vibrant hotel with 37 rooms ranging from 160 sq. ft. to 330 sq. ft. Rooms are categorized into Classic Room (1 Semi-Double Bed), Premier Twin Room (2 Single Beds), Premier Double Room (1 Semi-Double Bed), Signature Room (1 Queen Size Bed), and Signature Suite (1 Super King Size Bed).
We are located within easy reach of Central's popular SOHO District and Commercial Centre. A few minutes walk from Macau Ferry Pier and Out-lying Ferry Piers to go to Macau and different islands with many beautiful beaches. We are also near to bus stations and underground transportation system (MTR), with easy access to the airport and all areas of Hong Kong.
General Information
Address : 139 Bonham Strand,
Sheung Wan,
Hong Kong Island,
Hong Kong
Tel : +852 28518818
Fax : +852 28519933
Email : info@sohotel.com.hk
Website : http://www.sohotel.com.hk
Nearest MTR station : Sheung Wan

    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 = 1616 ORDER BY outletnameen
Photo