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

Regus Business Centre Limited

The Regus Group is the world’s leading provider of pioneering workplace solutions, with products and services ranging from fully equipped offices to professional meeting rooms, business lounges and the largest network of videoconference studios. Over 100,000 clients a day benefit from Regus Group facilities spread across a global footprint of 950 locations, in 400 cities and 70 countries which allows individuals and companies to work wherever, however and whenever they want to. Regus has 22 Centres in Greater China, and 6 in Hong Kong.

Regus has 6 business centres in Hong Kong, all of which are established at prestigious locations in business hubs in Hong Kong, with easy access to MTR stations, banks, restaurants, cafes, and department stores. They are in One IFC, 100 Queens Road Central, Shui On Centre, Citibank Plaza, The Lee Gardens, and Central Plaza.
General Information
Address : 35/F Central Plaza,
18 Harbour Road,
Wan Chai,
Hong Kong Island,
Hong Kong
Tel : +852 28248999
Fax : +852 28248000
Email : ruby.lee@regus.com
Website : www.regus.com
Nearest MTR station : Wan Chai
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 = 414 ORDER BY outletnameen