Baku, the capital and commercial hub of Azerbaijan, is a low-lying city with coastline along the Caspian Sea. It's famed for its medieval walled old city, which contains the Palace of the Shirvanshahs, a vast royal complex.
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-12:2026-12-12' 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 ('58') )
) 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.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
TOUR HIGHLIGHTED :
Baku trip Package from Pakistan
Day 1 : Arrival In Baku
On Arrival at baku international Airport pick up and Transfer in Hotels Check in hotel over night at hotel.
Day 2 Excursion through Baku and Old Town
Today’s excursion starts at the upland park – the spectacular place where you can enjoy an unsurpassed view of the city.Our next stop is Old Town. Here, on the hill and in front of Caspian Sea, the ancient city was born. Several dozens of historically architectural monuments are located in the territory of Old Town (UNESCO’s World Heritage): Palace of Shirvanshahs, Maiden Tower, Museum of Miniature Books, caravansaries, mosques, baths, etc.
Day 3 : Full Day Tour Gabba and Shamakhi
Breakfast at the hotel Today we leave for the mountain regions of Azerbaijan Arrival in a rich heritage town of Shamakhi. It provided the backdrop to major political events throughout much of its two millennia of existence. Being a capital of the Shirvanshahs state from the 9th century, it was one of the main towns along “The Great Silk Way”. During the excursion you visit architectural monuments such as Juma Mosque, Diri-Baba Mausoleum. Shamakhi delivers us to the greater Caucasus marvel Gabala through Ismayilli. Over Night At Baku Hotel
Day 4:Departure
After Breakfast Check out from hotel Transfer to Baku International Airport (in case of late departure, suitcases can be left in the hotel)