select  other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where 
city_id=498004389 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id  order by  en ascArray
(
)

Array
(
    [0] => Array
        (
            [id] => 154828
            [en] => Al Blidah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135298
            [asc_5] => 
            [distance] => 353.076344213582
        )

    [1] => Array
        (
            [id] => 154679
            [en] => Al Hurub
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135280
            [asc_5] => 
            [distance] => 71.459532452920
        )

    [2] => Array
        (
            [id] => 154243
            [en] => Al Masilah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135287
            [asc_5] => 
            [distance] => 187.628403805823
        )

    [3] => Array
        (
            [id] => 154777
            [en] => Al Tahir
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135289
            [asc_5] => 
            [distance] => 105.836383652283
        )

    [4] => Array
        (
            [id] => 154603
            [en] => Al Ulmah 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135276
            [asc_5] => 
            [distance] => 102.030210888402
        )

    [5] => Array
        (
            [id] => 154469
            [en] => Al Winzah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135270
            [asc_5] => 
            [distance] => 140.606256812022
        )

    [6] => Array
        (
            [id] => 190175
            [en] => Alagwat 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135307
            [asc_5] => 
            [distance] => 396.779085986842
        )

    [7] => Array
        (
            [id] => 190133
            [en] => Albayad
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135301
            [asc_5] => 
            [distance] => 556.038722148497
        )

    [8] => Array
        (
            [id] => 171473
            [en] => Albuni
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135306
            [asc_5] => 
            [distance] => 164.958214992401
        )

    [9] => Array
        (
            [id] => 498004130
            [en] => Algiers
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135290
            [asc_5] => 0
            [distance] => 342.009661010156
        )

    [10] => Array
        (
            [id] => 190528
            [en] => Aljilfah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135288
            [asc_5] => 
            [distance] => 323.604361864573
        )

    [11] => Array
        (
            [id] => 190081
            [en] => Almisriyah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135282
            [asc_5] => 
            [distance] => 672.418673867711
        )

    [12] => Array
        (
            [id] => 190018
            [en] => Alwad
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135263
            [asc_5] => 
            [distance] => 252.311407629479
        )

    [13] => Array
        (
            [id] => 155163
            [en] => Annabah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135306
            [asc_5] => 
            [distance] => 175.458954632613
        )

    [14] => Array
        (
            [id] => 154360
            [en] => Arzu
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135262
            [asc_5] => 
            [distance] => 626.227994422218
        )

    [15] => Array
        (
            [id] => 154605
            [en] => As Salif
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135277
            [asc_5] => 
            [distance] => 480.598587018678
        )

    [16] => Array
        (
            [id] => 154308
            [en] => Ayn Al Bayda 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135264
            [asc_5] => 
            [distance] => 72.771054580884
        )

    [17] => Array
        (
            [id] => 154515
            [en] => Ayn Malilah 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135264
            [asc_5] => 
            [distance] => 45.744713709273
        )

    [18] => Array
        (
            [id] => 153955
            [en] => Ayn Timusanat
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135304
            [asc_5] => 
            [distance] => 703.964193354634
        )

    [19] => Array
        (
            [id] => 154079
            [en] => Ayn Wissarah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135288
            [asc_5] => 
            [distance] => 336.598185269451
        )

    [20] => Array
        (
            [id] => 154861
            [en] => Bani Marad
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135298
            [asc_5] => 
            [distance] => 351.351555622016
        )

    [21] => Array
        (
            [id] => 154961
            [en] => Baraqi
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135290
            [asc_5] => 
            [distance] => 336.060273427034
        )

    [22] => Array
        (
            [id] => 154033
            [en] => Barikah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135302
            [asc_5] => 
            [distance] => 115.795146385155
        )

    [23] => Array
        (
            [id] => 189068
            [en] => Bassar 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135303
            [asc_5] => 
            [distance] => 932.439337134086
        )

    [24] => Array
        (
            [id] => 154152
            [en] => Batnah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135302
            [asc_5] => 
            [distance] => 40.774317174989
        )

    [25] => Array
        (
            [id] => 155047
            [en] => Bijayah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135300
            [asc_5] => 
            [distance] => 187.070629466153
        )

    [26] => Array
        (
            [id] => 154586
            [en] => Bir Waqiyah 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135286
            [asc_5] => 
            [distance] => 338.511173841976
        )

    [27] => Array
        (
            [id] => 190571
            [en] => Biralitir
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135270
            [asc_5] => 
            [distance] => 163.043569463757
        )

    [28] => Array
        (
            [id] => 190658
            [en] => Biskrah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135299
            [asc_5] => 
            [distance] => 117.432297803846
        )

    [29] => Array
        (
            [id] => 153898
            [en] => Bu Sadah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135287
            [asc_5] => 
            [distance] => 225.513272976507
        )

    [30] => Array
        (
            [id] => 154530
            [en] => Burj Bu Arririj
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135295
            [asc_5] => 
            [distance] => 185.167495224814
        )

    [31] => Array
        (
            [id] => 154739
            [en] => Constantina
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135280
            [asc_5] => 
            [distance] => 81.157054936683
        )

    [32] => Array
        (
            [id] => 154279
            [en] => Galizan
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135294
            [asc_5] => 
            [distance] => 547.771453788231
        )

    [33] => Array
        (
            [id] => 189646
            [en] => Gardayah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135293
            [asc_5] => 
            [distance] => 442.094661594655
        )

    [34] => Array
        (
            [id] => 154668
            [en] => Hamis Milyanah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135305
            [asc_5] => 
            [distance] => 402.610828306157
        )

    [35] => Array
        (
            [id] => 154062
            [en] => Hansalah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135292
            [asc_5] => 
            [distance] => 52.834893024497
        )

    [36] => Array
        (
            [id] => 153818
            [en] => Hassi Bahbah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135288
            [asc_5] => 
            [distance] => 331.668124492878
        )

    [37] => Array
        (
            [id] => 155108
            [en] => Jijili
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135289
            [asc_5] => 
            [distance] => 153.423213927228
        )

    [38] => Array
        (
            [id] => 190657
            [en] => Magniyah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135269
            [asc_5] => 
            [distance] => 762.364055612033
        )

    [39] => Array
        (
            [id] => 154676
            [en] => Medea
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135286
            [asc_5] => 
            [distance] => 353.291057358745
        )

    [40] => Array
        (
            [id] => 154800
            [en] => Milah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135285
            [asc_5] => 
            [distance] => 96.575858859236
        )

    [41] => Array
        (
            [id] => 190307
            [en] => Misad
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135288
            [asc_5] => 
            [distance] => 327.720792980272
        )

    [42] => Array
        (
            [id] => 154449
            [en] => Mostaghanem
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135283
            [asc_5] => 
            [distance] => 589.431799648526
        )

    [43] => Array
        (
            [id] => 154036
            [en] => Muaskar 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135284
            [asc_5] => 
            [distance] => 586.454999603208
        )

    [44] => Array
        (
            [id] => 154816
            [en] => Qalmah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135281
            [asc_5] => 
            [distance] => 118.694393356089
        )

    [45] => Array
        (
            [id] => 154389
            [en] => Qasr Al Buhari
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135286
            [asc_5] => 
            [distance] => 350.786772260868
        )

    [46] => Array
        (
            [id] => 190643
            [en] => Saidah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135279
            [asc_5] => 
            [distance] => 594.452392599302
        )

    [47] => Array
        (
            [id] => 155141
            [en] => Sakikdah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135278
            [asc_5] => 
            [distance] => 141.296022502030
        )

    [48] => Array
        (
            [id] => 153945
            [en] => Sariah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135270
            [asc_5] => 
            [distance] => 109.934986166096
        )

    [49] => Array
        (
            [id] => 154619
            [en] => Satif
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135276
            [asc_5] => 
            [distance] => 125.091286672710
        )

    [50] => Array
        (
            [id] => 154404
            [en] => Sidi Aissa
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135287
            [asc_5] => 
            [distance] => 258.406641534683
        )

    [51] => Array
        (
            [id] => 171462
            [en] => Sidi Amar
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135306
            [asc_5] => 
            [distance] => 164.306611428473
        )

    [52] => Array
        (
            [id] => 153879
            [en] => Sidi Balabbas 
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135275
            [asc_5] => 
            [distance] => 659.121350367732
        )

    [53] => Array
        (
            [id] => 154123
            [en] => Siq
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135284
            [asc_5] => 
            [distance] => 614.444236592704
        )

    [54] => Array
        (
            [id] => 153885
            [en] => Sugar
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135266
            [asc_5] => 
            [distance] => 465.900641901154
        )

    [55] => Array
        (
            [id] => 154690
            [en] => Suq Ahras
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135274
            [asc_5] => 
            [distance] => 140.782832101803
        )

    [56] => Array
        (
            [id] => 187365
            [en] => Tamanrasat
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135273
            [asc_5] => 
            [distance] => 1431.609500020500
        )

    [57] => Array
        (
            [id] => 154041
            [en] => Tibissah
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135270
            [asc_5] => 
            [distance] => 138.391764428342
        )

    [58] => Array
        (
            [id] => 190684
            [en] => Tilimsan
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135269
            [asc_5] => 
            [distance] => 724.894835778378
        )

    [59] => Array
        (
            [id] => 154176
            [en] => Tisamsilt
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135267
            [asc_5] => 
            [distance] => 434.222587380434
        )

    [60] => Array
        (
            [id] => 154023
            [en] => Tiyarat
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135266
            [asc_5] => 
            [distance] => 480.015851967043
        )

    [61] => Array
        (
            [id] => 155004
            [en] => Tizi Wazu
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135265
            [asc_5] => 
            [distance] => 260.138137219947
        )

    [62] => Array
        (
            [id] => 154380
            [en] => Umm-al-bawagi
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135264
            [asc_5] => 
            [distance] => 52.605539815311
        )

    [63] => Array
        (
            [id] => 154234
            [en] => Wahran
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135262
            [asc_5] => 
            [distance] => 653.458027633775
        )

    [64] => Array
        (
            [id] => 189253
            [en] => Warqla
            [important_3] => 1
            [asc_3] => 455
            [asc_4] => 135261
            [asc_5] => 
            [distance] => 423.666222695069
        )

    [testArray] => test
)
travelistica.ae.com: Distance between Al Shamra the most important cities of Algeria>

