venues

Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · PT · PL · IE · HR · GR · ME)

group
Top group: Stay / Eat & Drink / Other
family
Simplified family (Hotels, Guesthouses, Restaurants, Bars & Pubs…)
venue_type
Detailed canonical type (see the venue_types table)
type_granularity
'coarse' when the source lumps several real types (e.g. UK FSA)
rating_value
Normalized 1–5 grade, or blank if unrated
rating_scheme
star / key / flower / approved / none (see rating_schemes)
rating_label
Original rating string from the source (provenance)
source_type
Original type string from the national register (provenance)
source_category
Original category/rating field from the register
capacity_persons
Comparable headline capacity — beds/guests (stay) or seats (food)
rooms
Number of rooms / units (accommodation)
best_for
The single event this venue is best suited to (blank = not an event venue)
fit_wedding
Wedding-suitability score 0–100 (type + capacity + rating)
fit_conference
Conference-suitability score 0–100
fit_banquet
Banquet-suitability score 0–100
fit_spa
Spa-retreat-suitability score 0–100
fit_party
Party/celebration-suitability score 0–100
common_areas
On-site shared function space, from the register only (event_venue) — blank = not stated, never inferred
reachability_score
How easy to reach 0–100 (nearer airport + city = higher)
isolation_score
How remote 0–100 (farther from towns + fewer nearby venues = higher)
airport_km
Distance to nearest airport (km)
nearest_airport
Nearest airport (IATA or name)
city_km
Distance to nearest city ≥15k people (km)
town_km
Distance to nearest settlement ≥500 people (km)
venues_5km
Number of other venues within 5 km (local density)
cert_number
Certificate / registration number in the national register
source
Source register the row came from

249 rows where family = "hostels", group = "stay" and rating_value = 2

This data as json, CSV (advanced)

Suggested facets: rating_label, fit_wedding, reachability_score, isolation_score, source, source_type, source_category, valid_until (date)

country 2

rating_value 1

group 1

  • stay · 249 ✖

family 1

  • hostels · 249 ✖

best_for 1

common_areas 0

