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
Juliaca Travel Guide - Plan your Juliaca vacation. Juliaca flights, tours & hotel reviews
Home > South America > Peru > Lake Titicaca > Juliaca
Been to Juliaca?
Share your knowledge with other travelers.
What is this?
Juliaca 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

 

Juliaca

+ Add a Photo

By Ricardo Segreda

 

Lacking the glorious lake views and cultural fanfare of Puno, Juliaca has assumed the role of commercial travel conduit. What it lacks in cultural attractions, however, it makes up for in convenience. Despite its unattractive appearance, Juliaca has the closest airport to Lake Titicaca and rail and highway connections to Puno, Arequipa, and Cusco. The roads originating from Juliaca are also conducive to making the trek to Bolivia along the serpentine backroads winding their way along the northern shores of Lake Titicaca. If you decide to spend the night here, the best hotels and services are located near Plaza Bolognesi, where you can also find the train station.

Read more...

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/

Top Rated Hotels

The Royal Inn

A three-star hotel, the Royal Inn is Juliaca’s most upscale accommodation. Rooms come with room service, heati...


89% - 2 ratings

Hotel Sakura

This two-star facility offers good rooms, private bathrooms, hot water, cable TV, fax services, and breakfast. S...


0% - 0 ratings

Hostal Luquini

Here you have the option of a single room for only $5, with no private bathroom, or for $10 with. A double with ...


0% - 0 ratings

Top Rated Restaurants

Confiteria Meli Melo

If in Juliaca you feel your diet is challenged by a massive carbohydrate craving, you can resist it or you can v...


100% - 1 ratings

Royal Inn Restaurant

Part of the three-star Royal Inn, the restaurant matches the rest of the hotel; its clean, upscale interior cons...


0% - 0 ratings

Bar Restaurant Trujillo

A favorite among locals in Juliaca, this moderately large restaurant, capable of seating 70, features 200 menu i...


0% - 0 ratings

Top Rated Tours

General Service Agent Travel Agency

A short walk from the Plaza Bolognesi, General Service Agent can book tours to some of the more interesting dest...


0% - 0 ratings

Great V!VA Travel Guides Books about Juliaca
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 |