DISTANCES TO AL SHAMRA

Distance between Al Shamra the most important cities Algeria

Cities near to Al Shamra

Awlad Fadel 6 miles 10 km
Bolhelat 8 miles 13 km
Zigut Yusuf 62 miles 100 km
Hay Ben Qasha 63 miles 102 km
Salawa Announa 63 miles 102 km
Saqana 63 miles 102 km
Ain El Hagar 63 miles 102 km
Al Ulmah 63 miles 102 km
Zeghaya 63 miles 102 km
Al Alma 63 miles 102 km
Al Kasbat 64 miles 103 km
Qararam Quqa 64 miles 103 km
Ayn Azl 65 miles 104 km
Bu Hemdan 65 miles 104 km
Sidi Marwan 65 miles 104 km
Zarbiyatalwad 65 miles 105 km
Ruwasad 65 miles 105 km
Al Baraneis 65 miles 105 km
Ain Sandal 66 miles 106 km
Al Tahir 66 miles 106 km
Hawary Bu Medin 66 miles 106 km
Hemala 67 miles 108 km
Al Mazraa 67 miles 108 km
Farjiwah 67 miles 108 km
Ain Al Baydaa Hareesh 67 miles 108 km
Al Sheqara 68 miles 109 km
Sariah 68 miles 110 km
Bu Heshana 68 miles 110 km
Magaz Ammar 68 miles 110 km
Shetma 68 miles 110 km
Teraa Baynan 69 miles 111 km
Djemila 69 miles 111 km
Beer Mekdem 70 miles 112 km
Ben Geraah 70 miles 112 km
Khameisa 70 miles 113 km
Ghobala 70 miles 113 km
Al Ayadey Berbas 71 miles 114 km
Awlad Rabeh 71 miles 115 km
Barikah 72 miles 116 km
Al Harus 72 miles 116 km
Sidi Maarouf 72 miles 116 km
Al Gazzar 72 miles 116 km
Ain Al Naqa 73 miles 117 km
Lekhzara 73 miles 117 km
Biskrah 73 miles 117 km
Sidi Uqbah 73 miles 117 km
Al Ouwainaat 73 miles 118 km
Al Aِِwaynat 73 miles 118 km
Lu Taya 74 miles 119 km
Qalmah 74 miles 119 km
Madawrus 75 miles 120 km
Al Fagoug 75 miles 120 km
Hammam Al Nabaiyel 75 miles 120 km
Belkheir 75 miles 121 km
Tesdan Hedada 75 miles 121 km
Hiliopolis 76 miles 122 km
Bumahra Ahmad 76 miles 122 km
Salah Bay 76 miles 122 km
Hammam Awlad Ali 76 miles 122 km
Hammamat 76 miles 122 km
Tefash 76 miles 123 km
Ayn Wilman 76 miles 123 km
Al Setara 77 miles 124 km
Gemlah 77 miles 124 km
Bu Aati Mahmoud 78 miles 125 km
Awlad Aaskar 78 miles 125 km
Satif 78 miles 125 km
Mersat 78 miles 126 km
Gabalet Al Khamesi 78 miles 126 km
Al Fayd 78 miles 126 km
Al Hanansha 79 miles 127 km
Al Dereaa 79 miles 127 km
Awlad Yahia Khadroush 79 miles 127 km
Bourawi Belhadef 79 miles 127 km
Belaayba 79 miles 127 km
Beni Aziz 80 miles 128 km
Ayn Al Habira 80 miles 128 km
Al dehwara 80 miles 129 km
Bu Khodra 80 miles 129 km
Al Mliyah 80 miles 129 km
Beni Mezlein 81 miles 130 km
Awlad Ammar 81 miles 130 km
Al Housh 81 miles 130 km
Al Shohna 81 miles 131 km
Al Hageb 81 miles 131 km
Bitam 81 miles 131 km
Bu Drieaa Ben Yages 81 miles 131 km
Azzabah 82 miles 132 km
Ayn Arnat 83 miles 133 km
Wadi Al Shahm 83 miles 133 km
Tamalus 83 miles 133 km
Umas 83 miles 134 km
Borg El Tahr 84 miles 135 km
Neshameiya 85 miles 136 km
Amousha 85 miles 136 km
Al Mashrouha 85 miles 136 km
Bu Sheqouf 85 miles 137 km
Al Zaroureiya 86 miles 138 km
Taxeena 86 miles 138 km

