Holiday in the CR:CZeCOTTourmapsEast BohemiaSouth MoraviaTřeboň RegionUNESCOCzechTravelogueCzech inspirationActive holidayTimetables

(Pardubický festival vín 2009)

Type: exhibition, trade fair of wine, other (culinary), wine tasting
Event venue:
Date and time of event:
  • We July 29, 2009
  • Tu July 28, 2009
Significance of event: regional
Barrier-free access unknown (No wheelchair access)
Component of recurring event:
Event will likely be held again next year.
Telephone: 725707399
Telephone: 466052130
E-mail: marketing@zlatastika.cz
URL: http://www.wineofczechrepublic.cz/c-2066-pardubicky-festival-vin-cz.html
Data sources: Czech Wine Growers Association
Add a review at Facebook Rate using form
Book accommodation online
Euro penzion
10 km

Euro penzion

Chrudim

Photo
<- 1/1 ->
Points of interest in the surroundings
Automatic mills
288 m

Automatic mills

tourist building

Pardubice

Pardubice - urban conservation area
364 m

Pardubice - urban conservation area

tourist building

Pardubice

Nearest information centre
Pardubice Region Tourism
482 m

Pardubice Region Tourism

Pardubice

Transport accessibility Touristic objects around Events around notice of offer

[/home/projects/czecot.com/web/redesign/lib/ostatni/AkceBase.php,1365] Chyba pri provadeni dotazu " SELECT id_ac_opakovana_udalost, nazev, ( SELECT b.nazev FROM ac_opakovana_udalost_jazyk b WHERE b.id_ac_opakovana_udalost = ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost AND b.id_jazyk = '1' ) as "nazev_cz", ARRAY_TO_STRING( ARRAY( SELECT id_ac_konani::text || '^' || nazev || '^' || (SELECT b.nazev FROM ac_konani_jazyk b WHERE b.id_ac_konani = ac_konani_jazyk.id_ac_konani AND b.id_jazyk = '1') || '^' || ARRAY_TO_STRING( ARRAY( SELECT CASE WHEN timestamp_start::text IS NOT NULL THEN timestamp_start::text || '#' || COALESCE(timestamp_end::text,'') WHEN date_start::text IS NOT NULL THEN date_start::text || '#' || COALESCE(date_end::text,'') ELSE SUBSTR(month_start::text,1,7) || '#' || SUBSTR(COALESCE(month_end::text,''),1,7) END FROM ac_konani_cas WHERE id_ac_konani=ac_konani_jazyk.id_ac_konani AND (timestamp_start IS NOT NULL OR date_start IS NOT NULL OR month_start IS NOT NULL) ), '|' ) FROM ac_konani_jazyk WHERE id_ac_konani IN ( SELECT id_ac_konani FROM ac_opakovana_udalost_ac_konani WHERE id_ac_opakovana_udalost=ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost EXCEPT SELECT '63384' ) AND id_jazyk='2' ORDER BY ( SELECT COALESCE(timestamp_start,date_start,month_start) FROM ac_konani_cas WHERE id_ac_konani = ac_konani_jazyk.id_ac_konani ) desc ), '|*|' ) AS "konani", ARRAY_TO_STRING( ARRAY( SELECT id_ac_festival::text || '^' || nazev || '^' || (SELECT b.nazev FROM ac_festival_jazyk b WHERE b.id_ac_festival = ac_festival_jazyk.id_ac_festival AND b.id_jazyk = '1') FROM ac_festival_jazyk WHERE id_ac_festival IN ( SELECT id_ac_festival FROM ac_opakovana_udalost_ac_festival WHERE id_ac_opakovana_udalost=ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost EXCEPT SELECT id_ac_festival FROM ac_festival_ac_konani WHERE id_ac_konani = '63384' ) AND id_jazyk='2' ORDER BY nazev DESC ), '|' ) AS "festival" FROM ac_opakovana_udalost_jazyk WHERE id_ac_opakovana_udalost IN ( SELECT id_ac_opakovana_udalost FROM ac_opakovana_udalost_ac_konani WHERE id_ac_konani='63384' UNION SELECT id_ac_opakovana_udalost FROM ac_opakovana_udalost_ac_festival WHERE id_ac_festival IN ( SELECT id_ac_festival FROM ac_festival_ac_konani WHERE id_ac_konani='63384' ) ) AND id_jazyk='2' ORDER BY id_ac_opakovana_udalost DESC ", posledni chyba:"ERROR: more than one row returned by a subquery used as an expression"
How to get there by car from:
How to get there by train/bus:
From:
To:
Departure/Arrival:
one day earlierone day later Calendar - select dates one hour laterone hour earlierone minute laterone minute earlier
:
Schedule:
Provided by: Logo CHAPS spol. s r.o.
The nearest train stations: Pardubice-Pardubičky 1 km search for transport connection, Pardubice hlavní nádraží 2 km search for transport connection, Pardubice závodiště 3 km search for transport connection,
Bus station:Pardubice - autobusové nádraží 3 km
Airports:international: Pardubice 4 km search for transport connection, Mnichovo Hradiště 78 km search for transport connection, Praha Ruzyně 109 km search for transport connection
domestic: Chrudim 11 km search for transport connection, Hradec Králové 24 km search for transport connection, Skuteč 28 km search for transport connection
sport aviation facility: Kunětice 4 km search for transport connection, Luže 22 km search for transport connection, Rohozec 29 km search for transport connection
Distance from car park:own (capacity - cars: 25, price: free - coaches: 2, price: 100 CZK /day)
Bus stop:200 m
Taxi:yes
Description:How can you get to our hotel? Easily!


