Lugares de interés cerca de MUSEO ABEJAS DEL VALLE
Museo de Abejas en Poyales del Hoyo, Ávila
Poyales del Hoyo, Ávila
En estos momentos no está disponible la información de MUSEO ABEJAS DEL VALLE.
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(40.171226)) * COS(RADIANS(wp_postmeta.meta_value - -5.174495)) + SIN(RADIANS(mt1.meta_value)) * SIN(RADIANS(40.171226)), 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.9711598826372' AND '-3.3778299653628' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '38.361180361323' AND '41.971018133289' )
) 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
TALLER ALFACER
Alfarería y cerámica
Vivetietar
Descenso en Canoas
GREDOS ECUESTRE, CABALLOS PARA DISFRUTAR
Rutas a Caballo
Yeguada La Isla
Paseos a Caballo
Rutas a Caballo – Caballos La Vera
Rutas a Caballo
Deportes y Aventuras La Isla
Deportes y Aventuras
Paintball Piedralaves C.B
Paintball
Carchén Agroturismo Técnico
Formación y asesoría
Autocaravaning cazalegas “turismo-ocio”
Multiaventura
Campamento Los 3 Picos de la Vera
Campamento
Paintball Navaluenga
Paintball
Pelahustán Paintball
Paintball
Buses – Taxis – Javier Martín Fernández
Rutas vacacionales
Paintball Sotillo
Paintball
Valleaventura
Rutas 4X4
Paintball El Fresno
Paintball