callert3lib_DB::exec_SELECTquery
ERRORYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tx_ltgtreecache_cache.num_ratings > 3
GROUP BY tx_ltgtreecache_cache.page' at line 4
lastBuiltQuerySELECT DISTINCT tx_ltgtreecache_cache.page_uid,tx_ltgtreecache_cache.url,tx_ltgtreecache_cache.ave_rating,tx_ltgtreecache_cache.num_ratings,pages.title,pages.subtitle,pages.crdate
FROM pages_tx_ltgdbstructures_propertytype_mm AS mm,tx_ltgtreecache_cache,pages
WHERE
mm.uid_local = pages.uid AND mm.uid_foreign IN (2816) AND AND tx_ltgtreecache_cache.num_ratings > 3
GROUP BY tx_ltgtreecache_cache.page_uid
ORDER BY tx_ltgtreecache_cache.ave_rating DESC
debug_backtracetslib_fe->intincscript // tslib_cobj->user // tslib_cobj->calluserfunction // call_user_method // tx_ltgextendedmenus_pi2->ts_getleftmenus // tx_ltgextendedmenus_pi2->_getboxforlistpages // ltgtree->gettopchildpages // t3lib_db->exec_select_queryarray // t3lib_db->exec_selectquery // t3lib_db->debug
La Ceiba Travel Guide - Plan your La Ceiba vacation. La Ceiba flights, tours & hotel reviews

Honduras V!VA List Articles

Ready to go to La Ceiba?

Been to La Ceiba?
Share your knowledge with other travelers.
What is this?
La Ceiba Ratings:
0%
Based on 0 Ratings
  
V!VA Travel Guides WIKI
Share your knowledge on the web and get your review published in our next printed guidebook! Find out more about us.

Close box

 

La Ceiba

+ Add a Photo

V!VA User‘s Description

Honduras’ third-largest city and the major jumping-off point to the Bay Islands, La Ceiba is also a growing center for eco-tourism and nightlife. Surrounded by a national park, a wildlife refuge and a marine reserve, tours are being offered more and more that emphasize the many hiking, rafting, bird watching and natural opportunities in the area.

 

Read more...

Places in La Ceiba

Tela

Sponsors
¿Llamé su atención?
También llamo la atención de sus clientes potenciales. El "Text Ad" es la herramienta más efectiva y simple para obtener más ventas online.
www.vivatravelguides.com/anuncio/text-ads/

All Activities in La Ceiba

ruta garifuna

Good place to get to know the Garifuna culture of Honduras, Guatemala, Nicaragua and Belize....

See all La Ceiba Things to do

Top Rated Hotels

Diving Pelican Inn

Luxurious and intimate three room inn on the beach at Playa Helen. All rooms have air conditioning, hot water, ...


100% - 5 ratings
$50.00 - $50.00

Coco Pando Resort Hotel


0% - 0 ratings
50 - 75

Lodging by Price

See all La Ceiba hotels

Top Rated Schools

Ixbalanque Spanish School

Whether you are a tourist visiting Central America, or a businessperson who wants to improve your Spanish skills...


100% - 2 ratings

Spanish language School

We tecah spanish on a one on one basis. Homestay with a Hoinduran family, private room, 3 meals per day. daily e...


0% - 0 ratings

bravo school

We tecah spanish on a one on one basis. Homestay with a Hoinduran family, private room, 3 meals per day. daily e...


-10% - 1 ratings
Great V!VA Travel Guides Books about La Ceiba

V!VA List Latin America, 333 Places and Experiences that People Love

Packed with tales of travels from Tijuana to Tierra del Fuego, this compilation provides firsthand knowledge about places to visit, things to do, and where to stay, as well as insight into local cultures and customs.
Get it from Amazon, Barnes&Noble or direct from V!VA.
Download free chapters from this book.
Download free Google Earth version chapters.

 
South America | Central America and Mexico | Africa | Europe | Oceania | Asia | Antarctica | North America |
Advertise | Anúnciese | Jobs | Alliances | Alianzas | Terms of Use | Useful Sites | Contact Us | About Us |
Seen our new book? VIVA List Latin America