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 'estartit%' and parentlist like '%,5,-1'' at line 1
select parent_cat_name from scuba_diving_cat where cat_name like 'L'estartit%' and parentlist like '%,5,-1'
 scubish.com: Scuba diving L'estartit - Spain - Europe


L'estartit


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 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 _Gabri_, more information is available at http://www.flickr.com/photos/gabribcn/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 _Gabri_, more information is available at http://www.flickr.com/photos/gabribcn/ 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 pinkbelt, more information is available at http://www.flickr.com/photos/pinkbeltrage/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 pinkbelt, more information is available at http://www.flickr.com/photos/pinkbeltrage/ 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 ericvh, more information is available at http://www.flickr.com/photos/airwick/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 ericvh, more information is available at http://www.flickr.com/photos/airwick/ 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-nd/3.0/  The owner of this picture is yangwave, more information is available at http://www.flickr.com/photos/apt8/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 yangwave, more information is available at http://www.flickr.com/photos/apt8/ 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 Montanafish, more information is available at http://www.flickr.com/photos/colinspics/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 Montanafish, more information is available at http://www.flickr.com/photos/colinspics/ 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 Serge Melki, more information is available at http://www.flickr.com/photos/sergemelki/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 Serge Melki, more information is available at http://www.flickr.com/photos/sergemelki/ 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 toddneville, more information is available at http://www.flickr.com/photos/toddneville/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 toddneville, more information is available at http://www.flickr.com/photos/toddneville/ 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 dphershman, more information is available at http://www.flickr.com/photos/hershman/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 dphershman, more information is available at http://www.flickr.com/photos/hershman/ 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 Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/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 Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/ 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 Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/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 Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/ 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-sa/3.0/  The owner of this picture is Simon Welsh, more information is available at http://www.flickr.com/photos/simthom/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 Simon Welsh, more information is available at http://www.flickr.com/photos/simthom/

Hotels in L'estartit

Hotel Medes II Score 7.9 from 46 reviews
Guillem De Montgrí, 38 7.9/10
We are located in L’Estartit, a small fishing port in the county of El Baix Empordà –along the Costa Brava- right in front of the Medes Islands, one of the best-preserved marine nature reserves in the Mediterranean. This is the ideal place to do sea sports (diving, sailing...) and also to go shopping, go for a stroll and enjoy the natural beauty all around. ... more
 
Hostal Novel Risech Score 7.25 from 516 reviews
Avenida de Rhode, 185 7.25/10
Wi-Fi internet access is available in all communal areas of the hotel. ... more
 
Aparthotel & Village Golf Beach Score 7.4 from 9 reviews
Carretera Platja De Pals, Km. 4 7.4/10
Just minutes from the Girona beaches, surrounded by acres of green forests, and with a large outdoor swimming pool, this hotel is ideal for a relaxing holiday in the sun. Rent a car at the 24-hour reception and explore the 3 golf courses within the Pals area. Guests at the Aparthotel & Village Golf Beach can enjoy discounts at local golf facilities. The Aparthotel& Villa Golf Beach has a large pool and a kids pool for you and your family to sunbathe around, or you can head down to the sandy beaches. Enjoy spacious, well-equipped accommodation. Your apartment boasts full air conditioning and a kitchenette so that you can cook your own meals. You can admire the natural setting from your large private terrace, which can be accessed from both the bedroom and the living room. With a tour desk also on offer, the Aparthotel & Village Golf Beach is perfectly placed to make the most of Girona's cultural and leisure activities. ... more
 
Hotel Port-Bo Score 8.875 from 42 reviews
August Pi i Sunyer, 6 8.88/10
Located in the famously beautiful coastal town of Palafrugell, make the most of the Catalonian sunshine by the pool or in the garden. Enjoy wholesome buffet meals in the restaurant. Set in a quiet area of this peaceful fishing village, you are just 300 m from the charming beach. Here, refresh yourself with a dip in the Mediterranean and admire lovely views over the bay. Breathe the fresh sea air from the private balcony of your Hotel Port-Bo bedroom. Keep up-to-date with friends and world affairs on the Hotel Port-Bo's free wireless internet. ... more
 
