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

2,002 rows where country = "RO" and family = "hotels"

This data as json, CSV (advanced)

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

rating_value 5

  • 3 1,089
  • 4 511
  • 2 315
  • 5 46
  • 1 41

group 1

family 1

  • hotels · 2,002 ✖

country 1

  • RO · 2,002 ✖

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
15587 15587 BLEUMARIN RO stay hotels motel normal 3 star 3 - STELE 22 11 wedding 60 53 30 0 0   55 30 39.8 Câmpia Turzii Air Base 14.0 2.9 5 Com. Galda de Jos, Sat Galda de Jos ALBA   46.1816893 23.6566509 07.04.2011   RO-SITUR MOTEL 3 - STELE 11697/7475
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
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
15777 15777 ASTORIA RO stay hotels hotel normal 3 star 3 - STELE 69 30 wedding 70 63 40 0 0   65 20 44.6 Câmpia Turzii Air Base 9.1 1.2 5 Com. Sântimbru, Sat Sântimbru ALBA STR. Drumul DN 1 46.1395397 23.6376987 23.05.2012   RO-SITUR HOTEL 3 - STELE 12724/8710
15802 15802 NEDEI HOTEL & SPA RO stay hotels hotel normal 3 star 3 - STELE 80 40 wedding 80 73 50 0 0   55 10 36.6 SBZ 18.0 0.6 19 Com. Şugag, Sat Mărtinie ALBA STR. Strada Luncii , NR. 42B 45.7973968 23.6148127 29.07.2021   RO-SITUR HOTEL 3 - STELE 23547
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
15893 15893 CAROLINA HERITAGE RO stay hotels hotel normal 3 star 3 - STELE 27 15 wedding 60 53 30 0 0   65 0 50.9 SBZ 1.0 1.0 191 Mun. Alba Iulia ALBA STR. Piaţa Unirii , NR. 11 46.0691156 23.5705453 15.02.2023   RO-SITUR HOTEL 3 - STELE 33703
15901 15901 CETATE RO stay hotels hotel normal 3 star 3 - STELE 216 104 wedding 90 83 60 0 0   65 0 51.0 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA STR. Piaţa Unirii , NR. 3 46.0699016 23.5696515 09.07.2024   RO-SITUR HOTEL 3 - STELE 921
15915 15915 ELISABETA RO stay hotels hotel normal 3 star 3 - STELE 92 49 wedding 80 73 50 0 0   65 0 52.6 Câmpia Turzii Air Base 2.7 1.8 167 Mun. Alba Iulia ALBA STR. Strada Aleea Vilelor , NR. 4 46.0860794 23.5617206 21.05.2021   RO-SITUR HOTEL 3 - STELE 30672
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
15923 15923 HERMES RO stay hotels hotel normal 3 star 3 - STELE 42 19 wedding 70 63 40 0 0   65 10 51.9 SBZ 2.1 2.1 169 Mun. Alba Iulia ALBA STR. Strada Toporaşilor , NR. 20 46.0753981 23.5595508 14.09.2012   RO-SITUR HOTEL 3 - STELE 11404/7890
15937 15937 MARISS RO stay hotels hotel normal 3 star 3 - STELE 57 28 wedding 70 63 40 0 0   65 0 49.8 SBZ 1.8 1.8 171 Mun. Alba Iulia ALBA STR. Strada Viilor , NR. 39 46.0535521 23.5701201 24.03.2014   RO-SITUR HOTEL 3 - STELE 27811
15942 15942 MEDIEVAL RO stay hotels hotel normal 5 star 5 - STELE 44 22 wedding 80 70 50 60 0   65 0 50.6 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA STR. Strada Militari , NR. 2 46.0671679 23.5722201 08.08.2018   RO-SITUR HOTEL 5 - STELE 17946
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
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
16019 16019 DACIA RO stay hotels motel normal 1 star 1 - STELE 100 39 wedding 70 65 50 0 0   65 0 43.1 SBZ 1.1 1.1 30 Mun. Sebeş ALBA STR. Strada Drumul Sibiului , NR. 42 45.950638 23.582642 16.04.2026   RO-SITUR MOTEL 1 - STELE 18062
16021 16021 FAN RO stay hotels hotel normal 3 star 3 - STELE 84 36 wedding 80 73 50 0 0   65 0 42.6 SBZ 1.6 1.6 27 Mun. Sebeş ALBA STR. Strada Drumul Sibiului , NR. 45 45.9476014 23.5874321 16.11.2021   RO-SITUR HOTEL 3 - STELE 12497/7477
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
16029 16029 YVY RO stay hotels hotel normal 3 star 3 - STELE 57 29 wedding 70 63 40 0 0   65 0 46.2 SBZ 2.5 1.2 31 Mun. Sebeş ALBA STR. Strada Mihail Kogălniceanu , NR. 61 45.9764178 23.5566242 18.08.2023   RO-SITUR HOTEL 3 - STELE 35710
16030 16030 ALLEGRIA RO stay hotels hotel normal 3 star 3 - STELE 124 63 wedding 80 73 50 0 0   65 0 46.7 SBZ 3.4 0.2 32 Mun. Sebeş, Loc. Lancrăm ALBA NR. 9 45.9849776 23.5554968 14.01.2016   RO-SITUR HOTEL 3 - STELE 27380
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
16104 16104 CODRU MOMA RO stay hotels hotel normal 3 star 3 - STELE 204 102 wedding 90 83 60 0 0   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa, Sat Moneasa ARAD   46.4603468 22.2535709 12.09.2019   RO-SITUR HOTEL 3 - STELE 1024/321
16118 16118 PANORAMIC RO stay hotels hotel normal 3 star 3 - STELE 46 23 wedding 70 63 40 0 0   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa, Sat Moneasa ARAD   46.4603468 22.2535709 23.03.2011   RO-SITUR HOTEL 3 - STELE 14056
16119 16119 PARC RO stay hotels hotel normal 3 star 3 - STELE 102 47 wedding 80 73 50 0 0   45 0 68.3 OMR 54.3 1.6 36 Com. Moneasa, Sat Moneasa ARAD   46.4624161 22.2603649 08.07.2015   RO-SITUR HOTEL 3 - STELE 5046/3308
16122 16122 SÂNTANA RO stay hotels hotel normal 3 star 3 - STELE 84 41 wedding 80 73 50 0 0   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa, Sat Moneasa ARAD NR. 74 46.4603468 22.2535709 25.07.2013   RO-SITUR HOTEL 3 - STELE 27036
16171 16171 IOANIS RO stay hotels motel normal 3 star 3 - STELE 42 20 wedding 70 63 40 0 0   70 10 15.7 ARW 12.0 0.5 11 Com. Vladimirescu, Sat Mândruloc ARAD NR. 379/A 46.144684 21.4624123 06.07.2015   RO-SITUR MOTEL 3 - STELE 7610/5209
16190 16190 ANA RO stay hotels hotel normal 3 star 3 - STELE 32 16 wedding 70 53 30 0 0   80 10 6.7 ARW 2.7 2.7 392 Mun. Arad ARAD STR. Calea Radnei , NR. 133 46.1790234 21.3511016 30.03.2011   RO-SITUR HOTEL 3 - STELE 14115
16192 16192 ANIROC SIGNATURE RO stay hotels hotel normal 5 star 5 - STELE 160 80 wedding 100 80 70 60 0   80 0 3.8 ARW 1.4 1.4 404 Mun. Arad ARAD STR. Strada Vasile Goldiş , NR. 5 46.1709468 21.3134831 31.08.2023   RO-SITUR HOTEL 5 - STELE 35816
16196 16196 ARAD RO stay hotels hotel normal 3 star 3 - STELE 49 24 wedding 70 63 40 0 0   80 0 4.2 ARW 1.1 1.1 406 Mun. Arad ARAD STR. Bulevardul Decebal , NR. 9 46.1731963 21.3189087 23.08.2021   RO-SITUR HOTEL 3 - STELE 4837/3054
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
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
16245 16245 COANDI RO stay hotels hotel normal 3 star 3 - STELE 99 51 wedding 80 73 50 0 0   80 10 4.8 ARW 2.5 2.5 385 Mun. Arad ARAD STR. Calea Romanilor , NR. 47 46.1612414 21.3231912 07.09.2009   RO-SITUR HOTEL 3 - STELE 9408/5261
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
16249 16249 CRISANA RO stay hotels hotel normal 3 star 3 - STELE 42 21 wedding 70 63 40 0 0   80 0 5.4 ARW 1.5 1.5 397 Mun. Arad ARAD STR. Strada Petru Rareş , NR. 24 46.1921158 21.3312212 18.02.2011   RO-SITUR HOTEL 3 - STELE 13247/7305
16253 16253 DAROSY RO stay hotels hotel normal 3 star 3 - STELE 34 17 wedding 70 53 30 0 0   80 0 3.6 ARW 0.5 0.5 410 Mun. Arad ARAD STR. Calea Victoriei , NR. 2C 46.183611 21.309606 01.11.2018   RO-SITUR HOTEL 3 - STELE 6194/3868
16276 16276 GIO RO stay hotels hotel normal 3 star 3 - STELE 75 36 wedding 70 63 40 0 0   80 0 4.3 ARW 1.7 1.7 404 Mun. Arad ARAD NR. 3 46.1679216 21.3182705 25.08.2011   RO-SITUR HOTEL 3 - STELE 11338/7936
16280 16280 HANUL DE LA RĂSCRUCE RO stay hotels hotel normal 3 star 3 - STELE 69 32 wedding 70 63 40 0 0   70 30 6.5 ARW 10.0 7.6 9 Mun. Arad ARAD NR. F.N. 46.2054786 21.1906356 06.11.2025   RO-SITUR HOTEL 3 - STELE 18018
16283 16283 IBIS STYLES ARAD RO stay hotels hotel normal 3 star 3 - STELE 144 72 wedding 80 73 50 0 0   80 20 3.3 ARW 5.7 5.7 94 Mun. Arad ARAD STR. Calea Aurel Vlaicu , NR. 306 46.2032504 21.2478826 05.09.2018   RO-SITUR HOTEL 3 - STELE 18916
16285 16285 IRIS RO stay hotels hotel normal 3 star 3 - STELE 54 26 wedding 70 63 40 0 0   80 0 3.1 ARW 1.6 1.6 415 Mun. Arad ARAD NR. 1 46.1715719 21.3042347 12.10.2012   RO-SITUR HOTEL 3 - STELE 8582/5940
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
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
16299 16299 M CITY RO stay hotels aparthotel normal 3 star 3 - STELE 20 10 wedding 60 53 30 0 0   80 10 7.1 ARW 3.1 3.1 375 Mun. Arad ARAD STR. Calea Radnei , NR. 163 46.177532 21.356598 29.11.2023   RO-SITUR HOTEL APARTAMENT 3 - STELE 37118
16306 16306 MAXIM RO stay hotels hotel normal 3 star 3 - STELE 64 32 wedding 70 63 40 0 0   80 10 6.1 ARW 2.1 2.1 388 Mun. Arad ARAD STR. Calea Radnei , NR. 122 46.1803396 21.3433137 11.03.2021   RO-SITUR HOTEL 3 - STELE 10804/7033
16307 16307 MIKY RO stay hotels hotel normal 3 star 3 - STELE 76 38 wedding 70 63 40 0 0   80 10 7.8 ARW 3.8 2.9 347 Mun. Arad ARAD STR. Calea Radnei , NR. 231 46.1759734 21.3655141 27.08.2014   RO-SITUR HOTEL 3 - STELE 18454
16324 16324 PRESIDENT RO stay hotels hotel normal 3 star 3 - STELE 58 29 wedding 70 63 40 0 0   80 10 5.8 ARW 4.6 4.6 273 Mun. Arad ARAD STR. Calea Timişorii , NR. 164 46.1422618 21.3208731 01.08.2011   RO-SITUR HOTEL 3 - STELE 5145/5369
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
16367 16367 XE-MAR RO stay hotels hotel normal 3 star 3 - STELE 31 16 wedding 70 53 30 0 0   80 10 4.9 ARW 2.8 2.8 380 Mun. Arad ARAD STR. Piaţa Eroilor , NR. 1 46.1583565 21.3221171 18.02.2011   RO-SITUR HOTEL 3 - STELE 11336/7310
16371 16371 CRIS RO stay hotels hotel normal 3 star 3 - STELE 55 25 wedding 70 63 40 0 0   55 20 43.3 ARW 22.8 0.1 4 Oraş Chişineu-Criş ARAD STR. Strada Înfrăţirii 46.5239525 21.5180281 12.01.2022   RO-SITUR HOTEL 3 - STELE 13369
16375 16375 CENTRAL RO stay hotels hotel normal 3 star 3 - STELE 48 24 wedding 70 63 40 0 0   45 10 51.8 ARW 44.0 1.1 10 Oraş Ineu ARAD STR. Calea Republicii , NR. 21 46.4248845 21.8346096 02.12.2011   RO-SITUR HOTEL 3 - STELE 11885/8447
16377 16377 HANUL MOARA CU NOROC RO stay hotels hotel normal 3 star 3 - STELE 41 23 wedding 70 63 40 0 0   45 10 52.6 ARW 43.5 0.3 10 Oraş Ineu ARAD   46.4310262 21.840539 06.07.2015   RO-SITUR HOTEL 3 - STELE 27376
16381 16381 STEJARII RO stay hotels hotel normal 3 star 3 - STELE 46 23 wedding 70 63 40 0 0   45 20 50.2 ARW 45.3 2.6 10 Oraş Ineu ARAD STR. Strada Lacului , NR. 3 46.4105515 21.8225233 11.03.2021   RO-SITUR HOTEL 3 - STELE 17975
16395 16395 JACKSON RO stay hotels hotel normal 3 star 3 - STELE 49 23 wedding 70 63 40 0 0   55 20 41.6 ARW 19.3 2.0 6 Oraş Nădlac ARAD   46.166437 20.7237905 30.09.2020   RO-SITUR HOTEL 3 - STELE 21319
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
16448 16448 PÂRÂUL CAPRA RO stay hotels hotel normal 3 star 3 - STELE 36 18 wedding 70 53 30 0 0   55 0 64.0 SBZ 23.1 0.3 68 Com. Arefu, Sat Arefu ARGEŞ   45.3355809 24.5996176 20.08.2021   RO-SITUR HOTEL 3 - STELE 1663/819
16449 16449 PISCUL NEGRU RO stay hotels hotel normal 3 star 3 - STELE 108 54 wedding 80 73 50 0 0   45 40 47.5 SBZ 39.4 18.1 8 Com. Arefu, Sat Arefu ARGEŞ   45.5546062990405 24.6008747219513 12.02.2026   RO-SITUR HOTEL 3 - STELE 13000
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
16453 16453 SIESTA RO stay hotels hotel normal 3 star 3 - STELE 35 18 wedding 70 53 30 0 0   55 0 65.7 SBZ 22.1 1.0 89 Com. Arefu, Sat Arefu ARGEŞ   45.329334248848 24.6216094482299 18.10.2011   RO-SITUR HOTEL 3 - STELE 8076/7796
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
16500 16500 NET RO stay hotels hotel normal 3 star 3 - STELE 28 15 wedding 60 53 30 0 0   50 0 97.4 CRA 5.8 0.8 64 Com. Bascov, Sat Bascov ARGEŞ   44.8902101 24.8195596 14.12.2016   RO-SITUR HOTEL 3 - STELE 30424
16502 16502 SORELO RO stay hotels hotel normal 3 star 3 - STELE 54 27 wedding 70 63 40 0 0   50 0 97.5 CRA 5.6 0.6 76 Com. Bascov, Sat Bascov ARGEŞ NR. 7 44.8892515 24.8230993 11.08.2010   RO-SITUR HOTEL 3 - STELE 10933/7003
16506 16506 SORELO RO stay hotels hotel normal 1 star 1 - STELE 36 18 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 11.08.2010   RO-SITUR HOTEL 1 - STELE 7010/5052
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
16741 16741 MAGIC TRAVALE RO stay hotels hotel normal 3 star 3 - STELE 38 19 wedding 70 53 30 0 0   50 0 96.3 CRA 1.3 1.3 143 Com. Moşoaia, Sat Smeura ARGEŞ   44.8480956 24.8502118 27.04.2011   RO-SITUR HOTEL 3 - STELE 11933/7586
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
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
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
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
16946 16946 THR CENTER RO stay hotels hotel normal 3 star 3 - STELE 32 16 wedding 70 53 30 0 0   50 0 85.0 SBZ 1.0 1.0 72 Mun. Curtea de Argeş ARGEŞ STR. Bulevardul Basarabilor , NR. 125 45.1426903 24.6762267 27.10.2020   RO-SITUR HOTEL 3 - STELE 21921
16954 16954 ARGES RO stay hotels hotel normal 3 star 3 - STELE 92 46 wedding 80 73 50 0 0   50 0 98.3 CRA 0.9 0.9 142 Mun. Piteşti ARGEŞ STR. Piaţa Muntenia , NR. 3 44.856343 24.8733322 22.11.2010   RO-SITUR HOTEL 3 - STELE 779/334
16965 16965 CARMEN RO stay hotels hotel normal 3 star 3 - STELE 46 21 wedding 70 63 40 0 0   50 0 98.2 CRA 0.8 0.8 142 Mun. Piteşti ARGEŞ STR. Bulevardul Republicii , NR. 84 44.8563696 24.8717678 14.04.2021   RO-SITUR HOTEL 3 - STELE 6662/4054
16968 16968 CELLY RO stay hotels hotel normal 3 star 3 - STELE 64 32 wedding 70 63 40 0 0   50 10 99.6 CRA 2.2 2.2 136 Mun. Piteşti ARGEŞ   44.8582938 24.8915751 13.08.2009   RO-SITUR HOTEL 3 - STELE 9636/6241
16970 16970 COMPLEX HOTELIER ALCADIBO CENTER RO stay hotels hotel normal 3 star 3 - STELE 72 36 wedding 70 63 40 0 0   50 0 98.4 CRA 1.0 1.0 142 Mun. Piteşti ARGEŞ NR. 70 44.8578413 24.8732255 26.10.2011   RO-SITUR HOTEL 3 - STELE 8303/5545
16976 16976 CORNUL VÂNĂTORULUI BUSINESS CLASS RO stay hotels hotel normal 3 star 3 - STELE 76 50 wedding 70 63 40 0 0   50 10 95.8 CRA 2.4 2.2 152 Mun. Piteşti ARGEŞ STR. Strada Trivale , NR. 75 44.8539111 24.8360768 12.08.2010   RO-SITUR HOTEL 3 - STELE 15653/7021
16983 16983 DUET RO stay hotels hotel normal 3 star 3 - STELE 28 16 wedding 60 53 30 0 0   50 0 97.8 CRA 0.6 0.6 143 Mun. Piteşti ARGEŞ STR. Intrarea Rahovei , NR. 27 44.8555653 24.8660965 17.09.2010   RO-SITUR HOTEL 3 - STELE 10932/7079
16994 16994 HONOR RO stay hotels hotel normal 3 star 3 - STELE 44 22 wedding 70 63 40 0 0   50 10 98.2 CRA 2.4 2.4 152 Mun. Piteşti ARGEŞ STR. Aleea Negoiul , NR. 2 44.8704409 24.856133 21.09.2017   RO-SITUR HOTEL 3 - STELE 13236
17007 17007 MAGIC RO stay hotels hotel normal 3 star 3 - STELE 30 15 wedding 70 53 30 0 0   50 0 98.1 CRA 0.8 0.8 142 Mun. Piteşti ARGEŞ STR. Strada Armand Călinescu , NR. 16 44.857444 24.8689782 22.11.2010   RO-SITUR HOTEL 3 - STELE 6374/5149
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
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
17021 17021 REGAT RO stay hotels hotel normal 3 star 3 - STELE 29 15 wedding 60 53 30 0 0   50 0 98.2 CRA 1.2 1.2 150 Mun. Piteşti ARGEŞ STR. Bulevardul Republicii , NR. 7 44.8608188 24.8662856 19.10.2011   RO-SITUR HOTEL 3 - STELE 9084/5783
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
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
17041 17041 YAKY CENTER RO stay hotels hotel normal 3 star 3 - STELE 90 45 wedding 80 73 50 0 0   50 0 98.3 CRA 0.8 0.8 142 Mun. Piteşti ARGEŞ STR. Bulevardul Republicii , NR. 57 44.8559049 24.8731618 12.06.2012   RO-SITUR HOTEL 3 - STELE 12748/8763
17045 17045 GRANDIS APULUM RO stay hotels hotel normal 3 star 3 - STELE 50 25 wedding 70 63 40 0 0   50 10 96.0 GHV 1.6 1.6 16 Oraş Mioveni, Loc. Mioveni ARGEŞ NR. 144 44.9507843 24.9255937 25.05.2010   RO-SITUR HOTEL 3 - STELE 13458
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
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

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