VIRTUAL TRAVEL GLOBE
News
Countries
Cities
Accommodation
Beaches
Castles
Cathedrals
Galleries
Mountains
UNESCO World Heritage
more
Austria
Bulgaria
Cambodia
Cape Verde
Croatia
Czech republic
Egypt
England
France
French Polynesia
Germany
Gibraltar
Greece
Hungary
India
Israel
Italy
Jamaica
Kazakhstan
Laos
Nepal
Netherlands
Poland
San Marino
Scotland
Slovakia
Slovenia
Spain
Sri Lanka
Switzerland
Thailand
United Arab Emirates
USA
Vietnam
SELECT ID, ENNazev,ENq, Typ, Pocet FROM VR WHERE Nad = '4710' AND Active = 1 AND Street = 0 ORDER BY ENNazev
Carlsbad Region
Central Bohemian Region
Hradec Kralove Region
Liberec Region
Moravian-silesian Region
Olomouc Region
Pardubice Region
Pilsen Region
Prague
South Bohemian Region
South Moravian Region
Usti Nad Labem Region
Vysocina Region
Zlin Region
SELECT ID, ENNazev,ENq, Typ, Pocet FROM VR WHERE Nad = '4' AND Active = 1 AND Street = 0 ORDER BY ENNazev
Aš
Becov
Carlsbad
Cheb
Chlum Svate Mari
Chyse
Frantiskovy Lazne
Horni Hrad
Horni Slavkov
Jachymov
Kladska
Konstantinovy Lazne
Krasno
Kynsperk Nad Ohri
Kynzvart Spa
Kyselka
Loket
Marianske Lazne
Mostov
Natural Reserve SOOS
Nejdek
Ostroh
Ostrov
Skalna
Sokolov
Svatosske skaly ( rocks )
Tepla
Valec near Karlovy Vary
list
SELECT ID, ENNazev,ENq, Typ, Pocet FROM VR WHERE Nad = '133' AND Active = 1 AND Street = 0 ORDER BY ENNazev
Chateau Hotel Metternich ( 2 )
Chateau Kynzvart ( 5 )
1926, Chateau Kynzvart
1
2
3
4
5
< worst ... best >
Kynzvart Spa
Kynzvart Spa - panoramas
the Castle's Dining Hall
Chateau Kynzvart
1926
Chateau Kynzvart
Restaurant
Chateau Hotel Metternich
Chapel
Chateau Kynzvart
The Great Hall
Chateau Kynzvart
1927
Chateau Kynzvart
Saloon
Chateau Hotel Metternich
Czech republic
>
Carlsbad Region
Region:
West Bohemian Spa
Virtual tour groups
Chateau Hotel Metternich ( 2 )
Chateau Kynzvart ( 5 )