You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%' and parentlist like '%,5,-1'' at line 1
select parent_cat_name from scuba_diving_cat where cat_name like 'Mid Level's%' and parentlist like '%,5,-1'
scubish.com: Scuba diving Mid Level's - Hong Kong - Asia

Home
Buddyfinder
Gear
Divelog
Forum
Search
 

Mid Level's

This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is chrisbernardi, more information is available at http://www.flickr.com/photos/chrisbernardi/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is chrisbernardi, more information is available at http://www.flickr.com/photos/chrisbernardi/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is zusjes weblog, more information is available at http://www.flickr.com/photos/zusje/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is zusjes weblog, more information is available at http://www.flickr.com/photos/zusje/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is jbarreiros, more information is available at http://www.flickr.com/photos/tintedglasssky/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is jbarreiros, more information is available at http://www.flickr.com/photos/tintedglasssky/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is Kapungo, more information is available at http://www.flickr.com/photos/kapungo/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is Kapungo, more information is available at http://www.flickr.com/photos/kapungo/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is okyanos, more information is available at http://www.flickr.com/photos/nektar/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is okyanos, more information is available at http://www.flickr.com/photos/nektar/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is silly string, more information is available at http://www.flickr.com/photos/sillystring/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is silly string, more information is available at http://www.flickr.com/photos/sillystring/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is Romeocat, more information is available at http://www.flickr.com/photos/romeocat/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is Romeocat, more information is available at http://www.flickr.com/photos/romeocat/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is pakmat, more information is available at http://www.flickr.com/photos/dodol/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is pakmat, more information is available at http://www.flickr.com/photos/dodol/
This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is woofiegrrl, more information is available at http://www.flickr.com/photos/meredith/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is woofiegrrl, more information is available at http://www.flickr.com/photos/meredith/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is Jimp79, more information is available at http://www.flickr.com/photos/jimp79/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is Jimp79, more information is available at http://www.flickr.com/photos/jimp79/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is chrisbernardi, more information is available at http://www.flickr.com/photos/chrisbernardi/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is chrisbernardi, more information is available at http://www.flickr.com/photos/chrisbernardi/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is whiskymac, more information is available at http://www.flickr.com/photos/whiskymac/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is whiskymac, more information is available at http://www.flickr.com/photos/whiskymac/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/ The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is pianoforte, more information is available at http://www.flickr.com/photos/pianoforte/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/ The owner of this picture is pianoforte, more information is available at http://www.flickr.com/photos/pianoforte/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is chicatan, more information is available at http://www.flickr.com/photos/chicatan/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/ The owner of this picture is chicatan, more information is available at http://www.flickr.com/photos/chicatan/

Hotels in Mid Level's

Somerset Garden City, Shenzhen Score 8.125 from 4 reviews
Garden City Phase III, Nanhai Avenue, Nanshan District 8.13/10
It’s within walking distance to Shekou shopping center. It’s just a few minutes drive from Seaworld Square Entertainment Center, Shekou business area and Shekou Ferry Port. ... more
 
 Butterfly On Morrison Score 0 from 0 reviews
35-39 Morrison Hill Road 0/10
... more
 
Island Pacific Hotel Score 7.725 from 264 reviews
152 Connaught Road West 7.73/10
This 29-storey deluxe boutique hotel offers elegance and luxury right on the waterfront of Victoria Harbour. All the comfortable rooms and suites have spectacular views over the city or harbour. The rooms have trademarks such as full length windows, high ceilings, and a simple, warm and stylish decoration. The 343-room hotel offers easy access to the central business district and is only 15 minutes away from The Hong Kong Convention and Exhibition Centre. ... more
 
Metropark Hotel Wanchai Hong Kong Score 7.9 from 539 reviews
41-49 Hennessy Road 7.9/10
The modern Metropark Hotel is located at the heart of Wanchai, a popular commercial and business district. It offers stylish air-conditioned rooms with LCD TV, tea/coffee maker, minibar and safe. Tour arrangements can be made at Metropark Wanchai's tour desk. Airline ticketing and massage services are also available. In-room internet access is provided at an additional charge. The hotel's restaurant, Cafe de Metropark offers a wide buffet spread of western favourites and delicious oriental dishes. Wanchai MTR Station is just a few steps away. Hong Kong Convention and Exhibition Centre is an easy 10-minutes walk. Nearby attractions include several dining, shopping and entertainment options. ... more
 
