Costa Rica Vacations

Forgot password?

Remember me

LOG IN

CREATE TEMPORARY TABLE IF NOT EXISTS Search_799b4a2f9fd78bca42d623b81377c2ed 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_799b4a2f9fd78bca42d623b81377c2ed 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 cast(avg_price as unsigned) DESC LIMIT 0, 15;

30 results found.

Modify Search

Your Destination

CHECK IN

CHECK OUT

Rooms

123456789101112131415161718192021222324252627282930

Adults

123456789101112131415161718192021222324252627282930

Kids

012345678910

Age of Children

Child 1

01234567891011121314151617

search again

Price (avg/night)

User Rating

All

Accommodation Type

• All(30)
• Apartment(0)
• Hostel(0)
• Hotel(30)
• Packages(0)

Amenities

• WI_FI(16)
• SPA(18)
• SWIMMING POOL(11)
• FIRE PLACE(0)
• AIR CONDITIONING(4)
• FITNESS FACILITY(3)
• BEACHFRONT(9)
• COFFEE(2)
• DOORMAN(0)
• CONFERENCE ROOM(0)
• PLAY PLACE(0)
• COMPLIMENTARY BREAKFAST(2)
• HANDICAP ACCESSIBLE(1)
• ROOM SERVICE(0)
• TELEVISION(4)
• FREE PARKING(1)
• SUITABLE FOR EVENTS(0)
• BEACH(5)
• TELEPHONE(3)
• FRIDGE(1)
• BAR/LOUNGE(4)
• PICK AND DROP(0)
• SECURE VAULT(0)
• SMOKING ALLOWED(1)
• ALL INCLUSIVE(3)
• PRIVACY AND SECURITY(2)
• ELEVATOR IN BUILDING(0)
• ENTERTAINMENT(1)
• HOT TUB(0)
• PETS ALLOWED(0)
• GOLF(2)
• INFINITY POOL(2)
• GYM(2)
• Fast internet access(0)
• Hot water(0)
• Fan(0)
• Cable TV(0)
• Minibar(0)
• Coffee Machines(0)
• Restaurant(0)
• WINE BAR(0)
• OCEANFRONT DINING(1)

Sort results by:

• name
• price
• rating

Tortuga Lodge

Tortuguero Costa Rica

0 reviews

Tortuga Lodge is a boutique hotel in Tortuguero on the north-Caribbean side of Costa Rica. This hotel is close to

avg/night$618.00 SELECT

Aguila de Osa Inn

Osa Peninsula Costa Rica

1 reviews

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

avg/night$611.00 SELECT

The Springs Resort and Spa

Arenal Costa Rica

0 reviews

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

avg/night$490.00 SELECT

Arenal Nayara

Arenal Costa Rica

0 reviews

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

avg/night$443.00 SELECT

Arenas del Mar Hotel

Manuel Antonio Costa Rica

0 reviews

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

avg/night$400.00 SELECT

Arenal Kioro

Arenal Costa Rica

0 reviews

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

avg/night$288.00 SELECT

Finca Rosa Blanca Coffee Plantation Resort

Heredia Costa Rica

0 reviews

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

avg/night$280.00 SELECT

Punta Islita Resort

Punta Islita Costa Rica

0 reviews

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

avg/night$255.00 SELECT

Xandari Resort & Spa

Alajuela Costa Rica

0 reviews

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

avg/night$254.00 SELECT

Si Como No

Manuel Antonio Costa Rica

0 reviews

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

avg/night$250.00 SELECT

Parador Hotel

Manuel Antonio Costa Rica

0 reviews

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

avg/night$250.00 SELECT

Jardin del Eden

Tamarindo Costa Rica

0 reviews

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

avg/night$239.00 SELECT

Royal Corin

Arenal Costa Rica

0 reviews

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

avg/night$238.00 SELECT

Grano de Oro

San Jose Costa Rica

0 reviews

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

avg/night$225.00 SELECT

The Westin Golf Resort & Spa

Playa Conchal Costa Rica

0 reviews

The Westin Golf Resort & Spa is an all-inclusive resort that sits on 2400 acres in Playa Conchal. Between sparkling

avg/night$224.00 SELECT

• 1
• 2
• Next