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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [testArray] => test
)

Travel Guide of Constantina

Excursions . Tours. Photos . Maps . Transfers .Activities
Hotels.Cars .Tickets .Flights .Restaurants .Information

Constantine

14.98^° - 17.14^°

• Constantina
• Travel Guide
• Hotels
• Information
  • Distances
    
  • Weather
    
  • Map
    
  • Photos
    
• Attractions
  • Palaces
  • Attractions

Constantine
14.98^° - 17.14^°

ATTRACTIONS CONSTANTINA

LIST OF THE FEAUTURED ATTRACTIONS OF CONSTANTINA.

Cosentine

(Constantina)

Ahmed Bey Palace

(Constantina)

City center

(Constantina)

1st of November Square

(Constantina)

 

All attractions of Constantina

FEATURED HOTELS IN CONSTANTINA

MORE HOTELS CONSTANTINA

Novotel Constantine

Constantina

Click here to see more details and book Novotel Constantine . You see photos, situation, room facilities, hotel installations, entertainment facilities and payment methods Novotel ...

Save Up To 60%

Ibis Constantine

Constantina

Click here to see more details and book Ibis Constantine . You see photos, situation, room facilities, hotel installations, entertainment facilities and payment methods Ibis Consta ...

Save Up To 60%

Cirta

Constantina

Click here to see more details and book Cirta . You see photos, situation, room facilities, hotel installations, entertainment facilities and payment methods Cirta ...

Save Up To 60%

Marriott Constantine Hotel

...  Constantina

Click here to see more details and book Marriott Constantine Hotel . You see photos, situation, room facilities, hotel installations, entertainment facilities and payment methods M ...

Save Up To 60%

 

More Hotels Constantina

RESTAURANTS IN CONSTANTINA

A LIST OF THE MOST FEATURED RESTAURANTS IN CONSTANTINA

Dar Diaf
04, Rue Baghriche Mustefa Constantine

Igherssan Restaurant
58 Rue Larbi Ben M'hidi Constantine
Mediterranean Cuisine,

IL GUSTO
Sidi Mabrouk Inferieur;A Cote Technicum Bousahaba Constantine
Pizza,

El Baik
N3 Constantine

Patisserie Cassonade
Cite Filali Bloc G No 2 Constantine
French Cuisine,

Dar Es-Soltane
59 Avenue Ouati Mustapha Constantine

Cafe Beyrouth
04 Avenue Aouati Mostafa Constantine
Cafe,

 

MORE RESTAURANTS IN CONSTANTINA

NEAR AIRPORTS

116 km Ain Arnat Airport

120 km Rabah Bitat Airport (Les Salines Airport)

142 km Soummam Airport

191 km Biskra Airport

244 km Bou Saada Airport

305 km Algier - Houari Boumediene Airport

317 km Guemar Airport

334 km Boufarik Airport

339 km Blida Airport

486 km Tilrempt Airport

512 km Noumérat – Moufdi Zakaria Airport

523 km Oued Irara Airport

542 km Relizane Airport

596 km Ghriss Airport

65 km Skikda Airport

648 km Oran Tafaraoui Airport

655 km Oran Es Sénia Airport

662 km Sidi Bel Abbès Airport

72 km Batna Airport

731 km El Golea Airport

81 km Jijel Ferhat Abbas Airport

10 km Mohamed Boudiaf International Airport

967 km In Amenas Airport

971 km Boudghene Ben Ali Lotfi Airport

DISTANCE BETWEEN CONSTANTINA AND THE MOST IMPORTANT CITIES

13 km Al Hurub
199 km Al Masilah
59 km Al Tahir
85 km Al Ulmah
144 km Al Winzah
441 km Alagwat
589 km Albayad
110 km Albuni
319 km Algiers
356 km Aljilfah
701 km Almisriyah
333 km Alwad
120 km Annabah
624 km Arzu
474 km As Salif
94 km Ayn Al Bayda
36 km Ayn Malilah
708 km Ayn Timusanat
348 km Ayn Wissarah
334 km Bani Marad
315 km Baraqi
155 km Barikah
970 km Bassar
96 km Batnah
144 km Bijayah
332 km Bir Waqiyah
222 km Biralitir
184 km Biskrah
253 km Bu Sadah
180 km Burj Bu Arririj
548 km Galizan
507 km Gardayah
393 km Hamis Milyanah
114 km Hansalah
353 km Hassi Bahbah
91 km Jijili
771 km Magniyah
343 km Medea

See distances with more cities

SEARCH THE INTERNET FOR MORE INFORMATION ABOUT CONSTANTINA

Search Flicker for Photos of Constantina

If you need to see more photos sobre Constantina In Flicker. Use this link to sarch for the best photos of Constantina

Videos about Constantina

Watch videos about Constantina in Youtube. Search now the best videos with just a click

Map of Constantina

Walk Constantina Places, streets, squares, roads with many information , services and much more

News of Constantina

Search Bing for more news and information about Constantina Just click on the icon and you can see al the results

Search Google for te best photos of Constantina

If you need to see more photos sobre Constantina in Google. Use this link to sarch for the best photos of Constantina

Constantina in wikipedia

Search information about Constantina in all fields: history, geography, politics, population, habits fauna and flora

Links about Constantina

Search all information available about. Just click on the icon and you can see al the results.

More about Constantina

More information about Constantina in Yahoo. Just click on the icon and you can see al the results.

Receive our newsletter with the best offers!

Subscribe

Contact Us

Working hours are from Monday to Friday from 10:00 AM to 14:00PM and from 16:00 PM to 19:00 PM
Saturday from 10AM to 14 PM

Phone : +97155570144

Mobile : +971 56 691 7141

Whatsap : +971 56 691 7141

: Send a Message

My account

• Login
• Register

Login By Email

Did You Forget Your Password?

---

Login By Google

Login By FaceBook

AfghanistanAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBosnia and HerzegovinaBotswanaBrazilBritish Virgin IslandsBruneiBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African Rep.ChadChileChinaColombiaComorosCongo (Brazzaville)Congo (Kinshasa)Cook IslandsCosta RicaCroatiaCubaCURACAOCyprusCzech Republic (Czechia)DenmarkDjiboutiDominicaDominican RepublicEast TimorEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsle of ManIsraelItalyIvory CoastJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKosovoKuwaitKyrgyzstanLaosLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacauMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNetherlands AntillesNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth KoreaNorthern CyprusNorthern Mariana IslandsNorwayOmanPakistanPalauPalestinian TerritoryPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarReunionRomaniaRussiaRwandaSAINT BARTHELEMYSaint HelenaSaint Kitts and NevisSaint LuciaSaint Pierre and MiquelonSaint Vincent and the GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSerbiaSerbia And MontenegroSeychellesSierra LeoneSingaporeSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth KoreaSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan MayenSwazilandSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks and Caicos IslandsTuvaluU.S. Virgin IslandsUgandaUkraineUnited Arab EmiratesUnited KingdomUnited KingdomUnited StatesUnited States Minor Outlying IslandsUruguayUzbekistanVanuatuVaticanVenezuelaVietnamWallis and FutunaYemenZambiaZimbabwe

By creating an account, You accept the conditions of using our web Terms of Use and the Privacy Policy.

Choose Currency

AED

• European euro
• Saudi riyal
• UAE dirham
• United States dollar

 Español      English      العربيه

We are now looking for the best deals Constantina

Destination :

Check In & Out

Passengers