select [type] from [customtable_price_data] where NodeID='25788' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='25788' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Corpus Christi Airport
- Corpus Christi is the largest coastal city in Texas.
- It was founded in the 17th century by French and Spanish explorers.
- Eventually it became a smuggling town for goods from Mexico.
- Nearly all the city was destroyed and rebuilt in 1919 after a devastating hurricane.
- The city was fought over and changed hands several times in the Mexican-American War.
Corpus Christi Airport Mini Guide
Serving 97,657 passengers in 2006 is Corpus Christi Airport CRP. Via six gates the airport is served by airlines that provided international and domestic flights, including Continental Airlines, American Airlines and American Eagle. Once you have landed and collected your Corpus Christi Airport rental car, a short 9 kilometre drive will take you to the city centre. Here you can find a wide range of activities and attractions that are also very popular amongst the locals.
Corpus Christi Skate Park is a fun attraction. The park is open everyday until it gets dark and is situated in Cole Park which has great views of Corpus Christi Bay. Here guests can skate, fish at the parks pier, or simply enjoy a picnic in the designated area. USS Lexington on Shoreline Boulevard is a museum within the historical World War II aircraft carrier. Guests can have fun exploring the many levels and tunnels of the attraction and even try the flight simulator within the cockpit. Within the museum visitors can also find a gift store, Café named the Mess Deck Café and a theatre.
Texas State Aquarium is located on North Shoreline Boulevard and is open daily. Guests can come to the aquarium to see dolphin and wild flight presentations, you should arrive 15 minutes early due as the attraction is popular. Guests will also find many exhibits such as Dolphin Bay, Tortuga Cay featuring Sea Turtles and Otter Creek.