It's whale watching season in Costa Rica at Playa Nicuesa when hundreds of humpback whales in Costa Rica return to the gulf of Golfo Dulce from July through September.
SELECT wplb_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wplb_postmeta price_meta2 WHERE price_meta2.post_id=wplb_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-10-11:2026-10-11' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wplb_postmeta price_meta3 WHERE price_meta3.post_id=wplb_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wplb_posts INNER JOIN wplb_postmeta ON ( wplb_posts.ID = wplb_postmeta.post_id )
WHERE 1=1 AND (
( wplb_postmeta.meta_key = 'accommodation_location_post_id' AND wplb_postmeta.meta_value IN ('633') )
) AND wplb_posts.post_type = 'accommodation' AND ((wplb_posts.post_status = 'publish'))
GROUP BY wplb_posts.ID HAVING 1=1
ORDER BY wplb_posts.post_title ASC
Unfortunately no accommodations were found.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
Golfo Dulce, Costa Rica
The clear blue waters of the Golfo Dulce separate the Osa Peninsula and its natural wonders from the Costa Rican mainland. Surfers flock to the Gulf’s secluded beaches, and visitors to the tropic forest of Piedras Blancas National Park may run into scarlet macaws, howler monkeys, and the imposing but shy tapir. Golfo Dulce itself teems with sporting dolphins, and is even visited by the occasional whale