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 (3328) 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
Peruvian Andes- Northern Travel Guide - Plan your Peruvian Andes- Northern vacation. Peruvian Andes- Northern flights, tours & hotel reviews
Home > South America > Peru > Peruvian Andes- Northern

Ready to go to Peruvian Andes- Northern?

Been to Peruvian Andes- Northern?
Share your knowledge with other travelers.
What is this?
Peruvian Andes- Northern 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

 

Peruvian Andes- Northern

+ Add a Photo

By John Howison

The Northern Peruvian Highlands are one of Peru’s least traveled areas, but not for lack of attractions. The Andes climb up from the coast and descend into the Amazon and in the middle lay the Chachapoyas and Cajamarca regions of Peru. Chachapoyas is surrounded by recently discovered Incan ruins while Cajamarca is dotted with classic colonial architecture. The beauty of the two areas of Peru is that they are much less visited than other colonial and ruin destinations in Peru. The lack of visitors is not the result of less-than-spectacular attractions, but almost entirely to do with the windy, bumpy and generally shoddy roads that lead into the region.

Read more...

All Activities in Peruvian Andes- Northern

InkaNatura Travel - Tours

Offers interesting trips that combine the best of Cajamarca with Chiclayo (Tucume, Royal tombs Museum)...

Inca Baths

Legend has it that when the Spanish Conquistadores arrived in Cajamarca, Inca Atahualpa was relaxing i...

Levanto and Yálape

Yálape, built 1100-1350 A.D., was a major Chachapoya city. During Inca rule it served as the regionâ...

Top Rated Hotels

Hospedaje Jenny

Hospedaje Jenny is a no-frills, friendly inn that offers habitaciones for one or two persons. All rooms are goo...


75% - 1 ratings
6 soles /$2 - 8 soles /$2.60

Hostal Continental

Labyrinthine hallways lead to the rooms of the Hostal Continental. Almost every type of habitación is offered ...


75% - 2 ratings
15 soles /$5 - 55 soles /$18.30

Hotel Casa Blanca

Located right on the Plaza de Armas, the Casa Blanca is a good option for those who’d like to stay in Caja...


75% - 1 ratings

Top Rated Restaurants

Nature’s Center New Eden

The only "meat" served at New Eden is soya prepared with traditional Peruvian recipes. The lunch and dinner menÃ...


75% - 1 ratings

Restaurant-Pollería El Sabor Chiclayano

Lunch and suppertimes are busy in this large, well-lit restaurant. The waitresses are quick and attentive. Lunch...


50% - 1 ratings

Mari Pizza

This two-room pizza parlor is a beloved Chachapoyas meeting place. If one of the 14 varieties of pizza Mari offe...


100% - 1 ratings

Top Rated Tours

Cumbe Mayo Tours

One of several tour companies with their offices on the plaza, Cumbe Mayo Tours offers inexpensive half-day tour...


100% - 1 ratings

Panorama Viajes

Panorama Viajes offer a few different tour options to Cajamaraca and the surrounding areas. The agency was found...


0% - 0 ratings

Chachapoyas Tours SAC

Chachapoyas Tours offers the full gamut of tours available in northern Peru. Available are archeological tours, ...


0% - 0 ratings

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