Thalassa Sport Spa Score 6.725 from 9 reviews
Jacinto Benavente, 9 6.73/10
Thalassa Sport is a spa hotel, with an indoor swimming pool and fitness centre. It is set in Roses Bay, just 30 metres from Salatar Beach. Free private parking is available at the hotel. The historic centre of Roses is just a 10-minute walk away. The hotel reception also offers bicycle rental. The Thalassa Sport has a restaurant and bar. There is a sun terrace and a garden. The hotel offers free Wi-Fi access in public areas. The spa offers a sauna, steam bath and Hammam. There is also a hydrotherapy area with jacuzzi. Massages and treatments are available. The fitness centre offers a range of exercise classes. Rooms at the hotel have air conditioning and a balcony. They all have a minibar, satellite TV and tea and coffee-making facilities. ... more
 
More hotels in L'estartit

Day Tour to La Gomera 10 hours

La Gomera, Canary Islands

At Los Cristianos marina you will board a ferry for crossing to San Sebastian de la Gomera, harbor and capital of the island.

Once at this point, the ascent to the Parque National Garajonay, a paradise of laurisilva and a Cultural Heritage of Humanity nature reserve, will commence. A stop off will be made at Degollada de Peraza viewpoint where you have the opportunity to enjoy the fabulous panoramic views out over the island.

The route will then continue past La Palmita, through the national park before arriving at the little villages of Las Rosas and Agulo. Here, a stop will be made for lunch, which may be enjoyed in a restaurant typical of La Gomera. You should not leave without first witnessing a live demonstration of the particularly famous ""silbo gomero", a peculiar local method of communication.

Time permitting following your hearty lunch, there is nothing better than a call in at the visitor center where the ""juego de bolas"" (game of bowls) may be observed.

The return trip will be via the splendid Hermigua Valley, before arriving again at San Sebastian. It is possible to relax and take in the historical remains of Christopher Columbus' island presence before his departure for the Americas at the Torre del Conde or the house of Columbus.

Click here for more information and Booking Details


4x4 Jeep Adventure in the Prades Mountains 7 hours

4x4 Jeep Adventure in the Prades Mountains

Enjoy an excursion in a 4x4 vehicle (Nissan Patrol and Land Rover Defender or similar), switching between road and mountain treks in the area of the Prades mountains.

Your tour begins with an explanation of the itinerary which will take you through the landscape and villages, allowing opportunities for participants to enjoy the history and the typical dishes of the region.

After the first break, you tour continues to La Mussara, a village which is situated at an altitude of 3,280 feet (1,000 meters). It boasts views that will literally take one's breath away.

You will then be guided through the forest to La Febro, where there will be a stop for lunch to sample the culinary delights which the Prades Mountains have to offer.

Following lunch, you will visit Ciurana, a village which boasts an interesting history and culture. The tour continues to the Ciurana's reservoir, where there will be an opportunity to take a swim. You will then travel back through the villages of Alforja, Les Borges and Camp i Riudoms.

Click here for more information and Booking Details


Valencia Airport Private Arrival Transfer 30 minutes

Valencia Airport

Travel from Valencia Airport to your Valencia hotel. Transfer services are available 24 hours a day, 7 days a week. This is a private transfer so the price is the same for groups of:

  • 1 to 4 people

When making a booking, you will need to advise your flight details and your Valencia hotel details. Your transfer will be confirmed instantaneously and you will be provided with a travel voucher to present to the driver.

It's that easy!

Don't forget to book your Valencia Airport Departure Transfer, simply type the product code 3042VLCBHTLAPT into the Keyword Box.

At time of booking, YOU MUST include the following flight and hotel details in the "Special Requirements" box:

  • Airline
  • Flight Number
  • Departing Airport and Arrival City
  • Arrival Time
  • Full Hotel Name and Address

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear