SELECT wpfa_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpfa_postmeta price_meta2 WHERE price_meta2.post_id=wpfa_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-08-16:2028-08-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpfa_postmeta price_meta3 WHERE price_meta3.post_id=wpfa_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpfa_posts INNER JOIN wpfa_postmeta ON ( wpfa_posts.ID = wpfa_postmeta.post_id )
WHERE 1=1 AND (
( wpfa_postmeta.meta_key = 'accommodation_location_post_id' AND wpfa_postmeta.meta_value IN ('5635') )
) AND wpfa_posts.post_type = 'accommodation' AND ((wpfa_posts.post_status = 'publish'))
GROUP BY wpfa_posts.ID HAVING 1=1
ORDER BY wpfa_posts.post_title ASC
Unfortunately no accommodations were found.
11 Days in Ecuador
Quito • Cotopaxi • Baños • Riobamba • Cuenca • Guayaquil • Galápagos Islands
From
$
Experience Ecuador from the colonial streets of Quito and spectacular Avenue of the Volcanoes to the waterfalls of Baños, historic Cuenca and the extraordinary wildlife of the Galápagos Islands.
3 Days in Lima
Lima
From
$
Discover Peru's vibrant capital through its celebrated cuisine, colonial heritage and fascinating pre-Hispanic history. Explore colourful neighbourhoods, local markets, historic landmarks and one of Latin America's outstanding archaeological collections.
4 Days Arequipa & Colca Canyon
Arequipa • Chivay • Colca Canyon
From
$
Discover the colonial beauty of Arequipa before travelling deep into the Andes to experience spectacular Colca Canyon, traditional villages, volcanic landscapes and the majestic flight of the Andean condor.
5 Days in Chachapoyas
Chachapoyas
From
$
Journey into the cloud forests of northern Peru and discover the mysterious legacy of the ancient Chachapoya civilisation. Explore dramatic cliffside sarcophagi, the monumental fortress of Kuélap, ancient mausoleums and an extraordinary collection of archaeological treasures.
6 Days Cusco, Sacred Valley & Machu Picchu
Cusco • Sacred Valley • Machu Picchu
From
$
Something incredible is waiting to be known a very small stage in a vast cosmic arena of stellar alchemy and invent the universe.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.