SELECT wpnk_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpnk_postmeta price_meta2 WHERE price_meta2.post_id=wpnk_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-04-26:2027-04-26' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpnk_postmeta price_meta3 WHERE price_meta3.post_id=wpnk_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpnk_posts INNER JOIN wpnk_postmeta ON ( wpnk_posts.ID = wpnk_postmeta.post_id )
WHERE 1=1 AND (
( wpnk_postmeta.meta_key = 'accommodation_location_post_id' AND wpnk_postmeta.meta_value IN ('2408') )
) AND wpnk_posts.post_type = 'accommodation' AND ((wpnk_posts.post_status = 'publish'))
GROUP BY wpnk_posts.ID HAVING 1=1
ORDER BY wpnk_posts.post_title ASC
50, Niti Marg, Diplomatic Enclave, Chanakyapuri, New Delhi, Delhi 110021
From ₹
From all the 5 Star hotels in Delhi, The Ashok is very much popular among the tourists. A smooth check-in/check-out process, flexible policies and friendly management garner great customer satisfaction for this property.
Plot No. 50B, Kautilya Marg, Chanakyapuri, New Delhi, Delhi 110021
From ₹
Hotel Samrat’s structure built around a center flower-filled atrium an open-air courtyard lives up to the concept of a luxury hotel. The hotel has a choice of 255 rooms with a Pan-Asian restaurant “SHIRO,” a multicuisine restaurant ‘CHAKRAAS.”
