select [type] from [customtable_price_data] where NodeID='25664' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='25664' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Lafayette Airport Car Hire - Did You Know?
- Lafayette is acknowledged as the centre of Cajun culture in the US
- It’s also known as the main protagonist of Creole culture and cuisine
- Lafayette was founded in 1821
- The city was originally named Vemilionville by the French settlers
- The wetlands formed by the mouth of the Mississippi are internationally recognised for their size and diversity.
Lafayette Airport Mini Guide
Located in Louisiana
is Lafayette Airport LFT and is only 4 kilometres for the city centre which is accessed by Highway 90. In 2006 the airport handled 114,303 flights via several frequent airlines. These include American Eagle, Mesaba Airlines, Continental Airlines and Atlantic South East Airlines. Those utilizing car hire at Lafayette Airport can access the city via many good road links these include the Interstate Highway by following signs on the L10 and L49.
The other popular road direct from the airport is the southern located Highway 90. If collecting your rental from another location you can travel via the Antrak Sunset Limited railway service. This service connects from New Orleans
and Los Angeles
. Once you arrive at the city you will find a great range of sights. McGee's Landing is a great day out where you can find many things to do for all ages.
The Marina has many restaurants, bars and at weekends you will find live bands. Guides are available from here for hunting and fishing trips and swap tours where guests can see alligators and many fish. The city is a popular place for enjoy the outdoors, The Wetlands on North University Avenue and Le Vieux Chenes on Rue Des Vieux Chenes offer golf opportunities. For the adventurous Fausse Point Stake Park offers Canoe experiences on miles of water. Within the park are hiking trails, boats, camp site ad a playground for children.