| My Destination begins with: | A | | | B | | | C | | | D | | | E | | | F | | | G | | | H | | | I | | | J | | | K | | | L | | | M | | | N | | | O | | | P | | | Q | | | R | | | S | | | T | | | U | | | V | | | W | | | X | | | Y | | | Z |
Flight Search
Latest return flights to Gerona...
SELECT DISTINCT top 20 count(arr_airport) as total, airport.name, arr_airport, dep_airport, min(cast(standard_price as numeric)), min(cast(standard_price as numeric))/no_adults as price, cast(dep_date as datetime) as dep_date, cast(rtnDep_date as datetime) as rtndep_date, no_adults, datediff(d,dep_date,rtndep_date) FROM cached_offers_flights INNER JOIN airport ON (cached_offers_flights.dep_airport = airport.code) WHERE arr_airport = 'GRO' and cast(dep_date as datetime) >= '21/08/2008 22:48:37' GROUP BY dep_date,rtnDep_date,dep_airport,arr_airport, no_adults, airport.Name, [datetime] ORDER BY price ASC
Gerona Flights
The ancient city of Girona is ideally situated in Catalunya, with the rugged coastline of the Costa Brava a short distance away, the French border less than an hour's drive and Barcelona 90 minutes to the south. The city is bisected by the river Onyar, which separates the modern city, rich on coal mining and other industries, from the narrow cobbled streets and steep starways of the old town. Built right on the banks of the Onyar are ochre coloured houses, forming a colourful parade. The river is spanned by several bridges, including one by Gustav Eiffel, responsible for the Eiffel Tower in Paris and the design of New York's Statue of Liberty.
Top flight destinations...


