Yogyakarta
Yogyakarta, often referred to as Jogja, is a vibrant city located on the island of Java, Indonesia. It is renowned for its rich cultural heritage, historical significance, and as a hub of traditional Javanese arts and education. Here's some general information about the city:
- Cultural and Historical Significance: Yogyakarta is the cultural heart of Java, known for being one of the few cities in Indonesia with a Sultanate, and home to the Kraton (Sultan’s Palace), where the Sultan still resides. The city is a center for Javanese culture, traditional dance, batik art, and gamelan music. Yogyakarta is also in close proximity to two UNESCO World Heritage Sites, the Borobudur Temple, the largest Buddhist temple in the world, and the Prambanan Temple, a stunning Hindu temple complex.
- Education Hub: Yogyakarta is also a center for education, often called the "City of Students" due to the presence of many prestigious universities and educational institutions, including Gadjah Mada University, one of Indonesia's top universities.
- Tourism: Yogyakarta attracts both domestic and international tourists with its blend of ancient temples, cultural experiences, and natural beauty. It offers attractions like Mount Merapi, an active volcano popular with hikers, and beautiful beaches like Parangtritis on the southern coast. The bustling Malioboro Street is famous for its shopping, street food, and handicrafts.
- Local Cuisine: The city is famous for its traditional dishes, particularly Gudeg, a slow-cooked sweet jackfruit stew, and other local delicacies like Bakpia and Kopi Joss (charcoal coffee).
- Accessibility: Yogyakarta is easily accessible by air, train, and bus. Yogyakarta International Airport connects the city to major domestic and international destinations.
SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2025-07-11:2027-07-11' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_id AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('7449') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'e-floating-buttons','location','review','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','shop_order_refund','shop_order_placehold','whatsapp-accounts' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-floating-buttons','elementor_library','location','review','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','shop_order_placehold','wpcf7_contact_form','mc4wp-form','whatsapp-accounts' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-floating-buttons','elementor_library','location','review','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','shop_order_placehold','wpcf7_contact_form','mc4wp-form','whatsapp-accounts' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
PROMO
From
$
From the landscapes of Sumatra to cultural riches of Java and serene beauty of Bali, this trip offers an unforgettable glimpse, extraordinary adventure and soul of Indonesia.
Unfortunately no cruises were found.