from the train and the bus station (they are on the opposite sides) by trolley bus or bus
link nb. nb. of stops getting off bus stop
12 5 U Kostelíčka
13 5 U Kostelíčka
02 5 U Kostelíčka
09 5 Zlatá štika

You can find accurate schedules in the new window from the website of Dopravní podnik (Transport Company) in Pardubice.


by car
1. arrival from Chrudim - arrival to Pardubice on the main road, go straight on, on the fourth semaphore crossroad turn right, go straight on through two semaphore crossroads, there is a bridge in front of you, behind the bridge, turn left, after 50 m there is Zlatá štika hotel
2. arrival from Hradec Králové - keep the way to the city centre, on the traffic circle choose the way to train station, go straight on through two semaphore crossroads, on the third one turn left, then turn right, go straight on through two semaphore crossroads, there is a bridge in front of you, behind the bridge, turn left, after 50 m there is Zlatá štika hotel
3. arrival from Holice - pass the Carcentre Škoda and in front of the SLOVNAFT gas station turn right, go straight on, after about 500 m there is Zlatá štika hotel on your left
The stated values correspond to the air distance
© 2002-2012 World Media Partners
Data sources: Czech Wine Growers Association Poslední aktualizace: 13.02.2012 [63384]

Do not click this link and this link or you will be banned!


[/home/projects/czecot.com/web/redesign/lib/ostatni/AkceBase.php,1365] Chyba pri provadeni dotazu " SELECT id_ac_opakovana_udalost, nazev, ( SELECT b.nazev FROM ac_opakovana_udalost_jazyk b WHERE b.id_ac_opakovana_udalost = ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost AND b.id_jazyk = '1' ) as "nazev_cz", ARRAY_TO_STRING( ARRAY( SELECT id_ac_konani::text || '^' || nazev || '^' || (SELECT b.nazev FROM ac_konani_jazyk b WHERE b.id_ac_konani = ac_konani_jazyk.id_ac_konani AND b.id_jazyk = '1') || '^' || ARRAY_TO_STRING( ARRAY( SELECT CASE WHEN timestamp_start::text IS NOT NULL THEN timestamp_start::text || '#' || COALESCE(timestamp_end::text,'') WHEN date_start::text IS NOT NULL THEN date_start::text || '#' || COALESCE(date_end::text,'') ELSE SUBSTR(month_start::text,1,7) || '#' || SUBSTR(COALESCE(month_end::text,''),1,7) END FROM ac_konani_cas WHERE id_ac_konani=ac_konani_jazyk.id_ac_konani AND (timestamp_start IS NOT NULL OR date_start IS NOT NULL OR month_start IS NOT NULL) ), '|' ) FROM ac_konani_jazyk WHERE id_ac_konani IN ( SELECT id_ac_konani FROM ac_opakovana_udalost_ac_konani WHERE id_ac_opakovana_udalost=ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost EXCEPT SELECT '63384' ) AND id_jazyk='2' ORDER BY ( SELECT COALESCE(timestamp_start,date_start,month_start) FROM ac_konani_cas WHERE id_ac_konani = ac_konani_jazyk.id_ac_konani ) desc ), '|*|' ) AS "konani", ARRAY_TO_STRING( ARRAY( SELECT id_ac_festival::text || '^' || nazev || '^' || (SELECT b.nazev FROM ac_festival_jazyk b WHERE b.id_ac_festival = ac_festival_jazyk.id_ac_festival AND b.id_jazyk = '1') FROM ac_festival_jazyk WHERE id_ac_festival IN ( SELECT id_ac_festival FROM ac_opakovana_udalost_ac_festival WHERE id_ac_opakovana_udalost=ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost EXCEPT SELECT id_ac_festival FROM ac_festival_ac_konani WHERE id_ac_konani = '63384' ) AND id_jazyk='2' ORDER BY nazev DESC ), '|' ) AS "festival" FROM ac_opakovana_udalost_jazyk WHERE id_ac_opakovana_udalost IN ( SELECT id_ac_opakovana_udalost FROM ac_opakovana_udalost_ac_konani WHERE id_ac_konani='63384' UNION SELECT id_ac_opakovana_udalost FROM ac_opakovana_udalost_ac_festival WHERE id_ac_festival IN ( SELECT id_ac_festival FROM ac_festival_ac_konani WHERE id_ac_konani='63384' ) ) AND id_jazyk='2' ORDER BY id_ac_opakovana_udalost DESC ", posledni chyba:"ERROR: more than one row returned by a subquery used as an expression"
loginImage