SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='17'
ORDER BY price_promo ASC
SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='20'
ORDER BY price_promo ASC
SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='2'
ORDER BY price_promo ASC
SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='9'
ORDER BY price_promo ASC
Hotel Kivo 4*
| Localizare: |
hotelul se afla in Vassilias, un sat incantator la 3 km de orasul Skiathos. Aceasta locatie incantatoare nu este niciodata aglomerata excesiv si de aceea este considerate o oaza ascunsa la Marea Egee. |
| Facilitati hotel: |
bar, restaurant, gradina, piscina exterioara, centru SPA, seif, acces internet, centru depozitare, serviciu curatatorie. |
| Facilitati camere: |
TV satelit, telefon, radio, mini bar, baie proprie, balcon. |
Tarife pentru sezonul 2012 (
exprimate în EURO) charter + cazare 8 zile/7 nopti in
HOTEL KIVO 4* / BB cu plecare din
BucurestiCopii 0-2 ani gratuit
| Tip cazare |
iunie |
iulie |
august |
sept. |
| 2 |
9 |
16 |
23 |
30 |
7 |
14 |
21 |
28 |
4 |
11 |
18 |
25 |
1 |
8 |
| Loc in DBL |
385 437 |
388 437 |
460 519 |
513 580 |
520 582 |
520 582 |
599 687 |
662 762 |
668 762 |
668 762 |
668 762 |
662 756 |
599 675 |
509 580 |
443 360 |
| SGL |
561 647 |
566 647 |
690 791 |
784 899 |
788 896 |
788 896 |
944 1,097 |
1,064 1,241 |
1,074 1,241 |
1,074 1,241 |
1,074 1,241 |
1,061 1,227 |
944 1,079 |
777 899 |
639 497 |
| Primul copil 2-12 ani (pat suplimentar DBL) |
126 304 |
128 304 |
152 357 |
170 396 |
169 402 |
169 402 |
211 453 |
243 491 |
245 491 |
245 491 |
245 491 |
241 488 |
211 445 |
169 396 |
145 278 |
Tarife pentru sezonul 2012 (
exprimate în EURO) charter + cazare 8 zile/7 nopti in
HOTEL KIVO 4* / BB cu plecare din
ClujCopii 0-2 ani gratuit
| Tip cazare |
iunie |
iulie |
august |
sept. |
| 2 |
9 |
16 |
23 |
30 |
7 |
14 |
21 |
28 |
4 |
11 |
18 |
25 |
1 |
8 |
| Loc in DBL |
413 467 |
422 473 |
505 567 |
558 628 |
565 629 |
565 629 |
644 735 |
707 810 |
713 810 |
713 810 |
713 810 |
706 803 |
644 723 |
553 628 |
488 408 |
| SGL |
589 677 |
600 683 |
736 839 |
829 947 |
833 943 |
833 943 |
988 1,145 |
1,109 1,289 |
1,119 1,289 |
1,119 1,289 |
1,119 1,289 |
1,105 1,274 |
988 1,126 |
821 947 |
684 545 |
| Primul copil 2-12 ani (pat suplimentar DBL) |
126 334 |
128 340 |
152 405 |
170 444 |
169 449 |
169 449 |
211 501 |
243 539 |
245 539 |
245 539 |
245 539 |
241 536 |
211 493 |
169 444 |
145 326 |
| Tarifele sunt informative si valabile in functie de disponibilitate |
| TARIFELE INCLUD: | TARIFELE NU INCLUD: |
- Transport dus-intors cu avionul - cursa charter Tarom
- Transfer aeroport-hotel-aeroport
- 7 nopti cazare si masa-in functie de hotelul ales
- Asistenta turistica
|
- Asigurarea medicala (optional)
- Asigurarea Turist Plus (medicala + storno optional)
- Taxele - 95 euro
|
Optional, asiguram transfer cu avionul (compania Tarom) din Timisoara si Iasi, la Bucuresti. Tariful dus-intors este de 117 euro (taxe incluse).
Pentru copiii care nu au implinit varsta de 2 ani nu se plateste bilet de avion si nu beneficiaza de loc. Reducerile sunt valabile cu conditia achitarii integrale pana la 29.02.2012.
Tarifele pot varia de la momentul publicarii.
Pretul pachetului se calculeaza la momentul rezervarii.
|
