SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (886)
AND
tt1.term_taxonomy_id IN (2161,2165,2290,2292,2294,2296,2298,2300,2302,2304,2306,2330,2460,2485)
) AND (
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '1' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '0' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '' )
) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','listing','popup','acf-field-group','cookielawinfo','g','comarcas' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','listing','popup','acf-field-group','cookielawinfo','g','comarcas' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, RAND() DESC LIMIT 0, 10
Share
What to See in Algeciras
Do you want to check what to see in Algeciras and the outskirts? Find out with TUDESTINO all the activities you can do in Algeciras and the places to visit with our best recommendations. The only specialised website in the Province of Cádiz.
Located between the Atlantic ocean and the Mediterranean sea, El Estrecho Natural Park has unique characteristics. This is due to the extreme climatic conditions to which it is subjected, presenting a very particular fauna and flora. The east and west winds, so characteristic of the Strait, have set up dunes, white and fine sand beaches,...
The Archaeological Complex of the Medieval Walls houses the remains of a defensive complex built in the late 13th century. It happened when Algeciras was under Marinid domain. In 1379, the Nasrid Sultan Muhammad V carried out the destruction of the city and the walls. Then, the city was uninhabited until the arrival of new...
The San Garcia Fort (Fuerte de San García), located in the Parque del Centenario in Algeciras, is a valuable example of defensive architecture from the 18th century. Many facts led to the proliferation of defensive buildings at the Bay. Among them, there are two that stand out. The presence of the constant danger that caused...
Playa de Getares Beach is a city beach in Algeciras (Province of Cádiz). It is surrounded by mountains and vegetation. It has several services that make it very comfortable to use. Its name comes from a nearby Roman salting factory called Caetaria, where it would derive to Cetariis, adapted to Arabic as Xetares. On this...
Paseo de la Cornisa (“La Cornisa Promenade”) is a spectacular pedestrian path surrounded by green areas that runs along the seafront of Algeciras. Here you can find the headquarters of the Chamber of Commerce Industry and Navigation of Gibraltar. Also, sports facilities, schools or the remains of the tower popularly known as “Del Polvorín” or...
Playa El Rinconcillo is probably the most recommended beach in Algeciras. This is due to its great length and the availability of equipment and services. It is the most frequented one by locals. The beach has two distinct areas. The first one corresponds to the southern zone, from the small cove of La Concha to...
With 170,000 hectares, Los Alcornocales Natural Park is crowned as the best preserved nature treasure in the province of Cádiz. Its enormous extension covers 16 municipalities of Cadiz; such as Arcos de la Frontera, Tarifa, Medina Sidonia, Ubrique, Los Barrios, Jimena de la Frontera and Jerez de la Frontera. Its name refers to the park’s...
Playa de El Chinarral, in Algeciras, is located between the cliffs of Punta de San García and Punta del Rodeo. On this beach you will find several reefs stand out a few metres from the coast, known as las Hermanas. This makes it a dangerous place for navigation. Due to its small size, El Chinarral...
Río Palmones Marshland is an interesting place formed at the mouth of the Palmones River. It is a protected area that is located between Algeciras and Los Barrios. This place extends over 113 hectares. It was declared Natural space in 1989. The biological interest lies in being a stopping point for a large number of...
The Interpretive Centre of Al-Andalus Culture (Centro de Interpretación de la Cultura Andalusí), in Algeciras, aims to spread the medieval history of the city. In its facilities the importance of the town as a doorway to the Al-Andalus is perceived, as well as its great political and military...
Load more (8 of 18)
More Filter
Sorry! No more filter found for current selections
Cookies are important to you, they influence your browsing experience. We use analytical, personalization and advertising cookies (our own) to make profiles based on browsing habits and show you personalized content. You can consult our Cookies Policy. By clicking on "Accept all ", you consent to all cookies being saved on your device or you can configure or reject their use by clicking on "Settings ". Cookies PolicySettingsAccept all
Privacy & Cookies Policy
Policy Summary
This website uses cookies to improve your experience while browsing. We use cookies that are classified as necessary. These are stored in your browser and are essential for the basic operation of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt out of receiving these cookies, but this choice may affect your browsing experience.
