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
290 rows where family = "hostels" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: rating_label, fit_wedding, reachability_score, isolation_score, nearest_airport, source, source_type, source_category, valid_until (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15661 | 15661 | TERRA MYTHICA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 172 | 33 | wedding | 75 | 0 | 0 | 0 | 0 | 55 | 10 | 49.1 | Câmpia Turzii Air Base | 10.2 | 0.8 | 17 | Com. Ighiu, Sat Ighiu | ALBA | NR. 325 | 46.1438947 | 23.5121564 | 09.03.2021 | RO-SITUR | HOSTEL | 3 - STELE | 13868/9133 | ||
| 15804 | 15804 | PERLA MĂRTINIEI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 14 | 5 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 37.6 | SBZ | 18.3 | 0.5 | 15 | Com. Şugag, Sat Mărtinie | ALBA | STR. Strada Valea Mărtiniei , NR. 81A | 45.792978 | 23.6022296 | 06.12.2017 | RO-SITUR | HOSTEL | 3 - STELE | 31130 | |||
| 15981 | 15981 | TARA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 88 | 38 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 10 | 46.2 | Câmpia Turzii Air Base | 7.6 | 2.1 | 24 | Mun. Alba Iulia | ALBA | NR. 25 | 46.1288213 | 23.6229013 | 10.05.2019 | RO-SITUR | HOSTEL | 3 - STELE | 5685/3603 | ||
| 16062 | 16062 | EUROPA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 54 | 21 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 12.5 | Câmpia Turzii Air Base | 1.0 | 1.0 | 14 | Oraş Ocna Mureş | ALBA | STR. Strada Mihail Eminescu , NR. 27 | 46.391913 | 23.8540141 | 28.07.2022 | RO-SITUR | HOSTEL | 3 - STELE | 31785 | ||
| 16479 | 16479 | DRACULA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 120 | 40 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 65.9 | SBZ | 22.5 | 0.2 | 88 | Com. Arefu, Sat Căpăţânenii Ungureni | ARGEŞ | 45.3346043 | 24.6357864 | 20.12.2018 | RO-SITUR | HOSTEL | 3 - STELE | 27941 | |||
| 16552 | 16552 | MESTEACĂNUL | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 60 | 15 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 59.8 | GHV | 33.1 | 0.6 | 76 | Com. Bughea de Sus, Sat Bughea de Sus | ARGEŞ | NR. 621 | 45.2931835 | 25.0312529 | 14.04.2021 | RO-SITUR | HOSTEL | 3 - STELE | 16266 | ||
| 16642 | 16642 | CASA CHEILE DÂMBOVICIOAREI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 19 | 7 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 40.7 | GHV | 18.5 | 3.4 | 105 | Com. Dâmbovicioara, Sat Dâmbovicioara | ARGEŞ | NR. 268 | 45.4138549 | 25.2060801 | 22.12.2022 | RO-SITUR | HOSTEL | 3 - STELE | 33253 | |||
| 16743 | 16743 | MONTE CARLO | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 148 | 79 | wedding | 65 | 0 | 0 | 0 | 0 | 50 | 0 | 95.6 | CRA | 2.3 | 1.7 | 151 | Com. Moşoaia, Sat Smeura | ARGEŞ | STR. Strada Gazului , NR. 3 | 44.8492677 | 24.8377879 | 29.07.2021 | RO-SITUR | HOSTEL | 3 - STELE | 6664/7256 | ||
| 16750 | 16750 | DORUL PESCARULUI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 8 | 45 | 0 | 0 | 0 | 0 | 40 | 20 | 81.4 | GHV | 10.7 | 3.8 | 11 | Com. Muşăteşti, Sat Vâlsăneşti | ARGEŞ | 45.1832346 | 24.7910043 | 29.10.2020 | RO-SITUR | HOSTEL | 3 - STELE | 21983 | ||||
| 16885 | 16885 | CERAMUS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 54 | 17 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 62.2 | GHV | 31.3 | 1.9 | 68 | Mun. Câmpulung | ARGEŞ | NR. 2 | 45.267657 | 25.025716 | 05.09.2018 | RO-SITUR | HOSTEL | 3 - STELE | 18920 | ||
| 16918 | 16918 | GEOSTAR II | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 22 | 7 | 45 | 0 | 0 | 0 | 0 | 50 | 0 | 85.6 | SBZ | 0.2 | 0.2 | 72 | Mun. Curtea de Argeş | ARGEŞ | STR. Strada Negru Vodă , NR. 93 | 45.1358808 | 24.6755695 | 20.06.2019 | RO-SITUR | HOSTEL | 3 - STELE | 19945 | |||
| 16986 | 16986 | FLAMINGO | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 20 | 10 | 45 | 0 | 0 | 0 | 0 | 50 | 0 | 97.6 | CRA | 0.4 | 0.4 | 142 | Mun. Piteşti | ARGEŞ | STR. Strada Violetelor , NR. 11 | 44.8531652 | 24.8653277 | 06.04.2011 | RO-SITUR | HOSTEL | 3 - STELE | 14142 | |||
| 17141 | 17141 | MARIO RESORT | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 383 | 131 | wedding | 75 | 0 | 0 | 0 | 0 | 65 | 0 | 31.8 | BCM | 1.5 | 1.5 | 22 | Com. Poduri, Sat Poduri | BACĂU | STR. Albotești | 46.4871315 | 26.4976555 | 27.05.2025 | RO-SITUR | HOSTEL | 3 - STELE | 30184 | ||
| 17206 | 17206 | HAMLET | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 20 | 10 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 4.7 | BCM | 0.3 | 0.3 | 143 | Mun. Bacău | BACĂU | STR. Calea Mărăşeşti , NR. 5 | 46.5645295 | 26.9135514 | 29.08.2017 | RO-SITUR | HOSTEL | 3 - STELE | 29363 | |||
| 17207 | 17207 | HANAMI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 17 | 8 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.7 | BCM | 1.6 | 1.6 | 142 | Mun. Bacău | BACĂU | STR. Strada Tecuciului , NR. 60 | 46.5704752 | 26.9341224 | 15.02.2018 | RO-SITUR | HOSTEL | 3 - STELE | 31313 | |||
| 17209 | 17209 | KARISMA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 12 | 6 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 9.2 | BCM | 4.2 | 0.5 | 119 | Mun. Bacău | BACĂU | STR. Calea Moldovei , NR. 238A | 46.6043136 | 26.9029631 | 14.12.2016 | RO-SITUR | HOSTEL | 3 - STELE | 30416 | |||
| 17231 | 17231 | SPEED PARK | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 15 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 2.5 | BCM | 5.0 | 1.2 | 53 | Mun. Bacău | BACĂU | STR. Strada Chimiei , NR. 12 | 46.5266726 | 26.9426757 | 23.12.2015 | RO-SITUR | HOSTEL | 3 - STELE | 27495 | ||
| 18203 | 18203 | FELIX | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 103 | 32 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 4.5 | OMR | 2.0 | 2.0 | 363 | Mun. Oradea | BIHOR | STR. Strada Mihai Eminescu , NR. 11 | 47.0601654 | 21.9336171 | 26.04.2010 | RO-SITUR | HOSTEL | 3 - STELE | 9812/6646 | ||
| 18241 | 18241 | JUNIOR | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 29 | 15 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 4.7 | OMR | 4.1 | 2.4 | 584 | Mun. Oradea | BIHOR | STR. Strada Ogorului , NR. 63 | 47.0278235 | 21.9648451 | 17.02.2011 | RO-SITUR | HOSTEL | 3 - STELE | 13845 | |||
| 18251 | 18251 | LAN | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 84 | 40 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 10 | 5.2 | OMR | 2.9 | 2.9 | 339 | Mun. Oradea | BIHOR | STR. Strada Budai Nagy Antal , NR. 31 | 47.0714823 | 21.9128762 | 20.10.2011 | RO-SITUR | HOSTEL | 3 - STELE | 15970 | ||
| 18311 | 18311 | POSTICUM-MOVIMENTUM IUVENTUTTIS CHRISTIANAE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 32 | 10 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 3.3 | OMR | 1.4 | 1.4 | 393 | Mun. Oradea | BIHOR | STR. Strada Teiului , NR. 26 | 47.0439611 | 21.9364568 | 15.09.2017 | RO-SITUR | HOSTEL | 3 - STELE | 30792 | ||
| 18708 | 18708 | SAPHIR | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 13 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 74.3 | CLJ | 1.6 | 1.6 | 91 | Mun. Bistriţa | BISTRIŢA-NĂSĂUD | STR. Strada Calea Moldovei , NR. 15C | 47.1455223 | 24.511075 | 17.07.2023 | RO-SITUR | HOSTEL | 3 - STELE | 14261 | ||
| 19348 | 19348 | EUROPARK | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 36 | 10 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 35.0 | GHV | 14.3 | 1.9 | 239 | Com. Fundata, Sat Fundăţica | BRAŞOV | NR. 219 B | 45.433257 | 25.2978499 | 03.12.2020 | RO-SITUR | HOSTEL | 3 - STELE | 19390 | ||
| 19367 | 19367 | POARTA CRAIULUI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 19 | 7 | 45 | 0 | 0 | 0 | 0 | 55 | 0 | 32.3 | GHV | 12.4 | 0.7 | 337 | Com. Fundata, Sat Şirnea | BRAŞOV | NR. 146 | 45.4491878 | 25.3280052 | 23.06.2023 | RO-SITUR | HOSTEL | 3 - STELE | 34890 | |||
| 20099 | 20099 | ASTRA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 81 | 23 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 10.8 | GHV | 1.8 | 1.8 | 1131 | Mun. Braşov | BRAŞOV | STR. Strada Carpaţilor , NR. 60 , BL. OBIECT.96 | 45.6414274 | 25.6264872 | 08.11.2011 | RO-SITUR | HOSTEL | 3 - STELE | 16135 | ||
| 20119 | 20119 | BALCESCU | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 5 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 8.9 | GHV | 1.1 | 1.1 | 1178 | Mun. Braşov | BRAŞOV | STR. Strada Nicolae Bălcescu , NR. 45 , ET. II , AP. 10 | 45.6427725 | 25.594811 | 03.08.2022 | RO-SITUR | HOSTEL | 3 - STELE | 31848 | |||
| 20606 | 20606 | LA MAISONNETE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 14 | 5 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 8.7 | GHV | 1.4 | 1.4 | 1174 | Mun. Braşov | BRAŞOV | STR. Piaţa Sfatului , NR. 6 , AP. 3A1 | 45.6427062 | 25.5899557 | 21.12.2022 | RO-SITUR | HOSTEL | 3 - STELE | 27610 | |||
| 20694 | 20694 | MONIK | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 27 | 14 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 10.0 | GHV | 1.4 | 1.4 | 1128 | Mun. Braşov | BRAŞOV | STR. Strada Tomis , NR. 12 | 45.6495376 | 25.6238192 | 29.11.2011 | RO-SITUR | HOSTEL | 3 - STELE | 16248 | |||
| 21292 | 21292 | ZIUREL | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 60 | 14 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 16.7 | GHV | 1.1 | 1.1 | 110 | Mun. Săcele | BRAŞOV | STR. Bulevardul George Moroianu , NR. 17 | 45.6184357 | 25.6977481 | 28.09.2020 | RO-SITUR | HOSTEL | 3 - STELE | 21263 | ||
| 21302 | 21302 | NOMAD | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 23 | 6 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 4.4 | GHV | 5.8 | 0.7 | 108 | Oraş Ghimbav, Sat Ghimbav | BRAŞOV | STR. Strada Lungă , NR. 22 , ET. 1 | 45.6669433 | 25.5085228 | 08.05.2019 | RO-SITUR | HOSTEL | 3 - STELE | 19736 | |||
| 21388 | 21388 | COMPLEX PANORAMIC | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 70 | 22 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 0 | 22.2 | GHV | 13.3 | 1.8 | 339 | Oraş Predeal | BRAŞOV | STR. Strada Nicolae Bălcescu , NR. 31 | 45.5104026 | 25.5849748 | 25.09.2024 | RO-SITUR | HOSTEL | 3 - STELE | 8491/5219 | ||
| 21462 | 21462 | MOUNTAIN BREEZE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 60 | 24 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 0 | 22.3 | GHV | 13.1 | 1.4 | 339 | Oraş Predeal | BRAŞOV | STR. Strada Nicolae Bălcescu , NR. 8 - 10 | 45.5089631 | 25.5799885 | 23.12.2022 | RO-SITUR | HOSTEL | 3 - STELE | 33323 | ||
| 21785 | 21785 | PIATRA CRAIULUI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 55 | 17 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 20.9 | GHV | 1.8 | 1.8 | 193 | Oraş Zărneşti | BRAŞOV | STR. Strada Policlinicii , NR. 12 | 45.5703878 | 25.3366817 | 08.09.2023 | RO-SITUR | HOSTEL | 3 - STELE | 36017 | ||
| 21974 | 21974 | DENISA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 8 | 45 | 0 | 0 | 0 | 0 | 70 | 10 | 19.6 | Boboc Air Base | 10.1 | 1.5 | 6 | Com. Verneşti, Sat Verneşti | BUZĂU | STR. Strada Principală , NR. 200 | 45.2033035 | 26.7290906 | 18.02.2019 | RO-SITUR | HOSTEL | 3 - STELE | 31334 | |||
| 22050 | 22050 | ORHIDEEA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 34 | 16 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 13.9 | Boboc Air Base | 0.7 | 0.7 | 138 | Mun. Buzău | BUZĂU | STR. Strada Mesteacănului , NR. 10 (Activu | 45.1534847 | 26.825185 | 17.11.2015 | RO-SITUR | HOSTEL | 3 - STELE | 29015 | ||
| 22120 | 22120 | CASA DIN VIS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 126 | 53 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 10 | 36.5 | Feteşti Borcea Air Base | 12.7 | 2.5 | 28 | Mun. Călăraşi | CĂLĂRAŞI | STR. Prelungirea Sloboziei , NR. 74B | 44.21522 | 27.3410746 | 17.08.2022 | RO-SITUR | HOSTEL | 3 - STELE | 31931 | ||
| 22200 | 22200 | LA PĂDURE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 10 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 20 | 20.5 | CSB | 15.4 | 0.2 | 4 | Com. Brebu, Sat Brebu | CARAŞ-SEVERIN | 45.4197631 | 21.9898934 | 16.10.2023 | RO-SITUR | HOSTEL | 3 - STELE | 36490 | |||
| 22399 | 22399 | MISIAN MURA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 16 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 3.6 | CSB | 0.8 | 0.8 | 47 | Mun. Caransebeş | CARAŞ-SEVERIN | STR. Strada Nicolae Bălcescu , NR. 57 | 45.413969 | 22.206674 | 10.11.2011 | RO-SITUR | HOSTEL | 3 - STELE | 16147 | ||
| 22402 | 22402 | ŞANSA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 11 | 5 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 2.4 | CSB | 1.6 | 1.6 | 48 | Mun. Caransebeş | CARAŞ-SEVERIN | STR. Strada Ardealului , NR. 166 A | 45.4298111 | 22.2251584 | 25.06.2012 | RO-SITUR | HOSTEL | 3 - STELE | 12810/8800 | |||
| 22513 | 22513 | ELITE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 15 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 62.0 | CSB | 33.4 | 0.6 | 215 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Vicol , NR. 3 | 44.8746025 | 22.4143376 | 19.08.2010 | RO-SITUR | HOSTEL | 3 - STELE | 7343/5217 | ||
| 22548 | 22548 | PARADIS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 49 | 22 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 61.9 | CSB | 33.5 | 0.6 | 217 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Trandafirilor , NR. 18A | 44.8748054 | 22.410898 | 09.07.2015 | RO-SITUR | HOSTEL | 3 - STELE | 11036/5718 | ||
| 22559 | 22559 | SARAS SONS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 46 | 23 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 61.3 | CSB | 33.9 | 0.2 | 217 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Aleea Teilor , NR. 2A | 44.8807379 | 22.4152774 | 21.05.2010 | RO-SITUR | HOSTEL | 3 - STELE | 7941/3950 | ||
| 22607 | 22607 | CARAŞ | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 63 | 17 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 10 | 61.4 | CSB | 31.0 | 1.1 | 13 | Oraş Oraviţa | CARAŞ-SEVERIN | STR. Strada Zona Gării , BL. E6 | 45.040898 | 21.6831296 | 27.06.2019 | RO-SITUR | HOSTEL | 3 - STELE | 20015 | ||
| 23105 | 23105 | SEQUOIA E | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 28 | 8 | 45 | 0 | 0 | 0 | 0 | 45 | 10 | 60.9 | CLJ | 43.8 | 0.1 | 19 | Com. Săcuieu, Sat Săcuieu | CLUJ | NR. 211/E | 46.8223392 | 22.8872171 | 15.01.2019 | RO-SITUR | HOSTEL | 3 - STELE | 29785 | |||
| 23106 | 23106 | SEQUOIA F | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 69 | 21 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 10 | 60.9 | CLJ | 43.8 | 0.1 | 19 | Com. Săcuieu, Sat Săcuieu | CLUJ | NR. 211/E | 46.8223392 | 22.8872171 | 15.01.2019 | RO-SITUR | HOSTEL | 3 - STELE | 29786 | ||
| 23220 | 23220 | ABI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 8 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 4.7 | CLJ | 2.4 | 2.4 | 1133 | Mun. Cluj-Napoca | CLUJ | STR. Strada Târnavelor , NR. 23 | 46.7790862 | 23.6253468 | 28.04.2011 | RO-SITUR | HOSTEL | 3 - STELE | 8497/5595A | |||
| 23399 | 23399 | CITY CENTRAL | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 58 | 34 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 8.0 | CLJ | 1.1 | 1.1 | 1222 | Mun. Cluj-Napoca | CLUJ | STR. Strada Dr. Victor Babeş , NR. 13 | 46.765716 | 23.5855248 | 19.09.2017 | RO-SITUR | HOSTEL | 3 - STELE | 30811 | ||
| 24249 | 24249 | BELVEDERE B6 | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 130 | 60 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 47.9 | CND | 15.0 | 0.7 | 818 | Com. Costineşti, Sat Costineşti | CONSTANŢA | STR. Aleea Studenţească | 43.9443545 | 28.6362735 | 09.09.2025 | RO-SITUR | HOSTEL | 3 - STELE | 31568 | ||
| 24429 | 24429 | D.V.G. | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 38 | 19 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 47.9 | CND | 15.1 | 0.6 | 814 | Com. Costineşti, Sat Costineşti | CONSTANŢA | NR. 418 | 43.9448073 | 28.6362195 | 31.07.2018 | RO-SITUR | HOSTEL | 3 - STELE | 3986/3092 | ||
| 24430 | 24430 | D.V.G. TABERE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 40 | 10 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 47.9 | CND | 15.1 | 0.6 | 814 | Com. Costineşti, Sat Costineşti | CONSTANŢA | NR. 290 | 43.9448073 | 28.6362195 | 31.07.2018 | RO-SITUR | HOSTEL | 3 - STELE | 18766 | ||
| 24479 | 24479 | IUNONA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 70 | 35 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 46.7 | CND | 16.3 | 0.7 | 812 | Com. Costineşti, Sat Costineşti | CONSTANŢA | STR. Strada Tineretului , NR. 86A | 43.9557907 | 28.6380139 | 17.06.2021 | RO-SITUR | HOSTEL | 3 - STELE | 2586/1493 | ||
| 24538 | 24538 | PERLA COSTINEŞTI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 135 | 45 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 47.9 | CND | 15.1 | 0.6 | 814 | Com. Costineşti, Sat Costineşti | CONSTANŢA | NR. 229-237 | 43.9448073 | 28.6362195 | 28.09.2020 | RO-SITUR | HOSTEL | 3 - STELE | 18664 | ||
| 24542 | 24542 | PIERRE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 38 | 19 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 46.8 | CND | 16.2 | 0.7 | 812 | Com. Costineşti, Sat Costineşti | CONSTANŢA | STR. Strada Azurului , NR. 2 , ET. 1 | 43.9550562 | 28.6392526 | 14.05.2026 | RO-SITUR | HOSTEL | 3 - STELE | 9039/5810 | ||
| 24573 | 24573 | STEFANIA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 188 | 94 | wedding | 75 | 0 | 0 | 0 | 0 | 55 | 0 | 47.4 | CND | 15.4 | 0.2 | 811 | Com. Costineşti, Sat Costineşti | CONSTANŢA | 43.948293 | 28.6326526 | 22.08.2023 | RO-SITUR | HOSTEL | 3 - STELE | 12906 | |||
| 24607 | 24607 | VERONA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 10 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 46.4 | CND | 16.8 | 1.3 | 827 | Com. Costineşti, Sat Costineşti | CONSTANŢA | STR. Strada Pescarului , NR. 4 | 43.959575 | 28.6415368 | 19.06.2019 | RO-SITUR | HOSTEL | 3 - STELE | 19914 | ||
| 24878 | 24878 | PARADISUL COLORAT | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 89 | 28 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 48.1 | CND | 14.3 | 0.4 | 841 | Com. Costineşti, Sat Schitu | CONSTANŢA | STR. Strada Radarului | 43.940521 | 28.6240813 | 10.10.2016 | RO-SITUR | HOSTEL | 3 - STELE | 30059 | ||
| 24898 | 24898 | SEA BREEZE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 63 | 23 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 47.7 | CND | 14.9 | 0.3 | 821 | Com. Costineşti, Sat Schitu | CONSTANŢA | STR. Strada Şcolii , NR. 14 | 43.9448685 | 28.6270902 | 11.09.2024 | RO-SITUR | HOSTEL | 3 - STELE | 23352 | ||
| 24953 | 24953 | CASA EVELIN | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 36 | 12 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 10 | 51.6 | Balchik Airfield | 3.1 | 3.1 | 834 | Com. Limanu, Sat 2 Mai | CONSTANŢA | STR. Strada Mihail Kogălniceanu , NR. 468A | 43.7886906 | 28.577788 | 17.05.2021 | RO-SITUR | HOSTEL | 3 - STELE | 23125 | ||
| 25047 | 25047 | AMPHORA VAMA VECHE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 39 | 16 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 20 | 48.3 | Balchik Airfield | 7.3 | 6.4 | 375 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Falezei , NR. 36 | 43.750951 | 28.5761675 | 09.07.2025 | RO-SITUR | HOSTEL | 3 - STELE | 27143 | ||
| 25088 | 25088 | CASA KAROL | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 29 | 11 | 45 | 0 | 0 | 0 | 0 | 65 | 20 | 48.3 | Balchik Airfield | 6.9 | 5.9 | 376 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Nichita Stănescu , NR. 5 | 43.7544361 | 28.5703546 | 12.11.2020 | RO-SITUR | HOSTEL | 3 - STELE | 22201 | |||
| 25104 | 25104 | CASA ROBINSON | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 38 | 10 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 20 | 48.2 | Balchik Airfield | 7.3 | 6.4 | 375 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Midiei , NR. 7 | 43.7507924 | 28.5745242 | 26.07.2021 | RO-SITUR | HOSTEL | 3 - STELE | 23495 | ||
| 25143 | 25143 | LA JOHN | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 26 | 13 | 45 | 0 | 0 | 0 | 0 | 65 | 20 | 48.4 | Balchik Airfield | 6.9 | 6.1 | 376 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Falezei , NR. 5-7 | 43.7537813 | 28.5740955 | 20.10.2016 | RO-SITUR | HOSTEL | 3 - STELE | 30249 | |||
| 25147 | 25147 | LA PIOVRA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 25 | 10 | 45 | 0 | 0 | 0 | 0 | 65 | 20 | 48.6 | Balchik Airfield | 6.6 | 5.7 | 378 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Pescarilor , NR. 24 | 43.756965 | 28.5723363 | 28.12.2021 | RO-SITUR | HOSTEL | 3 - STELE | 24017 | |||
| 25151 | 25151 | LA TORTUGA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 20 | 5 | 45 | 0 | 0 | 0 | 0 | 65 | 20 | 48.2 | Balchik Airfield | 7.3 | 6.4 | 375 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Midiei , NR. 5 | 43.7508418 | 28.5747664 | 02.03.2022 | RO-SITUR | HOSTEL | 3 - STELE | 23439 | |||
| 25188 | 25188 | SEA STAR | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 47 | 21 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 20 | 48.3 | Balchik Airfield | 6.9 | 5.9 | 376 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Tudor Vladimirescu , NR. 10 | 43.7542398 | 28.5713149 | 16.06.2021 | RO-SITUR | HOSTEL | 3 - STELE | 15369 | ||
| 25197 | 25197 | SUNSET BEACH | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 43 | 20 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 20 | 48.4 | Balchik Airfield | 7.0 | 6.1 | 375 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Falezei , NR. 16 | 43.753275 | 28.5742677 | 17.07.2012 | RO-SITUR | HOSTEL | 3 - STELE | 6021/6067 | ||
| 25266 | 25266 | LA NAȘU | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 60 | 19 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 20 | 22.0 | CND | 11.6 | 2.0 | 2 | Com. Valu lui Traian, Sat Valu lui Traian | CONSTANŢA | STR. Strada Calea Dobrogei , NR. 1 | 44.1647609869096 | 28.4910871190491 | 27.08.2025 | RO-SITUR | HOSTEL | 3 - STELE | 43750 | ||
| 25385 | 25385 | COMPLEX UNIRII | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 26 | 13 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 22.6 | CND | 2.3 | 2.3 | 769 | Mun. Constanţa | CONSTANŢA | STR. Strada Unirii , NR. 32-34 | 44.1970361 | 28.6526257 | 02.10.2024 | RO-SITUR | HOSTEL | 3 - STELE | 39773 | |||
| 25762 | 25762 | DONA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 70 | 35 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 15.2 | CND | 6.2 | 4.0 | 1841 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2623995 | 28.6187463 | 21.07.2009 | RO-SITUR | HOSTEL | 3 - STELE | 7512/3679 | |||
| 25809 | 25809 | MIGNON MAMAIA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 19 | 8 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 17.3 | CND | 6.7 | 2.2 | 1030 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2405811 | 28.6232684 | 16.04.2021 | RO-SITUR | HOSTEL | 3 - STELE | 11941/7641 | ||||
| 26117 | 26117 | ATLANTIC | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 7 | 45 | 0 | 0 | 0 | 0 | 65 | 10 | 56.3 | CND | 4.8 | 2.8 | 877 | Mun. Mangalia, Loc. Neptun | CONSTANŢA | STR. Strada Plopilor | 43.859419 | 28.5706322 | 09.07.2012 | RO-SITUR | HOSTEL | 3 - STELE | 8851/5646 | |||
| 26126 | 26126 | CASA REBECA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 18 | 6 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 56.0 | CND | 5.6 | 0.8 | 745 | Mun. Mangalia, Loc. Neptun | CONSTANŢA | STR. Strada Trandafirilor , NR. 15B | 43.8647027 | 28.5967892 | 27.07.2021 | RO-SITUR | HOSTEL | 3 - STELE | 20143 | |||
| 26346 | 26346 | NAVONA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 28 | 10 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 55.5 | Balchik Airfield | 1.6 | 1.6 | 966 | Mun. Mangalia, Loc. Saturn | CONSTANŢA | STR. Strada Corneliu Coposu , NR. 12E | 43.8288218 | 28.5851358 | 11.05.2016 | RO-SITUR | HOSTEL | 3 - STELE | 13989A | |||
| 26555 | 26555 | ASTERIAS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 49 | 14 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 34.2 | CND | 12.1 | 0.8 | 992 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Strada Grivitei , NR. 9 A | 44.072364 | 28.6301774 | 24.07.2019 | RO-SITUR | HOSTEL | 3 - STELE | 20136 | ||
| 26689 | 26689 | CASA LIZ | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 15 | 5 | 45 | 0 | 0 | 0 | 0 | 55 | 0 | 34.2 | CND | 11.9 | 1.0 | 993 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | NR. 11 | 44.0737607 | 28.6374892 | 17.11.2015 | RO-SITUR | HOSTEL | 3 - STELE | 15252 | |||
| 26914 | 26914 | MARE MAR | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 66 | 33 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 34.8 | CND | 12.5 | 0.5 | 1106 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Strada Mihail Eminescu , NR. 41-42 | 44.068118 | 28.6374059 | 20.10.2016 | RO-SITUR | HOSTEL | 3 - STELE | 30256 | ||
| 26980 | 26980 | REGAL LITORAL EFORIE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 36 | 9 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 36.2 | CND | 13.9 | 1.3 | 1153 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Strada Marii , NR. FN , ET. parter | 44.0556093544274 | 28.6409760341156 | 09.09.2025 | RO-SITUR | HOSTEL | 3 - STELE | 43925 | ||
| 27122 | 27122 | BISTRIŢA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 91 | 42 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 39.5 | CND | 17.2 | 0.4 | 834 | Oraş Eforie, Loc. Eforie Sud | CONSTANŢA | STR. Strada Mihai Viteazu , NR. 48 | 44.0262026 | 28.6499849 | 30.08.2022 | RO-SITUR | HOSTEL | 3 - STELE | 13740 | ||
| 27255 | 27255 | PARADOX | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 24 | 9 | 45 | 0 | 0 | 0 | 0 | 55 | 0 | 39.2 | CND | 17.0 | 0.6 | 977 | Oraş Eforie, Loc. Eforie Sud | CONSTANŢA | STR. Strada Oituz , NR. 4 | 44.028493 | 28.6486231 | 26.10.2016 | RO-SITUR | HOSTEL | 3 - STELE | 30278 | |||
| 27804 | 27804 | CASA DE LA MARE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 32 | 16 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 13.4 | CND | 3.9 | 3.2 | 2197 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 32P | 44.2838858 | 28.6168313 | 28.10.2019 | RO-SITUR | HOSTEL | 3 - STELE | 10961/7269 | ||
| 27864 | 27864 | CEZAR ŞI CARA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 8 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 12.7 | CND | 4.5 | 3.7 | 1558 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , ET. 1 | 44.341087 | 28.6456565 | 23.07.2018 | RO-SITUR | HOSTEL | 3 - STELE | 18742 | |||
| 27951 | 27951 | DARIUS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 30 | 15 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 10.8 | CND | 1.3 | 1.3 | 2124 | Oraş Năvodari | CONSTANŢA | STR. Strada Constanţei , NR. 8 | 44.3240794 | 28.6127938 | 24.07.2012 | RO-SITUR | HOSTEL | 3 - STELE | 18177 | ||
| 28541 | 28541 | NINA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 26 | 8 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 12.3 | CND | 2.1 | 0.7 | 2497 | Oraş Năvodari | CONSTANŢA | STR. Strada D1 , NR. 7 | 44.3063176 | 28.621559 | 24.11.2015 | RO-SITUR | HOSTEL | 3 - STELE | 29087 | |||
| 28556 | 28556 | NOVA ROUTE | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 37 | 17 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 12.4 | CND | 2.1 | 0.8 | 2512 | Oraş Năvodari | CONSTANŢA | STR. Strada D1 , NR. 9 | 44.3048117 | 28.6212808 | 17.10.2016 | RO-SITUR | HOSTEL | 3 - STELE | 12272/8848 | ||
| 28681 | 28681 | PAMIRA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 80 | 20 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 12.2 | CND | 2.1 | 0.2 | 2267 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. FN | 44.3136811 | 28.6260149 | 26.08.2025 | RO-SITUR | HOSTEL | 3 - STELE | 27081 | ||
| 29393 | 29393 | HERBERTHS | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 47 | 25 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 12.1 | CND | 6.9 | 0.8 | 28 | Oraş Ovidiu | CONSTANŢA | STR. Strada Naţională , NR. 199 | 44.2640776 | 28.5547522 | 27.03.2012 | RO-SITUR | HOSTEL | 3 - STELE | 2700/3824 | ||
| 29477 | 29477 | LUGHET | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 24 | 8 | 45 | 0 | 0 | 0 | 0 | 45 | 10 | 43.8 | GHV | 30.2 | 1.4 | 16 | Com. Barcani, Sat Barcani | COVASNA | NR. 287 | 45.6872764 | 26.0858311 | 26.04.2022 | RO-SITUR | HOSTEL | 3 - STELE | 24729 | |||
| 29518 | 29518 | KOMMANDO CAMP | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 50 | 20 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 10 | 58.3 | GHV | 28.8 | 0.6 | 12 | Com. Comandău, Sat Comandău | COVASNA | NR. 4 | 45.7588798 | 26.2703591 | 02.10.2020 | RO-SITUR | HOSTEL | 3 - STELE | 21379 | ||
| 29554 | 29554 | VEVERIŢA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 21 | 6 | 45 | 0 | 0 | 0 | 0 | 70 | 20 | 27.9 | GHV | 13.4 | 3.4 | 12 | Com. Ozun, Sat Bicfalău | COVASNA | NR. 106 | 45.7632615 | 25.8726536 | 09.10.2017 | RO-SITUR | HOSTEL | 3 - STELE | 30887 | |||
| 29629 | 29629 | CASA ROSA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 15 | 5 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 27.3 | GHV | 0.6 | 0.6 | 62 | Mun. Sfântu Gheorghe | COVASNA | STR. Strada 1 Decembrie 1918 , NR. 29 , AP. 2 | 45.8649045 | 25.7904133 | 11.03.2025 | RO-SITUR | HOSTEL | 3 - STELE | 41748 | |||
| 29912 | 29912 | HARMONY BOUTIQUE HOSTEL | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 20 | 10 | 45 | 0 | 0 | 0 | 0 | 65 | 10 | 63.9 | OTP | 0.5 | 0.5 | 11 | Oraş Găeşti | DÂMBOVIŢA | STR. Strada 13 Decembrie , NR. 2 | 44.7189687 | 25.3225641 | 09.12.2011 | RO-SITUR | HOSTEL | 3 - STELE | 16276 | |||
| 29998 | 29998 | CASA ITALIA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 24 | 12 | 45 | 0 | 0 | 0 | 0 | 50 | 0 | 84.4 | CRA | 0.1 | 0.1 | 145 | Mun. Calafat | DOLJ | NR. 41 | 43.990384 | 22.9340537 | 31.05.2010 | RO-SITUR | HOSTEL | 3 - STELE | 9606/6739 | |||
| 30045 | 30045 | CASABLANCA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 132 | 67 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 10.3 | CRA | 4.0 | 1.9 | 173 | Mun. Craiova | DOLJ | STR. Calea Severinului , NR. 42A | 44.3409198 | 23.7635704 | 28.09.2009 | RO-SITUR | HOSTEL | 3 - STELE | 9336/6350 | ||
| 30096 | 30096 | GRIFFON YOUTH | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 58 | 23 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 5.4 | CRA | 2.2 | 2.2 | 225 | Mun. Craiova | DOLJ | NR. 21 BIS | 44.3060251 | 23.8234601 | 13.07.2010 | RO-SITUR | HOSTEL | 3 - STELE | 10372/6952 | ||
| 30143 | 30143 | SPORT | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 22 | 15 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 7.9 | CRA | 1.0 | 1.0 | 213 | Mun. Craiova | DOLJ | STR. Strada Brestei , NR. 25 | 44.3209069 | 23.7890342 | 06.07.2010 | RO-SITUR | HOSTEL | 3 - STELE | 6149/3910 | |||
| 30166 | 30166 | VICTORIA | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 32 | 15 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 5.8 | CRA | 1.8 | 1.8 | 226 | Mun. Craiova | DOLJ | STR. Strada Locomotivei , NR. 10 | 44.3272936 | 23.8173932 | 27.09.2010 | RO-SITUR | HOSTEL | 3 - STELE | 8165/5334 | ||
| 30171 | 30171 | TATĂ ŞI FII | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 45 | 0 | 0 | 0 | 0 | 45 | 20 | 57.7 | Dolna Mitropoliya Air Base | 43.9 | 0.5 | 1 | Oraş Bechet, Sat Bechet | DOLJ | NR. 51 | 43.7863101 | 23.9545699 | 21.08.2014 | RO-SITUR | HOSTEL | 3 - STELE | 18456 | |||||
| 30179 | 30179 | JOLIE 3 | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 5 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 49.5 | Cahul International Airport | 1.6 | 1.6 | 170 | GALAŢI | NR. 3 , ET. 1 şi 2 | 45.4280814 | 28.0343467 | 27.08.2019 | RO-SITUR | HOSTEL | 3 - STELE | 20299 | ||||
| 30189 | 30189 | CASA AURSEI | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 44 | 16 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 20 | 54.7 | Cahul International Airport | 10.4 | 0.5 | 3 | Com. Şendreni, Sat Şendreni | GALAŢI | NR. 789 | 45.4138165770808 | 27.9211510951065 | 21.01.2025 | RO-SITUR | HOSTEL | 3 - STELE | 41171 | ||
| 30237 | 30237 | DABO | RO | stay | hostels | hostel | normal | 3 | star | 3 - STELE | 16 | 8 | 45 | 0 | 0 | 0 | 0 | 65 | 10 | 44.6 | Cahul International Airport | 4.6 | 2.7 | 65 | Mun. Galaţi | GALAŢI | STR. Strada Traian , NR. 437 | 45.4768018 | 28.0335776 | 17.07.2024 | RO-SITUR | HOSTEL | 3 - STELE | 21853 |
Advanced export
JSON shape: default, array, newline-delimited
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");