Costa Rica Vacations EspañolCosta Rica Vacations Español
Forgot password?

Buscar resultados de alojamiento por:

  • Inicio
  • accommodation RESULTADOS DE LA BÚSQUEDA
CREATE TEMPORARY TABLE IF NOT EXISTS Search_02ad48e4ba42a27ce3443b40d7762fb9 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_02ad48e4ba42a27ce3443b40d7762fb9 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 cast(avg_price as unsigned) ASC LIMIT 15, 15;

37 resultados encontrados.

Modificar búsqueda


Todos

Ordenar resultados por:

Villa Blanca in the Cloud Forest Reserve

Situated amongst the Los Angeles Cloud Forest Reserve, sits one of Costa Rica’s most prestigious and desirable wedding/honeymoon destinations. Villa

Promedio/noche$170.00 SELECCIONAR
villa caletas
Comentarios

Villa Caletas is a luxury boutique hotel located on a rainforest hilltop in Jaco with a Tropical Victorian Architecture that

Promedio/noche$170.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/noche$175.00 SELECCIONAR
Tango mar beach view
Comentarios

In 150 acres of garden and over a mile of private beach sits Tango Mar, a luxury hotel and resort.

Promedio/noche$185.00 SELECCIONAR
laguna lodge pool
Comentarios

Laguna Lodge is an eco-tourism hotel located in Tortuguero. While it sits on fifteen acres of trees and tropical plants,

Promedio/noche$189.00 SELECCIONAR
Xandari
Comentarios

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

Promedio/noche$195.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/noche$205.00 SELECCIONAR
Romance parador hotel
Comentarios

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

Promedio/noche$210.00 SELECCIONAR
el establo
Comentarios

Sitting in Monteverde (one of the most bio-diverse places in the world), El Establo is a four-star hotel that combines

Promedio/noche$215.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/noche$230.00 SELECCIONAR

El Westin Golf Resort & Spa es un complejo todo incluido de unas 970 hectáreas en Playa Conchal. Entre aguas

Promedio/noche$235.00 SELECCIONAR
Comentarios

Asclepios is a Hotel & Spa dedicated to the Greek God of Health who was known for his gift to

Promedio/noche$260.00 SELECCIONAR
Arenas del Mar pool side
Comentarios

Arenas del Mar is located a few minutes away from Manuel Antonio National Park, an extraordinary place full of tropical

Promedio/noche$270.00 SELECCIONAR