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

315 rows where country = "RO", family = "hotels" and rating_value = 2

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_scheme, rating_label, fit_wedding, fit_conference, fit_banquet, reachability_score, isolation_score, nearest_airport, source_type, source_category

rating_value 1

group 1

family 1

  • hotels · 315 ✖

country 1

  • RO · 315 ✖

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
15690 15690 GELA RO stay hotels motel normal 2 star 2 - STELE 20 11 wedding 50 45 30 0 0   80 20 16.3 Câmpia Turzii Air Base 6.6 0.1 1 Com. Mirăslău, Sat Decea ALBA   46.3824267 23.764068 19.01.2011   RO-SITUR MOTEL 2 - STELE 11499/7250
15920 15920 HANUL CU BERZE RO stay hotels motel normal 2 star 2 - STELE 39 20 wedding 60 45 30 0 0   65 0 49.5 SBZ 3.3 0.9 159 Mun. Alba Iulia ALBA STR. Strada Regimentul V Vânători , NR. 83 - 85 46.0412652 23.5623064 03.12.2018   RO-SITUR MOTEL 2 - STELE 11696/7545
16009 16009 TARNAVELE RO stay hotels hotel normal 2 star 2 - STELE 40 20 wedding 60 55 40 0 0   65 0 36.3 Câmpia Turzii Air Base 0.5 0.5 28 Mun. Blaj ALBA STR. Bulevardul Republicii , NR. 1 46.176657 23.922037 12.11.2010   RO-SITUR HOTEL 2 - STELE 7575/7165
16044 16044 BIP RO stay hotels hotel normal 2 star 2 - STELE 22 10 wedding 50 45 30 0 0   45 10 66.0 Câmpia Turzii Air Base 32.6 0.5 17 Oraş Câmpeni ALBA STR. Strada Libertăţii , NR. 19A 46.3618 23.04885 02.04.2014   RO-SITUR HOTEL 2 - STELE 27859
16047 16047 TULNIC RO stay hotels hotel normal 2 star 2 - STELE 37 18 wedding 60 45 30 0 0   45 10 66.2 Câmpia Turzii Air Base 32.5 0.5 17 Oraş Câmpeni ALBA STR. Strada Revoluţiei 1848 , NR. 1 46.3628153 23.0459729 24.03.2011   RO-SITUR HOTEL 2 - STELE 9637/7428
16053 16053 DRAGANA RO stay hotels hotel normal 2 star 2 - STELE 30 15 wedding 60 45 30 0 0   65 10 56.6 SBZ 0.9 0.9 6 Oraş Cugir ALBA STR. Strada Alexandru Sahia , NR. 20 45.8424343 23.3612944 21.07.2009   RO-SITUR HOTEL 2 - STELE 6277/3818
16222 16222 AS RO stay hotels hotel normal 2 star 2 - STELE 36 18 wedding 60 45 30 0 0   80 20 6.1 ARW 5.1 5.1 195 Mun. Arad ARAD STR. Calea Timişorii , NR. 212 46.1373519 21.3198328 25.01.2021   RO-SITUR HOTEL 2 - STELE 10956/6978
16297 16297 LOTUS RO stay hotels hotel normal 2 star 2 - STELE 23 11 wedding 50 45 30 0 0   80 0 3.9 ARW 0.3 0.3 408 Mun. Arad ARAD STR. Strada Nicolae Ştefu , NR. 8 46.1847585 21.312928 07.09.2009   RO-SITUR HOTEL 2 - STELE 9644/6270
16362 16362 VOINICUL RO stay hotels hotel normal 2 star 2 - STELE 34 14 wedding 60 45 30 0 0   80 10 7.0 ARW 3.3 3.3 377 Mun. Arad ARAD STR. Strada Voinicilor , NR. 34 46.1714047 21.3556087 18.10.2019   RO-SITUR HOTEL 2 - STELE 12998/6979
16400 16400 TAVERNA PECICANĂ RO stay hotels hotel normal 2 star 2 - STELE 54 20 wedding 60 55 40 0 0   70 20 15.2 ARW 19.2 0.3 4 Oraş Pecica, Sat Pecica ARAD STR. Strada 501 , NR. 1 46.1689414 21.0678377 04.04.2022   RO-SITUR HOTEL 2 - STELE 18013
16507 16507 VALEA URSULUI RO stay hotels motel normal 2 star 2 - STELE 32 16 wedding 60 45 30 0 0   50 0 94.2 CRA 9.1 0.4 22 Com. Bascov, Sat Valea Ursului ARGEŞ   44.8895874 24.7660705 02.12.2015   RO-SITUR MOTEL 2 - STELE 11750/7865
16518 16518 VULTURUL RO stay hotels hotel normal 2 star 2 - STELE 34 17 wedding 60 45 30 0 0   50 0 97.8 CRA 3.2 1.0 113 Com. Bradu, Sat Geamăna ARGEŞ NR. 21 44.828632 24.8934015 12.10.2011   RO-SITUR HOTEL 2 - STELE 11946/8141
16628 16628 STILL RO stay hotels motel normal 2 star 2 - STELE 10 5 wedding 50 45 30 0 0   40 30 95.4 CRA 15.3 3.8 2 Com. Cotmeana, Sat Linteşti ARGEŞ   45.0041958 24.6118153 03.02.2012   RO-SITUR MOTEL 2 - STELE 16489
16629 16629 TRAFFIC RO stay hotels motel normal 2 star 2 - STELE 29 12 wedding 50 45 30 0 0   50 0 92.7 CRA 6.1 0.6 38 Com. Cotmeana, Sat Linteşti ARGEŞ STR. Strada Principală , NR. 11 44.8503164 24.7899365 11.04.2022   RO-SITUR MOTEL 2 - STELE 15996
16766 16766 LA CETATE RO stay hotels hotel normal 2 star 2 - STELE 48 23 wedding 60 55 40 0 0   50 0 100.0 OTP 4.2 1.5 110 Com. Priboieni, Sat Valea Mare ARGEŞ NR. 38 44.8718371 24.9097698 21.03.2011   RO-SITUR HOTEL 2 - STELE 14044A
16895 16895 MUSCELUL RO stay hotels hotel normal 2 star 2 - STELE 178 75 wedding 80 65 60 0 0   45 0 60.9 GHV 32.9 0.7 75 Mun. Câmpulung ARGEŞ STR. Strada Negru Vodă , NR. 164 45.2720478 25.0456364 14.02.2011   RO-SITUR HOTEL 2 - STELE 2173/299
17009 17009 METROPOL RO stay hotels hotel normal 2 star 2 - STELE 28 16 wedding 50 45 30 0 0   50 0 98.2 CRA 0.8 0.8 142 Mun. Piteşti ARGEŞ STR. Strada Panselelor , NR. 1 44.856933 24.870475 07.04.2011   RO-SITUR HOTEL 2 - STELE 3351/1272
17022 17022 REHOMA RO stay hotels hotel normal 2 star 2 - STELE 30 14 wedding 60 45 30 0 0   50 0 96.9 CRA 4.6 0.5 131 Mun. Piteşti ARGEŞ STR. Bulevardul Nicolae Bălcescu , NR. 54 44.8792281 24.8249046 12.11.2020   RO-SITUR HOTEL 2 - STELE 3347/1360
17048 17048 VALENTINO RO stay hotels hotel normal 2 star 2 - STELE 22 11 wedding 50 45 30 0 0   50 10 96.0 GHV 1.5 1.5 16 Oraş Mioveni, Loc. Mioveni ARGEŞ NR. 47 44.9511242 24.9258795 03.07.2023   RO-SITUR HOTEL 2 - STELE 11155/7108
17073 17073 KM. 17 RO stay hotels motel normal 2 star 2 - STELE 20 10 wedding 50 45 30 0 0   55 20 38.3 BCM 20.8 0.6 1 Com. Căiuţi, Sat Popeni BACĂU   46.1781255 26.9367076 17.09.2012   RO-SITUR MOTEL 2 - STELE 5328/3781
17274 17274 BUCOVINA RO stay hotels motel normal 2 star 2 - STELE 44 21 wedding 60 55 40 0 0   45 0 33.2 BCM 31.5 0.9 37 Mun. Oneşti BACĂU STR. Strada Emil Rebreanu , NR. 11A 46.2429402 26.7556116 16.11.2021   RO-SITUR MOTEL 2 - STELE 7220/5090
17282 17282 KM & GI RO stay hotels motel normal 2 star 2 - STELE 24 12 wedding 50 45 30 0 0   45 10 31.2 BCM 33.2 2.4 38 Mun. Oneşti BACĂU STR. Bulevardul Mărăşeşti , NR. 79 46.2530659 26.7936392 28.12.2021   RO-SITUR MOTEL 2 - STELE 12002/7573
17283 17283 LA STRADA RO stay hotels motel normal 2 star 2 - STELE 14 7 wedding 50 45 30 0 0   45 0 33.2 BCM 31.4 0.8 37 Mun. Oneşti BACĂU NR. 1 A. 46.2437167 26.7543595 27.07.2012   RO-SITUR MOTEL 2 - STELE 18196
17292 17292 PARC RO stay hotels hotel normal 2 star 2 - STELE 98 37 wedding 70 65 50 0 0   45 0 31.6 BCM 31.7 1.7 37 Mun. Oneşti BACĂU STR. Bulevardul Republicii , NR. 43 46.2543239 26.771443 13.01.2022   RO-SITUR HOTEL 2 - STELE 13350
17429 17429 MAGURA RO stay hotels hotel normal 2 star 2 - STELE 360 165 wedding 80 75 60 0 0   55 0 35.7 BCM 20.5 0.5 55 Oraş Târgu Ocna BACĂU STR. Strada Trandafirilor , NR. 2 46.2793783 26.6058858 15.12.2009   RO-SITUR HOTEL 2 - STELE 1372/521
17431 17431 MINERVA RO stay hotels motel normal 2 star 2 - STELE 49 22 wedding 60 55 40 0 0   55 0 34.5 BCM 22.7 1.9 55 Oraş Târgu Ocna BACĂU STR. Strada Costache Negri , NR. 217A 46.2737907 26.6407513 26.04.2022   RO-SITUR MOTEL 2 - STELE 16061
17788 17788 MUNCEL RO stay hotels hotel normal 2 star 2 - STELE 486 243 wedding 80 75 60 0 0   80 0 7.3 OMR 8.1 1.4 409 Com. Sânmartin, Sat Băile Felix BIHOR   46.988122 21.9824821 07.06.2010   RO-SITUR HOTEL 2 - STELE 2638/712
17789 17789 MURES RO stay hotels hotel normal 2 star 2 - STELE 650 360 wedding 80 75 60 0 0   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673 24.11.2009   RO-SITUR HOTEL 2 - STELE 2328/696
17985 17985 SÂNTANA RO stay hotels hotel normal 2 star 2 - STELE 124 42 wedding 70 65 50 0 0   80 0 6.2 OMR 6.6 0.6 430 Com. Sânmartin, Sat Sânmartin BIHOR   47.0025773 21.9770794 24.09.2014   RO-SITUR HOTEL 2 - STELE 16041/8924
17990 17990 DODO RO stay hotels motel normal 2 star 2 - STELE 67 26 wedding 60 55 40 0 0   80 0 6.0 OMR 5.6 0.2 103 Com. Sântandrei, Sat Sântandrei BIHOR NR. 180. 47.0670543 21.8517806 27.06.2012   RO-SITUR MOTEL 2 - STELE 18089
18075 18075 TERMAL RO stay hotels hotel normal 2 star 2 - STELE 96 42 wedding 70 65 50 0 0   80 0 7.4 CLJ 0.7 0.7 1222 Mun. Marghita BIHOR STR. Strada Eroilor , NR. 1 46.7695224 23.5911179 09.09.2011   RO-SITUR HOTEL 2 - STELE 1512/326
18359 18359 TERRA RO stay hotels hotel normal 2 star 2 - STELE 40 20 wedding 60 55 40 0 0   80 10 5.4 OMR 3.3 3.3 383 Mun. Oradea BIHOR STR. Strada Făcliei , NR. 29 47.0523878 21.9611791     RO-SITUR HOTEL 2 - STELE  
18681 18681 DECEBAL RO stay hotels hotel normal 2 star 2 - STELE 54 28 wedding 60 55 40 0 0   65 0 72.7 CLJ 0.8 0.8 92 Mun. Bistriţa BISTRIŢA-NĂSĂUD STR. Strada Cuza Vodă , NR. 2B 47.1381978 24.4931589 18.10.2022   RO-SITUR HOTEL 2 - STELE 2344/466
18820 18820 RAREȘ RO stay hotels hotel normal 2 star 2 - STELE 48 24 wedding 60 55 40 0 0   80 0 24.3 SCV 1.0 1.0 49 Mun. Botoşani BOTOŞANI STR. Strada 1 Decembrie , NR. 65 47.7410956 26.6684327 01.10.2025   RO-SITUR HOTEL 2 - STELE 1964/1071
18839 18839 FLORA RO stay hotels hotel normal 2 star 2 - STELE 212 106 wedding 80 75 60 0 0   65 0 67.4 TCE 9.0 0.3 27 Com. Chiscani, Sat Lacu Sărat BRĂILA   45.220328 27.8851026 06.09.2010   RO-SITUR HOTEL 2 - STELE 2954/935
18896 18896 REGAL RO stay hotels hotel normal 2 star 2 - STELE 62 30 wedding 60 55 40 0 0   65 0 62.8 TCE 0.3 0.3 90 Mun. Brăila BRĂILA STR. Strada Mihail Sebastian , NR. 21 45.2716978 27.9705117 07.04.2011   RO-SITUR HOTEL 2 - STELE 14155
18904 18904 SPORT RO stay hotels hotel normal 2 star 2 - STELE 49 27 wedding 60 55 40 0 0   65 0 62.5 TCE 0.2 0.2 90 Mun. Brăila BRĂILA STR. Strada Dimitrie Bolintineanu , NR. 2 45.2731246 27.9747303 07.06.2012   RO-SITUR HOTEL 2 - STELE 3752/1512
19197 19197 SOFIA RO stay hotels hotel normal 2 star 2 - STELE 34 15 wedding 60 45 30 0 0   80 0 23.7 GHV 7.3 1.9 451 Com. Bran, Sat Sohodol BRAŞOV STR. Strada Bradul Înalt , NR. 41 45.5153387 25.386097 29.09.2023   RO-SITUR HOTEL 2 - STELE 6210/3858
19764 19764 DOMENIUL BOGDAN RO stay hotels motel normal 2 star 2 - STELE 30 15 wedding 60 45 30 0 0   70 20 20.6 GHV 12.3 3.3 17 Com. Prejmer, Sat Lunca Calnicului BRAŞOV STR. Strada Principală 45.7562022 25.7781632 23.03.2026   RO-SITUR MOTEL 2 - STELE 46230
19887 19887 CIUCAS RO stay hotels motel normal 2 star 2 - STELE 31 14 wedding 60 45 30 0 0   80 10 19.6 GHV 6.7 2.6 25 Com. Tărlungeni, Sat Cărpiniş BRAŞOV NR. 976C 45.6623253 25.7669396 09.07.2010   RO-SITUR MOTEL 2 - STELE 13571
20100 20100 ASTRA RO stay hotels hotel normal 2 star 2 - STELE 125 48 wedding 70 65 50 0 0   80 0 10.8 GHV 1.8 1.8 1131 Mun. Braşov BRAŞOV STR. Strada Carpaţilor , NR. 60 45.6414274 25.6264872 05.04.2023   RO-SITUR HOTEL 2 - STELE 17950
20390 20390 DECEBAL RO stay hotels hotel normal 2 star 2 - STELE 192 96 wedding 80 65 60 0 0   80 0 10.3 GHV 1.4 1.4 1122 Mun. Braşov BRAŞOV STR. Strada Lunii , NR. 3 45.6451505 25.6239453 15.06.2011   RO-SITUR HOTEL 2 - STELE 12443/7784
20504 20504 HELIS RO stay hotels hotel normal 2 star 2 - STELE 42 21 wedding 60 55 40 0 0   80 0 7.4 GHV 1.9 1.9 1163 Mun. Braşov BRAŞOV STR. Strada Memorandumului , NR. 29 45.6533886 25.5823066 07.11.2011   RO-SITUR HOTEL 2 - STELE 16118
21141 21141 CARAIMAN RO stay hotels hotel normal 2 star 2 - STELE 132 66 wedding 70 65 50 0 0   80 20 12.6 GHV 7.6 5.9 233 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5934656 25.5488208 18.10.2010   RO-SITUR HOTEL 2 - STELE 6534/7117
21168 21168 OLIMPIC RO stay hotels hotel normal 2 star 2 - STELE 98 49 wedding 70 65 50 0 0   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291 09.11.2009   RO-SITUR HOTEL 2 - STELE 6535/4124
21336 21336 BUCEGI PORŢILE REGATULUI RO stay hotels hotel normal 2 star 2 - STELE 52 26 wedding 60 55 40 0 0   80 10 21.6 GHV 9.2 4.7 119 Oraş Predeal BRAŞOV STR. Strada Valea Râşnoavei , NR. 10 45.511684 25.508917 11.08.2015   RO-SITUR HOTEL 2 - STELE 557/381
21398 21398 DANA RO stay hotels hotel normal 2 flower 2 - MARGARETE 14 6 wedding 50 45 30 0 0   70 0 23.4 GHV 13.8 1.0 340 Oraş Predeal BRAŞOV STR. Strada Clăbucet 45.4989363 25.5796118 08.03.2024   RO-SITUR HOTEL 2 - MARGARETE 7071/5332A
21522 21522 PIATRA CRAIULUI RO stay hotels hotel normal 2 star 2 - STELE 44 22 wedding 60 55 40 0 0   80 10 21.6 GHV 9.2 4.6 137 Oraş Predeal, Loc. Pârâul Rece BRAŞOV NR. 10 45.5119484 25.5100822 19.12.2011   RO-SITUR HOTEL 2 - STELE 559/382
21524 21524 ALL TIMES RO stay hotels hotel normal 2 star 2 - STELE 36 20 wedding 60 45 30 0 0   70 10 25.4 GHV 14.6 2.3 402 Oraş Predeal, Loc. Timişu de Jos BRAŞOV NR. 32 45.4793067 25.5644985 16.02.2011   RO-SITUR HOTEL 2 - STELE 11365/7275
21526 21526 TIMTUR RO stay hotels motel normal 2 star 2 - STELE 33 15 wedding 60 45 30 0 0   70 10 26.0 GHV 15.0 2.8 400 Oraş Predeal, Loc. Timişu de Jos BRAŞOV NR. 22-A 45.4738044 25.562702 20.09.2011   RO-SITUR MOTEL 2 - STELE 7090/5680
21847 21847 2D RO stay hotels motel normal 2 star 2 - STELE 58 26 wedding 60 55 40 0 0   55 20 47.2 Boboc Air Base 26.0 1.0 5 Com. Cislău, Sat Cislău BUZĂU   45.2450915 26.3766644 20.11.2013   RO-SITUR MOTEL 2 - STELE 11469
21855 21855 HANUL OVIDIU RO stay hotels motel normal 2 star 2 - STELE 36 16 wedding 60 45 30 0 0   55 20 43.6 Boboc Air Base 18.8 0.3 1 Com. Glodeanu Sărat, Sat Căldăruşeanca BUZĂU STR. CALEA BUZAULUI 44.8809172 26.6909244 13.01.2026   RO-SITUR MOTEL 2 - STELE 12109/8630
21912 21912 MONTANA RO stay hotels hotel normal 2 star 2 - STELE 80 40 wedding 70 65 50 0 0   70 0 27.6 Boboc Air Base 15.1 0.2 41 Com. Merei, Sat Sărata-Monteoru BUZĂU STR. Aleea Ştrandului , NR. 1 45.1475653 26.6409383 10.07.2025   RO-SITUR HOTEL 2 - STELE 12113/6717
21913 21913 MONTEORU RO stay hotels hotel normal 2 star 2 - STELE 76 33 wedding 60 55 40 0 0   70 0 27.6 Boboc Air Base 15.1 0.2 41 Com. Merei, Sat Sărata-Monteoru BUZĂU STR. Aleea Ştrandului , NR. 3 45.1475653 26.6409383 10.07.2025   RO-SITUR HOTEL 2 - STELE 7234/4913
21981 21981 AQUA MAX RO stay hotels motel normal 2 star 2 - STELE 34 17 wedding 60 45 30 0 0   80 0 14.4 Boboc Air Base 1.5 1.5 138 Mun. Buzău BUZĂU STR. UNIRII NORD 45.155891 26.816742 04.07.2025   RO-SITUR MOTEL 2 - STELE 9930/6250
21986 21986 BUCEGI RO stay hotels hotel normal 2 star 2 - STELE 54 26 wedding 60 55 40 0 0   80 0 14.4 Boboc Air Base 0.9 0.9 138 Mun. Buzău BUZĂU STR. Bulevardul Gării , NR. 47 45.1437815 26.8259002 18.02.2026   RO-SITUR HOTEL 2 - STELE 2364/343
22035 22035 ILEANA RO stay hotels motel normal 2 star 2 - STELE 83 34 wedding 70 65 50 0 0   80 0 13.8 Boboc Air Base 1.9 1.9 132 Mun. Buzău BUZĂU STR. Strada Drăgăicii , NR. 2B 45.1353351 26.8451557 26.03.2026   RO-SITUR MOTEL 2 - STELE 17061
22046 22046 MUŞATINII RO stay hotels hotel normal 2 star 2 - STELE 44 24 wedding 60 55 40 0 0   80 10 13.2 Boboc Air Base 2.6 2.6 120 Mun. Buzău BUZĂU STR. Şoseaua Brăilei , NR. 17 45.134541 26.8573778 25.06.2012   RO-SITUR HOTEL 2 - STELE 10813/5283
22054 22054 SPORT B90 RO stay hotels hotel normal 2 star 2 - STELE 68 34 wedding 60 55 40 0 0   80 0 13.6 Boboc Air Base 0.9 0.9 138 Mun. Buzău BUZĂU STR. Strada Mesteacănului , NR. 1 45.1571537 26.8273389 02.12.2009   RO-SITUR HOTEL 2 - STELE 1792/584
22102 22102 DRAJNA RO stay hotels motel normal 2 star 2 - STELE 30 15 wedding 60 45 30 0 0   70 20 27.7 Feteşti Borcea Air Base 16.1 0.3 3 Com. Dragalina, Sat Drajna Nouă CĂLĂRAŞI   44.4202922 27.3796468 14.06.2011   RO-SITUR MOTEL 2 - STELE 9081/7778
22351 22351 RANDUNICA RO stay hotels hotel normal 2 star 2 - STELE 84 42 wedding 70 65 50 0 0   55 10 31.0 CSB 15.1 4.2 51 Com. Văliug, Sat Văliug CARAŞ-SEVERIN   45.1973861 22.0149645 19.08.2010   RO-SITUR HOTEL 2 - STELE 10921/7038
22432 22432 INTIM RO stay hotels hotel normal 2 star 2 - STELE 19 9 wedding 50 45 30 0 0   65 10 31.2 CSB 2.1 2.1 70 Mun. Reşiţa CARAŞ-SEVERIN STR. Bulevardul Republicii , NR. 2 45.3187373 21.8799736 24.05.2012   RO-SITUR HOTEL 2 - STELE 12084/8596
22447 22447 TURIST RO stay hotels hotel normal 2 star 2 - STELE 43 21 wedding 60 55 40 0 0   80 10 27.0 CSB 7.8 0.1 18 Mun. Reşiţa, Loc. Secu CARAŞ-SEVERIN   45.2712461 21.9793796 15.12.2009   RO-SITUR HOTEL 2 - STELE 6510/6510
22463 22463 ARTEMIS RO stay hotels hotel normal 2 star 2 - STELE 64 34 wedding 60 55 40 0 0   45 0 61.7 CSB 33.6 0.4 217 Oraş Băile Herculane CARAŞ-SEVERIN STR. Strada Castanilor , NR. 2 44.8765824 22.4134237 15.04.2019   RO-SITUR HOTEL 2 - STELE 9654/6081
22524 22524 HERCULES RO stay hotels hotel normal 2 star 2 - STELE 236 126 wedding 80 75 60 0 0   45 0 61.1 CSB 34.0 0.5 217 Oraş Băile Herculane CARAŞ-SEVERIN STR. Strada Izvorului , NR. 7 44.8831227 22.4172846 18.11.2010   RO-SITUR HOTEL 2 - STELE 973/768
22554 22554 ROMAN RO stay hotels hotel normal 2 star 2 - STELE 364 182 wedding 80 75 60 0 0   45 10 60.0 CSB 34.7 2.1 215 Oraş Băile Herculane CARAŞ-SEVERIN STR. Strada Romană , NR. 1 44.8952556 22.4282187 14.01.2026   RO-SITUR HOTEL 2 - STELE 977/769
22570 22570 TRANDAFIRUL GALBEN RO stay hotels hotel normal 2 star 2 - STELE 54 27 wedding 60 55 40 0 0   45 0 63.1 CSB 32.8 0.4 215 Oraş Băile Herculane CARAŞ-SEVERIN STR. Strada Trandafirilor , NR. 76 44.8629882 22.4043204 29.04.2011   RO-SITUR HOTEL 2 - STELE 5052/3005A
22626 22626 VICTORIA APAHIDA RO stay hotels motel normal 2 star 2 - STELE 24 12 wedding 50 45 30 0 0   70 0 4.5 CLJ 11.4 1.5 31 Com. Apahida, Sat Apahida CLUJ STR. Strada Libertăţii , NR. 63 46.7928151 23.74433 06.11.2013   RO-SITUR MOTEL 2 - STELE 16575
22905 22905 GILĂU RO stay hotels motel normal 2 star 2 - STELE 110 55 wedding 70 65 50 0 0   70 0 24.5 CLJ 17.7 1.7 42 Com. Gilău, Sat Gilău CLUJ STR. Strada Pădurii , NR. 1 46.7468131 23.3697768 27.11.2023   RO-SITUR MOTEL 2 - STELE 4659/3126
23013 23013 CIPRIAN RO stay hotels hotel normal 2 star 2 - STELE 38 19 wedding 60 45 30 0 0   70 20 27.7 CLJ 18.0 0.4 2 Com. Mihai Viteazu, Sat Corneşti CLUJ NR. 266 47.0348851 23.6786044 10.01.2011   RO-SITUR HOTEL 2 - STELE 10251/7242
23210 23210 TIVER RO stay hotels hotel normal 2 star 2 - STELE 54 26 wedding 60 55 40 0 0   80 10 4.8 Câmpia Turzii Air Base 0.5 0.5 20 Mun. Câmpia Turzii CLUJ STR. Strada Poet Andrei Mureşanu , NR. 1 46.545425 23.8856396 19.05.2010   RO-SITUR HOTEL 2 - STELE 3876/2064
23273 23273 BETA RO stay hotels hotel normal 2 star 2 - STELE 65 30 wedding 60 55 40 0 0   80 10 8.0 CLJ 2.7 2.7 1195 Mun. Cluj-Napoca CLUJ STR. Strada Giordano Bruno , NR. 1-3 46.7866543 23.580851 11.04.2016   RO-SITUR HOTEL 2 - STELE 7592/5189
23613 23613 LUCY STAR RO stay hotels hotel normal 2 star 2 - STELE 56 28 wedding 60 55 40 0 0   80 10 8.1 CLJ 2.9 2.9 1178 Mun. Cluj-Napoca CLUJ STR. Strada Giordano Bruno , NR. 25-27 46.788313 23.5793046 05.05.2011   RO-SITUR HOTEL 2 - STELE 14454A
23929 23929 ZIMBRU RO stay hotels hotel normal 2 star 2 - STELE 46 23 wedding 60 55 40 0 0   80 0 6.0 CLJ 1.7 1.7 1176 Mun. Cluj-Napoca CLUJ STR. Strada Bucureşti , NR. 73 46.7813245 23.6077737 17.11.2010   RO-SITUR HOTEL 2 - STELE 7591/5138
24022 24022 PALACE RO stay hotels hotel normal 2 star 2 - STELE 24 13 wedding 50 45 30 0 0   80 0 10.9 Câmpia Turzii Air Base 0.6 0.6 105 Mun. Turda CLUJ STR. Piaţa Republicii , NR. 31 46.5721169 23.7859703 20.03.2014   RO-SITUR HOTEL 2 - STELE 27803
24200 24200 POIENIȚA RO stay hotels hotel normal 2 star 2 - STELE 124 48 wedding 70 65 50 0 0   55 0 47.0 CND 16.0 0.4 809 Com. Costineşti CONSTANŢA   43.9532157 28.6366706 27.08.2025   RO-SITUR HOTEL 2 - STELE 14617
24211 24211 ALEX RO stay hotels hotel normal 2 star 2 - STELE 104 52 wedding 70 65 50 0 0   55 0 47.6 CND 15.2 0.3 815 Com. Costineşti, Sat Costineşti CONSTANŢA NR. 1 43.9470874 28.6325451 04.01.2022   RO-SITUR HOTEL 2 - STELE 12747/8676
24241 24241 AZUR RO stay hotels hotel normal 2 star 2 - STELE 150 75 wedding 80 65 60 0 0   55 0 48.2 CND 14.8 0.8 818 Com. Costineşti, Sat Costineşti CONSTANŢA   43.9420709 28.6377492 16.11.2011   RO-SITUR HOTEL 2 - STELE 527/3106
24425 24425 CRIS RO stay hotels hotel normal 2 star 2 - STELE 97 46 wedding 70 65 50 0 0   55 0 46.6 CND 16.4 0.9 815 Com. Costineşti, Sat Costineşti CONSTANŢA STR. ZONA STADION , NR. 8 43.9569653 28.6380974 30.09.2024   RO-SITUR HOTEL 2 - STELE 39038
24459 24459 FORUM RO stay hotels hotel normal 2 star 2 - STELE 293 139 wedding 80 75 60 0 0   55 0 48.3 CND 14.7 0.8 819 Com. Costineşti, Sat Costineşti CONSTANŢA   43.9412307 28.6376361 02.10.2020   RO-SITUR HOTEL 2 - STELE 180/3018
24885 24885 PRINCIPAL RO stay hotels hotel normal 2 star 2 - STELE 52 26 wedding 60 55 40 0 0   55 0 48.1 CND 14.5 0.2 826 Com. Costineşti, Sat Schitu CONSTANŢA STR. Strada Principală 43.9414118 28.6271651 25.01.2011   RO-SITUR HOTEL 2 - STELE 13826
25060 25060 BLUE NIGHT LA JOHN RO stay hotels hotel normal 2 star 2 - STELE 140 51 wedding 70 65 50 0 0   65 20 48.5 Balchik Airfield 6.9 6.0 376 Com. Limanu, Sat Vama Veche CONSTANŢA STR. Strada Falezei , NR. 8 43.7542935 28.5741015 21.05.2025   RO-SITUR HOTEL 2 - STELE 9034/5703
25153 25153 LAGUNA RO stay hotels hotel normal 2 star 2 - STELE 52 26 wedding 60 55 40 0 0   65 20 48.3 Balchik Airfield 7.0 6.1 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7529244 28.5725487 27.03.2023   RO-SITUR HOTEL 2 - STELE 8353/6246
25220 25220 WAVES RO stay hotels hotel normal 2 star 2 - STELE 70 35 wedding 60 55 40 0 0   65 20 48.3 Balchik Airfield 6.9 6.0 376 Com. Limanu, Sat Vama Veche CONSTANŢA STR. Strada Mihail Kogălniceanu , NR. 50 43.7539476 28.5713849 26.10.2022   RO-SITUR HOTEL 2 - STELE 20905
25326 25326 CALLA INN RO stay hotels hotel normal 2 star 2 - STELE 45 16 wedding 60 55 40 0 0   80 10 19.8 CND 4.0 2.7 931 Mun. Constanţa CONSTANŢA STR. Aleea Ciuleandra , NR. 8 44.2165543578278 28.6305070932541 07.08.2023   RO-SITUR HOTEL 2 - STELE 14833
25372 25372 CIREȘICA RO stay hotels hotel normal 2 star 2 - STELE 27 12 wedding 50 45 30 0 0   80 10 19.9 CND 3.6 2.6 914 Mun. Constanţa CONSTANŢA STR. Strada Dispensarului , NR. 10A 44.2126058 28.6247208 06.04.2010   RO-SITUR HOTEL 2 - STELE 10262/6541
25390 25390 CORA RO stay hotels hotel normal 2 star 2 - STELE 38 19 wedding 60 45 30 0 0   80 10 22.0 CND 2.4 2.4 829 Mun. Constanţa CONSTANŢA STR. Bulevardul Mamaia , NR. 201 44.2004298 28.6462692 06.07.2009   RO-SITUR HOTEL 2 - STELE 6643/3184
25410 25410 DOBROGEA RO stay hotels hotel normal 2 star 2 - STELE 20 10 wedding 50 45 30 0 0   80 10 19.8 CND 3.9 2.7 930 Mun. Constanţa CONSTANŢA STR. Bulevardul Alexandru Lăpuşneanu , NR. 194 44.2155608 28.6292348 12.07.2012   RO-SITUR HOTEL 2 - STELE 2056/127
25715 25715 AURORA RO stay hotels hotel normal 2 star 2 - STELE 682 341 wedding 80 75 60 0 0   80 10 19.2 CND 4.7 2.5 965 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2232454 28.6316764 24.11.2011   RO-SITUR HOTEL 2 - STELE 23/153
25787 25787 JIJO`S RO stay hotels hotel normal 2 star 2 - STELE 96 48 wedding 70 65 50 0 0   80 10 15.2 CND 6.2 4.0 1896 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2627817 28.6201169 15.07.2014   RO-SITUR HOTEL 2 - STELE 3239/1119
25808 25808 METROPOL RO stay hotels hotel normal 2 star 2 - STELE 430 215 wedding 80 75 60 0 0   80 10 16.0 CND 7.3 2.9 1334 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2521063 28.6185411 24.05.2012   RO-SITUR HOTEL 2 - STELE 44/412
25819 25819 NAŢIONAL RO stay hotels hotel normal 2 star 2 - STELE 320 160 wedding 80 75 60 0 0   80 10 17.3 CND 6.6 2.0 1032 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2393548 28.6223906 09.09.2025   RO-SITUR HOTEL 2 - STELE 37/599
25827 25827 OLT BY VENTURA RO stay hotels hotel normal 2 star 2 - STELE 144 66 wedding 70 65 50 0 0   80 10 16.2 CND 7.4 2.9 1279 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2513593 28.6197735 23.07.2024   RO-SITUR HOTEL 2 - STELE 2045/118
25837 25837 PESCARUŞ RO stay hotels hotel normal 2 star 2 - STELE 176 109 wedding 80 65 60 0 0   80 10 19.9 CND 4.2 3.1 918 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2183634 28.6372122 09.05.2024   RO-SITUR HOTEL 2 - STELE 17/370
26051 26051 CRISTAL RO stay hotels hotel normal 2 star 2 - STELE 194 97 wedding 80 65 60 0 0   65 10 57.4 CND 4.5 2.1 974 Mun. Mangalia, Loc. Cap Aurora CONSTANŢA   43.8526635 28.6018804 14.09.2010   RO-SITUR HOTEL 2 - STELE 129/416
26055 26055 SAFIR RO stay hotels hotel normal 2 star 2 - STELE 212 106 wedding 80 75 60 0 0   65 10 57.4 CND 4.5 2.1 974 Mun. Mangalia, Loc. Cap Aurora CONSTANŢA   43.8526635 28.6018804 14.04.2011   RO-SITUR HOTEL 2 - STELE 128/394A
26058 26058 CAMELIA RO stay hotels hotel normal 2 star 2 - STELE 108 54 wedding 70 65 50 0 0   65 0 57.0 CND 5.0 1.7 819 Mun. Mangalia, Loc. Jupiter CONSTANŢA STR. Strada Gala Galaction 43.8564851 28.6034964 23.07.2018   RO-SITUR HOTEL 2 - STELE 6651/5038
26100 26100 VIOLETA RO stay hotels hotel normal 2 star 2 - STELE 108 54 wedding 70 65 50 0 0   65 0 57.0 CND 5.0 1.7 819 Mun. Mangalia, Loc. Jupiter CONSTANŢA STR. Strada Gala Galaction , NR. 23 43.8560663 28.6049861 03.07.2023   RO-SITUR HOTEL 2 - STELE 10979/6560
26124 26124 CALLATIS RO stay hotels hotel normal 2 star 2 - STELE 192 96 wedding 80 65 60 0 0   65 0 53.8 Balchik Airfield 0.9 0.9 755 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Trandafirilor 43.8098909 28.5835736 14.05.2026   RO-SITUR HOTEL 2 - STELE 3734/892
26145 26145 DACIA RO stay hotels hotel normal 2 star 2 - STELE 328 164 wedding 80 75 60 0 0   65 0 55.8 CND 5.9 0.6 723 Mun. Mangalia, Loc. Neptun CONSTANŢA STR. Strada Trandafirilor , NR. 12 43.8668754 28.5976195 06.04.2026   RO-SITUR HOTEL 2 - STELE 121/165

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");