Regal Kowloon Hotel Score 7.4 from 75 reviews
71 Mody Road 7.4/10
Centrally located in Tsim Sha Tsui, Regal Hotel offers elegant rooms, a 24-hour fitness centre and easy access to Hong Kong's popular commercial district and transportation links. Regal Kowloon Hotel is close to attractions such as DFS Galleria and Granville Road. It is also within walking distance from MTR stations and the Star Ferry, as well as the Hydrofoil pier. Nearby are also a food street and plenty of restaurants to choose from. Calm and inviting, Rooms at Regal Kowloon are furnished in a European style with an Asian touch. They also offer scenic views of the park, city or Centennial Garden. For convenience, Regal Hotel has 6 floors of non-smoking rooms and offers 24-hour room service. Regal Kowloon Hotels also provides a 24-hour fitness centre so you can unwind and recharge with a work-out at any hour. There is also an entertainment lounge, sauna and beauty salon. Enjoy a variety of cuisines available at Regal Kowloon's 5 on-site restaurants, ranging from Italian, Chinese and International buffet spreads. You can also enjoy a cosy atmosphere with a cocktail and live music at Basso Bar. ... more
 
More hotels in Mid Level's

Deserted Beaches Hiking Tour 8.5 hours

Ham Tin Wan and Sharp Peak

The Deserted Beaches are long white sandy beaches in the East Sai Kung Country Park backed by mountains and separated by ridges running steeply down to the sea. The only access is by walking or by boat and during the week they are practically deserted.

You will access this hiking tour by train, minibus and bus from Central to Pak Tam Chung at the entrance to the Sai Kung Country Park. From there, you will walk along a Country Park access road following the northern shore of the High Island Reservoir, the largest fresh water reservoir in Hong Kong with extensive views over the islands and mountains of the eastern New Territories.

After crossing a ridge into the first bay at Sai Wan, you will follow part of Section 2 of the MacLehose Trail around the coast of the magnificent bay called Tai Long Wan with spectacular views of the clear blue waters of the bay backed by rugged hills. After crossing two more peninsulas which shelter inlets from Mirs Bay, you will finish the walk at Pak Tam Road and take public transport back to the urban area.

Click here for more information and Booking Details

Ocean Park Hong Kong Full Day Tour 8 hours

Ocean Park Rollercoaster

Ocean Park Hong Kong is one of the most spectacular oceanariums in the world with the largest marine theatre. It is also an amusement park perched around two mountain peaks, with an area of 870,000 square meters.

A breath-taking 8-minute ride by cable car to the headland gives a glorious view of Repulse Bay, Deep Water Bay, Aberdeen and the South China Sea. Sealions, dolphins, sharks, penguins and killer whales are housed in stimulated environments similar to their natural habitat and will show off their spectacular tricks to thrill you at the Ocean Theatre. Also an excellent opportunity to see its two most popular guests ? giant pandas An An and Jia Jia.

The park also offers a full range of hair raising rides:
  • The exhilarating Dragon Roller Coaster
  • The thrilling Mine Train
  • Flying Swing
  • The Eagle
  • the latest Abyss Turbo Drop (this guarantees you the utmost excitement by a sudden downward plunge from as high as a 20-storey building)
Travel down the mountain by the world?s second longest outdoor mountain-climbing escalator and transfer to the hotel. Click here for more information and Booking Details

Peak to Aberdeen Walking Tour 4.5 hours

Aberdeen Harbour

After ascending to the Peak on the famous Peak Tram, you will start this walk by following Lugard Road around the north and eastern faces of Victoria Peak with spectacular views over Victoria Harbour towards Lantau Island and the Kowloon Peninsula towards the mountains that geographically divide Kowloon from the New Territories.

You will then follow part of the Hong Kong Trail around the western end of Hong Kong Island, with views across the South China Sea towards Cheung Chau Island and across the Lamma Channel to Lamma Island.

Since this tour starts at Victoria Peak at about 450 metres above sea level and ends at Aberdeen at sea level it is mainly downhill but there are a few short uphill sections along the way. The trail's surface is partly Country Park roads, partly concrete and partly dirt.

Click here for more information and Booking Details