Link rowid ▼ name country group family venue_type type_granularity rating_value rating_scheme rating_label capacity_persons rooms best_for fit_wedding fit_conference fit_banquet fit_spa fit_party common_areas reachability_score isolation_score airport_km nearest_airport city_km town_km venues_5km city municipality address lat lng valid_until stop_date source source_type source_category cert_number
15594 15594 POARTA OILOR RO stay hostels hostel normal 2 star 2 - STELE 89 27 wedding 55 0 0 0 0   70 10 29.5 SBZ 15.8 1.3 6 Com. Gârbova, Sat Gârbova ALBA NR. 573 45.8593251 23.7201921 03.02.2021   RO-SITUR HOSTEL 2 - STELE 16307
16080 16080 CODRIŞOR RO stay hostels hostel normal 2 star 2 - STELE 12 4   35 0 0 0 0   45 20 73.8 OMR 51.1 0.6 1 Com. Dezna, Sat Dezna ARAD NR. 103 46.4053987 22.247706 29.11.2023   RO-SITUR HOSTEL 2 - STELE 37115
16129 16129 TESTA SILVIU RO stay hostels hostel normal 2 star 2 - STELE 23 7   35 0 0 0 0   70 10 26.0 ARW 22.4 0.7 16 Com. Păuliş, Sat Păuliş ARAD NR. 676 46.1191684 21.5918833 23.08.2021   RO-SITUR HOSTEL 2 - STELE 13552
16158 16158 CASA VERDE RO stay hostels hostel normal 2 star 2 - STELE 30 9   45 0 0 0 0   45 30 38.0 ARW 33.9 6.0 6 Com. Târnova, Sat Arăneag ARAD NR. 320 46.2186929 21.7541084 26.05.2022   RO-SITUR HOSTEL 2 - STELE 24892
16262 16262 ELECTRIC RO stay hostels hostel normal 2 star 2 - STELE 26 10   35 0 0 0 0   80 10 7.2 ARW 3.5 3.4 352 Mun. Arad ARAD STR. Calea Zimandului , NR. 14 46.2063406 21.347276 03.12.2020   RO-SITUR HOSTEL 2 - STELE 22433
16311 16311 MOARA CU NOROC 1 RO stay hostels hostel normal 2 star 2 - STELE 124 57 wedding 55 0 0 0 0   80 10 4.4 ARW 2.1 2.1 401 Mun. Arad ARAD STR. Strada Mucius Scaevola , NR. 11A 46.1644569 21.3194809 21.03.2022   RO-SITUR HOSTEL 2 - STELE 12118/6814
16312 16312 MOARA CU NOROC 2 RO stay hostels hostel normal 2 star 2 - STELE 62 29   45 0 0 0 0   80 10 4.4 ARW 2.1 2.1 401 Mun. Arad ARAD NR. 11A 46.1644569 21.3194809 21.03.2022   RO-SITUR HOSTEL 2 - STELE 13549
16585 16585 ELZA RO stay hostels hostel normal 2 star 2 - STELE 15 6   35 0 0 0 0   55 0 69.5 SBZ 18.9 0.5 86 Com. Corbeni, Sat Corbeni ARGEŞ   45.3035923 24.6540462 11.08.2010   RO-SITUR HOSTEL 2 - STELE 10162/7006
16722 16722 HANUL STEJARUL RO stay hostels hostel normal 2 star 2 - STELE 64 27   45 0 0 0 0   40 20 80.2 CRA 20.2 0.2 1 Com. Lunca Corbului, Sat Lunca Corbului ARGEŞ   44.6851752 24.7597034 25.02.2014   RO-SITUR HOSTEL 2 - STELE 12411
17122 17122 HANUL CODREANU RO stay hostels hostel normal 2 star 2 - STELE 38 8   45 0 0 0 0   55 10 46.3 BCM 25.4 3.9 34 Com. Oituz, Sat Hârja BACĂU   46.2010295 26.5256738 30.09.2020   RO-SITUR HOSTEL 2 - STELE 21323
17208 17208 HOLLAND RO stay hostels hostel normal 2 star 2 - STELE 32 12   45 0 0 0 0   80 0 6.0 BCM 1.6 1.6 144 Mun. Bacău BACĂU STR. Strada Nordului , NR. 19bis 46.5755128 26.8968399 06.09.2011   RO-SITUR HOSTEL 2 - STELE 15540
17605 17605 MILLENIUM RO stay hostels hostel normal 2 star 2 - STELE 10 4   35 0 0 0 0   80 10 27.4 OMR 4.3 0.9 16 Com. Mădăras, Sat Mădăras BIHOR NR. 189 46.8264916 21.690417 03.05.2016   RO-SITUR HOSTEL 2 - STELE 29853
18024 18024 PERLA ALBASTRĂ RO stay hostels hostel normal 2 star 2 - STELE 75 30   45 0 0 0 0   45 0 48.8 OMR 37.7 1.4 38 Com. Şuncuiuş, Sat Şuncuiuş BIHOR STR. Strada Unirii , NR. 654 , BL. 18 46.9461915 22.53508 14.07.2015   RO-SITUR HOSTEL 2 - STELE 28561
18060 18060 MARIA RO stay hostels hostel normal 2 star 2 - STELE 16 8   35 0 0 0 0   45 10 52.8 OMR 53.8 0.5 19 Mun. Beiuş BIHOR STR. Calea Bihorului , NR. 26 46.6658505 22.3564014 12.01.2012   RO-SITUR HOSTEL 2 - STELE 8092/5405
18155 18155 CASA MOV RO stay hostels hostel normal 2 star 2 - STELE 10 5   35 0 0 0 0   80 10 6.2 OMR 3.8 3.8 335 Mun. Oradea BIHOR STR. Strada Mehedinţi , NR. 117 47.0797019 21.9216774 16.09.2011   RO-SITUR HOSTEL 2 - STELE 15701
18207 18207 FOX INN HOSTEL ORADEA RO stay hostels hostel normal 2 star 2 - STELE 22 4   35 0 0 0 0   80 0 3.3 OMR 0.9 0.9 374 Mun. Oradea BIHOR NR. 40 47.049307 21.928847 05.11.2020   RO-SITUR HOSTEL 2 - STELE 22107
18333 18333 SCORPION RO stay hostels hostel normal 2 star 2 - STELE 57 28   45 0 0 0 0   80 10 5.8 OMR 3.7 3.7 329 Mun. Oradea BIHOR STR. Calea Borşului , NR. 12 47.0770595 21.9002689 17.02.2011   RO-SITUR HOSTEL 2 - STELE 4635/3309
18368 18368 TRAVELING LADYBUG RO stay hostels hostel normal 2 star 2 - STELE 19 3   35 0 0 0 0   80 10 4.6 OMR 2.1 2.1 362 Mun. Oradea BIHOR STR. Strada Episcop Roman Ciorogariu , NR. 49 , AP. 1 47.0625018 21.9299403 01.11.2018   RO-SITUR HOSTEL 2 - STELE 19107
18401 18401 OLIMPTOM RO stay hostels hostel normal 2 star 2 - STELE 49 20   45 0 0 0 0   45 20 37.5 OMR 36.2 0.4 5 Oraş Aleşd BIHOR STR. Piaţa Unirii , NR. 4A 47.0596898 22.3950562 01.03.2023   RO-SITUR HOSTEL 2 - STELE 4861/3158
18402 18402 PASCALIS RO stay hostels hostel normal 2 star 2 - STELE 14 5   35 0 0 0 0   45 20 36.9 OMR 35.5 1.0 5 Oraş Aleşd BIHOR STR. Strada Mihail Eminescu , NR. 31 47.0575783 22.3866318 03.03.2016   RO-SITUR HOSTEL 2 - STELE 18487
18608 18608 ŢULEAN RO stay hostels hostel normal 2 star 2 - STELE 17 5   35 0 0 0 0   55 30 72.1 BAY 14.5 5.0 6 Com. Romuli, Sat Dealu Ştefăniţei BISTRIŢA-NĂSĂUD NR. 37B 47.5774239 24.4186653 23.08.2022   RO-SITUR HOSTEL 2 - STELE 31986
18651 18651 PASUL TIHUŢA RO stay hostels hostel normal 2 star 2 - STELE 20 9   35 0 0 0 0   40 0 87.0 TGM 19.8 0.9 22 Com. Tiha Bârgăului, Sat Piatra Fântânele BISTRIŢA-NĂSĂUD NR. 16 47.2192375 24.7291873 19.11.2014   RO-SITUR HOSTEL 2 - STELE 28223
18849 18849 ALBINA RO stay hostels hostel normal 2 star 2 - STELE 59 26   45 0 0 0 0   55 30 63.8 Boboc Air Base 18.3 1.0 0 Com. Tichileşti, Sat Albina BRĂILA ET. P 45.1704062 27.790002 26.08.2019   RO-SITUR HOSTEL 2 - STELE 10847/5625
18912 18912 CORA RO stay hostels hostel normal 2 star 2 - STELE 38 12   45 0 0 0 0   45 20 40.2 Boboc Air Base 41.7 2.2 6 Oraş Ianca BRĂILA STR. Calea Brăilei , NR. 41 45.134852 27.47844 28.09.2021   RO-SITUR HOSTEL 2 - STELE 10143/6641
19253 19253 BOEMIA HOSTEL RO stay hostels hostel normal 2 star 2 - STELE 18 3   35 0 0 0 0   80 10 8.8 GHV 6.1 2.4 162 Com. Cristian, Sat Cristian BRAŞOV STR. Strada Eroilor , NR. 13 45.62967 25.4907666 01.07.2011   RO-SITUR HOSTEL 2 - STELE 15019
19805 19805 DUMBRAVA MINUNATĂ RO stay hostels hostel normal 2 star 2 - STELE 162 38 wedding 65 0 0 0 0   55 0 54.6 GHV 14.7 0.3 37 Com. Sâmbăta de Sus, Sat Sâmbăta de Sus BRAŞOV   45.7626028 24.8246228 05.09.2018   RO-SITUR HOSTEL 2 - STELE 16098
20399 20399 DOWNTOWN RO stay hostels hostel normal 2 star 2 - STELE 22 4   35 0 0 0 0   80 0 9.0 GHV 1.5 1.5 1175 Mun. Braşov BRAŞOV STR. Strada Castelului , NR. 60 , AP. 6 45.640128 25.591311 08.09.2023   RO-SITUR HOSTEL 2 - STELE 36028
20408 20408 DUMBRAVA MINUNATĂ RO stay hostels hostel normal 2 star 2 - STELE 26 13   35 0 0 0 0   80 10 6.9 GHV 2.2 2.2 1170 Mun. Braşov BRAŞOV   45.6625933 25.5865245 18.09.2019   RO-SITUR HOSTEL 2 - STELE 12891
20576 20576 KIDS RESORT HOLIDAYS RO stay hostels hostel normal 2 star 2 - STELE 52 8   45 0 0 0 0   80 10 5.1 GHV 7.6 3.9 151 Mun. Braşov BRAŞOV STR. Strada Baciului , NR. 9 C 45.7152868 25.5870773 09.07.2015   RO-SITUR HOSTEL 2 - STELE 28500
21377 21377 CASA STRUGUREL RO stay hostels hostel normal 2 star 2 - STELE 30 9   45 0 0 0 0   70 10 22.4 GHV 13.6 2.0 338 Oraş Predeal BRAŞOV STR. Bulevardul Libertăţii , NR. 79 45.5092952 25.5891212 11.09.2018   RO-SITUR HOSTEL 2 - STELE 18960
21482 21482 PREDEAL RO stay hostels hostel normal 2 star 2 - STELE 14 7   35 0 0 0 0   70 0 23.8 GHV 13.7 0.7 340 Oraş Predeal BRAŞOV NR. 71 45.4942334 25.5711375 17.11.2015   RO-SITUR HOSTEL 2 - STELE 29071
21819 21819 BALTA ALBĂ RO stay hostels hostel normal 2 star 2 - STELE 8 4   35 0 0 0 0   55 20 30.5 Boboc Air Base 25.7 0.8 3 Com. Balta Alba, Sat Balta Alba BUZĂU STR. Strada Staţiunii , NR. 32 45.2926751 27.3524473 02.07.2019   RO-SITUR HOSTEL 2 - STELE 14241
21909 21909 HANUL ANIŢEI - LA PĂDUCEL RO stay hostels hostel normal 2 star 2 - STELE 24 12   35 0 0 0 0   70 0 27.5 Boboc Air Base 15.1 0.2 41 Com. Merei, Sat Sărata-Monteoru BUZĂU   45.1475463 26.6409545 06.02.2024   RO-SITUR HOSTEL 2 - STELE 11828/7550
21929 21929 VULCANII NOROIOSI RO stay hostels hostel normal 2 star 2 - STELE 26 4   35 0 0 0 0   70 20 28.3 Boboc Air Base 25.3 1.1 2 Com. Scorţoasa, Sat Policiori BUZĂU   45.3450051 26.6662951 24.05.2011   RO-SITUR HOSTEL 2 - STELE 14948A
22136 22136 EUROPA RO stay hostels hostel normal 2 star 2 - STELE 17 4   35 0 0 0 0   65 20 62.5 BBU 1.9 1.9 5 Mun. Olteniţa CĂLĂRAŞI STR. Şoseaua Călăraşi , NR. 24 44.0977325 26.6463448 07.08.2017   RO-SITUR HOSTEL 2 - STELE 30575
22147 22147 TABĂRA MARABU RO stay hostels hostel normal 2 star 2 - STELE 40 9   45 0 0 0 0   55 20 78.4 CSB 17.1 2.0 1 Com. Berlişte, Sat Milcoveni CARAŞ-SEVERIN   45.0011447 21.4478597 28.09.2020   RO-SITUR HOSTEL 2 - STELE 21295
22289 22289 SILVIA RO stay hostels hostel normal 2 star 2 - STELE 32 16   45 0 0 0 0   70 10 19.6 CSB 19.9 1.2 8 Com. Slatina-Timiş, Sat Sadova Veche CARAŞ-SEVERIN NR. 157 45.2470166 22.2980609 31.10.2011   RO-SITUR HOSTEL 2 - STELE 3609/950
22384 22384 ŞURA ZONDA RO stay hostels hostel normal 2 star 2 - STELE 16 5   35 0 0 0 0   55 60 36.8 CSB 25.3 13.6 0 Estelnic CARAŞ-SEVERIN NR. 137 45.1139646 22.0740993 06.08.2019   RO-SITUR HOSTEL 2 - STELE 20182
22403 22403 SERENGĂU RO stay hostels hostel normal 2 star 2 - STELE 34 17   45 0 0 0 0   80 0 2.7 CSB 1.2 1.2 47 Mun. Caransebeş CARAŞ-SEVERIN NR. 8 45.4067586 22.2234333 02.10.2012   RO-SITUR HOSTEL 2 - STELE 25733
22673 22673 ROUA RO stay hostels hostel normal 2 star 2 - STELE 33 10   45 0 0 0 0   55 30 35.8 CLJ 29.7 9.3 16 Com. Băişoara, Sat Muntele Băişorii CLUJ NR. 461 46.5624551 23.3485652 22.02.2019   RO-SITUR HOSTEL 2 - STELE 31376
22802 22802 CASA KEREKI RO stay hostels hostel normal 2 star 2 - STELE 20 4   35 0 0 0 0   70 20 27.7 CLJ 18.0 0.4 2 Com. Corneşti, Sat Corneşti CLUJ NR. 137 47.0348851 23.6786044 16.06.2010   RO-SITUR HOSTEL 2 - STELE 13516
22959 22959 CRISTIAN RO stay hostels hostel normal 2 star 2 - STELE 8 4   35 0 0 0 0   45 0 61.1 CLJ 54.3 1.0 28 Com. Mărgău, Sat Răchiţele CLUJ NR. 333A 46.7152837 22.891139 13.10.2014   RO-SITUR HOSTEL 2 - STELE 18627
22961 22961 IOANA RO stay hostels hostel normal 2 star 2 - STELE 9 5   35 0 0 0 0   45 0 61.1 CLJ 54.3 1.0 28 Com. Mărgău, Sat Răchiţele CLUJ NR. 333A 46.7152837 22.891139 13.10.2014   RO-SITUR HOSTEL 2 - STELE 10398/8931
23025 23025 PĂDURENI LAND HOUSE RO stay hostels hostel normal 2 star 2 - STELE 34 5   45 0 0 0 0   65 30 39.7 CLJ 7.6 4.5 5 Com. Mintiu Gherlii, Sat Pădurenii CLUJ NR. 28 47.0715976 23.9997851 23.08.2022   RO-SITUR HOSTEL 2 - STELE 31989
23388 23388 CHOCO HOME & HOSTEL RO stay hostels hostel normal 2 star 2 - STELE 22 5   35 0 0 0 0   80 0 7.6 CLJ 1.6 1.6 1218 Mun. Cluj-Napoca CLUJ STR. Strada Horea , NR. 29 , ET. 2 , AP. 6-7 46.7778559 23.58684 08.10.2024   RO-SITUR HOSTEL 2 - STELE 39955
23396 23396 CITY CENTER RO stay hostels hostel normal 2 star 2 - STELE 24 5   35 0 0 0 0   80 0 7.7 CLJ 1.0 1.0 1225 Mun. Cluj-Napoca CLUJ STR. Strada Memorandumului , NR. 13 46.7695263 23.5872486 01.10.2012   RO-SITUR HOSTEL 2 - STELE 25731
23588 23588 KOLLEGIUM RO stay hostels hostel normal 2 star 2 - STELE 46 9   45 0 0 0 0   80 0 7.3 CLJ 0.8 0.8 1218 Mun. Cluj-Napoca CLUJ STR. Bulevardul 21 Decembrie 1989 , NR. 9 46.7718848 23.5925309 04.05.2018   RO-SITUR HOSTEL 2 - STELE 31566
23766 23766 RETRO HOSTEL RO stay hostels hostel normal 2 star 2 - STELE 46 13   45 0 0 0 0   80 0 7.8 CLJ 1.0 1.0 1227 Mun. Cluj-Napoca CLUJ STR. Strada Potaisa , NR. 13 46.7668322 23.5874206 04.05.2012   RO-SITUR HOSTEL 2 - STELE 5690/3556
23807 23807 SPORT CLUJ RO stay hostels hostel normal 2 star 2 - STELE 13 5   35 0 0 0 0   80 10 2.8 CLJ 4.6 4.6 651 Mun. Cluj-Napoca CLUJ STR. Strada Pintea Viteazul , NR. 9 46.7898337 23.6499431 13.01.2026   RO-SITUR HOSTEL 2 - STELE 45412
23854 23854 THE SPOT RO stay hostels hostel normal 2 star 2 - STELE 27 4   35 0 0 0 0   80 10 9.1 CLJ 2.5 2.5 1185 Mun. Cluj-Napoca CLUJ STR. Piaţa 14 Iulie , NR. 25 , AP. 1 46.7711266 23.5676454 06.07.2015   RO-SITUR HOSTEL 2 - STELE 28461
23911 23911 YOUTHINK RO stay hostels hostel normal 2 star 2 - STELE 24 4   35 0 0 0 0   80 0 7.7 CLJ 1.0 1.0 1222 Mun. Cluj-Napoca CLUJ STR. Strada Republicii , NR. 74 46.7598921 23.5917258 04.12.2015   RO-SITUR HOSTEL 2 - STELE 29246
23915 23915 ZEN RO stay hostels hostel normal 2 star 2 - STELE 28 7   35 0 0 0 0   80 0 7.1 CLJ 0.6 0.6 1219 Mun. Cluj-Napoca CLUJ STR. Bulevardul Eroilor , NR. 47 , AP. 6 46.7705059 23.5953898 27.05.2024   RO-SITUR HOSTEL 2 - STELE 29038
24373 24373 CASA ORION RO stay hostels hostel normal 2 star 2 - STELE 26 13   35 0 0 0 0   55 0 46.4 CND 16.6 1.1 825 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada Albatrosului , NR. 41A 43.9588692 28.6394601 17.11.2015   RO-SITUR HOSTEL 2 - STELE 29068
24604 24604 VERAL RO stay hostels hostel normal 2 star 2 - STELE 44 20   45 0 0 0 0   55 0 47.1 CND 15.9 0.5 808 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada G-ral. Grigore Berindei , NR. 2 A 43.9525361 28.6386729 05.05.2012   RO-SITUR HOSTEL 2 - STELE 9083/8691
24624 24624 WHITE INN RO stay hostels hostel normal 2 star 2 - STELE 82 36 wedding 55 0 0 0 0   55 0 47.1 CND 15.9 0.4 808 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada Tineretului , NR. 52 43.9525428 28.6366119 12.08.2024   RO-SITUR HOSTEL 2 - STELE 5053/3588
24626 24626 WYP RO stay hostels hostel normal 2 star 2 - STELE 16 8   35 0 0 0 0   55 0 47.4 CND 15.1 0.5 817 Com. Costineşti, Sat Costineşti CONSTANŢA   43.94752 28.6269245 17.07.2018   RO-SITUR HOSTEL 2 - STELE 18713
24787 24787 CASA STELUŢELE MĂRII RO stay hostels hostel normal 2 star 2 - STELE 18 4   35 0 0 0 0   55 0 47.5 CND 15.0 0.5 822 Com. Costineşti, Sat Schitu CONSTANŢA STR. Strada Marinarilor , NR. 11A+11 43.946414 28.6237592 04.09.2020   RO-SITUR HOSTEL 2 - STELE 15794
24803 24803 CINDARELLA RO stay hostels hostel normal 2 star 2 - STELE 15 7   35 0 0 0 0   55 0 47.4 CND 15.2 0.5 817 Com. Costineşti, Sat Schitu CONSTANŢA STR. Strada Liliacului , NR. 17 43.9474866 28.62733 21.08.2023   RO-SITUR HOSTEL 2 - STELE 35738
24912 24912 SOLEIL RO stay hostels hostel normal 2 star 2 - STELE 54 15   45 0 0 0 0   70 20 27.6 CND 26.6 0.3 1 Com. Crucea, Sat Crucea CONSTANŢA STR. Strada Poliţiei , NR. 2 44.5307746 28.2334401 19.01.2012   RO-SITUR HOSTEL 2 - STELE 16424
25125 25125 ELGAS PUNK ROCK RO stay hostels hostel normal 2 star 2 - STELE 72 35   45 0 0 0 0   65 20 48.3 Balchik Airfield 7.0 6.0 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7536458 28.5712256 12.05.2011   RO-SITUR HOSTEL 2 - STELE 11961/7637
25215 25215 VAMA VECHE KM O RO stay hostels hostel normal 2 star 2 - STELE 28 6   35 0 0 0 0   65 0 50.6 Balchik Airfield 3.6 0.6 523 Com. Limanu, Sat Vama Veche CONSTANŢA NR. 16 43.7971944 28.53965 02.08.2013   RO-SITUR HOSTEL 2 - STELE 27127
25743 25743 CAZINO SUD RO stay hostels hostel normal 2 star 2 - STELE 45 24   45 0 0 0 0   80 10 17.9 CND 6.0 2.1 1024 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.234776 28.6265329 11.01.2016   RO-SITUR HOSTEL 2 - STELE 29368
26116 26116 ATLANTIC RO stay hostels hostel normal 2 star 2 - STELE 31 15   45 0 0 0 0   65 0 56.0 CND 5.6 0.9 746 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Plopilor , BL. C10 43.864589 28.595853 09.05.2011   RO-SITUR HOSTEL 2 - STELE 14478
26118 26118 ATLANTIC RO stay hostels hostel normal 2 star 2 - STELE 18 9   35 0 0 0 0   65 0 56.0 CND 5.7 0.7 734 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Plopilor , BL. C10 43.864865 28.6000836 16.07.2012   RO-SITUR HOSTEL 2 - STELE 9017/5788
26147 26147 DAYTONA RO stay hostels hostel normal 2 star 2 - STELE 14 7   35 0 0 0 0   65 0 55.9 CND 5.6 0.9 743 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Plopilor , BL. C9 43.865072 28.595319 02.05.2019   RO-SITUR HOSTEL 2 - STELE 19709
26189 26189 RIO RO stay hostels hostel normal 2 star 2 - STELE 36 18   45 0 0 0 0   65 0 56.0 CND 5.6 0.9 746 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Plopilor , BL. C10 43.864589 28.595853 28.07.2011   RO-SITUR HOSTEL 2 - STELE 7963/5560
26190 26190 ROSEMARIE RO stay hostels hostel normal 2 star 2 - STELE 65 19   45 0 0 0 0   80 0 18.1 CND 5.3 1.1 655 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Aleea Steagurilor , NR. 7 , BL. C9 44.2194847 28.5965967 18.07.2016   RO-SITUR HOSTEL 2 - STELE 5713/3698
26203 26203 TINERET VIRGO RO stay hostels hostel normal 2 star 2 - STELE 36 18   45 0 0 0 0   65 0 55.9 CND 5.6 0.9 743 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Plopilor , BL. C9 , ET. 3 43.865072 28.595319 24.07.2009   RO-SITUR HOSTEL 2 - STELE 6484/3896
26464 26464 DOBROGEA RO stay hostels hostel normal 2 star 2 - STELE 24 12   35 0 0 0 0   80 10 21.5 CND 1.0 1.0 12 Mun. Medgidia CONSTANŢA STR. Strada Decebal , NR. 33 44.2459202 28.271867 30.03.2012   RO-SITUR HOSTEL 2 - STELE 8350/6170
26510 26510 ALEXANDRA N RO stay hostels hostel normal 2 star 2 - STELE 36 8   45 0 0 0 0   55 0 35.2 CND 13.1 0.3 1143 Oraş Eforie, Loc. Eforie Nord CONSTANŢA STR. Strada Transilvaniei , NR. 20 44.062569 28.6307266 21.05.2012   RO-SITUR HOSTEL 2 - STELE 12788/8695
26766 26766 COMPLEX MAREA NEAGRA RO stay hostels hostel normal 2 star 2 - STELE 312 128 wedding 65 0 0 0 0   55 0 35.1 CND 13.0 0.2 1136 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0641579 28.63453 12.03.2025   RO-SITUR HOSTEL 2 - STELE 14925/8887
26915 26915 MAREA NEAGRĂ NUDA RO stay hostels hostel normal 2 star 2 - STELE 53 24   45 0 0 0 0   55 0 35.4 CND 13.4 0.6 1154 Oraş Eforie, Loc. Eforie Nord CONSTANŢA STR. Bulevardul 23 August , NR. 11 44.0606965 28.6290315 12.08.2024   RO-SITUR HOSTEL 2 - STELE 39231
26916 26916 MAREA VIEŢII RO stay hostels hostel normal 2 star 2 - STELE 128 32 wedding 55 0 0 0 0   55 0 33.9 CND 11.8 1.1 959 Oraş Eforie, Loc. Eforie Nord CONSTANŢA STR. Strada Meduzei , NR. 8-10 44.0745953 28.6295603 17.07.2023   RO-SITUR HOSTEL 2 - STELE 35070
27211 27211 EMMA RO stay hostels hostel normal 2 star 2 - STELE 40 13   45 0 0 0 0   55 0 39.5 CND 17.3 0.3 834 Oraş Eforie, Loc. Eforie Sud CONSTANŢA   44.0258361 28.6486349 26.09.2016   RO-SITUR HOSTEL 2 - STELE 30147
28283 28283 LA PEŞTE RO stay hostels hostel normal 2 star 2 - STELE 16 4   35 0 0 0 0   80 10 13.5 CND 4.0 3.2 2200 Oraş Năvodari CONSTANŢA STR. Bulevardul Mamaia Nord , NR. 32T 44.2832336 28.6176128 22.05.2019   RO-SITUR HOSTEL 2 - STELE 19777
28423 28423 MAX RO stay hostels hostel normal 2 star 2 - STELE 16 8   35 0 0 0 0   80 10 15.6 CND 6.8 3.4 1554 Oraş Năvodari CONSTANŢA STR. Strada DC86 , NR. 2 44.2570702 28.6182702 30.07.2013   RO-SITUR HOSTEL 2 - STELE 9643/6002
29607 29607 CENTRUL DE AGREMENT ZĂBALA RO stay hostels hostel normal 2 star 2 - STELE 14 4   35 0 0 0 0   55 0 55.5 GHV 13.2 1.5 58 Com. Zăbala, Sat Zăbala COVASNA NR. 678/O 45.887703 26.189789 24.11.2016   RO-SITUR HOSTEL 2 - STELE 30342
29655 29655 ŞCOALA PĂDURII VIZIUNA VULPII RO stay hostels hostel normal 2 star 2 - STELE 26 6   35 0 0 0 0   80 0 26.9 GHV 0.8 0.8 63 Mun. Sfântu Gheorghe COVASNA   45.8609375 25.7885796 09.12.2022   RO-SITUR HOSTEL 2 - STELE 32997
29673 29673 GYOZO RO stay hostels hostel normal 2 star 2 - STELE 23 7   35 0 0 0 0   65 0 57.4 GHV 0.5 0.5 27 Mun. Târgu Secuiesc COVASNA STR. Strada Turia , NR. 5 46.002871 26.129069 07.09.2016   RO-SITUR HOSTEL 2 - STELE 30085
29679 29679 SZIKLA RO stay hostels hostel normal 2 star 2 - STELE 19 6   35 0 0 0 0   65 0 57.9 GHV 0.7 0.7 27 Mun. Târgu Secuiesc COVASNA STR. Strada Ady Endre , NR. 40 46.006149 26.1326953 29.11.2011   RO-SITUR HOSTEL 2 - STELE 12368/8428
29865 29865 AFC RO stay hostels hostel normal 2 star 2 - STELE 22 10   35 0 0 0 0   65 0 65.0 OTP 1.1 1.1 82 Mun. Târgovişte DÂMBOVIŢA STR. Bulevardul Unirii , NR. 2 44.921853 25.444234 14.12.2009   RO-SITUR HOSTEL 2 - STELE 4116/1736
29914 29914 RODIV RO stay hostels hostel normal 2 star 2 - STELE 22 11   35 0 0 0 0   65 10 64.1 OTP 0.6 0.6 11 Oraş Găeşti DÂMBOVIŢA   44.7208717 25.3206978 07.08.2013   RO-SITUR HOSTEL 2 - STELE 4665/2083
30175 30175 ROCOOP RO stay hostels hostel normal 2 star 2 - STELE 32 14   45 0 0 0 0   65 10 39.9 CRA 0.8 0.8 9 Oraş Filiaşi DOLJ STR. Bulevardul Racoţeanu , NR. 188 44.5565872 23.5131223 22.04.2010   RO-SITUR HOSTEL 2 - STELE 13372
30178 30178 JOLIE 2 RO stay hostels hostel normal 2 star 2 - STELE 32 8   45 0 0 0 0   65 0 49.6 Cahul International Airport 1.5 1.5 166   GALAŢI NR. 203A 45.4260957 28.0396163 27.08.2019   RO-SITUR HOSTEL 2 - STELE 20297
30220 30220 CANCAZ RO stay hostels hostel normal 2 star 2 - STELE 70 35   45 0 0 0 0   65 0 48.4 Cahul International Airport 1.3 1.3 174 Mun. Galaţi GALAŢI STR. Strada Tecuci , NR. 161 45.4389074 28.0336973 04.07.2018   RO-SITUR HOSTEL 2 - STELE 18684
30324 30324 AZUR 1 RO stay hostels hostel normal 2 star 2 - STELE 38 12   45 0 0 0 0   55 20 37.1 BBU 25.8 0.3 3 Com. Găiseni, Sat Căscioarele GIURGIU   44.4996271 25.6347739 10.10.2011   RO-SITUR HOSTEL 2 - STELE 11963/8140
30419 30419 IUNONA 2 RO stay hostels hostel normal 2 star 2 - STELE 24 8   35 0 0 0 0   45 0 72.4 SBZ 40.2 1.0 125 Com. Baia de Fier, Sat Baia de Fier GORJ   45.1753179 23.7644667 13.01.2016   RO-SITUR HOSTEL 2 - STELE 29382
30548 30548 ANDRA RO stay hostels hostel normal 2 star 2 - STELE 65 17   45 0 0 0 0   55 20 59.7 CRA 21.6 0.8 3 Com. Plopşoru, Sat Izvoarele GORJ NR. 77 44.7234525 23.3945188 18.08.2016   RO-SITUR HOSTEL 2 - STELE 14554A
30572 30572 PAN RO stay hostels hostel normal 2 star 2 - STELE 6 3   35 0 0 0 0   45 0 71.3 SBZ 42.4 0.6 124 Com. Polovragi, Sat Polovragi GORJ   45.1779928 23.7972575 24.11.2011   RO-SITUR HOSTEL 2 - STELE 16175
30644 30644 COMIS RO stay hostels hostel normal 2 star 2 - STELE 12 6   35 0 0 0 0   50 10 89.1 CSB 0.5 0.5 12 Mun. Motru GORJ STR. Aleea Teilor , NR. 2 44.8036903 22.9779865 22.12.2009   RO-SITUR HOSTEL 2 - STELE 13278
30651 30651 ACH RO stay hostels hostel normal 2 star 2 - STELE 20 20   35 0 0 0 0   50 0 89.5 CSB 1.1 1.1 127 Mun. Târgu Jiu GORJ STR. Strada Hidrocentralei , NR. 49 45.05538 23.271657 26.08.2013   RO-SITUR HOSTEL 2 - STELE 12320
30776 30776 CONDOR RO stay hostels hostel normal 2 star 2 - STELE 62 29   45 0 0 0 0   55 30 63.8 SBZ 27.1 11.8 38 Oraş Novaci GORJ   45.2892748 23.6770043 26.08.2019   RO-SITUR HOSTEL 2 - STELE 20269
30843 30843 SFÂNTUL NICODIM RO stay hostels hostel normal 2 star 2 - STELE 67 21   45 0 0 0 0   55 20 66.9 CSB 26.9 2.3 19 Oraş Tismana, Sat Tismana GORJ   45.0644089 22.9415184 21.11.2011   RO-SITUR HOSTEL 2 - STELE 9821/6228
30847 30847 TISMANA RO stay hostels hostel normal 2 star 2 - STELE 112 56 wedding 55 0 0 0 0   55 20 66.9 CSB 26.9 2.3 19 Oraş Tismana, Sat Tismana GORJ   45.0644089 22.9415184 23.09.2013   RO-SITUR HOSTEL 2 - STELE 27225
30898 30898 SCOALA PADURII RO stay hostels hostel normal 2 star 2 - STELE 37 9   45 0 0 0 0   55 20 75.6 BCM 11.7 1.3 1 Com. Ciucsângeorgiu, Sat Potiond HARGHITA NR. 212-214 46.3632401 25.9512087 03.08.2010   RO-SITUR HOSTEL 2 - STELE 10959/6929
30974 30974 HAVAS BUCSIN RO stay hostels hostel normal 2 star 2 - STELE 23 6   35 0 0 0 0   50 0 87.4 TGM 7.8 0.4 21 Com. Joseni, Sat Joseni HARGHITA   46.6989299 25.504907 18.08.2016   RO-SITUR HOSTEL 2 - STELE 30065
31041 31041 CASA ERSA RO stay hostels hostel normal 2 star 2 - STELE 83 25 wedding 55 0 0 0 0   65 0 63.0 TGM 8.9 0.3 28 Com. Lupeni, Sat Morăreni HARGHITA STR. Strada Principală , NR. 139 46.3571262 25.2189094 29.10.2024   RO-SITUR HOSTEL 2 - STELE 28640
31084 31084 ANI RO stay hostels hostel normal 2 star 2 - STELE 54 18   45 0 0 0 0   45 0 55.6 TGM 31.3 0.7 135 Com. Praid, Sat Praid HARGHITA NR. 54B 46.5553429 25.1272723 16.04.2010   RO-SITUR HOSTEL 2 - STELE 8918/6612
31233 31233 CSUR 1 RO stay hostels hostel normal 2 star 2 - STELE 34 5   45 0 0 0 0   55 40 56.5 TGM 16.3 5.9 2 Com. Şimoneşti, Sat Ceheţel HARGHITA NR. 14 46.398746 25.1423877 02.10.2019   RO-SITUR HOSTEL 2 - STELE 20520
31234 31234 CSUR 2 RO stay hostels hostel normal 2 star 2 - STELE 22 4   35 0 0 0 0   55 40 56.5 TGM 16.3 5.9 2 Com. Şimoneşti, Sat Ceheţel HARGHITA NR. 23 - 24 46.398746 25.1423877 02.10.2019   RO-SITUR HOSTEL 2 - STELE 20521

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE venues ("name" TEXT, "country" TEXT, "group" TEXT, "family" TEXT, "venue_type" TEXT, "type_granularity" TEXT, "rating_value" INTEGER, "rating_scheme" TEXT, "rating_label" TEXT, "capacity_persons" INTEGER, "rooms" INTEGER, "best_for" TEXT, "fit_wedding" INTEGER, "fit_conference" INTEGER, "fit_banquet" INTEGER, "fit_spa" INTEGER, "fit_party" INTEGER, "common_areas" TEXT, "reachability_score" INTEGER, "isolation_score" INTEGER, "airport_km" REAL, "nearest_airport" TEXT, "city_km" REAL, "town_km" REAL, "venues_5km" INTEGER, "city" TEXT, "municipality" TEXT, "address" TEXT, "lat" REAL, "lng" REAL, "valid_until" TEXT, "stop_date" TEXT, "source" TEXT, "source_type" TEXT, "source_category" TEXT, "cert_number" TEXT);
CREATE INDEX idx_country ON venues("country");
CREATE INDEX idx_group ON venues("group");
CREATE INDEX idx_family ON venues("family");
CREATE INDEX idx_venue_type ON venues("venue_type");
CREATE INDEX idx_rating_value ON venues("rating_value");
CREATE INDEX idx_rating_scheme ON venues("rating_scheme");
CREATE INDEX idx_city ON venues("city");
CREATE INDEX idx_best_for ON venues("best_for");
CREATE INDEX idx_common_areas ON venues("common_areas");