Distance between Al Shamra the most important cities Algeria

Al Blidah 219 miles 353 km
Al Hurub 44 miles 71 km
Al Masilah 117 miles 188 km
Al Tahir 66 miles 106 km
Al Ulmah 63 miles 102 km
Al Winzah 88 miles 141 km
Alagwat 247 miles 397 km
Albayad 345 miles 556 km
Albuni 103 miles 165 km
Algiers 213 miles 342 km
Aljilfah 201 miles 324 km
Almisriyah 418 miles 672 km
Alwad 157 miles 252 km
Annabah 109 miles 175 km
Arzu 389 miles 626 km
As Salif 299 miles 481 km
Ayn Al Bayda 45 miles 73 km
Ayn Malilah 29 miles 46 km
Ayn Timusanat 437 miles 704 km
Ayn Wissarah 209 miles 337 km
Bani Marad 218 miles 351 km
Baraqi 209 miles 336 km
Barikah 72 miles 116 km
Bassar 579 miles 932 km
Batnah 25 miles 41 km
Bijayah 116 miles 187 km
Bir Waqiyah 211 miles 339 km
Biralitir 101 miles 163 km
Biskrah 73 miles 117 km
Bu Sadah 140 miles 226 km
Burj Bu Arririj 115 miles 185 km
Constantina 50 miles 81 km
Galizan 341 miles 548 km
Gardayah 275 miles 442 km
Hamis Milyanah 250 miles 403 km
Hansalah 33 miles 53 km
Hassi Bahbah 206 miles 332 km
Jijili 95 miles 153 km
Magniyah 473 miles 762 km
Medea 219 miles 353 km
Milah 60 miles 97 km
Misad 204 miles 328 km
Mostaghanem 366 miles 589 km
Muaskar 364 miles 586 km
Qalmah 74 miles 119 km
Qasr Al Buhari 218 miles 351 km
Saidah 369 miles 594 km
Sakikdah 88 miles 141 km
Sariah 68 miles 110 km
Satif 78 miles 125 km
Sidi Aissa 160 miles 258 km
Sidi Amar 102 miles 164 km
Sidi Balabbas 409 miles 659 km
Siq 382 miles 614 km
Sugar 290 miles 466 km
Suq Ahras 88 miles 141 km
Tamanrasat 890 miles 1432 km
Tibissah 86 miles 138 km
Tilimsan 450 miles 725 km
Tisamsilt 270 miles 434 km
Tiyarat 298 miles 480 km
Tizi Wazu 162 miles 260 km
Umm-al-bawagi 33 miles 53 km
Wahran 406 miles 653 km
Warqla 263 miles 424 km

