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:2025-03-05:2027-03-05' 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 ('3078') )
) 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
Zanjan Dadamaan Hotel
Enghelab Square, South Saadi St., Chamani Alley, 3rd Dead-end Alley
From
€
Dadamaan traditional hotel is one of the oldest and most central parts of Zanjan. This beautiful hotel is the only traditional hotel in Zanjan province, and the building of this hotel is more than 200 years old.
Zanjan Park Hotel
Zanjan - Azadi Square
From
€
Zanjan Park Hotel is located in the heart of the city, near business centers and tourist attractions, and is one of the oldest hotels in this province.
Zanjan Sepehr Hotel
Zanjan – at the beginning of Gavazang Road - Sepehr Hotel
From
€
Zanjan Sepehr Hotel was built in2001. This hotel has 32 suites on 7 floors equipped with appropriate and desirable equipment and amenities.
Unfortunately no tours were found.
Unfortunately no cruises were found.
With Driver
From
150
€
The Kia Optima: A stylish mid-size sedan with a comfortable ride, advanced technology, and available hybrid and plug-in hybrid options.
With Driver
From
145
€
Lamari is a buzzword car brand which is synonymous with stylish looks and advanced tech for younger local consumers.
With Driver
From
80
€
The Peugeot 206, a popular and reliable hatchback car, enjoys widespread success in the Iranian automotive market. Known for its fuel efficiency, affordability, and stylish design, the 206 remains a favored choice among Iranian drivers.
With Driver
From
100
€
The Peugeot 207 is a stylish and popular super-mini car known for its distinctive design, comfortable interior, and agile handling.