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='11'
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='10'
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='13'
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
Hotel Aria 2*+
| Localizare: |
oferind o priveliste spectaculoasa asupra plajei Megali Ammos, hotelul Aria, situat la o inaltime de unde se poate admira marea si centrul orasului Skiathos, este construit intr-un stil modern. Oaspetii se pot relaxa luand micul dejun si admirand minunatele imprejurimi sau pot savura un cocktail la terasa barului. Hotelul este situat la doar 100 m fata de plaja Megali Ammos si la 700 m fata de centrul orasului, distanta fata de aeroport fiind de doar 2 km. |
| Facilitati hotel: |
piscina, receptie, salon de relaxare cu televiziune prin satelit, snack-bar. |
| Facilitati camere: |
aer conditionat, baie cu dus, frigider, telefon, terasa/balcon. |
Tarife pentru sezonul 2012 (
exprimate în EURO) charter + cazare 8 zile/7 nopti in
HOTEL ARIA 2*+ / BB cu plecare din
BucurestiCopii 0-2 ani gratuit, A/C 5 euro/zi
| Tip cazare |
iunie |
iulie |
august |
sept. |
| 2 |
9 |
16 |
23 |
30 |
7 |
14 |
21 |
28 |
4 |
11 |
18 |
25 |
1 |
8 |
| Loc in DBL |
260 289 |
262 289 |
337 374 |
374 416 |
382 421 |
443 493 |
448 507 |
448 507 |
452 507 |
452 507 |
452 507 |
449 505 |
448 499 |
371 416 |
354 398 |
Tarife pentru sezonul 2012 (
exprimate în EURO) charter + cazare 8 zile/7 nopti in
HOTEL ARIA 2*+ / BB cu plecare din
ClujCopii 0-2 ani gratuit, A/C 5 euro/zi
| Tip cazare |
iunie |
iulie |
august |
sept. |
| 2 |
9 |
16 |
23 |
30 |
7 |
14 |
21 |
28 |
4 |
11 |
18 |
25 |
1 |
8 |
| Loc in DBL |
288 319 |
296 325 |
382 422 |
419 464 |
427 468 |
488 540 |
493 555 |
493 555 |
497 555 |
497 555 |
497 555 |
494 552 |
493 546 |
416 464 |
399 446 |
| 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.
|
