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:2026-05-14:2028-05-14' 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 ('4055','4060','4059','4058','4057','4056') )
) 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
From
$
Hotel Suryauday Haveli is a beautiful heritage hotel located on the banks of the River Ganga in Varanasi. Known for its peaceful atmosphere, river-view rooms and rooftop restaurant, the hotel offers a comfortable stay close to Assi Ghat and Kashi Vishwanath Temple. For booking assistance or questions, contact Monu Tours at +91-7275602585.
From
$
Experience India’s famous Golden Triangle with Monu Tours on a 5 Nights 6 Days tour covering Delhi, Agra, and Jaipur. Visit the Taj Mahal, forts, palaces, temples, and heritage sites. Call 0091-7275602585 for bookings.
From
$
Book comfortable Maruti Suzuki Dzire taxi service across India with Monu Tours. Ideal for airport transfers, city sightseeing, outstation trips and India tour packages with professional drivers and affordable pricing. For booking assistance, contact +91-7275602585.