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

511 rows where country = "RO", family = "hotels" and rating_value = 4

This data as json, CSV (advanced)

Suggested facets: venue_type, 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 · 511 ✖

country 1

  • RO · 511 ✖

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
15701 15701 GOLF PIANU RO stay hotels hotel normal 4 star 4 - STELE 54 27 wedding 80 70 50 50 0   65 20 50.9 SBZ 9.7 2.9 7 Com. Pianu, Sat Pianu de Jos ALBA   45.9194786 23.4574781 07.12.2017   RO-SITUR HOTEL 4 - STELE 31139
15825 15825 POARTA RAIULUI RO stay hotels hotel normal 4 star 4 - STELE 64 32 wedding 80 70 50 50 0   55 40 49.0 SBZ 17.1 15.4 8 Com. Şugag, Sat Tău Bistra ALBA NR. 22 45.5833553 23.5271408 27.02.2024   RO-SITUR HOTEL 4 - STELE 29603
15854 15854 CARDINAL RO stay hotels hotel normal 4 star 4 - STELE 264 132 wedding 100 90 70 50 0   65 10 51.8 SBZ 7.6 0.3 10 Com. Vinţu de Jos, Sat Vinţu de Jos ALBA STR. Strada Mihai Eminescu , NR. 58 B 45.9920306 23.4864679 25.09.2017   RO-SITUR HOTEL 4 - STELE 30834
15868 15868 WINE & SIMPHONY RESORT RO stay hotels hotel normal 4 star 4 - STELE 32 16 wedding 80 60 40 50 0   80 10 23.1 Câmpia Turzii Air Base 3.6 0.6 17 Mun. Aiud, Sat Ciumbrud ALBA STR. Strada Salviei , NR. 6A 46.3112094 23.7680104 18.12.2024   RO-SITUR HOTEL 4 - STELE 41052
15884 15884 AURA UNIRII RO stay hotels hotel normal 4 star 4 - STELE 26 15 wedding 70 60 40 50 0   65 0 50.3 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA STR. Strada Mihai Viteazu , NR. 5 46.0681867 23.5780252 09.06.2023   RO-SITUR HOTEL 4 - STELE 34784
15943 15943 MERCURE ALBA IULIA RO stay hotels hotel normal 4 star 4 - STELE 236 118 wedding 100 90 70 50 0   65 0 50.0 SBZ 0.7 0.7 191 Mun. Alba Iulia ALBA STR. Strada Dimitrie Cantemir , NR. 2/A 46.0621519 23.5765002 21.10.2025   RO-SITUR HOTEL 4 - STELE 44526
15949 15949 ONE RO stay hotels aparthotel normal 4 star 4 - STELE 80 40 wedding 90 80 60 50 0   65 0 50.7 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA STR. Strada Mitropolit Alexandru Sterca Şuluţiu , NR. 1 46.0687094 23.5732911 31.07.2025   RO-SITUR HOTEL APARTAMENT 4 - STELE 42764
15952 15952 PARC RO stay hotels hotel normal 4 star 4 - STELE 140 72 wedding 90 80 60 50 0   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA STR. Strada Primăverii , NR. 4 46.0691429 23.581314 22.09.2011   RO-SITUR HOTEL 4 - STELE 9440/5927
15985 15985 TRANSILVANIA RO stay hotels hotel normal 4 star 4 - STELE 160 80 wedding 100 80 70 50 0   65 0 50.3 SBZ 0.6 0.6 191 Mun. Alba Iulia ALBA STR. Piaţa Iuliu Maniu , NR. 11 46.0716803 23.582319 03.02.2016   RO-SITUR HOTEL 4 - STELE 735/925
16025 16025 LEUL DE AUR RO stay hotels hotel normal 4 star 4 - STELE 210 105 wedding 100 90 70 50 0   65 0 44.6 SBZ 0.4 0.4 33 Mun. Sebeş ALBA STR. Bulevardul Lucian Blaga , NR. 8 45.9573216 23.5665329 12.12.2016   RO-SITUR HOTEL 4 - STELE 13492
16227 16227 BEST WESTERN CENTRAL RO stay hotels hotel normal 4 star 4 - STELE 84 42 wedding 90 80 60 50 0   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD STR. Strada Horia , NR. 8 46.1762734 21.316574 02.10.2012   RO-SITUR HOTEL 4 - STELE 2450/364
16247 16247 CONTINENTAL FORUM RO stay hotels hotel normal 4 star 4 - STELE 320 160 wedding 100 90 70 50 0   80 0 4.2 ARW 1.0 1.0 408 Mun. Arad ARAD STR. Bulevardul Revoluţiei , NR. 79-81 , BL. Astoria 46.1741356 21.318273 21.01.2019   RO-SITUR HOTEL 4 - STELE 2323/535
16293 16293 LEON RO stay hotels hotel normal 4 star 4 - STELE 60 31 wedding 80 70 50 50 0   80 0 5.8 ARW 1.8 1.8 402 Mun. Arad ARAD STR. Bulevardul Nicolae Titulescu , NR. 5 46.1796871 21.3397597 21.08.2014   RO-SITUR HOTEL 4 - STELE 18453
16451 16451 POSADA VIDRARU RO stay hotels hotel normal 4 star 4 - STELE 100 50 wedding 90 80 60 50 0   55 0 65.8 SBZ 22.6 0.4 87 Com. Arefu, Sat Arefu ARGEŞ   45.3358986 24.6362457 07.10.2016   RO-SITUR HOTEL 4 - STELE 13830
16455 16455 VALEA CU PESTI RO stay hotels hotel normal 4 star 4 - STELE 114 60 wedding 90 80 60 50 0   55 0 66.0 SBZ 22.3 0.2 89 Com. Arefu, Sat Arefu ARGEŞ NR. 200 45.3333451 24.6357028 01.11.2011   RO-SITUR HOTEL 4 - STELE 10159/5686
16886 16886 CIOBĂNAŞU RO stay hotels hotel normal 4 star 4 - STELE 42 21 wedding 80 70 50 50 0   45 0 61.4 GHV 32.3 1.0 75 Mun. Câmpulung ARGEŞ STR. Strada Petre Zamfirescu , NR. 16A 45.270703 25.0380686 12.03.2024   RO-SITUR HOTEL 4 - STELE 30189
16890 16890 IMPERIAL RO stay hotels hotel normal 4 star 4 - STELE 50 25 wedding 80 70 50 50 0   45 0 60.3 GHV 33.4 1.1 78 Mun. Câmpulung ARGEŞ STR. Strada Negru Vodă , NR. 202 45.2765814 25.0488231 25.11.2024   RO-SITUR HOTEL 4 - STELE 40672
16933 16933 POSADA RO stay hotels hotel normal 4 star 4 - STELE 138 69 wedding 90 80 60 50 0   50 10 84.1 SBZ 2.0 2.0 78 Mun. Curtea de Argeş ARGEŞ STR. Bulevardul Basarabilor , NR. 27-29 45.152189 24.675891 26.07.2021   RO-SITUR HOTEL 4 - STELE 1945/756
16945 16945 SUBCARPAŢI RO stay hotels hotel normal 4 star 4 - STELE 29 19 wedding 70 60 40 50 0   50 10 84.2 SBZ 2.2 2.2 76 Mun. Curtea de Argeş ARGEŞ STR. Strada Cuza Vodă , NR. 75E 45.1533136 24.681136 15.10.2020   RO-SITUR HOTEL 4 - STELE 9940/6986
17020 17020 RAMADA PITESTI RO stay hotels hotel normal 4 star 4 - STELE 270 135 wedding 100 90 70 50 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ STR. Calea Bucureşti , NR. 31 44.8646074 24.8772602 27.07.2011   RO-SITUR HOTEL 4 - STELE 15283A
17026 17026 SIERRA RO stay hotels hotel normal 4 star 4 - STELE 69 39 wedding 80 70 50 50 0   50 0 96.0 CRA 1.4 1.4 141 Mun. Piteşti ARGEŞ STR. Strada Profesor Ion Angelescu , NR. 78 44.8415687 24.8529893 21.08.2025   RO-SITUR HOTEL 4 - STELE 43662
17040 17040 VICTORIA RO stay hotels hotel normal 4 star 4 - STELE 125 98 wedding 90 80 60 50 0   50 0 98.2 CRA 0.7 0.7 142 Mun. Piteşti ARGEŞ STR. Strada Egalităţii , NR. 21 44.8539224 24.8742953 16.11.2009   RO-SITUR HOTEL 4 - STELE 13189
17101 17101 C&C KARO RESORT RO stay hotels hotel normal 4 star 4 - STELE 60 32 wedding 80 70 50 50 0   80 0 5.3 BCM 2.9 1.4 133 Com. Măgura, Sat Măgura BACĂU STR. Strada Karo , NR. 8 şi 8A 46.5637829 26.8767989 04.08.2023   RO-SITUR HOTEL 4 - STELE 12569/8619
17103 17103 HELEN RO stay hotels hotel normal 4 star 4 - STELE 76 38 wedding 80 70 50 50 0   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura, Sat Măgura BACĂU   46.5534109 26.878445 01.10.2021   RO-SITUR HOTEL 4 - STELE 13804
17195 17195 DUMBRAVA RO stay hotels hotel normal 4 star 4 - STELE 189 96 wedding 100 80 70 50 0   80 0 4.5 BCM 0.6 0.6 146 Mun. Bacău BACĂU STR. Strada Dumbrava Roşie , NR. 2 46.562238 26.911613 11.11.2021   RO-SITUR HOTEL 4 - STELE 1725/61
17198 17198 EMD RO stay hotels hotel normal 4 star 4 - STELE 72 35 wedding 80 70 50 50 0   80 0 6.0 BCM 1.2 1.2 143 Mun. Bacău BACĂU STR. Bulevardul Unirii , NR. 43 46.5745598 26.9260584 17.05.2023   RO-SITUR HOTEL 4 - STELE 13349
17203 17203 FIALD HOTEL & SPA RO stay hotels hotel normal 4 star 4 - STELE 118 59 wedding 90 80 60 50 0   80 0 6.7 BCM 1.9 1.9 144 Mun. Bacău BACĂU STR. Strada Tazlăului 46.5820215 26.9021363 30.05.2023   RO-SITUR HOTEL 4 - STELE 34682
17222 17222 PODU CU LANŢURI RO stay hotels hotel normal 4 star 4 - STELE 62 31 wedding 80 70 50 50 0   80 0 7.0 BCM 2.0 1.9 141 Mun. Bacău BACĂU STR. Calea Moldovei , NR. 4 46.585131 26.9129175 10.04.2018   RO-SITUR HOTEL 4 - STELE 31477
17223 17223 PRESIDENT RO stay hotels hotel normal 4 star 4 - STELE 56 30 wedding 80 70 50 50 0   80 0 4.8 BCM 0.5 0.5 145 Mun. Bacău BACĂU STR. Bulevardul Ioniţă Sandu Sturza , NR. 11 46.5647177 26.9086548 07.10.2021   RO-SITUR HOTEL 4 - STELE 13091
17341 17341 COROANA MOLDOVEI RO stay hotels hotel normal 4 star 4 - STELE 59 29 wedding 80 70 50 50 0   55 10 50.9 BCM 24.2 3.8 115 Oraş Slănic Moldova BACĂU STR. Strada Porumbeilor , NR. 1 46.2041431 26.4331932 27.11.2017   RO-SITUR HOTEL 4 - STELE 12535/8361
17376 17376 NEMIRA RO stay hotels hotel normal 4 star 4 - STELE 76 38 wedding 80 70 50 50 0   55 10 50.2 BCM 23.7 3.1 115 Oraş Slănic Moldova BACĂU STR. Strada Vasile Alecsandri , NR. 7 46.2085929 26.4394408 09.08.2018   RO-SITUR HOTEL 4 - STELE 13629
17380 17380 PERLA RO stay hotels hotel normal 4 star 4 - STELE 178 89 wedding 100 80 70 50 0   55 10 50.8 BCM 24.1 3.8 115 Oraş Slănic Moldova BACĂU STR. Strada Vasile Alecsandri , NR. 36 46.20424 26.433736 07.07.2016   RO-SITUR HOTEL 4 - STELE 29992
17697 17697 AVENTUS RO stay hotels hotel normal 4 star 4 - STELE 57 30 wedding 80 70 50 50 0   80 0 7.1 OMR 7.6 1.2 416 Com. Sânmartin, Sat Băile Felix BIHOR STR. Calea Beiuşului , NR. 19 46.9933078 21.9831643 03.09.2020   RO-SITUR HOTEL 4 - STELE 20804
17763 17763 INTERNATIONAL RO stay hotels hotel normal 4 star 4 - STELE 340 210 wedding 100 90 70 50 0   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673 09.07.2010   RO-SITUR HOTEL 4 - STELE 1003/692
17808 17808 PRESIDENT RO stay hotels hotel normal 4 star 4 - STELE 338 173 wedding 100 90 70 50 0   80 0 7.9 OMR 8.8 1.9 400 Com. Sânmartin, Sat Băile Felix BIHOR   46.9805797 21.9837496 06.12.2010   RO-SITUR HOTEL 4 - STELE 5465/1953
17849 17849 AQUA PRESIDENT SPA RO stay hotels hotel normal 4 star 4 - STELE 155 78 wedding 100 80 70 50 0   80 0 8.0 OMR 8.8 2.0 400 Com. Sânmartin, Sat Cordău BIHOR NR. 1/A 46.9798761 21.9835004 25.07.2017   RO-SITUR HOTEL 4 - STELE 27880
17926 17926 PERLA RO stay hotels hotel normal 4 star 4 - STELE 112 56 wedding 90 80 60 50 0   80 0 8.0 OMR 8.2 0.3 412 Com. Sânmartin, Sat Haieu BIHOR STR. Cartier Băile 1 Mai , NR. 65/B 46.997236 21.9991983 03.12.2020   RO-SITUR HOTEL 4 - STELE 11809/7600
18102 18102 ARIS BOUTIQUE HOTEL & SPA RO stay hotels hotel normal 4 star 4 - STELE 50 20 wedding 80 70 50 50 0   80 10 5.0 OMR 2.5 2.5 359 Mun. Oradea BIHOR STR. Strada Lămâiţei , NR. 7 47.0659814 21.9319973 06.11.2025   RO-SITUR HOTEL 4 - STELE 44842
18107 18107 ASTORIA RO stay hotels hotel normal 4 star 4 - STELE 92 50 wedding 90 80 60 50 0   80 0 4.1 OMR 1.6 1.6 364 Mun. Oradea BIHOR STR. Strada Teatrului , NR. 1-2 47.057339 21.930125 17.08.2022   RO-SITUR HOTEL 4 - STELE 813/884
18180 18180 CONTINENTAL FORUM RO stay hotels hotel normal 4 star 4 - STELE 336 168 wedding 100 90 70 50 0   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR STR. Aleea Ştrandului , NR. 1 47.055657 21.941854 21.01.2019   RO-SITUR HOTEL 4 - STELE 811/1341
18190 18190 DOUBLETREE BY HILTON RO stay hotels hotel normal 4 star 4 - STELE 294 147 wedding 100 90 70 50 0   80 10 4.8 OMR 2.5 2.5 375 Mun. Oradea BIHOR STR. Aleea Ştrandului , NR. 9 47.0543575 21.9485963 03.05.2023   RO-SITUR HOTEL 4 - STELE 18157
18199 18199 ELITE RO stay hotels hotel normal 4 star 4 - STELE 76 38 wedding 80 70 50 50 0   80 10 4.8 OMR 2.4 2.4 374 Mun. Oradea BIHOR NR. 24-26-28 47.0569106 21.9451201 12.03.2014   RO-SITUR HOTEL 4 - STELE 3406/1394
18275 18275 MAXIM RO stay hotels hotel normal 4 star 4 - STELE 78 39 wedding 80 70 50 50 0   80 10 4.8 OMR 2.2 2.2 363 Mun. Oradea BIHOR STR. Strada Dr. Victor Babeş , NR. 5 47.0620087 21.9348834 12.04.2012   RO-SITUR HOTEL 4 - STELE 12605/8594
18288 18288 NEVIS WELLNESS & SPA RO stay hotels hotel normal 4 star 4 - STELE 126 63 wedding 90 80 60 50 0   80 10 4.3 OMR 2.0 2.0 347 Mun. Oradea BIHOR STR. Strada Lăpuşului , NR. 2 47.0631495 21.9109641 18.10.2021   RO-SITUR HOTEL 4 - STELE 10064/6489
18316 18316 RAMADA RO stay hotels hotel normal 4 star 4 - STELE 242 121 wedding 100 90 70 50 0   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR STR. Calea Aradului , NR. 9 47.0556 21.916233 17.08.2010   RO-SITUR HOTEL 4 - STELE 13655
18399 18399 SLAVIA RO stay hotels hotel normal 4 star 4 - STELE 37 22 wedding 80 60 40 50 0   65 10 30.8 OMR 0.9 0.9 13 Mun. Salonta BIHOR STR. Strada 1 Decembrie , NR. 7 46.803644 21.6599765 06.07.2015   RO-SITUR HOTEL 4 - STELE 12839
18520 18520 PANORAMIC COLIBIŢA RO stay hotels hotel normal 4 star 4 - STELE 40 18 wedding 80 70 50 50 0   30 0 87.4 TGM 31.1 0.6 69 Com. Bistriţa Bârgăului, Sat Colibiţa BISTRIŢA-NĂSĂUD NR. 255C 47.1776112 24.9056372 10.12.2021   RO-SITUR HOTEL 4 - STELE 24127
18523 18523 ROSER HOUSE RO stay hotels hotel normal 4 star 4 - STELE 28 14 wedding 70 60 40 50 0   40 0 86.1 TGM 29.6 1.5 67 Com. Bistriţa Bârgăului, Sat Colibiţa BISTRIŢA-NĂSĂUD NR. 269 47.1706136 24.8872624 08.08.2018   RO-SITUR HOTEL 4 - STELE 17818
18542 18542 JELNA RO stay hotels hotel normal 4 star 4 - STELE 42 21 wedding 80 70 50 50 0   65 10 72.4 TGM 5.0 0.2 19 Com. Cetate, Sat Satu Nou BISTRIŢA-NĂSĂUD NR. 223 47.1113476 24.5577843 05.10.2023   RO-SITUR HOTEL 4 - STELE 36439
18687 18687 GRAND COROANA RO stay hotels hotel normal 4 star 4 - STELE 167 87 wedding 100 80 70 50 0   65 0 73.0 CLJ 0.3 0.3 92 Mun. Bistriţa BISTRIŢA-NĂSĂUD STR. Piaţa Petru Rareş , NR. 4 47.1360456 24.4995178 02.07.2024   RO-SITUR HOTEL 4 - STELE 1260
18703 18703 OZANA RO stay hotels hotel normal 4 star 4 - STELE 76 38 wedding 80 70 50 50 0   65 0 74.2 CLJ 1.5 1.5 91 Mun. Bistriţa BISTRIŢA-NĂSĂUD STR. Strada Calea Moldovei , NR. 17 47.144322 24.510262 16.06.2011   RO-SITUR HOTEL 4 - STELE 14659A
18815 18815 MARIA RO stay hotels hotel normal 4 star 4 - STELE 98 49 wedding 90 80 60 50 0   80 0 23.6 SCV 0.9 0.9 49 Mun. Botoşani BOTOŞANI STR. Strada Unirii , NR. 12 47.7442769 26.658168 03.12.2009   RO-SITUR HOTEL 4 - STELE 6502/4931
18821 18821 REDIU RO stay hotels hotel normal 4 star 4 - STELE 78 39 wedding 80 70 50 50 0   80 0 25.2 SCV 1.4 1.4 49 Mun. Botoşani BOTOŞANI STR. Strada I. C. Brătianu 47.7422718 26.6815708 28.03.2023   RO-SITUR HOTEL 4 - STELE 30958
18838 18838 ALMA HEALTH&SPA RETREAT RO stay hotels hotel normal 4 star 4 - STELE 366 185 wedding 100 90 70 50 0   65 10 64.8 TCE 8.7 2.4 37 Com. Chiscani, Sat Chiscani BRĂILA STR. Aleea Centrală , NR. 5 45.2064571 27.9135857 23.08.2022   RO-SITUR HOTEL 4 - STELE 31983
18845 18845 UNIQUE GARDEN RO stay hotels hotel normal 4 star 4 - STELE 30 15 wedding 80 60 40 50 0   65 0 63.2 TCE 9.1 1.4 34 Com. Chiscani, Sat Vărsătura BRĂILA STR. Strada Principală , NR. 27 45.1956088 27.9310483 29.09.2023   RO-SITUR HOTEL 4 - STELE 36298
18876 18876 GRAND HOTEL ORIENT RO stay hotels hotel normal 4 star 4 - STELE 88 40 wedding 90 80 60 50 0   65 0 62.1 TCE 0.4 0.4 90 Mun. Brăila BRĂILA STR. Strada Rubinelor , NR. 1 45.2698193 27.9783705 18.05.2011   RO-SITUR HOTEL 4 - STELE 14892
18900 18900 SAINT-GERMAIN BOUTIQUE HOTEL RO stay hotels hotel normal 4 star 4 - STELE 31 18 wedding 80 60 40 50 0   65 0 62.3 TCE 0.3 0.3 89 Mun. Brăila BRĂILA STR. Strada Grădinii Publice , NR. 1 45.2729473 27.9782124 13.03.2019   RO-SITUR HOTEL 4 - STELE 30151
19128 19128 MATCA RO stay hotels hotel normal 4 star 4 - STELE 46 23 wedding 80 70 50 50 0   80 0 27.5 GHV 9.2 0.5 459 Com. Bran, Sat Şimon BRAŞOV STR. Strada Bălăban , NR. 18, nr. 24 și nr. 26 45.4849128413776 25.3631580154053 20.01.2026   RO-SITUR HOTEL 4 - STELE 9966/6748
20018 20018 ACASĂ LA DRACULA RO stay hotels hotel normal 4 star 4 - STELE 37 21 wedding 80 60 40 50 0   80 20 12.4 GHV 6.7 5.1 287 Mun. Braşov BRAŞOV STR. Strada Poiana lui Stechil , NR. 22 45.5969445 25.5609009 15.12.2011   RO-SITUR HOTEL 4 - STELE 9439/5917
20046 20046 ALPIN RESORT HOTEL RO stay hotels hotel normal 4 star 4 - STELE 611 227 wedding 100 90 70 50 0   80 20 12.4 GHV 7.2 5.8 252 Mun. Braşov BRAŞOV STR. Strada Poiana Doamnei , NR. 9 45.5962808 25.5512779 18.07.2017   RO-SITUR HOTEL 4 - STELE 9467/5915
20053 20053 AMBIENT RO stay hotels hotel normal 4 star 4 - STELE 137 71 wedding 90 80 60 50 0   80 0 8.6 GHV 0.6 0.6 1175 Mun. Braşov BRAŞOV STR. Strada Iuliu Maniu , NR. 27A 45.6486552 25.5983695 01.06.2011   RO-SITUR HOTEL 4 - STELE 4308/1085
20061 20061 ANA HOTELS SPORT POIANA BRAŞOV RO stay hotels hotel normal 4 star 4 - STELE 333 167 wedding 100 90 70 50 0   80 20 12.7 GHV 7.3 5.5 243 Mun. Braşov BRAŞOV STR. Strada Valea Dragă , NR. 2 45.5935681 25.5549924 15.04.2021   RO-SITUR HOTEL 4 - STELE 3294/1264
20133 20133 BELVEDERE RO stay hotels hotel normal 4 star 4 - STELE 44 24 wedding 80 70 50 50 0   80 10 8.0 GHV 2.2 2.2 1158 Mun. Braşov BRAŞOV STR. Strada Stejerişului , NR. 11 45.6450749 25.5788229 01.08.2013   RO-SITUR HOTEL 4 - STELE 9354/5916
20378 20378 CUBIX RO stay hotels hotel normal 4 star 4 - STELE 114 57 wedding 90 80 60 50 0   80 10 11.8 GHV 2.8 2.8 1038 Mun. Braşov BRAŞOV STR. Bulevardul Saturn , NR. 47 45.6348378 25.6366912 10.03.2014   RO-SITUR HOTEL 4 - STELE 11799/7737
20433 20433 ESCALADE RO stay hotels hotel normal 4 star 4 - STELE 122 61 wedding 90 80 60 50 0   80 20 12.2 GHV 7.0 5.8 266 Mun. Braşov BRAŞOV STR. Strada Poiana Soarelui 45.5977233 25.5523932 20.06.2018   RO-SITUR HOTEL 4 - STELE 14631
20475 20475 GOLDEN TIME RO stay hotels hotel normal 4 star 4 - STELE 98 44 wedding 90 80 60 50 0   80 10 11.1 GHV 2.1 2.1 1125 Mun. Braşov BRAŞOV STR. Calea Bucureşti , NR. 99 45.6390899 25.6298084 02.12.2013   RO-SITUR HOTEL 4 - STELE 8359/5507
20478 20478 GRAND RO stay hotels hotel normal 4 star 4 - STELE 40 20 wedding 80 70 50 50 0   80 0 8.7 GHV 1.5 1.5 1171 Mun. Braşov BRAŞOV STR. Strada Gării Nouă , NR. 6 45.6426802 25.5887252 06.06.2023   RO-SITUR HOTEL 4 - STELE 13224
20479 20479 GRAND BELVEDERE RO stay hotels hotel normal 4 star 4 - STELE 88 44 wedding 90 80 60 50 0   80 10 7.9 GHV 2.2 2.2 1159 Mun. Braşov BRAŞOV STR. Strada Stejerişului , NR. 26 45.6454468 25.5777658 04.01.2018   RO-SITUR HOTEL 4 - STELE 31203
20600 20600 KRONWELL RO stay hotels hotel normal 4 star 4 - STELE 162 81 wedding 100 80 70 50 0   80 0 8.7 GHV 1.5 1.5 1173 Mun. Braşov BRAŞOV STR. Bulevardul Gării , NR. 7 45.6602966 25.6147789 26.11.2012   RO-SITUR HOTEL 4 - STELE 25941
20795 20795 POIANA URSULUI RO stay hotels hotel normal 4 star 4 - STELE 76 38 wedding 80 70 50 50 0   80 20 12.2 GHV 6.8 5.5 287 Mun. Braşov BRAŞOV STR. Strada Poiana Ursului , NR. 1 45.5983629 25.5561739 27.08.2018   RO-SITUR HOTEL 4 - STELE 13375
20809 20809 QOSMO RO stay hotels hotel normal 4 star 4 - STELE 266 133 wedding 100 90 70 50 0   80 10 8.1 GHV 2.5 2.5 1164 Mun. Braşov BRAŞOV STR. Strada Zaharia Stancu , NR. 4 45.6702502 25.6148346 25.10.2021   RO-SITUR HOTEL 4 - STELE 23969
20861 20861 RIZZO BOUTIQUE RO stay hotels hotel normal 4 star 4 - STELE 92 46 wedding 90 80 60 50 0   80 20 13.2 GHV 7.6 5.9 222 Mun. Braşov BRAŞOV STR. Strada Valea Lungă , NR. 8 45.5881319 25.5473425 15.10.2020   RO-SITUR HOTEL 4 - STELE 14461
20940 20940 SIMONA HALEP RO stay hotels hotel normal 4 star 4 - STELE 54 27 wedding 80 70 50 50 0   80 20 12.2 GHV 7.0 5.8 265 Mun. Braşov BRAŞOV STR. Strada Poiana Ruia , NR. 1 45.5982101 25.5523649 01.04.2025   RO-SITUR HOTEL 4 - STELE 9351/6044
21097 21097 VICTORIA BULEVARD RO stay hotels hotel normal 4 star 4 - STELE 40 20 wedding 80 70 50 50 0   80 0 8.9 GHV 0.9 0.9 1182 Mun. Braşov BRAŞOV STR. Bulevardul Victoriei , NR. 6 A 45.6559688 25.612144 24.08.2017   RO-SITUR HOTEL 4 - STELE 30684
21138 21138 AURELIUS IMPARATUL ROMANILOR RO stay hotels hotel normal 4 star 4 - STELE 174 90 wedding 100 80 70 50 0   80 20 12.8 GHV 7.6 5.8 226 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5920524 25.5502319 24.08.2022   RO-SITUR HOTEL 4 - STELE 13978
21139 21139 BRADUL RO stay hotels hotel normal 4 star 4 - STELE 118 59 wedding 90 80 60 50 0   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291 07.11.2012   RO-SITUR HOTEL 4 - STELE 2159/252
21163 21163 MIRAJ RO stay hotels hotel normal 4 star 4 - STELE 59 29 wedding 80 70 50 50 0   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV NR. 15 45.5990582 25.5573974 11.08.2023   RO-SITUR HOTEL 4 - STELE 7162/5123
21167 21167 NEW BELVEDERE RO stay hotels hotel normal 4 star 4 - STELE 44 15 wedding 80 70 50 50 0   80 20 13.2 GHV 7.9 5.7 221 Mun. Braşov, Loc. Poiana Braşov BRAŞOV NR. 51 45.5881574 25.5508511 05.09.2019   RO-SITUR HOTEL 4 - STELE 4476/1915
21170 21170 PIATRA MARE RO stay hotels hotel normal 4 star 4 - STELE 363 186 wedding 100 90 70 50 0   80 20 12.5 GHV 7.5 6.0 239 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5947093 25.5485191 08.12.2011   RO-SITUR HOTEL 4 - STELE 6123/3729
21180 21180 TELEFERIC GRAND HOTEL RO stay hotels hotel normal 4 star 4 - STELE 248 127 wedding 100 90 70 50 0   80 20 13.1 GHV 7.8 5.6 222 Mun. Braşov, Loc. Poiana Braşov BRAŞOV NR. 243 45.5893027 25.5523188 29.03.2016   RO-SITUR HOTEL 4 - STELE 29444
21271 21271 HP TOWER ONE RO stay hotels hotel normal 4 star 4 - STELE 226 113 wedding 100 90 70 50 0   80 10 15.0 GHV 4.1 4.1 189 Mun. Săcele BRAŞOV STR. Strada Calea Bucureşti , NR. 13 45.6099186 25.6590534 17.12.2024   RO-SITUR HOTEL 4 - STELE 12133/7959
21341 21341 CARMEN RO stay hotels hotel normal 4 star 4 - STELE 114 58 wedding 90 80 60 50 0   70 0 22.8 GHV 13.1 0.7 340 Oraş Predeal BRAŞOV STR. Bulevardul Mihail Săulescu , NR. 121 45.5039215 25.5734601 16.12.2016   RO-SITUR HOTEL 4 - STELE 854/33
21419 21419 ELEXUS PREDEAL RO stay hotels hotel normal 4 star 4 - STELE 96 49 wedding 90 80 60 50 0   70 0 22.6 GHV 13.3 1.3 339 Oraş Predeal BRAŞOV STR. Strada Muncii , NR. 6 45.5066249 25.5805374 17.02.2021   RO-SITUR HOTEL 4 - STELE 8320/5615
21435 21435 HART RO stay hotels hotel normal 4 star 4 - STELE 165 85 wedding 100 80 70 50 0   70 10 25.9 GHV 15.0 2.9 400 Oraş Predeal BRAŞOV STR. Şoseaua Naţională , NR. 5 45.4742381 25.5623289 20.08.2014   RO-SITUR HOTEL 4 - STELE 18443
21459 21459 MONTAN RO stay hotels aparthotel normal 4 star 4 - STELE 36 18 wedding 80 60 40 50 0   70 0 22.6 GHV 13.3 1.2 340 Oraş Predeal BRAŞOV STR. Strada Muncii , NR. 2 45.5062441 25.5799595 17.03.2025   RO-SITUR HOTEL APARTAMENT 4 - STELE 41898
21477 21477 PIEMONTE RO stay hotels hotel normal 4 star 4 - STELE 122 62 wedding 90 80 60 50 0   70 0 22.1 GHV 12.6 1.2 341 Oraş Predeal BRAŞOV STR. Bulevardul Mihail Săulescu , NR. 149 45.5100521 25.573298 28.02.2014   RO-SITUR HOTEL 4 - STELE 9960/6266
21483 21483 PREDEAL COMFORT SUITES RO stay hotels hotel normal 4 star 4 - STELE 72 36 wedding 80 70 50 50 0   70 0 21.9 GHV 12.2 1.2 352 Oraş Predeal BRAŞOV STR. Strada Trei Brazi , NR. 33 45.5105952 25.5668437 06.03.2018   RO-SITUR HOTEL 4 - STELE 9350/8236
21491 21491 ROZMARIN RO stay hotels hotel normal 4 star 4 - STELE 142 71 wedding 90 80 60 50 0   70 0 21.8 GHV 12.3 1.4 348 Oraş Predeal BRAŞOV STR. Bulevardul Mihail Săulescu , NR. 159 45.5125271 25.5714637 24.09.2018   RO-SITUR HOTEL 4 - STELE 7154/5303
21497 21497 SKI&SKY RO stay hotels hotel normal 4 star 4 - STELE 5353 29 wedding 100 90 70 50 0   70 0 23.1 GHV 13.5 0.8 340 Oraş Predeal BRAŞOV STR. Strada Liviu Rebreanu , NR. 2 45.5009137 25.5763884 30.09.2024   RO-SITUR HOTEL 4 - STELE 11357/7226
21508 21508 URSULEŢUL RO stay hotels hotel normal 4 star 4 - STELE 85 42 wedding 90 80 60 50 0   70 0 22.9 GHV 13.5 1.2 340 Oraş Predeal BRAŞOV STR. Strada Vasile Alecsandri , NR. 35 45.5039306 25.580729 02.06.2022   RO-SITUR HOTEL 4 - STELE 9005/6004
21604 21604 CUIBUL DE LEMN RO stay hotels hotel normal 4 star 4 - STELE 36 18 wedding 80 60 40 50 0   80 10 20.4 GHV 5.8 3.2 113 Oraş Râşnov BRAŞOV STR. Strada Glăjerie-Râul Mare 45.5312216 25.4428849 27.10.2020   RO-SITUR HOTEL 4 - STELE 21376
21613 21613 EDEL HOUSE RO stay hotels hotel normal 4 star 4 - STELE 44 22 wedding 80 70 50 50 0   80 0 13.0 GHV 1.8 1.8 152 Oraş Râşnov BRAŞOV STR. Strada Florilor , NR. 69 45.5963907 25.4639618 03.08.2011   RO-SITUR HOTEL 4 - STELE 15335A
21657 21657 RADSOR RO stay hotels hotel normal 4 star 4 - STELE 74 37 wedding 80 70 50 50 0   80 0 13.5 GHV 1.4 1.4 158 Oraş Râşnov BRAŞOV STR. Strada Ion Creangă , NR. 2 45.5913019 25.4641473 27.10.2020   RO-SITUR HOTEL 4 - STELE 30157
21777 21777 MARIDOR RESORT&SPA RO stay hotels hotel normal 4 star 4 - STELE 186 93 wedding 100 80 70 50 0   80 0 21.8 GHV 5.2 1.7 380 Oraş Zărneşti BRAŞOV STR. Şoseaua Branului 45.5386056 25.3768703 11.11.2022   RO-SITUR HOTEL 4 - STELE 12263/7582
21809 21809 WOLF 2 RO stay hotels hotel normal 4 star 4 - STELE 110 55 wedding 90 80 60 50 0   80 0 20.4 GHV 5.4 0.3 343 Oraş Zărneşti BRAŞOV STR. Strada Branului Tohanul Nou , NR. 36 bis 45.5493591 25.3853652 31.08.2017   RO-SITUR HOTEL 4 - STELE 13288
21983 21983 ART RO stay hotels hotel normal 4 star 4 - STELE 62 31 wedding 80 70 50 50 0   80 0 14.5 Boboc Air Base 1.3 1.3 138 Mun. Buzău BUZĂU STR. Bulevardul Nicolae Bălcescu , NR. 18 45.1529638 26.8167177 30.05.2011   RO-SITUR HOTEL 4 - STELE 14989
21984 21984 AVENUE RO stay hotels hotel normal 4 star 4 - STELE 132 66 wedding 90 80 60 50 0   80 0 14.8 Boboc Air Base 1.3 1.3 137 Mun. Buzău BUZĂU STR. Strada Lt. col. Gheorghe Iacob , NR. 2 45.14165 26.82247 30.09.2020   RO-SITUR HOTEL 4 - STELE 21316
22065 22065 AVO RO stay hotels hotel normal 4 star 4 - STELE 68 34 wedding 80 70 50 50 0   80 10 18.1 Boboc Air Base 1.7 1.0 20 Mun. Râmnicu Sărat BUZĂU STR. Strada Stadionului , NR. 10 45.3746032 27.0316467 23.03.2026   RO-SITUR HOTEL 4 - STELE 9787/6127
22123 22123 HESTIA RO stay hotels hotel normal 4 star 4 - STELE 94 47 wedding 90 80 60 50 0   65 0 38.9 Feteşti Borcea Air Base 9.8 1.8 29 Mun. Călăraşi CĂLĂRAŞI STR. Şoseaua Chiciului , NR. 2 A 44.1917094 27.3257188 04.11.2013   RO-SITUR HOTEL 4 - STELE 27357
22319 22319 MONTIS HOTEL & SPA RO stay hotels hotel normal 4 star 4 - STELE 94 47 wedding 90 80 60 50 0   80 0 7.2 CSB 9.6 0.2 22 Com. Turnu Ruieni, Sat Turnu Ruieni CARAŞ-SEVERIN   45.3900834 22.333759 30.09.2021   RO-SITUR HOTEL 4 - STELE 12491/8460

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