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

Bay Bridge Hong Kong by Hotel G

Facing Tsing Ma Bridge and the shore of South China Sea, Bay Bridge Hong Kong provides you with a blissful retreat. Guests can enjoy the tranquility of these elegantly furnished hotel & serviced apartments in Hong Kong facing the picturesque seafront amidst the hustle and bustle of the Hong Kong metropolis. Bay Bridge Hong Kong unit types are studio flats, 1-bedroom and 1-bedroom with terrace flats, ranging from approximately 440 sq.ft. to 800 sq.ft.
Bay Bridge Hong Kong by Hotel G
General Information
Address : 123 Castle Peak Road, Yau Kom Tau,
Tsuen Wan,
New Territories,
Hong Kong
Tel : +852 29451111
Fax : +852 24938033
Email : sales@baybridgehongkong.com
Website : http://baybridgehongkong.com
Nearest MTR station : Tsuen 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 = 22192 ORDER BY outletnameen
Food & Beverage Outlet
Outlet id Outlet Name Capacity Cuisine Type Remarks
4098 Anchor's Seafood and Beerhouse 116 SELECT text FROM v_mehk_cuisinetype ct, v_mehk_fboutletcuisinetype fct where ct.charsetid = 1 AND ct.value = fct.cuisinetypecode AND fct.fboutletid = 4098 International Cuisine , Buffet
Facilities

General Amenities and Facilities

Broadband Internet Access , Car Park , Conference and Meeting Facilities , Daily Local Newspapers , Laundry / Valet , Non-smoking Floors , Regular Shuttle Bus Service , Restaurants , Room Service (24 hours)

In-room Amenities and Facilities

Alarm Clock , Extra Bed , Free WiFi Access , Hair Dryer , In-room Safe Deposit Box , Iron & Ironing Board , Kitchenette , Shampoo , Shower Cap , Slippers , Tooth Brush , TV with Satellite Channels , Voice Mail

Recreation Facilities

Gymnasium , Sauna , Swimming Pool: Outdoor

Photo
Lobby Swimming pool
How to Get There

Bay Bridge Hong Kong is conveniently located in Tsuen Wan which has the benefits of a modern transportation network which includes the MTR station Tsuen Wan and direct access to Tsuen Wan Road interchange, Highways number 3, 5, 7, 8 and 9, West Kowloon Highway, Hong Kong International Airport, Tai Lam Tunnel and North Lantau Highway. •It takes only 7 minutes from MTR Tsuen Wan Station to The Bay Bridge Hong Kong by shuttle bus (complimentary) •30 minutes driving distance to and from the airport •MTR direct access to: Tsim Sha Tsui - 20 minutes •Central: 30 minutes