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

Home
Buddyfinder
Gear
Divelog
Forum
Search
 

L'estartit

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 pixie_bebe, more information is available at http://www.flickr.com/photos/pixie_bebe/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 pixie_bebe, more information is available at http://www.flickr.com/photos/pixie_bebe/ 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 kentbrew, more information is available at http://www.flickr.com/photos/kentbrew/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 kentbrew, more information is available at http://www.flickr.com/photos/kentbrew/ 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 corvettediver, more information is available at http://www.flickr.com/photos/70349997@N00/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 corvettediver, more information is available at http://www.flickr.com/photos/70349997@N00/ 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 si_si_ay, more information is available at http://www.flickr.com/photos/angellic/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 si_si_ay, more information is available at http://www.flickr.com/photos/angellic/ 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 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/3.0/ The owner of this picture is ctsnow, more information is available at http://www.flickr.com/photos/ctsnow/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 ctsnow, more information is available at http://www.flickr.com/photos/ctsnow/ 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 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-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-sa/3.0/ The owner of this picture is olivermccloud, more information is available at http://www.flickr.com/photos/mccloud/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 olivermccloud, more information is available at http://www.flickr.com/photos/mccloud/ 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 mahalie, more information is available at http://www.flickr.com/photos/mahalie/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 mahalie, more information is available at http://www.flickr.com/photos/mahalie/ 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 alismith44, more information is available at http://www.flickr.com/photos/alismith44/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 alismith44, more information is available at http://www.flickr.com/photos/alismith44/ 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 skippy13, more information is available at http://www.flickr.com/photos/skippy/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 skippy13, more information is available at http://www.flickr.com/photos/skippy/ 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 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/

Hotels in L'estartit

Blaumar Score 9.225 from 135 reviews
Farena, 36 9.23/10
This charming hotel is in Llafranc, one of the best beach resorts on the Costa Brava. All rooms at the Blaumar have a private terrace or garden with sea views. The Blaumar is located in the heart of the beautiful Empordà region. Along the coastline there are a range of beaches and interesting fishing towns. The hotel has soundproofed bedrooms with bright décor and lots of natural light. There are wooden floors and attractive furniture. Wi-Fi is free in both rooms and public areas. These include a living room where hot drinks are served around the fireplace. Breakfast includes local produce and fresh fruit and is available on the outdoor terrace. There are also gardens and a bar. Free public parking is possible on site. There are 10 golf courses within 20 kilometres. The Dalí Museum in Figueres is 1 hour away, and Girona is within 30 minutes. ... more
 
Marbella Score 6.45 from 131 reviews
Roca Negra 11-13 6.45/10
Take a stroll along the palm tree-lined promenade right into the centre of the ancient town of Roses and stop off at one of the many bars and cafés and enjoy the sea-view. The beach is fantastic and ideal for sunbathing. The network of navigable canals which enable boat owners to set to sea from moorings at the bottom of their gardens make this a truly unique area. The nightlife is international and offers a wide variety of different attractions. ... more
 
Hotel Picasso Score 7.925 from 44 reviews
Platja De La Gola 7.93/10
Restaurant opening times: Breakfast: 08:30-10:30 Lunch: 13:00-16:00 Dinner: 19:30-22:30 ... more
 
Duran Hotel & Restaurant Score 8.675 from 341 reviews
Lasauca, 5 8.68/10
The hotel has 65 rooms, some of which are equipped for the handicapped. They are all decorated following the latest trends yet the contrasting colours and wooden furniture provide an elegant and relaxing atmosphere. They are modern and fully equipped, including internet access and an impeccable service. The bathrooms are large, functional and stylish. ... more
 
Nieves Mar Score 8.55 from 45 reviews
Passeig del mar, 8 8.55/10
The hotel's restaurant is open for lunches and dinners: from 13:00 until 15:30, and from 20:00 until 22:30. ... more
 
More hotels in L'estartit

Catalan Festivals and Culture: Summer Human Castle Festival 8.5 hours

Catalan Festivals and Culture: Summer Human Castle Festival

Head inland to a medieval town, famous for the wine and cava industry. While the surrounding vineyards create the impression of a dusty sleepy world, the center of this town bursts with vitality. After morning mass, the atmosphere becomes electric and the festival kicks off in full swing. Different folkloric dances, which stem from traditions that are over seven hundred years old, can be seen. The strange but stunning choreography include Giants, Big heads, Eagles, Circle Dancers and Shepherds. Where do these ritual type traditions come from? Come along and find out!

An hour later and the tension in the main town square reaches fever pitch as the Human Castle team congregates in the main square. This town is the heart and soul of this spectacular tradition and the biggest Human Castles are built at this annual festival. A sea of colored shirts steadily forms into an organized huddle of bodies. Slowly but surely, a tower emerges from the hundreds of people beneath. The strain is visible on everybody's face as maximum concentration is used by all to keep the castle stable as it grows up to ten stories high.

You might not be building Human Castles but you will have had time to build up an appetite. Next stop is a traditional Catalan restaurant, specializing in local cuisine. Sample char-grilled meats, bread with tomato and garlic and wine from a glass container with a spout, called a "Purro".

Click here for more information and Booking Details

Granada Airport Private Departure Transfer 30 minutes

Granada Airport Private Departure Transfer

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

  • 1 - 3 people
  • 4 - 6 people
  • 7 people

When making a booking, you will need to advise your flight details and your Granada city hotel details. Your transfer will be confirmed within 24 hours, subject to availability. Upon confirmation you will be provided with a travel voucher to present to the driver.

It's that easy!

Don't forget to book your Granada Airport Arrival Transfer, simply type the product code 3443GRXAPTHTL 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 City / Arrival City
  • Departure Time
  • Hotel Name
  • Hotel Address

Click here for more information and Booking Details

Barcelona Aquarium and Montjuich Fountains 8 hours

Barcelona Aquarium and Montjuich Fountains

Begin this tour in the afternoon and go through until evening! Today includes two visits to different spectacles, both related to water - Barcelona Aquarium and the Montjuich Fountains.

At Barcelona Aquarium you are about to dive into the sea depths and discover an unknown, fascinating world. A magic, mysterious world that brings you closer to its inhabitants and its most curious aspects.

A living show, changing, with some 11,000 animals and approximately 450 different species in the Mediterranean and tropical tanks, as well as the permanent displays Planeta Aqua and Explora!

Next you will have some free time at the biggest commercial and cultural center of Barcelona, The Maremagnum. It is located at the port and is the old harbor of Barcelona. For the Olympic Games of 1992 it was partly redeveloped with a modern leisure area with shops, bars, cinemas and the Barcelona Aquarium.

Next you will see the Montjuich Fountains where you can see the show of water, lights and music. Admire this magic fountain when it explodes into a spectacular display of color and music! The Montjuich Fountains or The Magic Fountain is a "must see" for any visit to Barcelona!

Click here for more information and Booking Details