Restaurante Millenium
Restaurante en Montblanc, Tarragona
Montblanc, Tarragona
En estos momentos no está disponible la información de Restaurante Millenium.
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(41.373757)) * COS(RADIANS(wp_postmeta.meta_value - 1.164436)) + SIN(RADIANS(mt1.meta_value)) * SIN(RADIANS(41.373757)), 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 (59)
) AND (
( wp_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-0.63222902043718' AND '2.9611008968372' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '39.576982929504' AND '43.172824293573' )
) 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
Restaurante Viaurelia
Restaurante
RESTAURANTE FONDA DEL CASTLÁ
Restaurante
Restaurant Els Fogons de Vallclara
Restaurante
Cal Menut Restaurant
Restaurante
Can Japet km0
Restaurante
La Redolta
Restaurante
DARWING BEACH DELTANATUR
Chiringuito
Can Casanova
Restaurante
Restaurant Masía Cavall
Restaurante
Restaurant Lo Pati d’Agustí
Restaurante
Restaurant Lluisa del Peretó
Restaurante
Restaurante Casa Masover
Restaurante
Restaurante Roch
Restaurante
Restaurante la Closa
Restaurante
Bar de la Plaça y Restaurante Mallador
Bar y Restaurante
RESTAURANT SANT MIQUEL
Restaurant Rurals
Lugares de interés
Semana medieval de Montblanc
La semana que rodea el 23 de
abril, día de San Jordi, se celebra en Montblanc la Semana M...
Fiesta popular
Ruta del Cister
Los Monasterios de Santes Creus, Vallbona de les Monges, y Santa María de Poblet, definen...
Rutas culturales