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'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/home/scubish/scubish.com/www/location.php on line 87
scubish.com: Scuba diving L'estartit - Spain - Europe

WORLD EUROPE SPAIN L'ESTARTIT
L'estartit


Diveshops in 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 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 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 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/3.0/  The owner of this picture is acme, more information is available at http://www.flickr.com/photos/acme/
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 ippei + janine, more information is available at http://www.flickr.com/photos/ippei-janine/ 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 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-nd/3.0/  The owner of this picture is Mozzer502, more information is available at http://www.flickr.com/photos/andy_morris/

Hotels in L'estartit
Hotel Ramblamar Score 7.725 from 254 reviews
Avenida de Rhode, 153 7.73/10
In addition to the facilities already mentioned, this hotel has free Wi-Fi internet connection. ... more
 
Apartamentos Miami Score 7.9 from 101 reviews
Devesas, 23-25 7.9/10
Each apartment comes with one or 2 bedrooms (individual beds) and a lounge-diner with sofa bed. The kitchen includes a microwave, oven, hotplates, fridge freezer and washing machine, and opens onto the dining area. The bathroom comes with a shower bath combination. Each apartment also opens onto a furnished terrace or balcony and the 2-bedroom apartments have air conditioning. ... more
 
Apartamentos Les Palmeres Score 8.25 from 34 reviews
Avinguda Verona Terol, 23 8.25/10
Close to the Palmeres you can try out a range of water sports, including diving. The fantastic local landscape is popular for walking, cycling and golf. For a cultural day out, take the 30-minute journey to the beautiful, ancient city of Girona. ... more
 
El Pati Score 8.5 from 3 reviews
Hospital, 7 8.5/10
Housed in a charming and lovingly restored rural house dating from the 18th century, El Pati hotel is situated in a small village in the beautiful L’Empordà area of Catalonia. El Pati has 5 rooms, each of which boasts classical and very attractive interior decor. The rooms are spacious, with lots of natural light, and where you can enjoy tranquillity and rest. Surrounded by lovely gardens, you can relax in a natural setting, or lie back and soak up the sun on hot days. You can also sit back and sip a cold drink on the terrace of the restaurant and bar. Located just a short distance from Pals, Begur and Palafrugell this is ideal accommodation for visiting this stunning stretch of the Costa Brava coastline. ... more
 
Hostal Novel Risech Score 7.225 from 496 reviews
Avenida de Rhode, 185 7.23/10
Wi-Fi internet access is available in all communal areas of the hotel. ... more
 
More hotels in L'estartit

Private Day Tour of Granada's Tropical Coast and Caves of Nerja 10 hours

Caves of Nerja, Spain

The Granadine Coast boasts a mild climate with a temperature of 18 degrees centigrade, thus enabling the farming of custard apples, papaya, avocado, sugar cane. Motril is an important fishing and commercial port serving the region.

Turning in the direction towards Malaga, you will come across Salobrena, a white town perched on a hill and crowned by an ancient Arab Castle from where the panoramic views of the surrounding fertile plain and beaches can be admired.

Almunecar is the tourist haven along the coast, ancient Sexi of the Phoencians, and boasts important monuments: the Majuelo Park, the Castle of San Miguel and a beautiful old quarter where lunch will be served.

The Caves of Nerja are visited in the afternoon with their extensive grottoes and archaeological remains. The caves are a popular venue for concerts and classical music performances.

Click here for more information and Booking Details


Fuerteventura's Premium Cruise to Los Lobos 3.5 - 5 hours

Fuerteventura's Premium Cruise to Los Lobos

This is a cruise for adults only, no children 16 years or under are permitted.

After being met at your hotel or meeting point, you will be transferred to the harbor in Corralejo where you will board the Catamaran.

While sailing you can help the crew with the sailing or have a go at being the captain at the helm and steer the boat.

The boat will anchor off the desert island of Los Lobos, just off the north-east tip of Fuerteventura). At this point, steps are lowered into the water for you to be able to get in and out to swim. There is snorkeling equipment provided and a spin around the bay on a jet-ski is included.

Lunch is served while you are anchored at Los Lobos. This consists of pasta with a tomato and tuna sauce (tomato and vegetable for those who don't like tuna) cheese, bread and butter and salad.

Throughout the sailing there is a free bar and drinks are unlimited. The drinks available on board are red, white and rose wines, beer, coca cola, diet coke, fanta orange, fanta lemon, sprite, still water and sparkling water. You will also receive a champagne cocktail.

Once it's time to set sail back to Fuerteventura, again, you may join in and help the crew or just sit back, relax and let the crew bring drinks to you. On arrival back in Fuerteventura, you will be transferred back to your hotel.

This particular boat has been featured on Wish You Were Here, GMTV, Sky Travel channel and recently featured in OK magazine (Kian from Westlife said it was the only way to travel on the sea).

Click here for more information and Booking Details


Granada Airport Private Arrival Transfer 30 minutes

Granada Airport Private Arrival Transfer

Travel from Granada Airport to your Granada city hotel. 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 Departure Transfer, simply type the product code 3443GRXHTLAPT 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
  • Arrival Time
  • Hotel Name
  • Hotel Address

Click here for more information and Booking Details




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

© 2009 D4DR Media | All Rights Reserved | Terms and Conditions | Scubish.com | Copyright Notices