Valorar y escribir opinión de NAKEL SPORT NATURE
Turismo activo en Ribadesella, Asturias
Ribadesella, Asturias
En estos momentos no está disponible la información de NAKEL SPORT NATURE.
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(43.463326)) * COS(RADIANS(wp_postmeta.meta_value - -5.065575)) + SIN(RADIANS(mt1.meta_value)) * SIN(RADIANS(43.463326)), 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 (11,49,55)
) AND (
( wp_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-6.8622395807372' AND '-3.2689096634628' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '41.653696989988' AND '45.262918723079' )
) 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
Escuela de Surf Ribadesella
Escuela de Surf
DRAGON BOAT RIBADESELLA
Canoas
TURAVENTURA
Turismo activo
Escuela de Surf Marejada
Escuela de Surf
K2 AVENTURA
Turismo Activo
Fym Aventura
Canoas
Wadi Aventura
Turismo activo
SELLASTUR
Turismo activo
DESCENSOS EN CANOAS JAIRE
Turismo activo
Ven a Picos
Actividad
LOS CAUCES MULTIAVENTURA
Turismo activo
LA RUTA DE PEPIN
Culturales/Deportivas
Karting Soto de Dueñas
Karting
TRAVESIASTUR
Multiaventura
Zauber Rutes
Rutas a Caballo
TRAVEL LLANES
Agencia