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/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/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 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/3.0/  The owner of this picture is inkiboo, more information is available at http://www.flickr.com/photos/inkiboo/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 inkiboo, more information is available at http://www.flickr.com/photos/inkiboo/ 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/ 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-sa/3.0/  The owner of this picture is Henry Chen, more information is available at http://www.flickr.com/photos/henrychen/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 Henry Chen, more information is available at http://www.flickr.com/photos/henrychen/
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 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-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 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-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/

Hotels in L'estartit

Aigua Blava Score 8.75 from 154 reviews
Platja De Fornells, s/n 8.75/10
Set on the Mediterranean seafront, this hotel overlooks the beautiful bays of Fornells and Aiguablava – part of Spain’s idyllic Costa Brava coastline. The Hotel Aiguablava’s 85 rooms are spread over several small buildings surrounded by magnificent tropical gardens. Throughout the property you can admire the fantastic views over the crystal-clear waters of the Mediterranean Sea. When not relaxing on the secluded local beaches you can take a dip in the hotel’s outdoor swimming pool or sunbathe on the sun loungers. There is also a tennis court and children’s play area for more active pastimes. At the hotel restaurant you can try some of the local specialities whilst taking in the panoramic views of the sea, coves, beaches and forests. You can even choose to dine on the green lawns which surround the hotel. ... more
 
Hotel Reimar Score 7.25 from 44 reviews
Paseo Torre Valentina s/n 7.25/10
This family-run hotel is located in a beautiful, quiet corner of Palomos Bay on the Costa Brava, overlooking the clear waters of the Mediterranean Sea. Situated right on sea front the Reimar boasts a terrace with panoramic views over the bay. The fine sandy beaches and tranquil shallow waters are ideal for families with children. You can also walk along the coastal path to find several secluded coves and more sandy beaches. Those looking for an active time can head to the hotel’s own tennis courts. You will also find a diving school and windsurfing club available on the beach. ... more
 
Hotel S´Aguarda Score 7.65 from 9 reviews
Carretera Port-Lligat, 30 7.65/10
Hotel S’Aguarda is situated up on a hill in Cadaqués, with wonderful sea views. It has a swimming pool-solarium, a free Wi-Fi area and free private parking. All rooms at S’Aguarda include a private terrace and satellite TV. They all have a modern and elegant bathroom, with a bath, hairdryer and bidet. It is a short walk to the beach and to central Cadaqués. The Dalí Museum-House is within walking distance, and the Cap de Creus Natural Park is a short drive away. Buffet breakfast is served at S’Aguarda’s restaurant. The dining room offers beautiful views over the surroundings and has large windows. ... more
 
 Apartamentos Centremar Score 0 from 0 reviews
De la Devesa nº 2 0/10
The Centremar Apartments are 500 metres from the beach, in the Costa Brava resort of L’Estartit. The complex offers free access to its outdoor swimming pool, sun terrace and fitness centre. The apartments are near the centre of Estartit. There are many shops and bars nearby. The area is ideal for watersports. The Medes Islands are a popular diving location. Apartments have a comfortable living room, with satellite TV and a sofa bed. There is an open kitchen, with a dishwasher and washing machine. All apartments have a terrace, with views of the pool or street. The Centremar complex has a supermarket and a pizzeria. There is also a sauna and a games room. ... more
 
 La Torre Score 8.575 from 7 reviews
Passeig de la Torre, 26-28 8.58/10
Relax with an after-dinner drink from the hotel bar which is open all day. The hotel restaurant is open every day. ... more
 
More hotels in L'estartit

Shopping at Teguise Markets 4 - 5 hours

Shopping at Teguise Markets

The Teguise Market is a must when you are visiting Lanzarote, as it is a unique experience of color, traditional architecture, cultural mixture and local crafts.

You can easily find handicrafts from different places such as Africa and Spain, as well as typical products of the Canary Islands like canary moho sauce and fresh goat cheese. Enjoy the folk music performed by local groups as you browse the stalls for the object of your desire.

Also you can find quaint cafes, an art gallery, souvenir shops, exotic historic buildings and many places filled with charming old times reminiscences.

Click here for more information and Booking Details


Full Day Tour to Tenerife from Gran Canaria 14.5 hours

Volcanic landscape of Mt Teide, Tenerife

You will collected from your Gran Caraia hotel and transferred to the "Millenium II" ferry station in Las Palmas.

Upon arrival at Tenerife you will have a panoramic tour of the capital before departing to the center of the island.

Your tour will include La Esperanza, Los Miradores, Canadas del Teide, Orotava Valley and the Valley of Ucanca by Mount Teide which is the highest mountain and volcano in Spain.

Your tour includes lunch which will consist of salad, grilled meats, vegetable, potatoes and cake for dessert. Tea coffee, soft drinks, wine and beer are served with lunch.

Your final stop will be in Puerto de la Cruz where you have free time for shopping or to simply relax and stroll along the streets.

Click here for more information and Booking Details


Fuerteventura Airport Private Departure Transfer 10 - 50 minutes

Fuerteventura Airport

Travel from your Fuerteventura hotel to Fuerteventura International Airport. 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
  • 5 to 8 people

When making a booking, you will need to advise your flight details and your Fuerteventura hotel details. Your transfer will be confirmed instantaneously and you will be provided with a travel voucher to present to the driver. 24 - 48 hours prior to your transfer, you will be required to call the supplier directly (the contact number will be provided on your travel voucher) to reconfirm exact pick up times and places.

It's that easy!

Don't forget to book your Fuerteventura Airport Arrival Transfer, simply type the product code 3042FUEAPTHTL into the Keyword Box.

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

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

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear