select  other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where 
city_id=497881934 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] => 280.359268216735
        )

    [1] => Array
        (
            [id] => 497860096
            [en] => Augsburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137540
            [distance] => 263.575722727526
        )

    [2] => Array
        (
            [id] => 497885435
            [en] => Berlin
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135381
            [asc_5] => 137526
            [distance] => 323.589498444319
        )

    [3] => Array
        (
            [id] => 497884833
            [en] => Bielefeld
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137522
            [distance] => 185.203636480533
        )

    [4] => Array
        (
            [id] => 497884054
            [en] => Bochum
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137517
            [distance] => 219.778748153349
        )

    [5] => Array
        (
            [id] => 497882258
            [en] => Bonn
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137515
            [distance] => 209.255070139823
        )

    [6] => Array
        (
            [id] => 497884125
            [en] => Bottrop
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137512
            [distance] => 239.163308232813
        )

    [7] => Array
        (
            [id] => 497886019
            [en] => Bremen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135379
            [asc_5] => 137508
            [distance] => 281.567799142995
        )

    [8] => Array
        (
            [id] => 497886561
            [en] => Bremerhaven
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135379
            [asc_5] => 137507
            [distance] => 335.981091179961
        )

    [9] => Array
        (
            [id] => 497885135
            [en] => Brunswick
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135375
            [asc_5] => 137510
            [distance] => 180.493332185897
        )

    [10] => Array
        (
            [id] => 497882670
            [en] => Chemnitz
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135371
            [asc_5] => 137502
            [distance] => 201.272699358720
        )

    [11] => Array
        (
            [id] => 497882972
            [en] => Cologne
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137380
            [distance] => 220.002388250971
        )

    [12] => Array
        (
            [id] => 497875879
            [en] => Darmstadt
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135377
            [asc_5] => 137492
            [distance] => 135.053735355755
        )

    [13] => Array
        (
            [id] => 497884107
            [en] => Dortmund
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137477
            [distance] => 203.554235830833
        )

    [14] => Array
        (
            [id] => 497883250
            [en] => Dresden
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135371
            [asc_5] => 137476
            [distance] => 260.991266640496
        )

    [15] => Array
        (
            [id] => 497883967
            [en] => Duisburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137475
            [distance] => 246.941796994299
        )

    [16] => Array
        (
            [id] => 497883634
            [en] => Dusseldorf
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137473
            [distance] => 238.294748290116
        )

    [17] => Array
        (
            [id] => 497883100
            [en] => Erfurt
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135368
            [asc_5] => 137461
            [distance] => 76.232426217944
        )

    [18] => Array
        (
            [id] => 497884026
            [en] => Essen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137458
            [distance] => 232.184430948739
        )

    [19] => Array
        (
            [id] => 497878130
            [en] => Frankfurt
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135377
            [asc_5] => 137451
            [distance] => 115.959331419858
        )

    [20] => Array
        (
            [id] => 497857323
            [en] => Freiburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137449
            [distance] => 338.597991438055
        )

    [21] => Array
        (
            [id] => 497871764
            [en] => Furth
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137442
            [distance] => 147.388315504532
        )

    [22] => Array
        (
            [id] => 497884106
            [en] => Gelsenkirchen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137440
            [distance] => 226.818285477393
        )

    [23] => Array
        (
            [id] => 497884126
            [en] => Gottingen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135375
            [asc_5] => 137431
            [distance] => 96.194596789449
        )

    [24] => Array
        (
            [id] => 497883852
            [en] => Hagen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137423
            [distance] => 198.437792071519
        )

    [25] => Array
        (
            [id] => 497884072
            [en] => Halle
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135370
            [asc_5] => 137421
            [distance] => 159.819990893852
        )

    [26] => Array
        (
            [id] => 497886566
            [en] => Hamburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135378
            [asc_5] => 137420
            [distance] => 321.279939510894
        )

    [27] => Array
        (
            [id] => 497884338
            [en] => Hamm
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137418
            [distance] => 193.398445495433
        )

    [28] => Array
        (
            [id] => 497885289
            [en] => Hanover
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135375
            [asc_5] => 137417
            [distance] => 193.788928963195
        )

    [29] => Array
        (
            [id] => 497871030
            [en] => Heidelberg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137413
            [distance] => 170.366276927209
        )

    [30] => Array
        (
            [id] => 497867712
            [en] => Heilbronn
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137411
            [distance] => 180.678449365782
        )

    [31] => Array
        (
            [id] => 497884148
            [en] => Herne
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137407
            [distance] => 221.849071175642
        )

    [32] => Array
        (
            [id] => 497863649
            [en] => Ingolstadt
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137394
            [distance] => 232.774509541722
        )

    [33] => Array
        (
            [id] => 497866051
            [en] => Karlsruhe
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137389
            [distance] => 220.946420906164
        )

    [34] => Array
        (
            [id] => 497883777
            [en] => Kassel
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135377
            [asc_5] => 137388
            [distance] => 83.234954800023
        )

    [35] => Array
        (
            [id] => 497887849
            [en] => Kiel
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135369
            [asc_5] => 137384
            [distance] => 405.855032599709
        )

    [36] => Array
        (
            [id] => 497883796
            [en] => Krefeld
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137377
            [distance] => 256.977472341066
        )

    [37] => Array
        (
            [id] => 497883839
            [en] => Leipzig
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135371
            [asc_5] => 137348
            [distance] => 179.674398795807
        )

    [38] => Array
        (
            [id] => 497883209
            [en] => Leverkusen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137346
            [distance] => 220.053947843261
        )

    [39] => Array
        (
            [id] => 497887168
            [en] => Lubeck
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135369
            [asc_5] => 137339
            [distance] => 358.059748683021
        )

    [40] => Array
        (
            [id] => 497871753
            [en] => Ludwigshafen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135373
            [asc_5] => 137336
            [distance] => 176.163703677468
        )

    [41] => Array
        (
            [id] => 497884967
            [en] => Magdeburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135370
            [asc_5] => 137333
            [distance] => 194.704854691039
        )

    [42] => Array
        (
            [id] => 497877176
            [en] => Mainz
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135373
            [asc_5] => 137328
            [distance] => 148.491396307843
        )

    [43] => Array
        (
            [id] => 497871953
            [en] => Mannheim
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137326
            [distance] => 173.064896514722
        )

    [44] => Array
        (
            [id] => 497883528
            [en] => Monchengladbach
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137309
            [distance] => 262.432592508746
        )

    [45] => Array
        (
            [id] => 497883968
            [en] => Mulheim
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137306
            [distance] => 239.733689069352
        )

    [46] => Array
        (
            [id] => 497858364
            [en] => Munich
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137305
            [distance] => 302.978073907057
        )

    [47] => Array
        (
            [id] => 497884752
            [en] => Munster
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137304
            [distance] => 222.610137671809
        )

    [48] => Array
        (
            [id] => 497883529
            [en] => Neuss
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137296
            [distance] => 244.038966745513
        )

    [49] => Array
        (
            [id] => 497871389
            [en] => Nuremberg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137283
            [distance] => 152.622828354840
        )

    [50] => Array
        (
            [id] => 497884025
            [en] => Oberhausen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137279
            [distance] => 241.246296110851
        )

    [51] => Array
        (
            [id] => 497877992
            [en] => Offenbach
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135377
            [asc_5] => 137273
            [distance] => 111.851652798295
        )

    [52] => Array
        (
            [id] => 497886064
            [en] => Oldenburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135375
            [asc_5] => 137270
            [distance] => 303.807696718717
        )

    [53] => Array
        (
            [id] => 497885145
            [en] => Osnabruck
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135375
            [asc_5] => 137267
            [distance] => 227.174524766206
        )

    [54] => Array
        (
            [id] => 497884410
            [en] => Paderborn
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137259
            [distance] => 149.053789529364
        )

    [55] => Array
        (
            [id] => 497864831
            [en] => Pforzheim
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137254
            [distance] => 221.322690022001
        )

    [56] => Array
        (
            [id] => 497885301
            [en] => Potsdam
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135380
            [asc_5] => 137249
            [distance] => 282.894385995945
        )

    [57] => Array
        (
            [id] => 497866250
            [en] => Ratisbon
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137241
            [distance] => 234.615611640070
        )

    [58] => Array
        (
            [id] => 497884256
            [en] => Recklinghausen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137243
            [distance] => 226.452682321392
        )

    [59] => Array
        (
            [id] => 497883498
            [en] => Remscheid
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137240
            [distance] => 209.648087794521
        )

    [60] => Array
        (
            [id] => 497861193
            [en] => Reutlingen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137237
            [distance] => 250.191609590854
        )

    [61] => Array
        (
            [id] => 497887542
            [en] => Rostock
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135376
            [asc_5] => 137226
            [distance] => 404.415028141016
        )

    [62] => Array
        (
            [id] => 497869051
            [en] => Saarbrucken
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135372
            [asc_5] => 137188
            [distance] => 272.175219363598
        )

    [63] => Array
        (
            [id] => 497883497
            [en] => Solingen
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137195
            [distance] => 218.431725824285
        )

    [64] => Array
        (
            [id] => 497863812
            [en] => Stuttgart
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137178
            [distance] => 218.390225234742
        )

    [65] => Array
        (
            [id] => 497860494
            [en] => Ulm
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135383
            [asc_5] => 137163
            [distance] => 252.502773392586
        )

    [66] => Array
        (
            [id] => 497877842
            [en] => Wiesbaden
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135377
            [asc_5] => 137137
            [distance] => 146.035897313782
        )

    [67] => Array
        (
            [id] => 497885336
            [en] => Wolfsburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135375
            [asc_5] => 137131
            [distance] => 201.753675062739
        )

    [68] => Array
        (
            [id] => 497883676
            [en] => Wuppertal
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135374
            [asc_5] => 137128
            [distance] => 212.726517140077
        )

    [69] => Array
        (
            [id] => 497875224
            [en] => Wurzburg
            [important_3] => 1
            [asc_3] => 536
            [asc_4] => 135382
            [asc_5] => 137127
            [distance] => 97.175488965455
        )

    [testArray] => test
)
travelistica.ae.com: Distance between Andenhausen the most important cities of Germany>

