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

375 rows where best_for = "wedding", country = "RO" 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

country 1

  • RO · 375 ✖

best_for 1

  • wedding · 375 ✖

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
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
16164 16164 TAUŢ RO stay resorts holiday_village_resort normal 2 star 2 - STELE 99 30 wedding 70 0 50 0 0   45 20 51.3 ARW 47.2 0.9 2 Com. Tauţ, Sat Tauţ ARAD   46.289918 21.9107523 13.05.2014   RO-SITUR SAT DE VACANȚĂ 2 - STELE 11147
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
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
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
16382 16382 BAILE LIPOVA RO stay camping camping normal 2 star 2 - STELE 98 37 wedding 55 0 0 0 0   45 10 34.5 ARW 30.9 0.8 11 Oraş Lipova ARAD STR. Strada Lugojului , NR. 50 46.0841416 21.6918276 06.11.2009   RO-SITUR CAMPING 2 - STELE 6536/6423
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
16462 16462 CASA IULIANA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 80 38 wedding 55 0 0 0 0   55 0 68.0 SBZ 20.4 0.3 96 Com. Arefu, Sat Căpăţânenii Pământeni ARGEŞ NR. 99 45.3162504 24.6458936 19.01.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 24266
16488 16488 MARA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 98 49 wedding 55 0 0 0 0   50 20 95.1 SBZ 9.9 1.6 3 Com. Băiculeşti, Sat Băiculeşti ARGEŞ NR. 15 45.0468638 24.7000642 29.07.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 31342
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
17665 17665 TURUL RO stay camping camping normal 2 star 2 - STELE 204 51 wedding 65 0 0 0 0   45 20 46.6 OMR 47.4 0.5 3 Com. Remetea, Sat Remetea BIHOR NR. 8 46.7344677 22.3440694 12.05.2014   RO-SITUR CAMPING 2 - STELE 27885
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
19174 19174 CLUB VILA BRAN RO stay resorts holiday_village_resort normal 2 star 2 - STELE 48 24 wedding 60 0 40 0 0   80 0 23.5 GHV 5.9 1.8 465 Com. Bran, Sat Sohodol BRAŞOV STR. Strada Aluniş , NR. 13 45.5230653 25.3711609 22.07.2022   RO-SITUR SAT DE VACANȚĂ 2 - STELE 2508/652
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
19341 19341 SPORT RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 136 65 wedding 55 0 0 0 0   55 0 34.8 GHV 13.9 1.6 261 Com. Fundata, Sat Fundata BRAŞOV NR. 124 45.4371446 25.2919972 19.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 13967
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
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
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
21144 21144 CENTRUL DE ECHITAŢIE RO stay resorts holiday_village_resort normal 2 star 2 - STELE 62 10 wedding 60 0 40 0 0   80 20 11.5 GHV 6.5 6.1 382 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.6041286 25.5522439 10.03.2014   RO-SITUR SAT DE VACANȚĂ 2 - STELE 1646/1246
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
22456 22456 7 IZVOARE RO stay camping camping normal 2 star 2 - STELE 140 40 wedding 55 0 0 0 0   45 20 57.3 CSB 36.8 5.0 26 Oraş Băile Herculane CARAŞ-SEVERIN   44.9225867 22.4448299 06.09.2011   RO-SITUR CAMPING 2 - STELE 15456
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
22960 22960 IC PONOR-PADIŞ RO stay resorts holiday_village_resort normal 2 star 2 - STELE 12 6 wedding 50 0 30 0 0   45 30 68.1 CLJ 56.4 9.4 12 Com. Mărgău, Sat Răchiţele CLUJ NR. 333A 46.6397813 22.8183117 13.10.2014   RO-SITUR SAT DE VACANȚĂ 2 - STELE 10397/8930
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
23472 23472 DIAKONIA RO stay self_catering_villas villa normal 2 star 2 - STELE 99 35 wedding 55 0 0 0 0   80 0 6.8 CLJ 1.2 1.2 1234 Mun. Cluj-Napoca CLUJ STR. Strada Ponorului , NR. 1 46.7575538 23.6072588 06.07.2015   RO-SITUR VILĂ TURISTICĂ 2 - STELE 6045/5965
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
24235 24235 ARENA DOTRO RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 105 45 wedding 55 0 0 0 0   55 0 47.1 CND 15.8 0.3 808 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada Tineretului , NR. 53 43.9522126 28.6359491 09.06.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 22377
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
24383 24383 CASA POSEIDON - BRIANNA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 84 38 wedding 55 0 0 0 0   55 0 46.5 CND 16.6 1.1 819 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada Pescăruşului , NR. 31 43.9583651 28.6404384 14.04.2026   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 18494
24420 24420 COMPLEX MINERVA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 128 57 wedding 55 0 0 0 0   55 0 47.2 CND 15.8 0.3 808 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada Mării 43.9512591 28.6372272 07.08.2024   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 19751
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
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
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
24911 24911 VILADORA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 86 40 wedding 55 0 0 0 0   55 0 47.1 CND 15.6 0.3 809 Com. Costineşti, Sat Schitu CONSTANŢA STR. Strada Cireşului , NR. 21 43.9514809 28.6302413 11.09.2017   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 18190

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