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

38,854 rows where country = "RO"

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_scheme, fit_wedding, fit_conference, fit_banquet, fit_spa, fit_party, reachability_score, isolation_score, nearest_airport

family 12

rating_value 5

  • 3 24,457
  • 2 8,284
  • 1 3,303
  • 4 2,446
  • 5 353

best_for 3

group 2

country 1

  • RO · 38,854 ✖

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
15414 15414 AMAZONIS RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 6.6 BBU 1.3 1.3 2032       44.4438245 26.1106396 08.07.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 25226
15415 15415 AP RO stay self_catering_villas self_catering normal   none -       35 0 0 0 0   70 20 23.3 BBU 15.3 0.4 4       44.4373431072117 25.82369359375     RO-SITUR APARTAMENTE DE ÎNCHIRIAT - 32829
15416 15416 ATLAS RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 6.6 BBU 1.3 1.3 2032       44.4438245 26.1106396 08.07.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 25225
15417 15417 OLYMPOS RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 6.8 BBU 1.1 1.1 2030       44.4422562 26.1094982 08.07.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 25224
15418 15418 POIANA SAŞILOR RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 18 9   45 0 0 0 0   55 30 38.5 GHV 24.0 8.0 17       45.4048717 25.7678849     RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33091
15419 15419 PROMENADA ALEZZI APARTMENTS 1 RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 12.9 CND 2.7 1.1 2546       44.3013829 28.6261686     RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 23683
15420 15420 VIORICA RO stay self_catering_villas villa normal 3 star 3 - STELE       45 0 0 0 0   55 40 47.2 GHV 11.3 6.3 5       45.9446232442542 25.0201466882324     RO-SITUR VILĂ TURISTICĂ 3 - STELE 21973
15421 15421 SEAESTA MAMAIA NORD POOL AND SPA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   80 0 7.0 CRA 0.1 0.1 225     NR. 6G , ET. P , AP. 17 44.3174024 23.8000483 26.08.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 43724
15422 15422 LA BĂLCEŞTI RO stay camping chalet_bungalow_hut normal 1 star 1 - STELE 10 3   35 0 0 0 0   45 10 53.7 CLJ 46.8 3.6 50 Beliş ALBA NR. 39 46.6739964 23.0007088 05.09.2022   RO-SITUR BUNGALOURI 1 - STELE 32099
15423 15423 LA BĂLCEŞTI RO stay camping camping normal 1 star 1 - STELE 8 2   35 0 0 0 0   45 10 54.1 CLJ 47.3 4.2 50 Beliş ALBA NR. 39 46.6761017696198 22.9937565142334 05.09.2022   RO-SITUR CAMPING 1 - STELE 32100
15424 15424 CASA LAVINIA RO stay self_catering_villas self_catering normal 1 star 1 - STELE 8 1   35 0 0 0 0   55 20 46.1 Câmpia Turzii Air Base 10.1 2.2 11 Com Arieseni Sat Galbena ALBA STR. Principala , NR. 421 A 46.1558924 23.5556121 17.07.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 1 - STELE 38953
15425 15425 ARMONIA RO stay rural rural_agritourism normal 3 flower 3 - FLORI 12 6   45 0 0 0 0   45 0 66.7 CLJ 37.8 0.9 30 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 20 46.4496251 22.9620368 31.10.2022   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 32564
15426 15426 CASA CRISTALINA & DUMI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 16 7   45 0 0 0 0   45 0 67.0 CLJ 37.9 0.2 30 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 74 46.4529317 22.9546794 21.10.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 21746
15427 15427 CASA DIN PARC RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   55 10 67.9 Câmpia Turzii Air Base 26.8 0.4 13 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 60C 46.2775979 23.06286 23.03.2026   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 46227
15428 15428 CASUȚA DE LA MUNTE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   45 10 66.4 Câmpia Turzii Air Base 32.4 0.7 17 Com. Albac, Sat Albac ALBA STR. Strada Horea , NR. 55A 46.3624812 23.0436858 11.02.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 45639
15429 15429 CERBUL APUSEAN RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 10 5   35 0 0 0 0   45 0 66.7 CLJ 37.8 0.9 30 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 27 46.4499706 22.9621576 17.10.2013   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 27334
15430 15430 CERNAT RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 4   45 0 0 0 0   45 0 66.9 CLJ 37.1 1.7 30 Com. Albac, Sat Albac ALBA STR. Strada Cloşca , NR. 41 46.4417768 22.9669298 22.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33249
15431 15431 DAIANA RO stay rural rural_agritourism normal 2 flower 2 - FLORI 14 6   35 0 0 0 0   45 0 66.8 CLJ 38.0 0.5 30 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 41 46.4526584 22.9584958 21.09.2011   RO-SITUR PENSIUNE AGROTURISTICĂ 2 - FLORI 15789
15432 15432 FELYVISS RO stay rural rural_agritourism normal 3 flower 3 - FLORI 10 4   45 0 0 0 0   45 0 66.8 CLJ 37.5 1.1 31 Com. Albac, Sat Albac ALBA NR. 37 46.447039 22.964202 29.03.2011   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 5366/7467
15433 15433 GAYU RO stay guesthouses guesthouse normal 2 flower 2 - FLORI 13 6   35 0 0 0 0   45 0 66.6 CLJ 37.8 1.1 30 Com. Albac, Sat Albac ALBA STR. Strada Horea , NR. 16 46.4488841 22.9653161 27.11.2023   RO-SITUR PENSIUNE TURISTICĂ 2 - FLORI 31371
15434 15434 JIANU RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 14 7   35 0 0 0 0   45 0 66.6 CLJ 37.6 1.3 30 Com. Albac, Sat Albac ALBA STR. Strada Cloşca , NR. 19 46.4473631 22.9664262 08.02.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 31300
15435 15435 MERY RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 10 5   45 0 0 0 0   45 0 66.6 CLJ 37.8 1.1 30 Com. Albac, Sat Albac ALBA STR. Strada Horea , NR. 27 46.4488841 22.9653161 17.08.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 8511/5885
15436 15436 STEAUA ARIEŞULUI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 52 26 wedding 55 0 0 0 0   45 0 67.0 CLJ 37.9 0.2 30 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 60 46.452808 22.954159 02.02.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 10155/6236
15437 15437 VILLA RUSTICĂ RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 10 5   35 0 0 0 0   45 0 66.8 CLJ 37.9 0.6 30 Com. Albac, Sat Albac ALBA STR. Strada Crişan , NR. 36 46.4518695 22.9590759 15.03.2011   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 5114/3344
15438 15438 CASA BRĂDEANĂ RO stay rural rural_agritourism normal 3 flower 3 - FLORI 12 6   45 0 0 0 0   45 10 64.0 CLJ 39.7 3.5 28 Com. Albac, Sat Bărăşti ALBA NR. 1A 46.458313 22.9970461 28.10.2019   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 20663
15439 15439 CASA MARIA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   45 0 65.8 CLJ 38.4 1.8 29 Com. Albac, Sat Cioneşti ALBA NR. 8 46.4517887 22.9755255 27.11.2015   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 29206
15440 15440 POIANA VERDE RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 30 15 wedding 65 0 0 0 0   45 0 65.8 CLJ 38.4 1.8 29 Com. Albac, Sat Cioneşti ALBA   46.4517887 22.9755255 02.08.2011   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 8280/5597
15441 15441 CLA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 7   45 0 0 0 0   45 10 63.1 CLJ 42.1 3.1 35 Com. Albac, Sat Dealu Lămăşoi ALBA NR. 8 46.4858618 22.9836361 28.05.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 42780
15442 15442 ADY RO stay rural rural_agritourism normal 2 flower 2 - FLORI 10 4   35 0 0 0 0   45 0 66.1 CLJ 39.1 1.3 40 Com. Albac, Sat Faţă ALBA NR. 13 46.4627467 22.9596548 28.03.2011   RO-SITUR PENSIUNE AGROTURISTICĂ 2 - FLORI 8521/7464
15443 15443 ARDEALUL RO stay rural rural_agritourism normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   45 0 66.1 CLJ 39.1 1.3 40 Com. Albac, Sat Faţă ALBA NR. 8 46.4627467 22.9596548 28.02.2023   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 33716
15444 15444 CASA MATIAS RO stay self_catering_villas self_catering normal 2 star 2 - STELE 5 1   35 0 0 0 0   45 0 66.1 CLJ 39.1 1.3 40 Com. Albac, Sat Faţă ALBA NR. 50A 46.4627467 22.9596548 27.05.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 2 - STELE 42760
15445 15445 CHEILE ALBACULUI RO stay rural rural_agritourism normal 3 flower 3 - FLORI 15 8   45 0 0 0 0   45 0 67.9 CLJ 37.8 1.2 35 Com. Albac, Sat Faţă ALBA NR. 1 46.4559688 22.9371365 05.11.2020   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 5169/3404
15446 15446 POIENIŢA RO stay rural rural_agritourism normal 3 flower 3 - FLORI 12 6   45 0 0 0 0   45 0 67.3 CLJ 37.7 0.1 30 Com. Albac, Sat Faţă ALBA NR. 13 46.4525884 22.9502512 20.01.2016   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 29407
15447 15447 POIENIŢA APUSENILOR RO stay rural rural_agritourism normal 3 flower 3 - FLORI 16 6   45 0 0 0 0   45 0 67.3 CLJ 37.7 0.1 30 Com. Albac, Sat Faţă ALBA NR. 13 46.4525884 22.9502512 28.09.2020   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 21285
15448 15448 TULNICUL MUNŢILOR RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 16 8   35 0 0 0 0   45 0 66.3 CLJ 38.3 0.9 30 Com. Albac, Sat Faţă ALBA NR. 64 46.4546719 22.9634386 07.03.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 31367
15449 15449 DANCIU RO stay guesthouses guesthouse normal 2 flower 2 - FLORI 14 6   35 0 0 0 0   45 0 68.3 CLJ 36.9 1.1 30 Com. Albac, Sat Pleşeşti ALBA NR. 8 46.4469616 22.9399791 09.12.2021   RO-SITUR PENSIUNE TURISTICĂ 2 - FLORI 14521
15450 15450 PERLA APUSENILOR RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 98 49 wedding 65 0 0 0 0   45 0 68.3 CLJ 36.9 1.1 30 Com. Albac, Sat Pleşeşti ALBA NR. 30A 46.4469616 22.9399791 26.05.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 23173
15451 15451 ANDRA RO stay rural rural_agritourism normal 2 flower 2 - FLORI 12 6   35 0 0 0 0   45 10 68.2 CLJ 35.5 2.8 35 Com. Albac, Sat Rogoz ALBA NR. 5 46.4282075 22.9613178 19.07.2011   RO-SITUR PENSIUNE AGROTURISTICĂ 2 - FLORI 15167
15452 15452 LA TOPIVAN RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 20 10   45 0 0 0 0   45 10 68.2 CLJ 35.5 2.8 35 Com. Albac, Sat Rogoz ALBA NR. 1A 46.4282075 22.9613178 07.07.2015   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 11556/8098
15453 15453 WELNESS SPA REGAL CHEF DECEBAL RO stay rural rural_agritourism normal 3 flower 3 - FLORI 12 6   45 0 0 0 0   55 20 73.4 Câmpia Turzii Air Base 25.8 0.1 1 Com. Almaşu Mare, Sat Almaşu Mare ALBA NR. 214 46.1106669 23.1163988 08.12.2021   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 24186
15454 15454 CASA DAVID RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   55 40 73.0 Câmpia Turzii Air Base 24.6 6.2 3 Com. Almaşu Mare, Sat Cib ALBA NR. 160 46.0543933 23.1913833 13.11.2017   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 12663/2664
15455 15455 CHEILE CIBULUI RO stay rural rural_agritourism normal 3 flower 3 - FLORI 8 4   45 0 0 0 0   55 40 73.0 Câmpia Turzii Air Base 24.6 6.2 3 Com. Almaşu Mare, Sat Cib ALBA NR. 66A 46.0543933 23.1913833 23.06.2016   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 29949
15456 15456 CASA GLOD RO stay guesthouses rooms_to_rent normal 1 star 1 - STELE 10 5   35 0 0 0 0   55 30 74.6 Câmpia Turzii Air Base 25.3 4.2 3 Com. Almaşu Mare, Sat Glod ALBA NR. 44 46.0592227 23.1570476 05.09.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 1 - STELE 35996
15457 15457 BIANCA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 16 6   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 483/A 46.4767851 22.7543707 28.03.2011   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 9704/7454
15458 15458 CASA ALINA RO stay rural rural_agritourism normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   45 0 79.1 CLJ 38.5 0.5 91 Com. Arieşeni, Sat Arieşeni ALBA NR. 28A 46.4791118 22.7517253 24.08.2018   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 13751
15459 15459 CASA AURORA II RO stay guesthouses rooms_to_rent normal 1 star 1 - STELE 6 2   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 26E 46.4767851 22.7543707 19.04.2016   RO-SITUR CAMERE DE ÎNCHIRIAT 1 - STELE 29807
15460 15460 CASA BINU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   45 0 79.2 CLJ 38.3 0.5 92 Com. Arieşeni, Sat Arieşeni ALBA NR. 17 46.4766597 22.7512398 28.10.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20659
15461 15461 CASA DĂNUTZA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 10 5   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 33C 46.4767851 22.7543707 07.05.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 19730
15462 15462 CASA DE VIS RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   45 0 78.6 CLJ 38.0 0.4 99 Com. Arieşeni, Sat Arieşeni ALBA   46.4747681 22.7616423 16.04.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19599
15463 15463 CASA DOBRA RO stay guesthouses rooms_to_rent normal 1 star 1 - STELE 9 3   35 0 0 0 0   45 0 79.3 CLJ 38.3 0.6 91 Com. Arieşeni, Sat Arieşeni ALBA NR. 31A 46.4765625 22.7496509 14.04.2011   RO-SITUR CAMERE DE ÎNCHIRIAT 1 - STELE 14206
15464 15464 CASA DOBRA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 16 6   35 0 0 0 0   45 0 79.3 CLJ 38.3 0.6 91 Com. Arieşeni, Sat Arieşeni ALBA NR. 31A 46.4765625 22.7496509 26.09.2014   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 14206/8927
15465 15465 CASA DORY & DAN RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 16 8   35 0 0 0 0   45 0 79.0 CLJ 39.0 1.0 88 Com. Arieşeni, Sat Arieşeni ALBA NR. 33B 46.4836654 22.7493152 18.04.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 18583
15466 15466 CASA MED 2 RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 16 8   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 25 /C 46.4767851 22.7543707 05.08.2015   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 28667
15467 15467 CASA MOTULUI RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 25 13 wedding 55 0 0 0 0   30 0 80.4 CLJ 38.7 1.9 86 Com. Arieşeni, Sat Arieşeni ALBA NR. 468A 46.4795259 22.7324206 19.01.2011   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 13821
15468 15468 CASA NEAG RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 28 14   35 0 0 0 0   45 0 79.0 CLJ 38.7 0.7 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 26D 46.4806509 22.7510367 14.09.2016   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 30120
15469 15469 CASA TUDOR RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 11 5   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 25 B 46.4767851 22.7543707 05.08.2015   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 28668
15470 15470 DIANA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 10 5   35 0 0 0 0   30 10 81.4 CLJ 40.7 4.4 99 Com. Arieşeni, Sat Arieşeni ALBA NR. 31/B 46.4951561 22.7067816 28.03.2011   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 14075
15471 15471 GIANINA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 20 10   45 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 31A 46.4767851 22.7543707 05.10.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 12211/8100
15472 15472 LA VASILE RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 29 15   45 0 0 0 0   45 0 78.9 CLJ 38.2 0.1 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 16 46.476397 22.7559676 22.05.2012   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 12229/8584
15473 15473 MOARA TITULUI RO stay self_catering_villas self_catering normal 3 star 3 - STELE 9 2   45 0 0 0 0   45 0 78.6 CLJ 37.9 0.5 100 Com. Arieşeni, Sat Arieşeni ALBA NR. 1F 46.4739594 22.7624819 02.11.2021   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 27179
15474 15474 SARRA VANK RO stay guesthouses guesthouse normal 3 star 3 - STELE 24 12   45 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 29A 46.4767851 22.7543707 01.08.2012   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 12359/8864
15475 15475 SIMONA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 12 6   45 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 3F 46.4767851 22.7543707 15.04.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 10135/7549
15476 15476 SKY HUB RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 24 12   45 0 0 0 0   45 10 78.1 CLJ 36.6 2.2 103 Com. Arieşeni, Sat Arieşeni ALBA NR. 352B 46.4625566 22.7776309 02.08.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 10082/5379
15477 15477 SPERANŢA RO stay guesthouses guesthouse normal 2 flower 2 - FLORI 18 9   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 26 A 46.4767851 22.7543707 20.05.2022   RO-SITUR PENSIUNE TURISTICĂ 2 - FLORI 27051
15478 15478 TREI BRAZI RO stay rural rural_agritourism normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   45 0 79.0 CLJ 38.4 0.4 93 Com. Arieşeni, Sat Arieşeni ALBA NR. 24 46.4780286 22.7526867 18.08.2023   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 35713
15479 15479 VALEA BRAZILOR RO stay guesthouses guesthouse normal 3 flower 3 - MARGARETE 14 8   45 0 0 0 0   45 0 79.5 CLJ 38.2 0.8 90 Com. Arieşeni, Sat Arieşeni ALBA NR. 33A 46.476431 22.747297 15.04.2024   RO-SITUR PENSIUNE TURISTICĂ 3 - MARGARETE 25742
15480 15480 VANESA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   30 0 80.0 CLJ 38.3 1.4 85 Com. Arieşeni, Sat Arieşeni ALBA NR. 57 46.4762351 22.7396601 14.02.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 31312
15481 15481 VANESA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   30 0 80.0 CLJ 38.3 1.4 85 Com. Arieşeni, Sat Arieşeni ALBA NR. 57 46.4762351 22.7396601 03.01.2017   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 30491
15482 15482 VANK RO stay self_catering_villas villa normal 2 star 2 - STELE 50 15   45 0 0 0 0   45 0 79.3 CLJ 38.3 0.6 91 Com. Arieşeni, Sat Arieşeni ALBA NR. 29A 46.4766179 22.7499137 19.01.2012   RO-SITUR VILĂ TURISTICĂ 2 - STELE 8570/5872
15483 15483 VIORICA RO stay guesthouses guesthouse normal 2 flower 2 - FLORI 18 8   35 0 0 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni, Sat Arieşeni ALBA NR. 28 46.4767851 22.7543707 12.05.2011   RO-SITUR PENSIUNE TURISTICĂ 2 - FLORI 8530/7639
15484 15484 ANDREEA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   30 20 81.5 CLJ 42.0 5.6 69 Com. Arieşeni, Sat Bubeşti ALBA   46.506757 22.698283 21.09.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 15787
15485 15485 ANDREEA - MARIA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 18 10   45 0 0 0 0   30 10 81.3 CLJ 41.1 4.7 97 Com. Arieşeni, Sat Bubeşti ALBA   46.4994983 22.7065417 08.02.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 31302
15486 15486 APUSENI RO stay self_catering_villas villa normal 3 star 3 - STELE 30 14 wedding 55 0 0 0 0   45 40 73.0 CLJ 52.9 14.7 12 Com. Arieşeni, Sat Bubeşti ALBA NR. 87 46.6084985 22.7642009 04.08.2011   RO-SITUR VILĂ TURISTICĂ 3 - STELE 11517/7771
15487 15487 ARNICA MONTANĂ RO stay rural rural_agritourism normal 3 flower 3 - FLORI 10 5   45 0 0 0 0   30 20 81.2 CLJ 41.9 5.3 79 Com. Arieşeni, Sat Bubeşti ALBA NR. 70A 46.5056923 22.7032471 20.01.2016   RO-SITUR PENSIUNE AGROTURISTICĂ 3 - FLORI 29406
15488 15488 CASA GYL RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 8 4   45 0 0 0 0   30 10 81.3 CLJ 41.1 4.7 97 Com. Arieşeni, Sat Bubeşti ALBA NR. 68 46.4994983 22.7065417 12.05.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 24773
15489 15489 COTA 1000 RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   30 20 81.4 CLJ 41.4 5.0 96 Com. Arieşeni, Sat Bubeşti ALBA NR. 80 A 46.5015959 22.7032457 28.09.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 30231
15490 15490 DIANA ŞI LARISA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   65 0 52.5 SBZ 2.6 1.9 167 Com. Arieşeni, Sat Bubeşti ALBA NR. 81/C 46.0852098 23.5617656 05.08.2015   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 28669
15491 15491 POARTA ARIEŞULUI RO stay guesthouses guesthouse normal 2 flower 2 - MARGARETE 16 8   35 0 0 0 0   30 20 81.5 CLJ 42.0 5.6 71 Com. Arieşeni, Sat Bubeşti ALBA NR. 75 C 46.5063128 22.6991864 18.04.2012   RO-SITUR PENSIUNE TURISTICĂ 2 - MARGARETE 17239
15492 15492 RODICA RO stay guesthouses rooms_to_rent normal 1 star 1 - STELE 18 9   35 0 0 0 0   30 10 81.3 CLJ 41.1 4.7 97 Com. Arieşeni, Sat Bubeşti ALBA NR. 70 46.4994983 22.7065417 24.09.2014   RO-SITUR CAMERE DE ÎNCHIRIAT 1 - STELE 18585
15493 15493 VALEA ARIEŞULUI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   30 20 81.5 CLJ 42.0 5.6 70 Com. Arieşeni, Sat Bubeşti ALBA NR. 75H 46.5063228 22.6986572 27.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33351
15494 15494 VARTOP RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 46 23   45 0 0 0 0   30 10 81.3 CLJ 41.1 4.7 97 Com. Arieşeni, Sat Bubeşti ALBA NR. 88A 46.4994983 22.7065417 18.04.2011   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 5613/3760
15495 15495 VRAJA MUNTELUI RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 27 12   45 0 0 0 0   30 20 81.2 CLJ 41.8 5.2 93 Com. Arieşeni, Sat Bubeşti ALBA NR. 76A 46.5051118 22.7036806 05.05.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 10530/7411
15496 15496 CASA DE PIATRĂ RO stay rural rural_agritourism normal 2 flower 2 - FLORI 10 4   35 0 0 0 0   45 50 74.2 CLJ 44.8 7.0 0 Com. Arieşeni, Sat Casa de Piatra ALBA NR. 100 46.536498 22.7839625 08.09.2020   RO-SITUR PENSIUNE AGROTURISTICĂ 2 - FLORI 27471
15497 15497 POPASUL VÂNĂTORILOR RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 12 6   35 0 0 0 0   45 10 79.5 CLJ 40.7 3.1 95 Com. Arieşeni, Sat Cobleş ALBA NR. 183 A 46.4981084 22.7328724 24.11.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 22348
15498 15498 CASA DEEA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 16 7   35 0 0 0 0   45 10 78.4 CLJ 36.1 2.6 102 Com. Arieşeni, Sat Dealu Bajului ALBA NR. 224 46.4576436 22.7780022 31.08.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 20706
15499 15499 CASA DENISA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   45 10 78.4 CLJ 36.1 2.6 102 Com. Arieşeni, Sat Dealu Bajului ALBA NR. 252 46.4576436 22.7780022 08.02.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 31301
15500 15500 CASA GEORGIANA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 11 5   35 0 0 0 0   45 10 78.4 CLJ 36.1 2.6 102 Com. Arieşeni, Sat Dealu Bajului ALBA NR. 245 46.4576436 22.7780022 22.10.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 44588
15501 15501 CASA PATRICIA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   45 10 78.4 CLJ 36.1 2.6 102 Com. Arieşeni, Sat Dealu Bajului ALBA NR. 229 46.4576436 22.7780022 30.10.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20680
15502 15502 CASA STAN RO stay guesthouses rooms_to_rent normal 1 star 1 - STELE 12 6   35 0 0 0 0   45 10 78.4 CLJ 36.1 2.6 102 Com. Arieşeni, Sat Dealu Bajului ALBA NR. 243A 46.4576436 22.7780022 05.09.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 1 - STELE 32097
15503 15503 CASA ALINA ŞI ANDREEA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 10 6   35 0 0 0 0   45 0 78.9 CLJ 39.3 1.2 88 Com. Arieşeni, Sat Faţa Cristesei ALBA NR. 296A 46.4855826 22.7496184 01.11.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 24014
15504 15504 CASA CERBU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 5   45 0 0 0 0   45 0 78.9 CLJ 39.3 1.2 88 Com. Arieşeni, Sat Faţa Cristesei ALBA NR. 315 46.4855826 22.7496184 27.10.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 21887
15505 15505 CASA DAN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 20 10   45 0 0 0 0   45 0 78.9 CLJ 39.3 1.2 88 Com. Arieşeni, Sat Faţa Cristesei ALBA NR. 288 46.4855826 22.7496184 18.04.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19660
15506 15506 PANTURISM RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 18 9   45 0 0 0 0   45 0 78.9 CLJ 39.3 1.2 88 Com. Arieşeni, Sat Faţa Cristesei ALBA NR. 264A 46.4855826 22.7496184 27.10.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 28434
15507 15507 SOFY RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 20 10   45 0 0 0 0   45 0 78.9 CLJ 39.3 1.2 88 Com. Arieşeni, Sat Faţa Cristesei ALBA NR. 288A 46.4855826 22.7496184 08.07.2015   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 28435
15508 15508 CASA PARCUL APUSENI RO stay camping camping normal 3 star 3 - STELE 4 2   45 0 0 0 0   45 0 78.5 CLJ 37.1 1.4 104 Com. Arieşeni, Sat Faţa Lăpuşului ALBA NR. 345 46.4666561 22.7682126 30.10.2019   RO-SITUR CĂSUȚE TIP CAMPING 3 - STELE 20676
15509 15509 MARIA RO stay guesthouses guesthouse normal 2 flower 2 - FLORI 10 5   35 0 0 0 0   45 0 78.5 CLJ 37.1 1.4 104 Com. Arieşeni, Sat Faţa Lăpuşului ALBA NR. 352A 46.4666561 22.7682126 29.03.2011   RO-SITUR PENSIUNE TURISTICĂ 2 - FLORI 8527/7469
15510 15510 ARION RO stay guesthouses rooms_to_rent normal 1 star 1 - STELE 10 5   35 0 0 0 0   30 0 80.3 CLJ 38.4 1.7 86 Com. Arieşeni, Sat Galbena ALBA NR. 382/B 46.47745 22.7346816 06.06.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 1 - STELE 18581
15511 15511 CASA COSMINA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 9 6   45 0 0 0 0   30 10 81.0 CLJ 37.0 2.2 78 Com. Arieşeni, Sat Galbena ALBA NR. 424 46.4640273 22.7349567 01.02.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 22691
15512 15512 CASA DINTRE BRAZI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   30 0 80.4 CLJ 37.6 1.6 84 Com. Arieşeni, Sat Galbena ALBA NR. 414A 46.4703003 22.7378854 19.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33136
15513 15513 CASA DORINA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 10 5   35 0 0 0 0   30 0 80.3 CLJ 37.9 1.5 85 Com. Arieşeni, Sat Galbena ALBA NR. 413 46.4727049 22.7381593 18.04.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 14027

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