Costa Rica Vacations Español

Forgot password?

Remember me

LOG IN

CREATE TEMPORARY TABLE IF NOT EXISTS Search_d3a51922558465d4022add0858be9fe3 AS SELECT t1.*, meta_c1.post_id AS room_id, meta_c2.meta_value AS max_adults, meta_c3.meta_value AS max_kids, meta_c4.meta_value AS minimum_stay
					FROM ( SELECT DISTINCT it2.element_id AS acc_id FROM (SELECT post_s1.ID AS acc_id FROM crv_2_posts AS post_s1 
						WHERE (post_s1.post_status = 'publish') AND (post_s1.post_type = 'accommodation')) AS t0
						INNER JOIN crv_2_icl_translations it1 ON (it1.element_type = 'post_accommodation') AND it1.element_id = t0.acc_id
						INNER JOIN crv_2_icl_translations it2 ON (it2.element_type = 'post_accommodation') AND it2.language_code='es' AND it2.trid = it1.trid  ) AS t1
					INNER JOIN crv_2_postmeta AS meta_c1 ON (meta_c1.meta_key = 'trav_room_accommodation') AND (t1.acc_id = meta_c1.meta_value)
					INNER JOIN crv_2_postmeta AS meta_c2 ON (meta_c1.post_id = meta_c2.post_id) AND (meta_c2.meta_key='trav_room_max_adults')
					LEFT JOIN crv_2_postmeta AS meta_c3 ON (meta_c1.post_id = meta_c3.post_id) AND (meta_c3.meta_key='trav_room_max_kids')
					LEFT JOIN crv_2_postmeta AS meta_c4 ON (t1.acc_id = meta_c4.post_id) AND (meta_c4.meta_key='trav_accommodation_minimum_stay') WHERE (meta_c2.meta_value >= 1) AND (meta_c2.meta_value + IFNULL(meta_c3.meta_value,0) >= 1 + 0) GROUP BY acc_id

SELECT t1.*, post_l1.post_title as acc_title, meta_rating.meta_value as review, meta_price.meta_value as avg_price FROM Search_d3a51922558465d4022add0858be9fe3 as t1
				INNER JOIN crv_2_posts post_l1 ON (t1.acc_id = post_l1.ID) AND (post_l1.post_status = 'publish') AND (post_l1.post_type = 'accommodation')
				LEFT JOIN crv_2_postmeta AS meta_rating ON (t1.acc_id = meta_rating.post_id) AND (meta_rating.meta_key = 'review')
				LEFT JOIN crv_2_postmeta AS meta_price ON (t1.acc_id = meta_price.post_id) AND (meta_price.meta_key = 'trav_accommodation_avg_price') WHERE  1=1 GROUP BY acc_id ORDER BY review DESC LIMIT 0, 15;

37 resultados encontrados.

Modificar búsqueda

Tu Destino

LLEGADA

SALIDA

Cuartos

123456789101112131415161718192021222324252627282930

Adultos

123456789101112131415161718192021222324252627282930

Niños

012345678910

Age of Children

Child 1

01234567891011121314151617

busca de nuevo

Precio (promedio/noche)

Opiniones de usuarios

Todos

Tipo de Alojamiento

• Todos(37)

Comodidades

Ordenar resultados por:

• nombre
• precio
• clasificación

Doubletree Resort Todo Incluído

Comentarios

El Doubletree Resort forma parte de la famosa cadena hotelera, el Hilton. Ubicado en Puntarenas a lo largo de la

Promedio/noche120.00 SELECCIONAR

Aguila de Osa Inn

Comentarios

Ubicado en uno de los lugares con/de mayor biodiversidad del planeta (según el National Geographic), este “Boutique Hotel” ofrece a

Promedio/noche442.00 SELECCIONAR

Xandari Resort & Spa

Comentarios

Xandari is a resort and spa in Alajuela, close to the International Airport. This hotel is a tropical paradise with

Promedio/noche195.00 SELECCIONAR

Jardin del Eden

Comentarios

Jardin del Eden is situated in Tamarindo Beach, on Costa Rica’ s north Pacific Coast. This hotel offers amazing ocean

Promedio/noche140.00 SELECCIONAR

Springs Resort y Spa

Comentarios

The Springs is a luxury resort and spa located in Arenal and according to CNN it’s one of the seven

Promedio/noche425.00 SELECCIONAR

Four Seasons Resort

Comentarios

El Four Seasons Resort en Costa Rica está ubicado a lo largo de la Costa Pacífica en Papagayo, Guanacaste. Un

Promedio/noche450.00 SELECCIONAR

Arenal Kioro

Comentarios

Arenal Kioro sits on 27 acres of undulating land viewing the Arenal Volcano. With nature paths and thermal hot springs

Promedio/noche375.00 SELECCIONAR

Club del Mar

Comentarios

Club del Mar is a resort and condominium positioned in Jaco, a popular beach town on Costa Rica`s Pacific Coast.

Promedio/noche115.00 SELECCIONAR

Arenal Paraiso Hotel & Spa

Comentarios

Arenal Paraiso is a hotel and spa located in Alajuela that views the Arenal Volcano (one of the top must-see

Promedio/noche85.00 SELECCIONAR

Trapp Family Lodge

Comentarios

Trapp Family Lodge is the nearest hotel to Monteverde Reserve, a protected area with the most bountiful biodiversity in Costa

Promedio/noche100.00 SELECCIONAR

Costa Rica Marriott

Comentarios

Costa Rica Marriott is part of a renowned luxury hotel chain. Located in La Ribera de Belen in Heredia, just

Promedio/noche139.00 SELECCIONAR

Arenal Nayara

Comentarios

Arenal Nayara is a luxury boutique hotel, widely recognized for it’s premium amenities and ultra-personalized service. Located in the outskirts

Promedio/noche230.00 SELECCIONAR

La Mansion Inn

Comentarios

When someone thinks about a hotel in a tropical country like Costa Rica they think about an ocean view, luxury

Promedio/noche175.00 SELECCIONAR

Si Como No

Comentarios

Perched upon the oceanfront terraces of Costa Rica’s Central Pacific in Manuel Antonio, Si Como No Resort, Spa & Wildlife

Promedio/noche205.00 SELECCIONAR

Hotel Parador

Comentarios

A «parador» is a hotel with a European style to their design and the Parador Hotel in Manuel Antonio is

Promedio/noche210.00 SELECCIONAR

• 1
• 2
• 3
• Siguiente