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 ('2329') )
) 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
2, 16, W Patel Nagar Rd, Block 4, Near, Karol Bagh, New Delhi, Delhi 110008
From ₹
Hotel Amrapali Grand is a good choice for travellers looking for a 4 star hotel in Delhi. It is located in Pusa road. Hotel is rated 3.9 out of 5, which is considered as good.
1, 10, Patel Rd, Block 1, West Patel Nagar, Shadipur, New Delhi, 110008
From ₹
Hotel Golden Grand is an Excellent Boutique Hotel, which is strategically located in the Key Corporate Zone of Central Delhi and is just few minutes away from Commercial Business District of Rajendra Place
2/6, Pusa Rd, opposite Metro Pillar No. 167, Block 2, East Patel Nagar, Karol Bagh, New Delhi, Delhi 110008
From ₹
Hotel Regent Grand, a Centrally Air-conditioned luxury hotel located in Central Delhi, welcomes business and leisure travelers to experience the grandeur of Indian hospitality. Hotel Regent Grand has won laurels for highest quality luxurious accommodation and excellence in dining, interiors, business facilities and personalized services.
