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

Search Accommodation Results for: 

CREATE TEMPORARY TABLE IF NOT EXISTS Search_a837edb63c2c7662b8dd654590f52eac 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_a837edb63c2c7662b8dd654590f52eac 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 acc_title ASC LIMIT 15, 15;

37 results found.

Modify Search


All

Sort results by:

Pool of Finca Rosa Blanca in Santa Barbara

Finca Rosa Blanca is a country inn that has been constructed in over four hectares of private property which includes

avg/night$250.00 SELECT
Four Seasons ocean view

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

avg/night$450.00 SELECT
Grano de Oro
reviews

In the heart of San Jose, Grano de Oro is a boutique hotel with luxury rooms that converts a Victorian

avg/night$135.00 SELECT
mimos hotel
reviews

Mimos Hotel is in Manuel Antonio, Costa Rica’s hot-spot for tourism, surfers and nature lovers. With a famous natural reserve

avg/night$50.00 SELECT
Romance parador hotel
reviews

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

avg/night$210.00 SELECT
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

avg/night$170.00 SELECT
Jardin del Eden swimming pool
reviews

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

avg/night$140.00 SELECT
JW Marriott Guanacaste

El JW Marriot Guanacaste Resort es un complejo de lujo en Santa Cruz, Guanacaste. El JW Marriott Guanacaste no solo

avg/night$269.00 SELECT
La mansion inn
reviews

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

avg/night$175.00 SELECT
laguna lodge pool
reviews

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

avg/night$189.00 SELECT
Poco a Poco in Monteverde

A few minutes from one of Costa Rica’s most famous cloud forest reserve, Monteverde, sits Poco a Poco Hotel &

avg/night$135.00 SELECT
Punta Islita Pool

Perched above a secluded cove along the Pacific Coast of Guanacaste, sit one of the finest eco-friendly luxury hotels; Punta

avg/night$320.00 SELECT
Royal Corin
reviews

Royal Corin is located in Arenal, a popular tourist area because of the Arenal Volcano (most active volcano in Costa

avg/night$299.00 SELECT
Si como no
reviews

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

avg/night$205.00 SELECT
The Springs in Arenal

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

avg/night$425.00 SELECT