SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND wp_posts.post_author IN (5150) AND (
( wp_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-9.2711750170944' AND '-5.67784509982' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '35.436927784503' AND '39.062896608407' )
) AND wp_posts.post_type = 'interesting_place' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
El propietario no tiene lugares de interés publicados en este momento..
¡Anímale a que transmita información a todos los viajeros para conocer su zona!
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND wp_posts.post_author NOT IN (5150) AND (
( wp_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-9.2711750170944' AND '-5.67784509982' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '35.436927784503' AND '39.062896608407' )
) AND wp_posts.post_type = 'interesting_place' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
Lugares de interés cercanos a Casas do Palheiro Velho
Castillo Trujillo

Monumento Histórico
Balneario romano de Alange (Badajoz)
Alange,
Tierra de Mérida - Vegas Bajas

Termas Naturales
Marismas de Isla Cristina

Paraje natural
Castillo de Guzmán el Bueno

Cultura y tradiciones
Gruta de las Maravillas

Cueva Turística
Peña de Arias Montano

Mirador Natural
Mezquita islámica de Almonaster la Real

Mezquita
Los Barruecos

Rutas Naturales
Conjunto Arqueológico de Itálica

Ciudad romana
Parque Nacional de Doñana

Rutas Naturales
Conjunto Arqueológico Baelo Claudia

Ciudad romana
Castillo de Las Siete Torres

Castillo Medieval