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

5,145 rows where best_for = "wedding" and country = "RO"

This data as json, CSV (advanced)

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

family 8

rating_value 5

  • 3 2,658
  • 4 1,789
  • 2 375
  • 5 223
  • 1 100

group 1

country 1

  • RO · 5,145 ✖

best_for 1

  • wedding · 5,145 ✖

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
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
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
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
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
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
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
15529 15529 CASA NOASTRA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 16 8 wedding 55 0 0 0 0   30 10 80.5 CLJ 38.8 2.1 86 Com. Arieşeni, Sat Izlaz ALBA   46.4800503 22.7306245 12.11.2010   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 5043/5161
15534 15534 TRANSYLVANIA HOUSE RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 16 8 wedding 55 0 0 0 0   30 0 80.3 CLJ 38.7 1.8 86 Com. Arieşeni, Sat Izlaz ALBA NR. 468B 46.479385 22.7338581 24.02.2026   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 36970
15557 15557 CĂSUŢA DIN VII RO stay camping camping normal 4 star 4 - STELE 4 1 wedding 55 0 0 0 0   65 20 37.3 SBZ 8.3 0.5 3 Com. Cergău, Sat Cergău Mare ALBA NR. 203C 46.1 23.916667 21.12.2022   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 33223
15558 15558 FATA VIILOR RO stay rural rural_agritourism normal 4 flower 4 - MARGARETE 14 7 wedding 55 0 0 0 0   65 20 37.2 SBZ 8.8 1.3 1 Com. Cergău, Sat Cergău Mare ALBA STR. Strada Principală , NR. 160 46.0959098 23.9069755 04.11.2025   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - MARGARETE 44808
15559 15559 MARIA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 16 8 wedding 55 0 0 0 0   55 30 30.8 TGM 13.6 0.2 0 Com. Cetatea de Balta, Sat Cetatea de Balta ALBA STR. Strada Cetăţii , NR. 105A 46.2466621 24.1697793 05.10.2011   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 10916/8096
15563 15563 CRIZANTEMA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31050
15565 15565 FERIGA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31046
15566 15566 HIBISCUS RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31053
15567 15567 HORTENSIA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31045
15569 15569 IASOMIA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31051
15572 15572 IRIS RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31056
15574 15574 LAVANDA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31057
15575 15575 LILIAC RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31054
15576 15576 MAGNOLIA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31047
15577 15577 MARGARETA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31055
15578 15578 PETUNIA RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31052
15579 15579 ROZELOR RO stay self_catering_villas villa normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31049
15580 15580 ROZMARIN RO stay self_catering_villas villa normal 4 star 4 - STELE     wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31048
15581 15581 THEODORA RO stay self_catering_villas villa normal 4 star 4 - STELE 8 4 wedding 55 0 0 0 0   65 10 48.9 SBZ 4.1 3.1 118 Com. Ciugud, Sat Teleac ALBA NR. 75 C 46.0879079 23.6272492 15.11.2017   RO-SITUR VILĂ TURISTICĂ 4 - STELE 31044
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
15588 15588 FLOARE DE COLŢ RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 28 12 wedding 55 0 0 0 0   55 40 40.0 Câmpia Turzii Air Base 17.1 5.1 3 Com. Galda de Jos, Sat Galda de Jos ALBA NR. 74 46.2462984 23.519528 17.11.2015   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 29004
15590 15590 POIANA GALDEI RO stay rural rural_agritourism normal 4 flower 4 - FLORI 16 8 wedding 55 0 0 0 0   55 30 39.8 Câmpia Turzii Air Base 16.6 4.4 3 Com. Galda de Jos, Sat Galda de Jos ALBA NR. 32A 46.2433979 23.527937 27.11.2017   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 31109
15594 15594 POARTA OILOR RO stay hostels hostel normal 2 star 2 - STELE 89 27 wedding 55 0 0 0 0   70 10 29.5 SBZ 15.8 1.3 6 Com. Gârbova, Sat Gârbova ALBA NR. 573 45.8593251 23.7201921 03.02.2021   RO-SITUR HOSTEL 2 - STELE 16307
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
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
15631 15631 KARSTIC CHALETS RO stay camping camping normal 4 star 4 - STELE 8 2 wedding 55 0 0 0 0   45 10 68.0 CLJ 42.4 4.4 30 Com. Horea, Sat Horea ALBA NR. 409 46.5068806 22.8925928 18.09.2023   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 36077
15661 15661 TERRA MYTHICA RO stay hostels hostel normal 3 star 3 - STELE 172 33 wedding 75 0 0 0 0   55 10 49.1 Câmpia Turzii Air Base 10.2 0.8 17 Com. Ighiu, Sat Ighiu ALBA NR. 325 46.1438947 23.5121564 09.03.2021   RO-SITUR HOSTEL 3 - STELE 13868/9133
15675 15675 CASTEL TEMPLUL CAVALERILOR RO stay self_catering_villas villa normal 3 star 3 - STELE 38 20 wedding 55 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   46.388229 23.5607031 14.12.2020   RO-SITUR VILĂ TURISTICĂ 3 - STELE 13145
15678 15678 HARVEST HOUSE TRANSYLVANIA RO stay rural rural_agritourism normal 4 flower 4 - MARGARETE 12 6 wedding 55 0 0 0 0   65 0 50.6 Câmpia Turzii Air Base 3.3 0.4 183 Com. Lunca Mureşului, Sat Lunca Mureşului ALBA NR. 310B 46.0963679 23.5889273 11.02.2026   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - MARGARETE 45625
15686 15686 BUNĂ ZIUA RO stay rural rural_agritourism normal 4 flower 4 - FLORI 8 4 wedding 55 0 0 0 0   55 50 55.4 Câmpia Turzii Air Base 17.4 5.3 0 Com. Meteş, Sat Lunca Ampoiţei ALBA NR. 52A 46.1428056 23.3862314 28.09.2020   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 21176
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
15709 15709 LA NENEA IANCU RO stay rural rural_agritourism normal 4 flower 4 - FLORI 8 4 wedding 55 0 0 0 0   65 10 49.2 SBZ 9.4 0.9 7 Com. Pianu, Sat Pianu de Sus ALBA NR. 532 45.9053678 23.4747941 18.08.2023   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 35706
15725 15725 CONACUL SECUIESC I RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 34 15 wedding 65 0 0 0 0   70 0 26.1 Câmpia Turzii Air Base 17.5 0.2 42 Com. Rimetea, Sat Colţeşti ALBA NR. 77-78 46.4241956 23.5641929 25.10.2022   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 10/707
15726 15726 CONACUL SECUIESC II RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 16 8 wedding 55 0 0 0 0   70 0 26.1 Câmpia Turzii Air Base 17.5 0.2 42 Com. Rimetea, Sat Colţeşti ALBA NR. 77-78 46.4241956 23.5641929 15.11.2022   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 13854
15727 15727 CONACUL SECUIESC III RO stay guesthouses guesthouse normal 4 star 4 - STELE 9 5 wedding 55 0 0 0 0   70 0 26.1 Câmpia Turzii Air Base 17.5 0.2 42 Com. Rimetea, Sat Colţeşti ALBA NR. 89 46.4241956 23.5641929 06.06.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - STELE 34750
15748 15748 DOCTOR DEMETER BELA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 35 14 wedding 55 0 0 0 0   70 0 24.9 Câmpia Turzii Air Base 19.4 0.3 41 Com. Rimetea, Sat Rimetea ALBA NR. 55 46.4503162 23.5702052 05.11.2012   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 25827
15759 15759 PERLA TRASCĂULUI RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 29 14 wedding 55 0 0 0 0   70 10 23.5 Câmpia Turzii Air Base 18.0 3.9 37 Com. Rimetea, Sat Rimetea ALBA NR. 348 46.4839922 23.5806213 13.03.2018   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 17014
15763 15763 TRUSKO ECO RESORT RO stay camping camping normal 4 star 4 - STELE 24 12 wedding 55 0 0 0 0   70 0 25.0 Câmpia Turzii Air Base 20.1 0.7 45 Com. Rimetea, Sat Rimetea ALBA STR. Strada Cabanelor , NR. 1 46.4563136225279 23.5664391132446 05.08.2025   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 43492
15768 15768 GHERMAN RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 24 12 wedding 55 0 0 0 0   55 10 35.6 Câmpia Turzii Air Base 23.7 1.8 9 Com. Sălciua ALBA NR. 533 46.4037555 23.444193 20.10.2020   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 21711
15774 15774 SUB PIATRĂ RO stay self_catering_villas villa normal 3 star 3 - STELE 48 24 wedding 55 0 0 0 0   55 20 35.2 Câmpia Turzii Air Base 21.6 3.5 9 Com. Sălciua, Sat Sub Piatra ALBA NR. 516B 46.3833121 23.4607753 16.06.2021   RO-SITUR VILĂ TURISTICĂ 3 - STELE 11917/8928
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
15783 15783 MARTINI RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 16 8 wedding 55 0 0 0 0   65 10 42.1 SBZ 7.6 0.2 8 Com. Săsciori, Sat Sebeşel ALBA NR. 171G 45.8884402 23.5641632 27.11.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 37067
15785 15785 HANUL ŞURIANU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 42 21 wedding 55 0 0 0 0   70 20 21.5 SBZ 23.0 2.7 8 Com. Şibot, Sat Şibot ALBA NR. 490 45.8498629 23.8252972 31.08.2017   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 30726
15787 15787 AXA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 30 15 wedding 65 0 0 0 0   55 20 32.3 SBZ 12.1 0.2 4 Com. Şpring, Sat Cunţa ALBA NR. 225 45.9268703 23.7215322 09.11.2017   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 18588
15793 15793 COLEV RO stay rural rural_agritourism normal 4 flower 4 - FLORI 8 4 wedding 55 0 0 0 0   55 10 36.1 Câmpia Turzii Air Base 11.3 1.1 10 Com. Stremţ, Sat Stremţ ALBA NR. 24 46.2265952 23.6368859 03.12.2018   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 19208
15795 15795 LIVADA BUNICILOR RO stay rural rural_agritourism normal 4 flower 4 - FLORI 10 5 wedding 55 0 0 0 0   55 10 36.1 Câmpia Turzii Air Base 11.3 1.1 10 Com. Stremţ, Sat Stremţ ALBA NR. 277 A 46.2265952 23.6368859 15.12.2014   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 28293
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
15803 15803 PERLA MĂRTINIEI RO stay guesthouses guesthouse normal 5 flower 5 - FLORI 24 12 wedding 55 0 0 0 0   55 10 37.6 SBZ 18.3 0.5 15 Com. Şugag, Sat Mărtinie ALBA STR. Strada Valea Mărtiniei , NR. 81A 45.792978 23.6022296 06.12.2017   RO-SITUR PENSIUNE TURISTICĂ 5 - FLORI 31129
15809 15809 NUŢA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 30 14 wedding 55 0 0 0 0   55 10 36.2 SBZ 20.2 1.6 20 Com. Şugag, Sat Şugag ALBA NR. 34/1 45.7776871 23.6206131 14.01.2016   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 29393
15810 15810 SF. PETRU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 60 28 wedding 55 0 0 0 0   55 40 49.0 SBZ 17.1 15.4 8 Com. Şugag, Sat Şugag ALBA NR. 17 45.5833553 23.5271408 09.01.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 27861
15816 15816 CASA DAROM RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 30 15 wedding 65 0 0 0 0   55 40 49.0 SBZ 17.1 15.4 8 Com. Şugag, Sat Tău Bistra ALBA NR. 16 45.5833553 23.5271408 29.07.2013   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 27055
15817 15817 COLŢ DIN RAI RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 30 15 wedding 65 0 0 0 0   55 40 49.1 SBZ 17.2 15.5 8 Com. Şugag, Sat Tău Bistra ALBA NR. 13 45.5861587 23.5222225 19.11.2020   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 16408
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
15826 15826 POPASUL REGELUI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 36 18 wedding 55 0 0 0 0   55 40 40.3 SBZ 24.4 10.2 11 Com. Şugag, Sat Tău Bistra ALBA NR. 36C 45.6799134 23.5899299 04.09.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 35932
15830 15830 COTUL ARIEŞULUI RO stay camping chalet_bungalow_hut normal 3 star 3 - STELE 36 14 wedding 55 0 0 0 0   45 20 69.1 CLJ 32.5 2.2 11 Com. Vadu Moţilor, Sat Necşeşti ALBA   46.3888 22.99 19.01.2022   RO-SITUR CABANĂ TURISTICĂ 3 - STELE 12889
15839 15839 RIVUS RETREAT RO stay rural rural_agritourism normal 4 flower 4 - MARGARETE 16 8 wedding 55 0 0 0 0   55 20 74.8 CLJ 28.3 2.1 19 Com. Vidra, Sat Lunca Goieşti ALBA NR. 231 46.3707419 22.9152773 17.12.2024   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - MARGARETE 41037
15849 15849 VIDRA DACICA RO stay rural rural_agritourism normal 4 flower 4 - MARGARETE 12 6 wedding 55 0 0 0 0   55 10 76.5 CLJ 27.4 0.2 16 Com. Vidra, Sat Vidra ALBA STR. VIDRA , NR. 3 46.3685279 22.8900502 17.12.2024   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - MARGARETE 41034
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
15858 15858 ATRIS RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 40 20 wedding 55 0 0 0 0   80 10 24.8 Câmpia Turzii Air Base 0.0 0.0 17 Mun. Aiud ALBA STR. Strada Iuliu Maniu , NR. 8 46.3101466 23.7218599 27.05.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 42740
15865 15865 MOBIS RO stay guesthouses guesthouse normal 3 star 3 - STELE 31 15 wedding 55 0 0 0 0   80 10 24.0 Câmpia Turzii Air Base 1.1 1.1 17 Mun. Aiud ALBA STR. Strada Transilvaniei , NR. 120 46.319548 23.7202595 07.04.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 7574/5203
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
15873 15873 ALBA FORUM RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 14 7 wedding 55 0 0 0 0   65 0 50.9 SBZ 1.9 1.9 169 Mun. Alba Iulia ALBA STR. Strada Brânduşei , NR. 20A 46.0610873 23.5604711 28.11.2018   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 19189
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
15885 15885 AVE, ALBA! RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 26 13 wedding 55 0 0 0 0   65 0 51.3 SBZ 1.4 1.4 191 Mun. Alba Iulia ALBA STR. Bulevardul Horea , NR. 27 46.0721724 23.5669675 26.11.2018   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 19186
15891 15891 CAROL RO stay self_catering_villas villa normal 3 star 3 - STELE 38 19 wedding 55 0 0 0 0   65 10 52.1 SBZ 2.5 2.5 170 Mun. Alba Iulia ALBA STR. Bulevardul Transilvaniei , NR. 47 46.0711121 23.5516174 27.05.2025   RO-SITUR VILĂ TURISTICĂ 3 - STELE 42741
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
15899 15899 CASA TRAIANA RO stay guesthouses guesthouse normal 3 star 3 - STELE 32 13 wedding 55 0 0 0 0   65 0 51.3 SBZ 2.2 1.5 182 Mun. Alba Iulia ALBA STR. Strada Arieşului , NR. 49A 46.0861184 23.5832981 14.04.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 14210
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
15908 15908 CREMA RESIDENCE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 40 13 wedding 55 0 0 0 0   65 10 51.5 SBZ 2.1 2.1 169 Mun. Alba Iulia ALBA STR. Bulevardul Revoluţiei 1989 , NR. 2E 46.0658147 23.5561195 12.11.2020   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 22188
15909 15909 CREMA RESIDENCE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 40 13 wedding 55 0 0 0 0   65 10 51.5 SBZ 2.1 2.1 169 Mun. Alba Iulia ALBA NR. 14 46.0656602 23.5561058 12.11.2020   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 22187
15914 15914 ELEMENT RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 20 10 wedding 55 0 0 0 0   65 10 52.2 SBZ 2.5 2.5 170 Mun. Alba Iulia ALBA STR. Strada Mircea Eliade , NR. 2A 46.07182 23.5512779 20.12.2018   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 19319
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
15928 15928 LA MAISON DE CAROLINE RO stay guesthouses guesthouse normal 4 star 4 - STELE 26 13 wedding 55 0 0 0 0   65 0 50.1 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA STR. Strada Primăverii , NR. 11 46.0700226 23.5840516 18.07.2012   RO-SITUR PENSIUNE TURISTICĂ 4 - STELE 18160
15931 15931 MA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 15 wedding 55 0 0 0 0   65 0 51.2 SBZ 2.2 1.5 182 Mun. Alba Iulia ALBA STR. Strada Arieşului , NR. 51 46.0862059 23.5839806 18.08.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 8642/6032
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
15940 15940 MARYLOU RO stay guesthouses guesthouse normal 4 star 4 - STELE 16 8 wedding 55 0 0 0 0   65 10 51.4 SBZ 2.0 2.0 169 Mun. Alba Iulia ALBA STR. Strada Lalelelor , NR. 18 46.0646743 23.5571589 15.06.2011   RO-SITUR PENSIUNE TURISTICĂ 4 - STELE 11893/7785
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
15957 15957 PRECIOSA RO stay self_catering_villas villa normal 4 star 4 - STELE 18 10 wedding 55 0 0 0 0   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA STR. Strada Lucian Blaga , NR. 10 46.0671371 23.578956 08.09.2020   RO-SITUR VILĂ TURISTICĂ 4 - STELE 13795
15958 15958 PRESTIGE RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 84 39 wedding 65 0 0 0 0   65 0 51.2 SBZ 1.4 1.4 186 Mun. Alba Iulia ALBA STR. Strada Vasile Alecsandri , NR. 60 46.0773629 23.5747711 12.10.2016   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 30180
15963 15963 SELECT RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 35 15 wedding 65 0 0 0 0   65 0 49.5 SBZ 4.4 0.9 134 Mun. Alba Iulia ALBA NR. 72 46.0327439 23.5544652 15.12.2014   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 28295
15972 15972 STEAUA NORDULUI RO stay self_catering_villas villa normal 3 star 3 - STELE 36 18 wedding 55 0 0 0 0   65 0 51.8 SBZ 2.0 2.0 184 Mun. Alba Iulia ALBA STR. Bulevardul Republicii , NR. 5A 46.0809587 23.5679724 08.08.2018   RO-SITUR VILĂ TURISTICĂ 3 - STELE 11839/7664
15981 15981 TARA RO stay hostels hostel normal 3 star 3 - STELE 88 38 wedding 65 0 0 0 0   65 10 46.2 Câmpia Turzii Air Base 7.6 2.1 24 Mun. Alba Iulia ALBA NR. 25 46.1288213 23.6229013 10.05.2019   RO-SITUR HOSTEL 3 - STELE 5685/3603
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
16003 16003 MAN PRESIDENT RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 34 15 wedding 55 0 0 0 0   65 0 36.5 Câmpia Turzii Air Base 0.8 0.4 28 Mun. Blaj ALBA STR. Calea Clujului , NR. 111 46.1738826 23.9049233 16.12.2014   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 28376
16006 16006 PARADISUL TRANSILVANIEI RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 30 15 wedding 55 0 0 0 0   65 0 33.9 Câmpia Turzii Air Base 3.7 0.2 26 Mun. Blaj ALBA STR. Strada Horea , NR. 43 46.2002006 23.9470361 22.12.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 22357
16007 16007 PARADISUL TRANSILVANIEI RO stay guesthouses guesthouse normal 5 flower 5 - FLORI 16 8 wedding 55 0 0 0 0   65 0 33.9 Câmpia Turzii Air Base 3.7 0.2 26 Mun. Blaj ALBA STR. Strada Horea , NR. 43 46.2002006 23.9470361 02.09.2020   RO-SITUR PENSIUNE TURISTICĂ 5 - FLORI 20771
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
16010 16010 LA VIE RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 30 15 wedding 65 0 0 0 0   65 0 37.1 Câmpia Turzii Air Base 1.1 0.1 28 Mun. Blaj, Loc. Izvoarele ALBA NR. 8 46.1690262 23.904278 14.01.2016   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 29390

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