Adosadas Lambda
Casas en Almuñécar, Granada
Almuñécar,
En estos momentos no está disponible la información de Adosadas Lambda.
A continuación te mostramos resultados cercanos:
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, ROUND(111.111 * DEGREES(ACOS(LEAST(COS(RADIANS(mt1.meta_value)) * COS(RADIANS(36.738667)) * COS(RADIANS(wp_postmeta.meta_value - -3.671675)) + SIN(RADIANS(mt1.meta_value)) * SIN(RADIANS(36.738667)), 1.0)))) AS distance_in_km FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 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_term_relationships.term_taxonomy_id IN (5,7,8,9,10)
) AND (
( wp_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-5.4683400362372' AND '-1.8750101189628' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '34.933788400348' AND '38.536294833073' )
) AND wp_posts.post_type = 'estate_property' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY distance_in_km ASC, wp_posts.post_date DESC LIMIT 0, 16
APARTAMENTO 1ª LINEA PLAYA
Desde 60 €
/ noche
4

Casa Rural
Casa Mariana
Desde 72 €
/ noche
14

Casa Rural
Castillo del Mar
Desde 36 €
/ noche
22

Apartamento
Casa Yeray
Desde 58 €
/ noche
4

Apartamentos
CORTIJO DE LA LUNA
Desde 60 €
/ noche
14

Cortijo Rural
La Herradura

Camping
Hotel Salambina

Hotel
LA CHARCA
Desde 180 €
/ noche
12

Casa Rural
Villa Alhambra
Desde 43 €
/ noche
6

Otro
La Casa del Sol
Desde 60 €
/ noche
9

Casa Rural
CONJUNTO RURAL LAS ROSAS
Desde 90 €
/ noche
6

Casa Rural
Don Cactus

Camping y Bungalows
Hotel los Caracoles

Hotel Rural
Casa rural La Ventera
Desde 55 €
/ noche
8

Casa Rural
HOTEL NUEVO MANOLETE

Hotel **
Venta de los Herradores
Desde 80 €
/ noche
4

Complejo Rural
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, ROUND(111.111 * DEGREES(ACOS(LEAST(COS(RADIANS(mt1.meta_value)) * COS(RADIANS(36.738667)) * COS(RADIANS(wp_postmeta.meta_value - -3.671675)) + SIN(RADIANS(mt1.meta_value)) * SIN(RADIANS(36.738667)), 1.0)))) AS distance_in_km 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_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-5.4683400362372' AND '-1.8750101189628' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '34.933788400348' AND '38.536294833073' )
) AND wp_posts.post_type = 'interesting_place' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY distance_in_km ASC, wp_posts.post_modified DESC LIMIT 0, 2
Lugares de interés
Estación recreativa Puerto de la Rag...
La Estación Recreativa Puerto de la Ragua es un lugar
idílico para los amantes del depor...

Rutas Naturales
Paseo al mirador “el fin del mundo”...
Un precioso paseo desde la Almazara de apr una hora y media a dos horas
Es un paseo que...

Lugar de interes