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

1,922 rows where best_for = "wedding", country = "RO" and family = "guesthouses"

This data as json, CSV (advanced)

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

rating_value 5

  • 3 1,047
  • 4 750
  • 5 100
  • 2 14
  • 1 11

group 1

family 1

  • guesthouses · 1,922 ✖

country 1

  • RO · 1,922 ✖

best_for 1

  • wedding · 1,922 ✖

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
16020 16020 EKA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 80 40 wedding 65 0 0 0 0   65 0 45.7 SBZ 1.7 1.7 31 Mun. Sebeş ALBA STR. Strada Mihail Kogălniceanu , NR. 156 45.9681504 23.5576034 27.11.2018   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19195
16024 16024 LA UNCHIUL NICKY RO stay guesthouses guesthouse normal 3 star 3 - STELE 30 15 wedding 55 0 0 0 0   65 0 43.8 SBZ 0.4 0.4 32 Mun. Sebeş ALBA   45.9550117 23.5759279 05.07.2010   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 13416
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
16034 16034 CASA LA MESTECENI RO stay guesthouses guesthouse normal 5 flower 5 - FLORI 10 5 wedding 55 0 0 0 0   65 10 38.4 SBZ 7.1 0.3 6 Mun. Sebeş, Sat Răhău ALBA STR. Strada Principală , NR. 1A 45.9025466 23.6193564 16.12.2014   RO-SITUR PENSIUNE TURISTICĂ 5 - FLORI 8985/6017
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
16043 16043 BALEA RO stay guesthouses guesthouse normal 3 star 3 - STELE 32 15 wedding 55 0 0 0 0   45 10 65.5 Câmpia Turzii Air Base 33.0 0.6 17 Oraş Câmpeni ALBA   46.363137 23.0553594 15.04.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 14108A
16049 16049 CASA BALEA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 78 39 wedding 55 0 0 0 0   45 20 64.4 Câmpia Turzii Air Base 33.2 2.3 17 Oraş Câmpeni, Loc. Vârşi ALBA NR. 89 46.3544064 23.0736277 05.09.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 35980
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
16106 16106 LACUL LINIŞTIT RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 31 14 wedding 55 0 0 0 0   45 0 68.4 OMR 54.1 1.9 36 Com. Moneasa, Sat Moneasa ARAD   46.4630007 22.2654462 10.03.2021   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 14297
16107 16107 LACUL LINIŞTIT RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 31 14 wedding 55 0 0 0 0   45 0 68.4 OMR 54.1 1.9 36 Com. Moneasa, Sat Moneasa ARAD   46.4630007 22.2654462 10.03.2021   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 22853
16109 16109 MAYUMI RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 37 13 wedding 55 0 0 0 0   45 0 68.4 OMR 54.4 1.3 36 Com. Moneasa, Sat Moneasa ARAD   46.4605754 22.2569865 17.02.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 6727/5239
16124 16124 CASA BARAŢCA RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 36 18 wedding 55 0 0 0 0   70 20 29.5 ARW 25.9 3.9 19 Com. Păuliş, Sat Baraţca ARAD   46.1076589 21.6342431 11.03.2019   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 19459
16136 16136 CONACUL DE PE LAC RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 14 wedding 55 0 0 0 0   70 20 13.0 ARW 14.0 1.1 2 Com. Şagu, Sat Şagu ARAD NR. 933 46.0597281 21.2840562 05.10.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 12695
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
16174 16174 CASA VERDE RO stay guesthouses guesthouse normal 3 star 3 - STELE 33 15 wedding 55 0 0 0 0   80 0 11.3 ARW 7.6 0.9 49 Com. Vladimirescu, Sat Vladimirescu ARAD   46.1617681 21.4100291 15.12.2009   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 13267
16175 16175 JOSHUA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 40 14 wedding 55 0 0 0 0   80 0 9.8 ARW 6.0 0.8 74 Com. Vladimirescu, Sat Vladimirescu ARAD STR. Strada Minerva , NR. 2 46.1657831 21.3909082 12.09.2023   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 14301
16177 16177 ROUA RESIDENCE RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 40 20 wedding 55 0 0 0 0   80 0 10.9 ARW 7.1 0.4 59 Com. Vladimirescu, Sat Vladimirescu ARAD STR. Strada Roma , NR. 37, 39, 41, 43, 45 46.1634927 21.4047125 05.11.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 44821
16250 16250 CRISS & SAM RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 50 26 wedding 55 0 0 0 0   80 10 6.2 ARW 2.4 2.4 388 Mun. Arad ARAD STR. Calea Zimandului 46.1989993 21.3383378 14.03.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 33991
16259 16259 DOR-TIN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 30 16 wedding 55 0 0 0 0   80 10 6.1 ARW 2.2 2.2 391 Mun. Arad ARAD NR. 50 46.1968431 21.3381779 12.12.2016   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 30400
16281 16281 HOFFMANN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 40 20 wedding 55 0 0 0 0   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD STR. Strada Adam M. Guttenbrunn , NR. 90 46.1865606 21.3122677 29.03.2024   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 23660
16286 16286 JOHANNA RO stay guesthouses guesthouse normal 3 star 3 - STELE 41 15 wedding 55 0 0 0 0   80 10 6.3 ARW 2.3 2.3 393 Mun. Arad ARAD STR. Calea Radnei , NR. 109 46.1800408 21.3459991 21.02.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 11797/7327
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
16335 16335 ROUA 2 RO stay guesthouses guesthouse normal 3 star 3 - STELE 38 20 wedding 55 0 0 0 0   80 10 8.0 ARW 4.0 2.8 330 Mun. Arad ARAD STR. Strada Păuliş , NR. 1-3 46.1764402 21.3679403 07.03.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 7222/5199
16339 16339 SELECT RO stay guesthouses guesthouse normal 3 star 3 - STELE 33 14 wedding 55 0 0 0 0   80 10 6.4 ARW 2.4 2.4 390 Mun. Arad ARAD STR. Calea Radnei , NR. 117 46.179758 21.346847 29.04.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - STELE 14292
16354 16354 SUBCETATE RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 34 17 wedding 55 0 0 0 0   80 10 5.4 ARW 2.7 2.7 379 Mun. Arad ARAD STR. Strada Gladiator , NR. 1 46.1612414 21.3305484 10.03.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 22864
16399 16399 SOFIA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 14 wedding 55 0 0 0 0   70 30 13.2 ARW 17.3 2.1 4 Oraş Pecica, Sat Pecica ARAD STR. Strada 1 46.1727861 21.0930242 04.12.2020   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 22438
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
16422 16422 PĂSTRĂVARIA BRĂTIOARA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 15 wedding 55 0 0 0 0   45 0 59.7 GHV 32.5 0.1 36 Com. Albeştii de Muşcel, Sat Albeşti ARGEŞ NR. 219 45.3088669 25.0068461 12.08.2015   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 12317/8550
16423 16423 SATU MUSCELEAN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 34 17 wedding 55 0 0 0 0   45 0 59.7 GHV 32.5 0.1 36 Com. Albeştii de Muşcel, Sat Albeşti ARGEŞ   45.3088669 25.0068461 11.09.2020   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 21020
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
16457 16457 ADONIS RO stay guesthouses guesthouse normal 3 flower 3 - MARGARETE 32 14 wedding 55 0 0 0 0   55 0 68.0 SBZ 20.4 0.3 96 Com. Arefu, Sat Căpăţânenii Pământeni ARGEŞ   45.3162504 24.6458936 21.02.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - MARGARETE 13865
16459 16459 BELLA VISTA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 38 15 wedding 55 0 0 0 0   55 0 66.1 SBZ 22.2 0.2 89 Com. Arefu, Sat Căpăţânenii Pământeni ARGEŞ NR. 198 45.3319547 24.6355824 25.01.2021   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 11394/7187
16462 16462 CASA IULIANA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 80 38 wedding 55 0 0 0 0   55 0 68.0 SBZ 20.4 0.3 96 Com. Arefu, Sat Căpăţânenii Pământeni ARGEŞ NR. 99 45.3162504 24.6458936 19.01.2022   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 24266
16468 16468 IULIANA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 34 15 wedding 55 0 0 0 0   55 0 68.0 SBZ 20.4 0.3 96 Com. Arefu, Sat Căpăţânenii Pământeni ARGEŞ NR. 99 45.3162504 24.6458936 05.05.2012   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 8296/5506
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
16488 16488 MARA RO stay guesthouses rooms_to_rent normal 2 star 2 - STELE 98 49 wedding 55 0 0 0 0   50 20 95.1 SBZ 9.9 1.6 3 Com. Băiculeşti, Sat Băiculeşti ARGEŞ NR. 15 45.0468638 24.7000642 29.07.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 2 - STELE 31342
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
16558 16558 LAC CĂLINEŞTI RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 15 wedding 55 0 0 0 0   40 20 92.1 OTP 11.0 1.2 4 Com. Călineşti, Sat Călineşti ARGEŞ   44.8761248 25.0185889 29.01.2021   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 22672
16578 16578 BELVEDERE RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 35 14 wedding 55 0 0 0 0   55 0 68.7 SBZ 19.5 0.9 96 Com. Corbeni, Sat Corbeni ARGEŞ NR. 215 45.3089679 24.6477727 06.06.2011   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 14156
16579 16579 CASA LĂZĂROIU RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 84 42 wedding 65 0 0 0 0   55 0 71.2 SBZ 16.8 0.5 66 Com. Corbeni, Sat Corbeni ARGEŞ   45.2846283 24.6553387 15.04.2021   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 20532
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
16600 16600 POMI RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 15 wedding 55 0 0 0 0   55 0 73.4 SBZ 13.7 0.3 48 Com. Corbeni, Sat Oeştii Ungureni ARGEŞ   45.2558346 24.6485954 18.05.2012   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 17955
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
16634 16634 SERAFIN RO stay guesthouses guesthouse normal 3 flower 3 - MARGARETE 47 15 wedding 55 0 0 0 0   55 0 34.6 GHV 12.3 1.5 113 Com. Dâmbovicioara, Sat Ciocanu ARGEŞ NR. 46 B 45.4622452 25.2463835 18.08.2016   RO-SITUR PENSIUNE TURISTICĂ 3 - MARGARETE 30066
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
16660 16660 BELVEDERE HAVEN RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 30 15 wedding 55 0 0 0 0   55 0 42.3 GHV 20.0 2.0 107 Com. Dâmbovicioara, Sat Podu Dâmboviţei ARGEŞ NR. 7C 45.4043981 25.1910064 31.10.2023   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 36648
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
16681 16681 NEDEEA 2 RO stay guesthouses rooms_to_rent normal 3 star 3 - STELE 44 22 wedding 55 0 0 0 0   55 10 39.1 GHV 17.3 3.8 106 Com. Dâmbovicioara, Sat Podu Dâmboviţei ARGEŞ STR. Punctul Dealul Sasului 45.4157835 25.2387093 04.02.2025   RO-SITUR CAMERE DE ÎNCHIRIAT 3 - STELE 41109
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
16727 16727 DIANA RO stay guesthouses guesthouse normal 3 flower 3 - FLORI 30 15 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. 204A 44.9218035 24.8675884 16.08.2017   RO-SITUR PENSIUNE TURISTICĂ 3 - FLORI 30661
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

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