Nearest Airports to Al Shamra

Biskra Airport 76 miles 122 km
Ain Arnat Airport 81 miles 131 km
Skikda Airport 88 miles 141 km
Jijel Ferhat Abbas Airport 91 miles 146 km
Rabah Bitat Airport (Les Salines Airport) 106 miles 170 km
Soummam Airport 114 miles 184 km
Bou Saada Airport 137 miles 221 km
Guemar Airport 147 miles 236 km
Batna Airport 19 miles 31 km
Algier - Houari Boumediene Airport 204 miles 328 km
Boufarik Airport 218 miles 351 km
Blida Airport 221 miles 355 km
Tilrempt Airport 265 miles 427 km
Oued Irara Airport 275 miles 442 km
Noumérat – Moufdi Zakaria Airport 277 miles 445 km
Relizane Airport 337 miles 542 km
Ghriss Airport 365 miles 588 km
Oran Tafaraoui Airport 401 miles 646 km
Oran Es Sénia Airport 406 miles 654 km
Sidi Bel Abbès Airport 407 miles 655 km
El Golea Airport 411 miles 662 km
Mohamed Boudiaf International Airport 45 miles 72 km
In Amenas Airport 553 miles 890 km
Boudghene Ben Ali Lotfi Airport 580 miles 934 km


Receive our newsletter with the best offers!

We are now looking for the best deals Al Shamra


Destination :

Check In & Out

Passengers