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 (19594)
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 Seville City
What to see in Seville, Spain? Must-See tourist attractions in Seville. Seville Cathedral, Alcazar in Seville… Reviews, photos and more on Tudestino.
If you are thinking about what to see in Seville (Spain), here on TUDESTINO we propose a wide list of cultural spots and natural spaces that you should visit and that will surprise you while you enjoy unique moments and experiences.
You will find all the information of the main cultural and natural attractions of Seville. Its monuments are thousands of years old and places have a unique natural diversity.
On a cultural level, the city of Seville has a spectacular collection of historical buildings, museums and exhibition centres, religious buildings, monuments, theatres and unique spots, which will delight lovers of culture and history. Reflection of a past of splendour and of having been thousands of years populated by different civilisations.
On the other hand, you cannot miss the numerous charming villages of the province, as well as its natural monuments.
We have compiled all these spots for you, so you can find what to see during your stay in Seville on TUDESTINO.
The General Archive of the Indies (Archivo General de Indias) in Seville, Spain was founded by King Charles III of Spain in 1785. He did so with the aim of having control over all documents in the administration of the Spanish colonies in one place. The Casa Lonja de Mercaderes, from the sixteenth century, was...
Capilla del Cachorro, also known as Basílica del Cristo de la Expiración, Basílica del Cachorro or Basílica del Patrocinio, is located in Seville‘s Triana district (Andalusia, Spain). This temple consists of two chapels attached to each other due to their small size. The first chapel dates from the seventeenth century, while the second one is...
The Seville Cathedral, or the Cathedral of Saint Mary of the See, is considered one of the largest Gothic cathedrals in the world. Only the St. Peter’s Basilica and the St. Paul’s Outside the Walls are larger. Its area covers more than 11,500 sqm. The cathedral length is 115 metres, the width is more than...
The Church of Santa Maria de las Nieves de Sevilla, known as Church of Santa Maria la Blanca, is located in the old town, on Santa Maria la Blanca Street. It is the Holy See of the Brotherhood of the Rosario de Nuestra Señora de las Nieves. It was originally a mosque and a synagogue....
Jardines de la Buhaira (“Buhaira Gardens”) are a safe bet if you are looking for a moment of peace in Seville (Andalusia, Spain). These gardens, located in Seville’s Nervión district, are divided into two areas. First of all, the Jardín del Palacio (“Palace Garden”), with a fountain in the middle of a little square, two...
Calle Sierpes (Sierpes Street) is an iconic shopping street in Seville (Spain), one of the busiest in the city. It is a pedestrian street since the nineteenth century, so its great commercial activity makes it very attractive. Tourists and Sevilians go down the street looking for shops or tapas bars. In summer, in order to...
The Capilla de los Marineros (literally, “Chapel of the Sailors”) is a Catholic church located in the neighbourhood of Triana, in Seville, Spain. It is just two minutes walk from the Church of Santa Ana. This is the Holy See of the Brotherhood of Esperanza de Triana. The image of Nuestra Señora de la Esperanza...
The building of the Hospital de las Cinco Llagas de Nuestro Redentor (literally “Five Wounds of Our Redeemer Hospital”), also known as Hospital de la Sangre (“Hospital of Blood”), is located in the Sevillian neighbourhood of La Macarena. It worked as a hospital until 1972 and today is the headquarters of the Andalusian Parliament since...
The Basilica of Jesus del Gran Poder is located in Seville’s San Lorenzo district. This Catholic temple is built next to its brotherhood and the parish of San Lorenzo, from the thirteenth century. These buildings are located in Plaza de San Lorenzo, near the Alameda de Hercules. Its facade has neo-baroque style. The interior is...
Torre del Oro, very close to the Plaza de Toros de la Real Maestranza Bullring, served at the time as watchtower of Seville against attacks perpetrated from the Guadalquivir river. It was part of the city wall and was connected to the Torre de la Plata. It belonged to the defense of the Fortress of...
Load more (58 of 68)
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.
