Pusholire.com |   Tour tags  Expeditions
  • VacationsAmazing travel packages
        • Browse by location

          • Hello world!

            Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
            More info
        • Browse by type

        • All inclusive
        • Adults only
        • Last minute
        • Ultra All Inclusive
        • Summer 2020
        • We recommend

        • Vacations in Turkey
        • Vacations in Maldives
        • Vacations in Thailand
        • Vacations in Dubai
        • Last minute deals

          SELECT SQL_CALC_FOUND_ROWS wp_rh9xgp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rh9xgp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rh9xgp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2021-01-21:2023-01-21' LIMIT 1), 0) accommodation_price FROM wp_rh9xgp_posts JOIN wp_rh9xgp_icl_translations wpml_translations ON wp_rh9xgp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_rh9xgp_posts.post_type) LEFT JOIN wp_rh9xgp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND wpml_translations_default.source_language_code IS NULL WHERE 1=1 AND wp_rh9xgp_posts.post_type = 'accommodation' AND ((wp_rh9xgp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR ( wpml_translations.language_code = 'en' AND wp_rh9xgp_posts.post_type IN ( 'product' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_rh9xgp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'en' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_rh9xgp_icl_translations t2 JOIN wp_rh9xgp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'en' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_rh9xgp_posts.post_type IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wpforms','wpb_safe-file','wpb_safe-metrics','wp-backitup_backup','wp-backitup_restore','wp-backitup_cleanup','location','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','wpcf7_contact_form' ) ) OR wp_rh9xgp_posts.post_type NOT IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wpforms','wpb_safe-file','wpb_safe-metrics','wp-backitup_backup','wp-backitup_restore','wp-backitup_cleanup','location','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','wpcf7_contact_form' ) ) GROUP BY wp_rh9xgp_posts.ID HAVING 1=1 ORDER BY wp_rh9xgp_posts.post_date DESC LIMIT 0, 3
          LAST MINUTE

          Vonresort Golden Coast & Aqua – Kids Concept     

          Colakli Beldesi Manavgat, 07600 Side, Turkey
          From €
          LAST MINUTE

          Vonresort Golden Beach    

          Tilkiler Mevkii Colakli, Antalya, 07600 Side, Turkey
          From €
          LAST MINUTE

          Vonresort Elite     

          Colakli, Manavgat 07600 Turkey
          From €
  • City breaksGuided tours & excursions
        • Browse by location

        • City breaks
        • Expeditions
        • Browse by type

        • Less than 1 day
        • More than 1 day
        • More than 3 days
        • Browse by duration

        • Tours in Greece
        • Tours in Italy
        • Tours in Spain
        • Sofia Tours

          From €

          Macedonia Tours

          From €

          Montenegro Tours

          From €
  • CruisesUnforgettable sailings
        • Browse by Location

        • Last minute
        • Family
        • Luxury
        • Browse by type

        • Up to 1 week
        • More than 1 week
        • Browse by duration

        • Cruises in Greece
        • Cruises in Italy
        • Cruises in Spain
        • Cruises in Tunisia
        • LAST MINUTE

          11 Nights Western Mediterranean

          Barcelona - Valencia - Alicante - Gibraltar - Malaga - Provence - Nice (Villefranche) - Livorno (Florence/Pisa) - Civitavecchia (Rome) - Barcelona
          From €
          LUXURY

          9 Nights Eastern Mediterranean

          Civitavecchia (Rome) - Naples - Cagliari - Tunis - Chania (Crete) - Santorini - Athens - Kalamata - Malta - Civitavecchia (Rome)
          From €
          FAMILY

          4 Nights Spain and Balearic islands

          Barcelona - Ciutadella (Menorca) - Palma (Mallorca) - Ibiza - Alicante - Valencia - Barcelona
          From €
  • DestinationsWhere we can take you
  • Albanian
  • English
shopping_cart 0

Expeditions

Albania Tours

From €
Book now

Amsterdam Tours

From €
Book now

Athens Tours

From €
Book now

Barcelona Spain Tours

From €
Book now

Berlin Tours

From €
Book now

Brussels Tours

From €
Book now

Budapest Tours

From €
Book now

Burj Khalifa Dubai Tours

From €
Book now

Frankfurt Tours

From €
Book now

Helsinki Tours

From €
Book now

Istanbul Turkey Tours

From €
Book now

Lisbon Tours

From €
Book now
First page123>Last page

  • Pusholire

    place MATI 1, N.N. 10000 Prishtine, KS

    call +383 49 25 30 35

    email info@pusholire.com

  • Follow us

© 2019 Pusholire.com

  • Home
  • Configure
x

Log in

Forgot your password?
Don't have an account yet? Sign up.

x

Register