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

10,603 rows where country = "RO", family = "guesthouses" and rating_value = 3

This data as json, CSV (advanced)

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

rating_value 1

  • 3 · 10,603 ✖

group 1

family 1

  • guesthouses · 10,603 ✖

country 1

  • RO · 10,603 ✖

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
15514 15514 CASA MONA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 6   45 0 0 0 0   30 0 80.4 CLJ 38.4 1.8 86 Com. Arieşeni, Sat Galbena ALBA NR. 383 46.4773408 22.7340672 30.10.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20672
15516 15516 CASA NICO NELU DUPLEX RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 1   45 0 0 0 0   30 0 80.4 CLJ 37.6 1.6 83 Com. Arieşeni, Sat Galbena ALBA NR. 426B 46.4700756 22.7379715 21.09.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 36126
15518 15518 CASA RALUCA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 16 8   45 0 0 0 0   30 10 80.9 CLJ 37.8 2.2 85 Com. Arieşeni, Sat Galbena ALBA NR. 392 46.4711678 22.7300433 24.10.2024   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20652
15521 15521 IARA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 14 7   45 0 0 0 0   45 0 79.0 CLJ 38.3 0.3 94 Com. Arieşeni, Sat Galbena ALBA   46.4767818 22.7535599 27.09.2018   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 11446/8496
15522 15522 MONTANA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 12 6   45 0 0 0 0   30 10 80.9 CLJ 37.8 2.2 85 Com. Arieşeni, Sat Galbena ALBA NR. 424/A 46.4711678 22.7300433 12.04.2016   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 29792
15524 15524 VALEA GALBENEI RO stay guesthouses guesthouse normal 3 flower 3 - MARGARETE 16 8   45 0 0 0 0   30 10 80.9 CLJ 37.8 2.2 85 Com. Arieşeni, Sat Galbena ALBA NR. 397 46.4711678 22.7300433 31.10.2022   RO-SITUR PENSIUNE TURISTICĂ 3 - MARGARETE 28831
15525 15525 ZÂNA VĂII RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 32 15 wedding 55 0 0 0 0   30 10 80.9 CLJ 37.0 2.1 80 Com. Arieşeni, Sat Galbena ALBA NR. 424B 46.4641267 22.7362814 11.11.2015   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 12357
15528 15528 CASA NATALIA & RAISA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 13 6   45 0 0 0 0   30 10 81.0 CLJ 39.2 2.8 86 Com. Arieşeni, Sat Izlaz ALBA NR. 477 46.4829998 22.7214604 18.04.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19661
15535 15535 CASA EMILIA ARIEŞENI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 5   45 0 0 0 0   45 0 77.5 CLJ 38.1 1.5 104 Com. Arieşeni, Sat Pănteşti ALBA NR. 534/A 46.4758141 22.7773594 08.12.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 24184
15536 15536 WILD ARIESENI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 0 79.7 CLJ 37.4 1.0 88 Com. Arieşeni, Sat Ştei-Arieşeni ALBA NR. 624 46.4688338 22.7502658 21.09.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 36123
15542 15542 POIENIŢA MOŢILOR RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 7   45 0 0 0 0   40 10 81.8 CLJ 27.6 0.6 8 Com. Avram Iancu, Sat Orgeşti ALBA NR. 587 46.3819071 22.7909331 14.03.2022   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 24535
15551 15551 CASA MOŢILOR RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 8 3   45 0 0 0 0   55 20 64.5 Câmpia Turzii Air Base 29.6 4.4 16 Com. Bucium, Sat Bucium ALBA NR. 43 46.2615626 23.1209891 01.10.2020   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 29789
15552 15552 LA MĂTUŞA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 5   45 0 0 0 0   55 20 64.5 Câmpia Turzii Air Base 29.6 4.4 16 Com. Bucium, Sat Bucium ALBA NR. 23 46.2615626 23.1209891 19.10.2016   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 30242
15556 15556 GIULIA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 11 4   45 0 0 0 0   45 20 64.0 Câmpia Turzii Air Base 30.1 3.7 13 Com. Bucium, Sat Izbita ALBA NR. 368 46.2435463 23.1403548 30.01.2014   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 27613
15562 15562 CĂSUȚA CU BRAZI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 46.7 SBZ 3.5 0.1 127 Com. Ciugud, Sat Şeuşa ALBA STR. Strada Ioan Oprean , NR. 120 46.0591563 23.6274676 04.08.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 43471
15584 15584 ANA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 18 9   45 0 0 0 0   70 40 24.2 Câmpia Turzii Air Base 16.9 3.0 0 Com. Fărău, Sat Sânbenedic ALBA NR. 5 46.3149463 24.0459518 05.04.2016   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 29758
15597 15597 CASA BUNĂ RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 28 12   45 0 0 0 0   55 20 33.2 SBZ 12.9 2.1 7 Com. Gârbova, Sat Reciu ALBA   45.8650605 23.674016 04.12.2018   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 13162
15599 15599 CĂPRIOARA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 13 5   45 0 0 0 0   45 0 76.2 CLJ 35.8 0.5 46 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 97 E 46.45434 22.8133413 08.08.2018   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 17807
15600 15600 CASA ALEX RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 15 8   45 0 0 0 0   45 0 74.0 CLJ 37.7 1.4 44 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 130A 46.4708063 22.8321845 28.10.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20658
15602 15602 CASA EDMA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 5   45 0 0 0 0   45 10 75.0 CLJ 37.6 2.3 62 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 142 46.471007 22.8168923 09.08.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 17822
15604 15604 CASA IULY RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 8   45 0 0 0 0   45 0 76.5 CLJ 36.0 1.1 69 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 96A 46.4567265 22.80613 01.09.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20732
15605 15605 CASA IUNIA RO stay guesthouses guesthouse normal 3 flower 3 - MARGARETE 16 7   45 0 0 0 0   45 0 76.3 CLJ 36.0 0.9 62 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 94A 46.4563788 22.8102461 26.04.2021   RO-SITUR PENSIUNE TURISTICĂ 3 - MARGARETE 23042
15606 15606 CASA NEGOIESCU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 16 8   45 0 0 0 0   45 0 76.8 CLJ 36.1 1.5 79 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 101C 46.4580358 22.800567 18.04.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19657
15608 15608 DANCIU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 30 15 wedding 55 0 0 0 0   45 0 76.2 CLJ 35.8 0.5 46 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 51 46.45434 22.8133413 04.04.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 8507/5391
15609 15609 DIGS RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 19 8   45 0 0 0 0   45 0 76.3 CLJ 36.0 0.9 64 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 95 46.456623 22.8092765 16.10.2018   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 6549/3893
15610 15610 EMANUEL RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 22 8   45 0 0 0 0   45 0 76.2 CLJ 35.8 0.5 46 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 131A 46.45434 22.8133413 20.12.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 37392
15614 15614 MAMA UŢA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 25 13   45 0 0 0 0   45 0 76.6 CLJ 36.0 1.2 70 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 97 46.4568635 22.805182 28.09.2020   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 14107
15615 15615 MARYDOR RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 21 9   45 0 0 0 0   45 0 75.6 CLJ 35.7 0.6 44 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 64 46.453097 22.822685 25.01.2012   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 16470
15617 15617 ONELIA RO stay guesthouses guesthouse normal 3 star 3 - STELE 40 20 wedding 55 0 0 0 0   45 0 76.8 CLJ 36.0 1.3 70 Com. Gârda de Sus, Sat Gârda de Sus ALBA NR. 98B 46.4563802 22.8022573 08.04.2016   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 16350
15620 15620 CASA SUVENIRURILOR RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 5   45 0 0 0 0   45 10 73.8 CLJ 40.0 3.7 45 Com. Gârda de Sus, Sat Gheţari ALBA NR. 235/B 46.4918026 22.8188259 05.09.2024   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19628
15623 15623 CONACUL SAMFIREI RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 14 6   45 0 0 0 0   45 0 73.7 CLJ 36.4 1.0 34 Com. Gârda de Sus, Sat Izvoarele ALBA NR. 8 46.4579234 22.8470327 28.09.2020   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 27552
15630 15630 CĂSUŢA DIN POVEŞTI RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 7   45 0 0 0 0   45 0 64.5 CLJ 42.7 0.3 37 Com. Horea, Sat Horea ALBA STR. Strada Nicola Vasile Ursu , NR. 23 46.4997283 22.9505161 01.10.2020   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 30119
15635 15635 OLD CHALET RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 4 2   45 0 0 0 0   45 0 64.5 CLJ 42.9 0.2 36 Com. Horea, Sat Horea ALBA STR. Strada Nicola Vasile Ursu , NR. 67A 46.501291 22.9491144 11.02.2026   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 45628
15638 15638 ALEX OLAR NEW ONE RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 20 10   45 0 0 0 0   45 10 67.0 CLJ 42.4 3.1 32 Com. Horea, Sat Mătişeşti ALBA NR. 340 A 46.5046097 22.9097164 24.11.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 36971
15639 15639 ALEXOLAR RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 6 3   45 0 0 0 0   45 10 67.0 CLJ 42.4 3.1 32 Com. Horea, Sat Mătişeşti ALBA NR. 340 A 46.5046097 22.9097164 08.08.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 17817
15640 15640 APUSENI AIR LUNA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 67.1 CLJ 42.6 3.4 32 Com. Horea, Sat Mătişeşti ALBA NR. 400E 46.5069962 22.9061388 25.03.2026   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 46286
15641 15641 APUSENI AIR SOARE RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 67.1 CLJ 42.6 3.4 32 Com. Horea, Sat Mătişeşti ALBA NR. 400E 46.5069962 22.9061388 25.03.2026   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 46287
15643 15643 CASA ARISTOCRATĂ RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 67.1 CLJ 42.9 3.6 32 Com. Horea, Sat Mătişeşti ALBA NR. 448 46.5099297 22.9044748 07.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32822
15644 15644 CASA BOEMA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 67.1 CLJ 42.9 3.6 32 Com. Horea, Sat Mătişeşti ALBA NR. 448 46.5098748 22.9045185 07.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32824
15645 15645 CASA DE PE LAC RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 66.8 CLJ 43.3 3.6 32 Com. Horea, Sat Mătişeşti ALBA NR. 448 46.5136875 22.9058125 07.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32821
15648 15648 CASA NORDICA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 67.1 CLJ 42.9 3.6 32 Com. Horea, Sat Mătişeşti ALBA NR. 448 46.5100276 22.9044474 07.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32819
15649 15649 CASA REINTERPRETATĂ RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 2 1   45 0 0 0 0   45 10 67.1 CLJ 42.9 3.6 32 Com. Horea, Sat Mătişeşti ALBA NR. 448 46.5098203 22.9045452 07.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32823
15655 15655 COTA 1600 PETREASA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 10 5   45 0 0 0 0   45 10 63.2 CLJ 46.4 3.8 29 Com. Horea, Sat Petreasa ALBA NR. 800 46.5361053 22.9424224 27.05.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 23192
15658 15658 CASA DE VACANŢĂ LA MOŞU VASILICĂ RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 6 3   45 0 0 0 0   55 10 46.8 Câmpia Turzii Air Base 11.6 0.2 11 Com. Ighiu, Sat Bucerdea Vinoasa ALBA NR. 104 46.162994 23.5258832 28.02.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33721
15660 15660 HANUL SF.GHEORGHE RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 16 8   45 0 0 0 0   55 10 48.8 Câmpia Turzii Air Base 10.2 0.5 14 Com. Ighiu, Sat Ighiu ALBA NR. 50 46.1456489709292 23.5162387221206 04.02.2026   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 3991/1648
15663 15663 FRIENDLY GREEN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 8 4   45 0 0 0 0   65 0 50.2 Câmpia Turzii Air Base 7.5 0.6 22 Com. Ighiu, Sat Şard ALBA NR. 425 G 46.12337 23.5311306 05.09.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32096
15670 15670 CASA DINTRE VII RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   55 20 35.5 Câmpia Turzii Air Base 15.9 1.0 1 Com. Jidvei, Sat Jidvei ALBA STR. Strada Gării , NR. 33 46.2226645 24.1098947 01.03.2022   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 27047
15674 15674 CASA DE VACANŢĂ VĂLIŞOARA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 6 1   45 0 0 0 0   70 20 28.0 Câmpia Turzii Air Base 15.1 3.9 10 Com. Livezile, Sat Vălişoara ALBA NR. 172 46.388229 23.5607031 25.01.2021   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 14229
15679 15679 GALAXY RO stay guesthouses guesthouse normal 3 flower 3 - MARGARETE 16 8   45 0 0 0 0   45 10 52.3 Câmpia Turzii Air Base 38.7 0.1 7 Com. Lupşa, Sat Luncă ALBA NR. 58 46.3798194 23.2271817 25.07.2013   RO-SITUR PENSIUNE TURISTICĂ 3 - MARGARETE 27042
15680 15680 CASA APUSEANA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 25 15   45 0 0 0 0   45 30 56.2 Câmpia Turzii Air Base 40.7 2.4 4 Com. Lupşa, Sat Mănăstire ALBA NR. 1035 46.3789596 23.1750177 28.03.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 8120/7435
15682 15682 CASA AMPOIŢANĂ RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 16 8   45 0 0 0 0   55 10 53.2 Câmpia Turzii Air Base 10.2 1.8 14 Com. Meteş, Sat Ampoiţa ALBA NR. 13C 46.1182608 23.4735226 29.05.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 10105/7355
15683 15683 CĂSUŢA DE SUB PĂDURE RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 4 1   45 0 0 0 0   55 10 53.6 Câmpia Turzii Air Base 10.9 1.1 10 Com. Meteş, Sat Ampoiţa ALBA NR. 199 D 46.1184403 23.4638471 08.09.2020   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 20876
15700 15700 STONE GARDEN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 8 4   45 0 0 0 0   70 20 28.7 Câmpia Turzii Air Base 22.9 3.5 11 Com. Ocoliş, Sat Vidolm ALBA NR. 42 46.4801084 23.5117947 01.10.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 21344
15707 15707 IEDERA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 10 5   45 0 0 0 0   65 10 49.2 SBZ 9.4 0.9 7 Com. Pianu, Sat Pianu de Sus ALBA STR. Strada Principală , NR. 534 45.9053678 23.4747941 08.08.2018   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 13385
15716 15716 FRIENDS CHALET RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   55 20 34.5 Câmpia Turzii Air Base 16.6 4.3 10 Com. Râmeţ, Sat Valea Inzelului ALBA NR. 64 46.333899 23.5074715 28.05.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 42773
15730 15730 AGOTTA 2 RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 12 6   45 0 0 0 0   70 0 25.0 Câmpia Turzii Air Base 19.9 0.4 41 Com. Rimetea, Sat Rimetea ALBA STR. Strada Principală , NR. 278 46.4535574 23.5671787 27.11.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19196
15731 15731 ANDRÁS VENDÉGHÁZ RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 4 2   45 0 0 0 0   45 10 62.8 Câmpia Turzii Air Base 32.1 1.1 6 Com. Rimetea, Sat Rimetea ALBA STR. Strada Principală , NR. 219 46.3032584 23.1197619 04.12.2024   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 40850
15733 15733 BITAI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 4 2   45 0 0 0 0   70 0 25.2 Câmpia Turzii Air Base 19.5 0.2 41 Com. Rimetea, Sat Rimetea ALBA NR. 1 46.4486122 23.5658991 01.02.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 22693
15736 15736 CASA BOTAR RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 7   45 0 0 0 0   70 0 25.2 Câmpia Turzii Air Base 20.2 0.7 45 Com. Rimetea, Sat Rimetea ALBA NR. 231 46.4555745 23.5641646 16.09.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 23742
15737 15737 CASA DE VACANȚĂ "ZABPATAK" RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 6 3   45 0 0 0 0   70 0 24.7 Câmpia Turzii Air Base 19.7 0.5 41 Com. Rimetea, Sat Rimetea ALBA STR. Strada Principală , NR. 130 46.4537195 23.5708645 28.05.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 40851
15739 15739 CASA EXIGUL RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 6 2   45 0 0 0 0   70 0 25.0 Câmpia Turzii Air Base 19.7 0.3 41 Com. Rimetea, Sat Rimetea ALBA NR. 176 46.4523988 23.5675171 06.12.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 32696
15740 15740 CASA KIRALY VENDEGHAZ RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 17 7   45 0 0 0 0   70 0 25.0 Câmpia Turzii Air Base 20.2 0.8 45 Com. Rimetea, Sat Rimetea ALBA NR. 173/A 46.4568176 23.5659942 15.05.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19755
15742 15742 CASA RITA & BENCE VENDEGHAZ RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 8 4   45 0 0 0 0   70 0 25.0 Câmpia Turzii Air Base 19.6 0.2 41 Com. Rimetea, Sat Rimetea ALBA NR. 172 46.4513677 23.5682645 27.10.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 21688
15743 15743 CASA SIMON RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 14 6   45 0 0 0 0   70 0 25.1 Câmpia Turzii Air Base 19.8 0.3 41 Com. Rimetea, Sat Rimetea ALBA NR. 151 46.4529846 23.566412 09.02.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33625

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