Las habitaciones varían de tamaño debido a la antigí¼edad del edificio. Están muy bien decoradas en un estilo tradicional con vigas de madera que proporcionan un ambiente rústico ...
xxxselect id, es, asc_3, asc_6, geotype_id from keops.geoplaces where
id and asc_6=497865879 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
(
[0] => Array
(
[id] => 498077881
[es] => Iglesia y Monasterio del Sacrificio de la Virgen
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 23
)
[1] => Array
(
[id] => 498077879
[es] => Catedral de San Nicolás
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 23
)
[2] => Array
(
[id] => 498077885
[es] => Cervecería Budvar
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 8
)
[3] => Array
(
[id] => 498077883
[es] => Museo del Sur de Bohemia
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 30
)
[4] => Array
(
[id] => 498077884
[es] => Museo del Ferrocarril
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 30
)
[5] => Array
(
[id] => 498077880
[es] => Torre Rebenstejin
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 8
)
[6] => Array
(
[id] => 498077877
[es] => Plaza de Otakara II
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 8
)
[7] => Array
(
[id] => 498077882
[es] => Museo de la Motocicleta
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 30
)
[8] => Array
(
[id] => 498077878
[es] => Torre Negra
[asc_3] => 531
[asc_6] => 497865879
[geotype_id] => 8
)
)