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,446 rows where country = "RO" and rating_value = 4

This data as json, CSV (advanced)

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

best_for 3

group 2

rating_value 1

  • 4 · 2,446 ✖

country 1

  • RO · 2,446 ✖

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
16011 16011 LA VIE 1 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 Ciufud 46.1690262 23.904278 30.09.2020   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 21330
16022 16022 KARLHOF RO stay self_catering_villas villa normal 4 star 4 - STELE 20 11 wedding 55 0 0 0 0   65 0 44.3 SBZ 0.5 0.5 32 Mun. Sebeş ALBA STR. Strada Şurianu , NR. 30 45.9523901 23.5674561 14.01.2016   RO-SITUR VILĂ TURISTICĂ 4 - STELE 29389
16023 16023 KARLHOF II RO stay self_catering_villas villa normal 4 star 4 - STELE 13 7 wedding 55 0 0 0 0   65 0 44.3 SBZ 0.5 0.5 32 Mun. Sebeş ALBA STR. Strada Şurianu , NR. 30 45.9523901 23.5674561 16.04.2019   RO-SITUR VILĂ TURISTICĂ 4 - STELE 19604
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
16026 16026 REICHAU TRANSILVANIA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 15 6 wedding 55 0 0 0 0   65 0 47.1 SBZ 3.9 0.4 36 Mun. Sebeş ALBA NR. 197-199 45.9896076 23.5538317 17.08.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 35690
16027 16027 RYN RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 22 12 wedding 55 0 0 0 0   65 0 45.6 SBZ 1.4 1.4 33 Mun. Sebeş ALBA STR. Strada Occidentului , NR. 1A 45.9599339 23.553387 03.06.2021   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 23232
16041 16041 ROUA MUNTELUI RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 16 8 wedding 55 0 0 0 0   45 20 48.2 Câmpia Turzii Air Base 34.6 0.1 4 Oraş Baia de Arieş, Sat Baia de Arieş ALBA   46.3806546 23.2822917 10.11.2015   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 28918
16075 16075 CASA BATA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 34 15 wedding 65 0 0 0 0   45 30 58.7 TSR 35.9 2.7 2 Com. Bata, Sat Ţela ARAD NR. 12 45.9949722 22.0483951 03.07.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 16274
16148 16148 AGROVILLAGE RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 18 9 wedding 55 0 0 0 0   45 30 39.2 TSR 31.6 7.6 6 Com. Şiştarovăţ, Sat Labaşinţ ARAD NR. 43 45.96272 21.794351 11.01.2022   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 26999
16227 16227 BEST WESTERN CENTRAL RO stay hotels hotel normal 4 star 4 - STELE 84 42 wedding 90 80 60 50 0   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD STR. Strada Horia , NR. 8 46.1762734 21.316574 02.10.2012   RO-SITUR HOTEL 4 - STELE 2450/364
16247 16247 CONTINENTAL FORUM RO stay hotels hotel normal 4 star 4 - STELE 320 160 wedding 100 90 70 50 0   80 0 4.2 ARW 1.0 1.0 408 Mun. Arad ARAD STR. Bulevardul Revoluţiei , NR. 79-81 , BL. Astoria 46.1741356 21.318273 21.01.2019   RO-SITUR HOTEL 4 - STELE 2323/535
16289 16289 LA CONAC RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 14 7 wedding 55 0 0 0 0   80 10 1.9 ARW 2.7 2.7 367 Mun. Arad ARAD STR. Strada Sfântul Nicolae , NR. 9 46.1871431 21.282405 11.09.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 23974
16290 16290 LA CUSCRII RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 17 8 wedding 55 0 0 0 0   80 10 1.6 ARW 3.0 3.0 375 Mun. Arad ARAD STR. Calea Bodrogului , NR. 20 46.1699106 21.2832509 28.11.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 22939
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
16404 16404 RUSTIK LANCRĂM RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 20 10 wedding 55 0 0 0 0   65 0 48.2 SBZ 5.2 1.7 36 Sebeş ARAD   45.9995393 23.5448781 03.01.2017   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 30482
16426 16426 PAPILLON RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 24 12 wedding 55 0 0 0 0   50 10 95.1 CRA 5.3 2.2 38 Com. Albota, Sat Albota ARGEŞ STR. Strada Dâmbovnic , NR. 3 44.8033354 24.876825 11.02.2014   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 27656
16451 16451 POSADA VIDRARU RO stay hotels hotel normal 4 star 4 - STELE 100 50 wedding 90 80 60 50 0   55 0 65.8 SBZ 22.6 0.4 87 Com. Arefu, Sat Arefu ARGEŞ   45.3358986 24.6362457 07.10.2016   RO-SITUR HOTEL 4 - STELE 13830
16455 16455 VALEA CU PESTI RO stay hotels hotel normal 4 star 4 - STELE 114 60 wedding 90 80 60 50 0   55 0 66.0 SBZ 22.3 0.2 89 Com. Arefu, Sat Arefu ARGEŞ NR. 200 45.3333451 24.6357028 01.11.2011   RO-SITUR HOTEL 4 - STELE 10159/5686
16480 16480 DRACULA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 22 10 wedding 55 0 0 0 0   55 0 65.9 SBZ 22.5 0.2 88 Com. Arefu, Sat Căpăţânenii Ungureni ARGEŞ   45.3346043 24.6357864 20.12.2018   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 6418/6080
16482 16482 LA CĂSUŢE RO stay camping camping normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   55 0 67.7 SBZ 20.6 0.6 96 Com. Arefu, Sat Căpăţânenii Ungureni ARGEŞ NR. 38B 45.3178989 24.6426911 31.10.2023   RO-SITUR POPAS TURISTIC 4 - STELE 36646
16526 16526 RUXANDRA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 28 14 wedding 55 0 0 0 0   55 0 75.2 GHV 19.0 1.5 21 Com. Brăduleţ, Sat Brăduleţ ARGEŞ   45.2946515 24.7560756 18.12.2023   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 37318
16546 16546 CÂMPULUNG CHALETS RO stay camping camping normal 4 star 4 - STELE 12 6 wedding 55 0 0 0 0   45 0 58.1 GHV 34.3 1.7 68 Com. Bughea de Sus ARGEŞ STR. Bughita Albeștilor , NR. Lot 3 45.3131341097717 25.0312878823502 25.08.2024   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 39357
16551 16551 MĂLINULUI RESORT RO stay camping camping normal 4 star 4 - STELE 26 13 wedding 55 0 0 0 0   45 0 59.8 GHV 33.1 0.6 76 Com. Bughea de Sus, Sat Bughea de Sus ARGEŞ   45.2931835 25.0312529 03.09.2025   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 43794
16562 16562 SWE SAR RO stay self_catering_villas villa normal 4 star 4 - STELE 16 8 wedding 55 0 0 0 0   55 0 72.8 SBZ 13.2 0.5 23 Com. Cicăneşti, Sat Cicăneşti ARGEŞ NR. 183 45.2445122 24.6111116 28.12.2021   RO-SITUR VILĂ TURISTICĂ 4 - STELE 24312
16588 16588 SELECT RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 6 3 wedding 55 0 0 0 0   55 0 69.2 SBZ 19.1 0.6 87 Com. Corbeni, Sat Corbeni ARGEŞ NR. 97B 45.3049653 24.6512465 20.06.2019   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 19928
16595 16595 BUN 88 RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 20 10 wedding 55 0 0 0 0   55 0 73.8 SBZ 13.4 0.2 45 Com. Corbeni, Sat Oeştii Ungureni ARGEŞ   45.25355 24.6514964 02.02.2011   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 11276/7272
16602 16602 IRINA RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 16 8 wedding 55 0 0 0 0   55 0 68.5 SBZ 20.2 0.5 95 Com. Corbeni, Sat Poienari ARGEŞ NR. 66 45.3157729 24.6561243 11.03.2026   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 10139/6440
16626 16626 LIVADA BUNICULUI RO stay rural rural_agritourism normal 4 flower 4 - FLORI 16 8 wedding 55 0 0 0 0   55 10 75.7 GHV 16.1 0.5 17 Com. Corbi, Sat Stăneşti ARGEŞ STR. Strada Erou Mihai Ungurenuş , NR. 14 45.2283887 24.830131 15.10.2019   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 28875
16635 16635 URSA MICĂ RO stay camping camping normal 4 star 4 - STELE 48 12 wedding 65 0 0 0 0   55 0 34.5 GHV 12.5 1.8 143 Com. Dâmbovicioara, Sat Ciocanu ARGEŞ NR. 47 45.4577352 25.2553627 08.04.2026   RO-SITUR SPAȚII DE CAMPARE 4 - STELE 22306
16636 16636 URSA MICĂ RO stay camping camping normal 4 star 4 - STELE 24 12 wedding 55 0 0 0 0   55 0 34.5 GHV 12.4 1.8 143 Com. Dâmbovicioara, Sat Ciocanu ARGEŞ NR. 47 45.4579268976229 25.2553709857971 08.04.2026   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 22305
16658 16658 PIATRA CRAIULUI RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 30 15 wedding 65 0 0 0 0   55 0 37.0 GHV 14.6 1.1 90 Com. Dâmbovicioara, Sat Dâmbovicioara ARGEŞ   45.4490914 25.2193589 22.11.2010   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 13762
16665 16665 CASA EUROPAN RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 20 10 wedding 55 0 0 0 0   55 10 41.5 GHV 19.3 3.1 106 Com. Dâmbovicioara, Sat Podu Dâmboviţei ARGEŞ   45.4061086 25.2056876 29.11.2010   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 7601/5153
16675 16675 CHEILE DÂMBOVICIOAREI 3 RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 20 10 wedding 55 0 0 0 0   55 10 41.5 GHV 19.3 3.1 106 Com. Dâmbovicioara, Sat Podu Dâmboviţei ARGEŞ NR. 253 45.4061086 25.2056876 05.05.2026   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 46634
16683 16683 PADINA CRAIULUI RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 12 6 wedding 55 0 0 0 0   55 10 41.9 GHV 19.7 2.6 105 Com. Dâmbovicioara, Sat Podu Dâmboviţei ARGEŞ   45.4050847 25.1990447 06.08.2013   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 27159
16709 16709 JUPÂNIŢA RO stay guesthouses guesthouse normal 4 flower 4 - FLORI 20 10 wedding 55 0 0 0 0   45 0 54.2 GHV 31.7 0.5 30 Com. Lereşti, Sat Lereşti ARGEŞ NR. 1 117430 45.3336482 25.0728317 16.11.2012   RO-SITUR PENSIUNE TURISTICĂ 4 - FLORI 25839
16712 16712 THE BAKER`S HOUSE RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 13 6 wedding 55 0 0 0 0   45 0 55.1 GHV 32.7 1.5 47 Com. Lereşti, Sat Lereşti ARGEŞ STR. Strada Ţarină , NR. 118C 45.3212774 25.0756126 11.02.2026   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 45638
16724 16724 ANDREI RO stay rural rural_agritourism normal 4 flower 4 - FLORI 14 7 wedding 55 0 0 0 0   50 0 101.1 GHV 7.2 0.7 27 Com. Mărăcineni, Sat Argeşelu ARGEŞ NR. 248 D 44.9218035 24.8675884 04.12.2015   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 29252
16736 16736 CONACUL DE PE DEAL RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 26 12 wedding 55 0 0 0 0   45 0 62.8 GHV 32.6 0.7 42 Com. Mioarele, Sat Măţău ARGEŞ   45.236951 25.0743196 19.03.2025   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 26784
16738 16738 MUSCELEANCA RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 14 7 wedding 55 0 0 0 0   45 0 62.8 GHV 32.6 0.7 42 Com. Mioarele, Sat Măţău ARGEŞ   45.236951 25.0743196 19.03.2025   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 26957
16748 16748 SUNRISE GLAMPING RETREAT RO stay camping camping normal 4 star 4 - STELE 24 12 wedding 55 0 0 0 0   55 10 78.9 GHV 13.0 1.1 15 Com. Muşăteşti, Sat Robaia ARGEŞ NR. 48 45.2263899 24.7765609 06.09.2022   RO-SITUR CĂSUȚE TIP CAMPING 4 - STELE 32159
16760 16760 CASA DE OASPETI CAEZU RO stay rural rural_agritourism normal 4 flower 4 - FLORI 14 7 wedding 55 0 0 0 0   55 10 68.5 GHV 26.5 0.3 8 Com. Nucşoara, Sat Slatina ARGEŞ STR. Strada Fermei , NR. 3 45.3558662 24.7989776 28.12.2021   RO-SITUR PENSIUNE AGROTURISTICĂ 4 - FLORI 24309
16765 16765 CONACUL SOFRA RO stay guesthouses guesthouse normal 4 flower 4 - MARGARETE 18 7 wedding 55 0 0 0 0   55 30 66.8 GHV 28.0 0.3 0 Com. Poienarii de Muscel, Sat Jugur ARGEŞ NR. 251C 45.1896568 25.0846576 04.09.2025   RO-SITUR PENSIUNE TURISTICĂ 4 - MARGARETE 43849

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