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-06-02:2028-06-02' 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','4259','4258','4251','4250','4232','4228','4225','4224','4223','4222','4221','4220','4215','4214','4208','4060','4059','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
$
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
$
Discover the beauty of India with this 13 Days India Tour Package covering the famous Golden Triangle (Delhi, Agra & Jaipur), the royal city of Udaipur, the spiritual charm of Varanasi, and the vibrant life of Mumbai. This journey offers history, culture, heritage, and unforgettable experiences with Monu Tours.
From
$
Experience the best of Mumbai with Monu Tours on this exciting 3 Nights / 4 Days Mumbai Tour Package. Visit famous attractions like Gateway of India, Elephanta Caves, Marine Drive, Dharavi Slum, Sanjay Gandhi National Park, and Gorai Beach while enjoying the vibrant culture and local life of Mumbai. For bookings and travel assistance, contact Monu Tours at 0091-7275602585.
From
$
Discover the beauty of Rajasthan with the 14 Nights 15 Days Rajasthan Tour Package by Monu Tours. Visit Jaipur, Udaipur, Jaisalmer, Jodhpur, Ranthambore, Pushkar, and more while enjoying forts, palaces, desert safari, tiger safari, lakes, and cultural experiences. Contact 0091-7275602585 for bookings.
From
$
Explore the beauty of South India with this Tamil Nadu Tour Package covering Chennai, Mahabalipuram, Puducherry, Ooty, Madurai, Kanyakumari, and more. Discover ancient temples, scenic hill stations, beaches, culture, and heritage during this unforgettable 16 Nights / 17 Days journey with Monu Tours.
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.