Costa Rica VacationsCosta Rica Vacations
Forgot password?

Search Accommodation Results for:

CREATE TEMPORARY TABLE IF NOT EXISTS Search_fe43f7804555dabf1302491c61315d89 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_posts AS post_s1 
						WHERE (post_s1.post_status = 'publish') AND (post_s1.post_type = 'accommodation')) AS t0
						INNER JOIN crv_icl_translations it1 ON (it1.element_type = 'post_accommodation') AND it1.element_id = t0.acc_id
						INNER JOIN crv_icl_translations it2 ON (it2.element_type = 'post_accommodation') AND it2.language_code='en' AND it2.trid = it1.trid  ) AS t1
					INNER JOIN crv_postmeta AS meta_c1 ON (meta_c1.meta_key = 'trav_room_accommodation') AND (t1.acc_id = meta_c1.meta_value)
					INNER JOIN crv_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_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_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_fe43f7804555dabf1302491c61315d89 as t1
				INNER JOIN crv_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_postmeta AS meta_rating ON (t1.acc_id = meta_rating.post_id) AND (meta_rating.meta_key = 'review')
				LEFT JOIN crv_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;

Sort results by:

Aguila de Osa Beautiful rustic bedroom
avg/night$611.00

Aguila de Osa Inn
Osa Peninsula Costa Rica

Situated in one of the most bio-diverse and intense places on the planet (according to National Geographic) this boutique hotel

Xandari
avg/night$254.00

Xandari Resort & Spa
Alajuela Costa Rica

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

Jardin del Eden swimming pool
avg/night$239.00

Jardin del Eden
Tamarindo Costa Rica

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

arenal kioro
avg/night$288.00

Arenal Kioro
Arenal Costa Rica

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

Club del Mar in Jaco
avg/night$143.00

Club del Mar
Jaco Costa Rica

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

Arenal Nayara
avg/night$443.00

Arenal Nayara
Arenal Costa Rica

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

Si como no
avg/night$250.00

Si Como No
Manuel Antonio Costa Rica

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

Romance parador hotel
avg/night$250.00

Parador Hotel
Manuel Antonio Costa Rica

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

Villa Blanca in the Cloud Forest Reserve
avg/night$190.00

Villa Blanca Cloud Forest Hotel
San Ramon Costa Rica

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