Bogor
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=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.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 )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('7821') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Unfortunately no accommodations were found.
BOGOR
![Kampunt Turis Sentul 1](https://inn2travel.com/wp-content/uploads/2023/08/Kampunt-Turis-Sentul-1-400x300.jpg)
From
Rp
Only an hour from Jakarta discover the hidden treasures of Kampung Turis Sentul Bogor. Explore its waterfalls, culture,culinary and beautiful landscapes.
BOGOR
![Kampung Turis 15](https://inn2travel.com/wp-content/uploads/2023/08/Kampung-Turis-15-400x300.jpg)
From
Rp
In Sentul Tourist Village you are not only invited to enjoy the beauty of nature or see the local culture, but you will indirectly help improve the village economy.
BOGOR
![Kampung Turis 23](https://inn2travel.com/wp-content/uploads/2023/08/Kampung-Turis-23-400x300.jpg)
From
Rp
With Pawon Experience you will explore Kampung Turis Sentul to cook traditional Sundanese cuisine and looking for the ingredients with beautiful scenery.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.