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

WORLD ASIA HONG KONG MID LEVEL'S

Mid Level's


Diveshops in Mid Level's:


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 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/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 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/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 josephp, more information is available at http://www.flickr.com/photos/sumsinnow/ 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/3.0/  The owner of this picture is brookenovak, more information is available at http://www.flickr.com/photos/brookenovak/

Hotels in Mid Level's
Novotel Century Hong Kong Score 7.25 from 4 reviews
238 Jaffe Road, Wanchai 7.25/10
Strategically located in Wanchai, Hong Kong’s commercial, shopping and entertainment district, this hotel is minutes from Hong Kong Convention and Exhibition Centre, Wanchai MTR station and Star Ferry Pier. Easily accessible by all forms of public transport, the hotel has 511 rooms catering to both leisure and business needs. All rooms are feature the listed amenities, and disabled rooms can be offered on request, subject to availability. The health club facilities include a gym and outdoor swimming pool for your exercise essentials, as well as a sauna to help you relax and rejuvenate. If you are travelling on business, you can also take full advantage of the wired and Wi-Fi broadband internet connections in your room and throughout the hotel. ... more
 
Holiday Inn Express Luohu Shenzhen Score 8.85 from 7 reviews
No.6 Guiyuan North Road, Luohu District 8.85/10
Within 3 minutes' walk from the hotel is the metro station, while Luohu transport station is 5 minutes away. With the metro, it takes only 5 minutes to travel to Huaqiangbei shopping centre. The Shenzhen Baoan International Airport is 40 minutes' drive away. ... more
 
Harbour Plaza North Point Score 7.35 from 7 reviews
665 King's Road, Quarry Bay 7.35/10
Harbour Plaza North Point houses numerous business and recreational facilities. Enjoy the convenience of our 24-hour business centre and meeting facilities. Our 1,000 sq. m (10,764 sq. ft) of function rooms enable us to cater to all sorts of formal and celebratory events, while our swimming pool and fitness centre will leave you relaxed and refreshed. ... more
 
Metropark Hotel Causeway Bay Hong Kong Score 7.2 from 5 reviews
148 Tung Lo Wan Road 7.2/10
This is a contemporary hotel that meets the needs of both business and leisure travellers. It has been developed by China Travel Service (Holdings) Hong Kong Ltd. and is managed by CTS HK Metropark Hotels Management Co. Ltd. Floor-to-ceiling glazing features throughout the 33-floor hotel tower, providing magnificent views of Hong Kong's famous Victoria Harbour and Park from many of the rooms. The design concept of our hotel emphasises comfort and spaciousness. The size of the rooms, from standard to executive parlour, is slightly larger than other Hong Kong hotels in the same class. Innovative dining concepts and well-equipped facilities are complemented by great service. Facilities include complementary broadband internet access, business centre, restaurant and pub. There is also a health club and a rooftop outdoor swimming pool (temporarily closed in January and February). ... more
 
L'hotel Causeway Bay Harbour View Score 7.45 from 29 reviews
18 King's Road, Causeway Bay 7.45/10
Over one third of 275 guest rooms offer breathtaking and unobstructed views of Victoria Harbour and Hong Kong skyline. Well appointed rooms with warm teak wood flooring, harmonic coloured furniture, all ensure superior quality and standard. All rooms are equipped with the amenities for our guests comfort and convenience. Assured, light, clean and tranquillity style with a choice of King bed or twin beds. Executive Harbour View Suites and other Deluxe Suites offer spacious separate sitting and bedroom, of which separate washroom and bathroom for ultimate convenience. ... more
 
More hotels in Mid Level's

Hong Kong Harbour Night Junk Cruise including Drinks 1.5 hours

Hong Kong by Night

Board a traditional junk, enjoy sipping cocktails with the open-bar hospitality onboard while seeing the fantastic night view from all different angles. Cruise to the colorful Western District, once the busy waterfront trading center in the old days.

See more activities in the main harbor through the busy freighter anchorage, towards the Kowloon Promenade. Sail along the Island East waterfront and pass by Causeway Bay Typhoon Shelter before ending the cruise.

Click here for more information and Booking Details


Cultural Heritage of Hong Kong - Buddhist Monastery, Big Hat Mountain 4 - 5 hours

Tai Mo Shan Lookout

Off the beaten track from the city?s high rise apartment to the suburban area. You will be astonished at how much remain from 6000 years of human settlement in the territory across ancient archaeological site, traditional Chinese structures, temples to different clan?s ancestral halls around the cultural side of New Territories, which occupies 980 square km or 91% of Hong Kong?s land area.

The tour begins with an impressive Buddhist Monastery (Chuk Lam Shim Yuen), housing the 3 largest 'Precious Buddha' statues in Hong Kong. The complex includes many features of traditional Chinese architecture and surrounded by a beautiful plantation of bamboo trees. Heading up to the highest mountain Tai Mo Shan (Big Hat Mountain), you will have a panoramic view of Lam Chuen Valley, Shek Kong Airport and Camps, and see the nearby cities in China at the Route Twisk Look Out Point.

Our next stop is to visit the Tin Hau Temple (Goddess of the Sea). The temple was built in 1736 near Tai Po in Lam Tsuen, local come to the temple for guidance by shaking the prediction box, especially fishing folks. Next to the Tin Hau Temple, is the magnificent Wishing Tree where people write wishes on colorful papers and throw them into the air to catch on the tree, it will mean the wishes are granted.

The tour will then take you to the Tang Chung Ling Ancestral Hal, that was built in 1525 in honor of the founding ancestor. Tang Chung Ling (1302-1387). The building is exquisitely decorated with fine wood-carvings, fully reflecting the superb craftsmanship of the old days. Next to the ancestral hall is Lo Wai, which is the first and one of the five renowned walled villages in Lung Yeuk Tau, Fanling was established by the Tang clan whose ancestors branched out from the main Tang settlement in Kam Tin in the 13 century.

Click here for more information and Booking Details


Lantau Big Buddha to Tai O (Mountain Route) Hiking Tour 8.5 hours

Ngong Ping Plateau

The tour starts by taking a ferry and bus to the Ngong Ping plateau on Lantau Island where the Po Lin Monastery and Big Buddha are located. You will have an opportunity to briefly explore the Buddha, Monastery and Wisdom Path before starting the walk.

The hiking tour starts at the Ngong Ping plateau at about 450 metres above sea level and ends at the picturesque fishing village of Tai O at sea level. This hike follows the ridge of the mountains which encircle the Keung Shan Valley. Consequently whilst the views are more spectacular from the tops of the hills, the walking is more strenuous and there are a number of steep hills both up and down.

The highest point is Keung Shan at 490 metres above sea level. Along the route you will pass a monastery with a flying dragon on the hillside behind and the mansion of a rich merchant built in traditional Chinese style with green tiled roofs and a lily pond.

At Tai O there will be time to stroll along the main street lined with traditional shops selling live and dried seafood and photograph the houses built over the creek on stilts.This villages' origins extend over 1,000 years when it was the centre of the salt extraction business in the area. You will return to Central by bus and train.

Click here for more information and Booking Details


For a complete scuba diving guide with great articles and more destination information, visit Divepilot.com
ADD TO DEL.ICIO.US   ADD TO DIGG   ADD TO FURL   ADD TO REDDIT   ADD TO STUMBLEUPON   ADD TO TECHNORATI FAVORITES   ADD TO WINDOWS LIVE   ADD TO YAHOO MYWEB   ADD TO GOOGLE

© 2008 D4DR Media | All Rights Reserved | Terms and Conditions | Copyright Notices