Urnshausen 6 miles 10 km
Rossdorf 6 miles 10 km
Friedelshausen 7 miles 11 km
Biebelried 62 miles 100 km
Lahntal 62 miles 100 km
Ebergotzen 62 miles 100 km
Buchbrunn 62 miles 100 km
Zwinge 62 miles 100 km
Frankenberg 62 miles 100 km
Stockey 62 miles 100 km
Daasdorf 62 miles 100 km
Kleinneuhausen 62 miles 100 km
Seeburg 62 miles 100 km
Friedberg 62 miles 100 km
Kahl 62 miles 100 km
Albertshofen 62 miles 100 km
Kups 62 miles 100 km
Hallstadt 62 miles 100 km
Bad Nauheim 62 miles 100 km
Maintal 62 miles 100 km
Remlingen 62 miles 100 km
Milda 62 miles 100 km
Sachsenhausen 63 miles 101 km
Kronach 63 miles 101 km
Reinstadt 63 miles 101 km
Rollshausen 63 miles 101 km
Gollingen 63 miles 101 km
Burgwindheim 63 miles 101 km
Schillingstedt 63 miles 101 km
Wilhelmsthal 63 miles 101 km
Uettingen 63 miles 101 km
Hamma 63 miles 101 km
Triefenstein 63 miles 101 km
Werther 63 miles 101 km
Langgons 63 miles 101 km
Umpferstedt 63 miles 101 km
Grossbrembach 63 miles 101 km
Schoneck 63 miles 101 km
Mespelbrunn 63 miles 101 km
Hanau 63 miles 101 km
Kleinlangheim 63 miles 101 km
Krebeck 63 miles 101 km
Grosskrotzenburg 63 miles 101 km
Randersacker 63 miles 101 km
Wollbrandshausen 63 miles 101 km
Bendeleben 63 miles 101 km
Wiegendorf 63 miles 102 km
Lohra 63 miles 102 km
Burgwald 63 miles 102 km
Wollstadt 63 miles 102 km
Heringen 63 miles 102 km
Hammerstedt 63 miles 102 km
Etzleben 63 miles 102 km
Altendorf 63 miles 102 km
Schollbrunn 63 miles 102 km
Rudenhausen 63 miles 102 km
Tschirn 63 miles 102 km
Gundelsheim 63 miles 102 km
Heuchelheim 63 miles 102 km
Rudershausen 63 miles 102 km
Walsdorf 63 miles 102 km
Linden 63 miles 102 km
Abtswind 63 miles 102 km
Theilheim 63 miles 102 km
Altenkunstadt 63 miles 102 km
Gorsleben 63 miles 102 km
Ober-morlen 63 miles 102 km
Rhumspringe 63 miles 102 km
Ossmannstedt 63 miles 102 km
Liebstedt 63 miles 102 km
Frankendorf 64 miles 103 km
Kleinschwabhausen 64 miles 103 km
Heimbuchenthal 64 miles 103 km
Schesslitz 64 miles 103 km
Eisingen 64 miles 103 km
Ellersleben 64 miles 103 km
Silkerode 64 miles 103 km
Badra 64 miles 103 km
Bovenden 64 miles 103 km
Holzkirchen 64 miles 103 km
Orlamunde 64 miles 103 km
Butzbach 64 miles 103 km
Seligenstadt 64 miles 103 km
Krolpa 64 miles 103 km
Kleinostheim 64 miles 103 km
Dobritschen 64 miles 103 km
Grosslangheim 64 miles 103 km
Seisla 64 miles 103 km
Burgkunstadt 64 miles 103 km
Waldbrunn 64 miles 103 km
Bockelnhagen 64 miles 103 km
Hemleben 64 miles 103 km
Allendorf 64 miles 103 km
Olbersleben 64 miles 103 km
Grossschwabhausen 64 miles 103 km
Memmelsdorf 64 miles 103 km
Rohrbach 64 miles 103 km
Beichlingen 64 miles 103 km
Bodensee 64 miles 103 km
Wattendorf 65 miles 104 km
Aachen 174 miles 280 km
Augsburg 164 miles 264 km
Berlin 201 miles 324 km
Bielefeld 115 miles 185 km
Bochum 137 miles 220 km
Bonn 130 miles 209 km
Bottrop 149 miles 239 km
Bremen 175 miles 282 km
Bremerhaven 209 miles 336 km
Brunswick 112 miles 180 km
Chemnitz 125 miles 201 km
Cologne 137 miles 220 km
Darmstadt 84 miles 135 km
Dortmund 127 miles 204 km
Dresden 162 miles 261 km
Duisburg 153 miles 247 km
Dusseldorf 148 miles 238 km
Erfurt 47 miles 76 km
Essen 144 miles 232 km
Frankfurt 72 miles 116 km
Freiburg 211 miles 339 km
Furth 91 miles 147 km
Gelsenkirchen 141 miles 227 km
Gottingen 60 miles 96 km
Hagen 123 miles 198 km
Halle 99 miles 160 km
Hamburg 199 miles 321 km
Hamm 120 miles 193 km
Hanover 121 miles 194 km
Heidelberg 106 miles 170 km
Heilbronn 112 miles 181 km
Herne 138 miles 222 km
Ingolstadt 145 miles 233 km
Karlsruhe 137 miles 221 km
Kassel 52 miles 83 km
Kiel 252 miles 406 km
Krefeld 160 miles 257 km
Leipzig 112 miles 180 km
Leverkusen 137 miles 220 km
Lubeck 222 miles 358 km
Ludwigshafen 109 miles 176 km
Magdeburg 121 miles 195 km
Mainz 92 miles 148 km
Mannheim 107 miles 173 km
Monchengladbach 163 miles 262 km
Mulheim 149 miles 240 km
Munich 188 miles 303 km
Munster 139 miles 223 km
Neuss 152 miles 244 km
Nuremberg 95 miles 153 km
Oberhausen 150 miles 241 km
Offenbach 70 miles 112 km
Oldenburg 189 miles 304 km
Osnabruck 141 miles 227 km
Paderborn 93 miles 149 km
Pforzheim 137 miles 221 km
Potsdam 176 miles 283 km
Ratisbon 146 miles 235 km
Recklinghausen 140 miles 226 km
Remscheid 130 miles 210 km
Reutlingen 155 miles 250 km
Rostock 251 miles 404 km
Saarbrucken 169 miles 272 km
Solingen 135 miles 218 km
Stuttgart 135 miles 218 km
Ulm 157 miles 253 km
Wiesbaden 91 miles 146 km
Wolfsburg 126 miles 202 km
Wuppertal 132 miles 213 km
Wurzburg 60 miles 97 km
Giebelstadt Airport 71 miles 114 km
Frankfurt Airport 80 miles 128 km
Bindlacher Berg Airport 84 miles 135 km
Mainz-Finthen Airport 91 miles 147 km
Nuremberg Airport 93 miles 149 km
Leipzig/Halle Airport 107 miles 173 km
Mannheim City Airport 107 miles 173 km
Heidelberg Airport 108 miles 174 km
Leipzig-Altenburg Airport 109 miles 175 km
RAF Gütersloh 116 miles 186 km
Dortmund Airport 122 miles 196 km
Hannover Airport 125 miles 201 km
Frankfurt-Hahn Airport 134 miles 215 km
Stuttgart Hauptbahnhof 136 miles 219 km
Stuttgart Airport 142 miles 228 km
Essen/Mülheim Airport 145 miles 234 km
Zweibrücken Airport 156 miles 251 km
Augsburg Airport 160 miles 257 km
Dresden Airport 164 miles 264 km
Saarbrücken Airport 166 miles 267 km
Merzbrück Airport 170 miles 274 km
Bremen Airport 173 miles 279 km
RAF Gatow 181 miles 292 km
Allgäu Airport 185 miles 298 km
Berlin Brandenburg Airport 188 miles 303 km
Berlin Schönefeld Airport 190 miles 305 km
Berlin Tegel Airport 190 miles 306 km
Schwerin-Parchim Airport 204 miles 328 km
Bremerhaven Airport 206 miles 332 km
JadeWeser Airport 214 miles 344 km
Emden Airport 224 miles 360 km


Receive our newsletter with the best offers!

We are now looking for the best deals Andenhausen