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
Las Tunas Travel Guide - Plan your Las Tunas vacation. Las Tunas flights, tours & hotel reviews
Home > South America > Ecuador > The Southern Coast > Las Tunas
Been to Las Tunas?
Share your knowledge with other travelers.
What is this?
Las Tunas 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

 

Las Tunas

Tsafiki Cabins in Las Tunas
Tsafiki Cabins in Las Tunas
+ Add a Photo

See all Las Tunas Photos

V!VA User‘s Description

Las Tunas is a small beach town between Puerto Rico and Ayampe along the Ruta del Sol, about a 10-minute bus ride south of Pueto López. A very quiet town with a fair stretch of beach, Las Tunas is still in the very developmental stages, as far as tourism goes. If you come for a swim, wear water shoes as the beach can be fairly rocky.

Read more...

Sponsors
Ecuador Mountain Biking Tours - Aries Bike Company
Over 18 years of experience in Downhill, Mountain Biking and Hiking in Ecuador.Our tours take you around some of the most beautiful mountains and active volcanoes in the world.
www.ariesbikecompany.com
¿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/

Top Rated Hotels

Tsafiki Hostería

Tsafiki (or Tsafiky - it is spelled one way on the brochure and another on the main sign) just opened in Decembe...


83% - 23 ratings

Equus Erro Hostería

The seaside Equus Erro Hostería's main draw is its views. Almost all rooms have views of the sea. With seven ro...


100% - 1 ratings
$75 for a simple matrimonial room - $180 for a VIP suite that can sleep up to 6 and includes DirecTV, a kitchen, minibar and living room

Top Rated Restaurants

Tsafiki's Wahoo Restaurant

Located on the second floor of the main building in the Tsafiki Hostería with an outdoor porch overlooking the ...


62% - 2 ratings

GACEBO Equus Erro

Gacebo Equus Erro specializes in exquisitely prepared, gourmet seafood. The vast wine list presents endless poss...


100% - 1 ratings
Sponsors
Ecuador & Galapagos Tours with PTS
We are the #1 travel and tour operator for upscale cruises and soft-adventure vacation travel packages for Ecuador and the Galapagos Islands.
www.galapagoslegend.com
Great V!VA Travel Guides Books about Las Tunas
Buy the world's most up-to-date guidebook about Ecuador.
Get it from Amazon, Barnes&Noble or direct from V!VA.
Or download free chapters from this book.
Buy the world's most up-to-date guidebook about Peru.
Get it from Amazon or direct from V!VA.
Or download free chapters from this book.

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 |
Luna Runtun The Adventure Spa