Printer Friendly Version: Visitors

Visitors

 Share this page

Visitors

The draw of authentic Acadian culture, diverse environment and wildlife, plantation homes, excellent food, and close proximity to New Orleans, Baton Rouge and Lafayette make Houma-Terrebonne an excellent central location for the visitor who wishes to see all the sights and sounds of the bayou wonderland of South Louisiana.

SELECT _section_title, title, url, request_module, request_page, request_query, _menu_new_window FROM ( SELECT module_id AS _module_id, id AS _section_id, title AS _section_title, sort_order AS _section_sort_order FROM Navigation_Menu WHERE parent_id IS NULL AND show_on_internet=1 ) AS _SectionListing LEFT JOIN( SELECT parent_id AS _section_id, title, url, module_name AS request_module, request_page, is_new_window as _menu_new_window, request_query, sort_order AS _menu_sort_order FROM Navigation_Menu LEFT JOIN Navigation_Module ON Navigation_Module.module_id=request_module WHERE parent_id IS NOT NULL AND show_on_internet=1 AND parent_id in (371,373,374) ) AS _MenuListing ON _SectionListing._section_id=_MenuListing._section_id WHERE _module_id=44 and title is NOT NULL ORDER BY _section_sort_order, _menu_sort_order