Пользуясь сайтом krouz-tour.ru, Вы автоматически принимаете правила передачи и обработки персональных данных.
г. Пенза, ул. Кирова, 55А, офис 14
(ТЦ "Славянский", 3 этаж)
Карта проезда
Пн-Пт с 10:00 до 18:00
Перерыв с 13:00 до 14:00
Сб-Вс: выходной
тел. экстренной связи
8 909 315 44 37
г. Заречный Пензенской обл.,
ул. Комсомольская, 1, оф. 100
Пн - Пт с 10:00 до 18:00
Перерыв: с 13:00 до 14:00
Сб-Вс: выходной
+7 (8412) 65-45-46

 +7 960 326 42 77
+79603264277

SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3555, 3632) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3674, 3675, 3676) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3505, 3506) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3510) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3561) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3519, 3521, 3522, 3523, 3524, 3525, 3526, 3527, 3528, 3529) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3678) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3656, 3657, 3658, 3659, 3660, 3661, 3662) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3636) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3568) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3651) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3553) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3559) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3539, 3540) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3516) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3541) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3641, 3642) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3638, 3639) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (2891) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3664, 3666, 3667, 3668, 3669) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3671, 3672) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3565) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (2892) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3654) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3542, 3543, 3544, 3545) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3515, 3681, 3682) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3646, 3648) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3573) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3536) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3534) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3538) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3532) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'SELECT `shop_items`.`id` FROM `shop_items` INNER JOIN `property_value_datetimes` AS `pvd1` ON `shop_items`.`id` = `pvd1`.`entity_id` WHERE `shop_items`.`id` IN (3547, 3548) AND `pvd1`.`property_id` = 34 AND `pvd1`.`value` BETWEEN '2026-01-18' AND '2199-12-31'

График автобусных туров из Пензы

Дата
Название
Количество дней
Стоимость

Теряетесь в выборе? Мы поможем!

Заполняя данную форму вы принимаете условия Соглашения об использовании сайта, в том числе в части обработки и использования персональных данных