
The building housing the hotel has been completely restored, and the 38-room hotel was built in 1984. The hotel was renovated in 2008. Amenities include a lobby, hotel safe, lift a ...
select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497875050 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by en ascArray ( )
Array ( [0] => Array ( [id] => 497882396 [en] => Aachen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137558 [distance] => 290.906518693633 ) [1] => Array ( [id] => 497860096 [en] => Augsburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137540 [distance] => 174.184791751951 ) [2] => Array ( [id] => 497885435 [en] => Berlin [important_3] => 1 [asc_3] => 536 [asc_4] => 135381 [asc_5] => 137526 [distance] => 403.738550956977 ) [3] => Array ( [id] => 497884833 [en] => Bielefeld [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137522 [distance] => 267.472343919073 ) [4] => Array ( [id] => 497884054 [en] => Bochum [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137517 [distance] => 267.282641610915 ) [5] => Array ( [id] => 497882258 [en] => Bonn [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137515 [distance] => 224.070291509715 ) [6] => Array ( [id] => 497884125 [en] => Bottrop [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137512 [distance] => 284.749844284885 ) [7] => Array ( [id] => 497886019 [en] => Bremen [important_3] => 1 [asc_3] => 536 [asc_4] => 135379 [asc_5] => 137508 [distance] => 374.335398342628 ) [8] => Array ( [id] => 497886561 [en] => Bremerhaven [important_3] => 1 [asc_3] => 536 [asc_4] => 135379 [asc_5] => 137507 [distance] => 428.644485295075 ) [9] => Array ( [id] => 497885135 [en] => Brunswick [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137510 [distance] => 280.342198899326 ) [10] => Array ( [id] => 497882670 [en] => Chemnitz [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137502 [distance] => 245.409077350410 ) [11] => Array ( [id] => 497882972 [en] => Cologne [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137380 [distance] => 243.947586233916 ) [12] => Array ( [id] => 497875879 [en] => Darmstadt [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137492 [distance] => 89.506451852969 ) [13] => Array ( [id] => 497884107 [en] => Dortmund [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137477 [distance] => 256.167808719738 ) [14] => Array ( [id] => 497883250 [en] => Dresden [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137476 [distance] => 307.739794740202 ) [15] => Array ( [id] => 497883967 [en] => Duisburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137475 [distance] => 287.087936946939 ) [16] => Array ( [id] => 497883634 [en] => Dusseldorf [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137473 [distance] => 272.161633979159 ) [17] => Array ( [id] => 497883100 [en] => Erfurt [important_3] => 1 [asc_3] => 536 [asc_4] => 135368 [asc_5] => 137461 [distance] => 157.310896634350 ) [18] => Array ( [id] => 497884026 [en] => Essen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137458 [distance] => 276.691203767235 ) [19] => Array ( [id] => 497878130 [en] => Frankfurt [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137451 [distance] => 93.807738208762 ) [20] => Array ( [id] => 497857323 [en] => Freiburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137449 [distance] => 248.257654215117 ) [21] => Array ( [id] => 497871764 [en] => Furth [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137442 [distance] => 85.956701300677 ) [22] => Array ( [id] => 497884106 [en] => Gelsenkirchen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137440 [distance] => 274.090752944782 ) [23] => Array ( [id] => 497884126 [en] => Gottingen [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137431 [distance] => 194.601696735089 ) [24] => Array ( [id] => 497883852 [en] => Hagen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137423 [distance] => 245.851989078473 ) [25] => Array ( [id] => 497884072 [en] => Halle [important_3] => 1 [asc_3] => 536 [asc_4] => 135370 [asc_5] => 137421 [distance] => 239.250833922642 ) [26] => Array ( [id] => 497886566 [en] => Hamburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135378 [asc_5] => 137420 [distance] => 420.707588705830 ) [27] => Array ( [id] => 497884338 [en] => Hamm [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137418 [distance] => 256.095310732472 ) [28] => Array ( [id] => 497885289 [en] => Hanover [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137417 [distance] => 291.504074819603 ) [29] => Array ( [id] => 497871030 [en] => Heidelberg [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137413 [distance] => 94.636639866621 ) [30] => Array ( [id] => 497867712 [en] => Heilbronn [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137411 [distance] => 85.667588349032 ) [31] => Array ( [id] => 497884148 [en] => Herne [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137407 [distance] => 271.466996183747 ) [32] => Array ( [id] => 497863649 [en] => Ingolstadt [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137394 [distance] => 158.910779884202 ) [33] => Array ( [id] => 497866051 [en] => Karlsruhe [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137389 [distance] => 137.817564147286 ) [34] => Array ( [id] => 497883777 [en] => Kassel [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137388 [distance] => 173.547121507836 ) [35] => Array ( [id] => 497887849 [en] => Kiel [important_3] => 1 [asc_3] => 536 [asc_4] => 135369 [asc_5] => 137384 [distance] => 505.065281075434 ) [36] => Array ( [id] => 497883796 [en] => Krefeld [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137377 [distance] => 291.569168441835 ) [37] => Array ( [id] => 497883839 [en] => Leipzig [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137348 [distance] => 249.273792270256 ) [38] => Array ( [id] => 497883209 [en] => Leverkusen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137346 [distance] => 248.092730702139 ) [39] => Array ( [id] => 497887168 [en] => Lubeck [important_3] => 1 [asc_3] => 536 [asc_4] => 135369 [asc_5] => 137339 [distance] => 457.904643533139 ) [40] => Array ( [id] => 497871753 [en] => Ludwigshafen [important_3] => 1 [asc_3] => 536 [asc_4] => 135373 [asc_5] => 137336 [distance] => 108.938660738548 ) [41] => Array ( [id] => 497884967 [en] => Magdeburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135370 [asc_5] => 137333 [distance] => 288.297740104644 ) [42] => Array ( [id] => 497877176 [en] => Mainz [important_3] => 1 [asc_3] => 536 [asc_4] => 135373 [asc_5] => 137328 [distance] => 118.595418293876 ) [43] => Array ( [id] => 497871953 [en] => Mannheim [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137326 [distance] => 106.191147926309 ) [44] => Array ( [id] => 497883528 [en] => Monchengladbach [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137309 [distance] => 291.220206147032 ) [45] => Array ( [id] => 497883968 [en] => Mulheim [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137306 [distance] => 281.163438238267 ) [46] => Array ( [id] => 497858364 [en] => Munich [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137305 [distance] => 223.487919080123 ) [47] => Array ( [id] => 497884752 [en] => Munster [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137304 [distance] => 289.627523439508 ) [48] => Array ( [id] => 497883529 [en] => Neuss [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137296 [distance] => 275.372003841941 ) [49] => Array ( [id] => 497871389 [en] => Nuremberg [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137283 [distance] => 91.927788065440 ) [50] => Array ( [id] => 497884025 [en] => Oberhausen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137279 [distance] => 284.016082562939 ) [51] => Array ( [id] => 497877992 [en] => Offenbach [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137273 [distance] => 87.035630780596 ) [52] => Array ( [id] => 497886064 [en] => Oldenburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137270 [distance] => 392.129400251327 ) [53] => Array ( [id] => 497885145 [en] => Osnabruck [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137267 [distance] => 305.989954236643 ) [54] => Array ( [id] => 497884410 [en] => Paderborn [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137259 [distance] => 230.126057437183 ) [55] => Array ( [id] => 497864831 [en] => Pforzheim [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137254 [distance] => 131.247776079398 ) [56] => Array ( [id] => 497885301 [en] => Potsdam [important_3] => 1 [asc_3] => 536 [asc_4] => 135380 [asc_5] => 137249 [distance] => 366.661889698970 ) [57] => Array ( [id] => 497866250 [en] => Ratisbon [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137241 [distance] => 182.138395931935 ) [58] => Array ( [id] => 497884256 [en] => Recklinghausen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137243 [distance] => 277.990234413690 ) [59] => Array ( [id] => 497883498 [en] => Remscheid [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137240 [distance] => 245.853205649001 ) [60] => Array ( [id] => 497861193 [en] => Reutlingen [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137237 [distance] => 151.487970733083 ) [61] => Array ( [id] => 497887542 [en] => Rostock [important_3] => 1 [asc_3] => 536 [asc_4] => 135376 [asc_5] => 137226 [distance] => 502.745718535101 ) [62] => Array ( [id] => 497869051 [en] => Saarbrucken [important_3] => 1 [asc_3] => 536 [asc_4] => 135372 [asc_5] => 137188 [distance] => 218.164485760129 ) [63] => Array ( [id] => 497883497 [en] => Solingen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137195 [distance] => 253.037558368633 ) [64] => Array ( [id] => 497863812 [en] => Stuttgart [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137178 [distance] => 120.918019079731 ) [65] => Array ( [id] => 497860494 [en] => Ulm [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137163 [distance] => 153.581080790926 ) [66] => Array ( [id] => 497877842 [en] => Wiesbaden [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137137 [distance] => 122.716351645290 ) [67] => Array ( [id] => 497885336 [en] => Wolfsburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137131 [distance] => 301.270093100342 ) [68] => Array ( [id] => 497883676 [en] => Wuppertal [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137128 [distance] => 251.990140315367 ) [69] => Array ( [id] => 497875224 [en] => Wurzburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137127 [distance] => 4.847184837249 ) [testArray] => test )