This hotel is located in the beautiful Camprodon Valley, in the Oriental Pyrenees. Guests can reach Girona in around an hour and Barcelona within an hour and a half drive by car. T ...
xxxselect id, es, asc_3, asc_6, geotype_id from keops.geoplaces where id and asc_6=497915621 and important_6=1 and (geotype_id!=9 and geotype_id!=153 and geotype_id!=154 and geotype_id!=155) order by important_1 DESC, important_2 desc, important_3 desc, rand() limit 30 Array ( )