select [type] from [customtable_price_data] where NodeID='19320' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='19320' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Logrono Airport Car Hire - Did You Know?
- Until the 1950s, the airport was a military one.
- The airport now has its own museum detailing its history.
- The airport is the only airport for the Rioja region.
- Logrono Airport receives only flights from Madrid.
- The airport’s proper name in Agoncillo Airport, named after the municipality in which it is found.
- The airport served 20,000 passengers last year, an increase of nearly 8% on the previous year
Logrono Airport Mini Guide
Logrono-Agoncillo Airport is a small airport located just outside the city. It only offers flights to Barcelona, Madrid,
Ibiza and
Palma de Mallorca. These flights are served by Air Nostrum, which offers several flights daily. It has a small but very personal terminal building with enough facilities to provide for each customer satisfactorily.
Logrono itself is located in the northern part of Spain along the Ebro River. It is best known for its trade in Rioja wine although it also produces fine textiles. One of the main attractions there is the Co-Cathedral Santa Maria de la Redonda. An amazing Gothic style church which is actually built where a 12th century temple once stood. It has two huge towers which were added in the 18th century, an incredible sight which should be seen.
For a proper taste of the Spanish way of life, take a drive in your hire car along the National Road (N-111) which follows the Iregua River. You will see quaint Spanish villages such as Nalda and Abelda. These are strewn with vineyards and orchards, a true haven for nature lovers.
For something a little livelier, head to the town square on the avenue of peace. You will see street performers and many public acts and the occasional concert if you are there at the right time. It is also the perfect place to just sit back and watch the world go by while sipping a coffee from one of the many cafes.