Dehradun City Airport
Dehradun Airport, also known as Jolly Grant Airport, is a domestic airport serving Dehradun, the capital of Uttarakhand, India. It is located in Jauligrant, 25 km south of the city, 20 km from Rishikesh and 35 km from Haridwar.
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-12-23:2026-12-23' 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 ('168') )
) 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.
From
₹
Also known as the 'Adobe of Drona', Dehradun has always been an important center for Garhwal rulers which was captured by the British. The headquarters of many National Institutes and Organizations like ONGC, Survey Of India, Forest Research Institute, Indian Institute of Petroleum etc are located in the city.
Special
Mussoorie Tour Package
Mussoorie, Uttarakhand, India
From
₹
Nestled in the foothills of the Himalayas, Mussoorie is a picturesque hill station in Uttarakhand, India. Popularly known as the "Queen of the Hills," it boasts stunning panoramic views, lush greenery, and a pleasant climate, making it a favored destination for tourists seeking respite from the heat of the plains.
Tempo
From
₹
Spacious Interiors: The 16-seater Tempo Traveller boasts expansive interiors, ensuring each passenger has enough legroom and comfort during the trip. The spaciousness of the vehicle makes long journeys more enjoyable.