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
Montañita Travel Guide - Plan your Montañita vacation. Montañita flights, tours & hotel reviews
Been to Montañita?
Share your knowledge with other travelers.
What is this?
Montañita Ratings:
94%
Based on 13 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

 

Montañita

Sunset at La Punta, Montañita
photo by Dawn Wohlfarth
Sunset at La Punta, Montañita photo by Dawn Wohlfarth
+ Add a Photo

See all Montañita Photos

V!VA User‘s Description

Montañita is a lively beach town with a reputation for its plethora of parties, surfers and hippies. About three and a half hours north of Guayaquil along the Ruta del Sol, Montañita is one of the few Ecuadorian beach towns with a great selection of international restaurants and hostels for all budgets. Central Montañita is about ten minutes south (walking) of the best surfing spot, La Punta. There are hostels and restaurants in both places. La Punta tends to be much more quiet at night when parties are raging in the center of town. Likewise, the town becomes ghostlike until the sun is high in the sky while surfers are tearing up the waves at La Punta.

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

Angauel Hostería Playa Rosada

Hostería Playa Rosada is located on a remote streath of Costa del Sol beach, about three kilometers north of Pa...


98% - 5 ratings

Hostal Papaya

The best rooms at Hostal Papaya are upstairs. There are a few downstairs rooms, one with a shared bath that kno...


87% - 22 ratings
Price per person for shared bath $3, private bath $5 - Price per person for shared bath $6, private bath $8. National Holidays, $15 per person.

Tierra Prometida

Run by a young, energetic group of Israeli friends, Tierra Prometida (Promised Land) is hip, new, fun and always...


83% - 31 ratings
5 - 20

Top Rated Restaurants

La Casa Blanca Restaurante

The restaurant on the first floor of La Casa Blanca features a fair amount of veggie cuisine including the best ...


83% - 7 ratings

Hola Ola Restaurante

The Hola Ola Restaurante is part of Tierra Prometida. Along with excellent breakfasts, steak, seafood and burge...


80% - 14 ratings

Restaurant Zoociedad

An Ecuadorian Italian fusion restaurant with cuisine like nowhere else on the Ecuadorian coast, Zoociedad has de...


70% - 7 ratings

Top Rated Schools

Learn Spanish Montanita Spanish School

Montanita Spanish School is located right on the main beach of Montanita. It offers classes from total beginner ...


100% - 3 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

Traveler Reviews of Montañita

excellent

Rating: 100%

Absolutely loved it. Great staff. I was traveling alone and they made me feel like I was part of the family.

By V!VA User from Canada, Nov 12, 2007

don pepe

Rating: 100%

dpnm èè yeahh

By V!VA User from argentina, May 27, 2007

HOTEL PARADISE SOUTH

Rating: 0%

THIS HOTEL IS NOT COOL. THE EMPLOYEE STOLE OUR CAMERA AND MONEY AND STILL TRIED TO DENY IT AFTER WE CAUGHT HIM RED HANDED. THERE IS NO POLICE IN TOWN. WE ARE NOT HAPPY WITH MONTANITA. THE PEOPLE HERE ARE FAKE AND PATHETIC. NO ONE HAS A BUENA ONDA. SKIP THIS PLACE.

By Anne Welcenbach from NICE FRANCE, May 16, 2007

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