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,470 rows where family = "self_catering_villas", group = "stay" and rating_value = 3

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_scheme, rating_label, fit_wedding, isolation_score, source_type, source_category, valid_until (date), stop_date (date)

country 6

rating_value 1

  • 3 · 10,470 ✖

group 1

  • stay · 10,470 ✖

family 1

  • self_catering_villas · 10,470 ✖

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
11136 11136 Killarney Lakeland Cottages IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   19   45 0 0 0 0   60 10 16.9 KIR 30.6 3.7 58 Killarney Kerry Muckross 52.03096 -9.48165     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08510
11137 11137 Quilty Holiday Cottages IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   24   45 0 0 0 0   45 30 37.7 SNN 30.7 4.1 5 Quilty Clare Caherush 52.8306 -9.44334     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08521
11140 11140 Doonbeg Holiday Cottages IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   7   45 0 0 0 0   45 40 44.0 SNN 41.0 8.7 2 Doonbeg Clare Caherlean 52.74591 -9.57385     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08593
11141 11141 Kinsale Holiday Village IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   9   45 0 0 0 0   70 10 14.7 ORK 13.9 1.0 14 Kinsale Cork Glanbeg 51.70971 -8.51654     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08615
11142 11142 Ardnagashel Estate IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   16   45 0 0 0 0   35 30 50.6 KIR 62.5 5.4 7 Ballylickey Cork Ardnagashel 51.72692 -9.47242     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08650
11143 11143 Dingle Marina Cottages IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   6   45 0 0 0 0   45 10 51.9 KIR 42.0 0.8 13 Dingle Kerry The Wood 52.14033 -10.2811     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08674
11147 11147 Robertstown Holiday Village IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   8   45 0 0 0 0   70 30 23.8 Weston Airport 10.2 0.4 0 Robertstown Kildare Lowtown Road 53.27199 -6.82206     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08694
11150 11150 Fairgreen Holiday Cottages IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star / 2 Star   15   45 0 0 0 0   60 20 10.2 CFN 40.4 0.5 2 Dungloe Donegal Meenmore 54.95319 -8.36593     IE-Failte Holiday Cottage Holiday Cottage - 3 Star / 2 Star SCS08723
11152 11152 Pipers Chair Houses IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   3   45 0 0 0 0   45 30 46.2 SNN 32.4 6.1 19 Doolin Clare Doolin Village, Fitz's Cross 53.01653 -9.37522     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08760
11154 11154 Isaacs Apartments IE stay self_catering_villas self_catering normal 3 star Holiday Apartment - 3 Star   11   45 0 0 0 0   80 0 6.9 ORK 0.4 0.4 24 Cork Cork 48 Maccurtain Street 51.90159 -8.46809     IE-Failte Holiday Apartment Holiday Apartment - 3 Star SCS09220
11191 11191 East Clare Holiday Village IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   8   45 0 0 0 0   55 30 31.1 SNN 26.2 4.4 1 Bodyke Clare Coolreagh 52.89988 -8.5976     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08800
11236 11236 Cluain Raite IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   10   45 0 0 0 0   70 20 7.1 SNN 13.8 3.0 9 Bunratty Clare Bunratty West 52.69887 -8.81978     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08832
11305 11305 Arranmore Holiday Village IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   8   45 0 0 0 0   60 40 12.5 CFN 49.2 9.7 3 Arranmore Donegal Arainn Mhor 54.98019 -8.50296     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS08889
11314 11314 Grange Lodge IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   45 40 49.8 NOC 45.4 4.8 0 Strokestown Roscommon Grange 53.82309 -8.07216     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL32572
11383 11383 Ballyvaughan Cottages IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   5   45 0 0 0 0   55 40 48.4 SNN 18.6 13.1 6 Ballyvaughan Clare Knocknagroagh 53.11571 -9.14875     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15823
11408 11408 Brielle House IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   65 20 61.5 Weston Airport 8.8 0.3 1 Mountmellick Laois Irishtown 53.11256 -7.32443     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15346
11420 11420 Carnakilla Cottages IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   5   45 0 0 0 0   65 30 75.5 NOC 7.6 7.6 6 Glasson Westmeath Carnakilla Point, Portlick 53.4903 -7.91605     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15536
11431 11431 Carrigmore Farm IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   55 40 48.2 SNN 27.6 3.7 0 Doon Limerick Carrig More 52.56995 -8.24465     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL34496
11435 11435 Cassidy Holiday Homes IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   2   45 0 0 0 0   45 20 32.3 ENK 57.1 0.9 3 Belturbet Cavan Cullighan 54.11164 -7.57278     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15012
11463 11463 Country Cottages IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   3   45 0 0 0 0   55 50 49.2 SNN 16.8 12.8 5 Ballyvaughan Clare Bishop's Quarter 53.12818 -9.12404     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15945
11488 11488 Dromatouk Cottage IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   45 10 32.8 KIR 44.1 2.8 26 Kenmare Kerry Droumatouk 51.8865 -9.54295     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15954
11490 11490 Droumkeal Cottage IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   35 30 49.7 KIR 61.0 6.4 6 Bantry Cork Dromduff West, Coomhola 51.73713 -9.43799     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15563
11491 11491 Drumkeeran Holiday Homes IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   4   45 0 0 0 0   55 60 31.6 SXL 23.4 11.8 0 Drumkeeran Leitrim Derrinweir 54.17349 -8.14934     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15484
11496 11496 Eagle View IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   55 20 45.3 Casement Air Base 15.3 1.8 2 Moone Kildare Belan Ave 52.96754 -6.83852     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15959
11517 11517 Garveys Cottage IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   45 50 60.0 KIR 50.4 9.2 0 Ventry Kerry Kilvickadownig 52.11206 -10.39576     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15604
11535 11535 Grattan House IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Apartment - 3 Star   7   45 0 0 0 0   65 0 63.2 SNN 1.7 1.7 35 Galway city Galway 103 Upper Salthill, Salthill 53.26334 -9.07114     IE-Failte Individual Self Catering Apartment Individual Self Catering Apartment - 3 Star SCL15137
11537 11537 Green Acres IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   60 30 21.0 NOC 57.7 4.4 2 Claremorris Mayo Ballinlough 53.79092 -9.0653     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15307
11540 11540 Rockview House IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   60 50 8.6 NOC 38.8 6.2 0 Charlestown Mayo Carracastle 53.94885 -8.70385     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15339
11545 11545 Harap Farm IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   4   45 0 0 0 0   80 20 7.3 DUB 3.5 3.5 8 Swords Dublin Magillstown, Balheary 53.49114 -6.22653     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15468
11552 11552 Horse House One IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   45 30 37.3 NOC 58.9 2.5 1 Ballina Mayo Prospect, Castlehill 54.07748 -9.31268     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15467
11556 11556 Inishmulclohy Lodge IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   80 20 2.6 SXL 8.0 1.3 3 Rosses Point Sligo Coney Island 54.30117 -8.58096     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15507
11568 11568 Killarney Haven Suites IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Apartment - 3 Star   10   45 0 0 0 0   70 0 13.4 KIR 26.7 0.2 65 Killarney Kerry 50 High Street 52.06082 -9.51062     IE-Failte Individual Self Catering Apartment Individual Self Catering Apartment - 3 Star SCL15128
11657 11657 Rathmines (Dublin 6) IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Apartment - 3 Star   2   45 0 0 0 0   80 0 11.6 DUB 1.8 0.7 105 Dublin 6 Dublin Apartment 5, 12A Grosvenor Square 53.32415 -6.27166     IE-Failte Individual Self Catering Apartment Individual Self Catering Apartment - 3 Star SCL15179
11663 11663 Riverbank Cottages IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   3   45 0 0 0 0                 Scarriff Clare Drewsboro         IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15335
11672 11672 Rolfs Holiday Cottages IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   4   45 0 0 0 0   35 40 72.7 ORK 70.3 10.5 7 Baltimore Cork Rolfs Country House, Baltimore Hilll 51.4796 -9.36859     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15048
11702 11702 Seaview Self Catering IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Apartment - 3 Star   4   45 0 0 0 0   80 0 11.4 DUB 2.6 0.9 99 Dublin 4 Dublin 21 Strand Road, Sandymount 53.33112 -6.21001     IE-Failte Individual Self Catering Apartment Individual Self Catering Apartment - 3 Star SCL15058
11708 11708 Shramore Lodge IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   80 20 11.6 SXL 8.2 1.5 3 Collooney Sligo Union Wood 54.19693 -8.49206     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15437
11754 11754 The White Cottage IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   55 20 61.9 NOC 21.6 4.8 9 Oughterard Galway Ardnasillagh 53.42021 -9.26176     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15547
11841 11841 Atlantic Apartotel IE stay self_catering_villas self_catering normal 3 star Holiday Apartment - 3 Star   35   45 0 0 0 0   55 20 30.6 SXL 26.6 0.5 5 Bundoran Donegal Main Street 54.48002 -8.2749     IE-Failte Holiday Apartment Holiday Apartment - 3 Star SCS40994
12240 12240 Árasaín Cholmcille IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Apartment - 3 Star   2   45 0 0 0 0                 Tory Island Donegal Derrybeg         IE-Failte Individual Self Catering Apartment Individual Self Catering Apartment - 3 Star SCL34359
12312 12312 Ballymalone More IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   55 20 36.8 SNN 21.5 2.0 6 Ballina Tipperary Ballymalone More 52.80647 -8.40565     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL24446
12458 12458 Ash Lodge IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   55 50 30.9 SXL 24.6 13.1 1 Sligo Sligo Flagfield, Geevagh 54.08283 -8.26576     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL40172
12519 12519 Glenview Bungalow IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0                 Ballinamore Leitrim Aghoo         IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL40405
12573 12573 Dingle Manor IE stay self_catering_villas self_catering normal 3 star Holiday Cottage - 3 Star   12   45 0 0 0 0   45 10 49.7 KIR 40.2 1.8 13 Dingle Kerry Ballintaggart House, Ballintaggart 52.13081 -10.24751     IE-Failte Holiday Cottage Holiday Cottage - 3 Star SCS41104
12671 12671 Rookery Mews Apartments IE stay self_catering_villas self_catering normal 3 star Holiday Apartment - 3 Star   16   45 0 0 0 0   70 0 14.0 KIR 27.7 1.1 62 Killarney Kerry Rookery Road, Ballycasheen 52.05667 -9.49399     IE-Failte Holiday Apartment Holiday Apartment - 3 Star SCS41539
12687 12687 Cliff View IE stay self_catering_villas self_catering normal 3 star Individual Self Catering Cottage - 3 Star   1   45 0 0 0 0   45 30 46.6 SNN 32.9 7.0 19 Doolin Clare Fisher Street 53.01373 -9.38838     IE-Failte Individual Self Catering Cottage Individual Self Catering Cottage - 3 Star SCL15476
15414 15414 AMAZONIS RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 6.6 BBU 1.3 1.3 2032       44.4438245 26.1106396 08.07.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 25226
15416 15416 ATLAS RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 6.6 BBU 1.3 1.3 2032       44.4438245 26.1106396 08.07.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 25225
15417 15417 OLYMPOS RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 6.8 BBU 1.1 1.1 2030       44.4422562 26.1094982 08.07.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 25224
15419 15419 PROMENADA ALEZZI APARTMENTS 1 RO stay self_catering_villas self_catering normal 3 star 3 - STELE       45 0 0 0 0   80 0 12.9 CND 2.7 1.1 2546       44.3013829 28.6261686     RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 23683
15420 15420 VIORICA RO stay self_catering_villas villa normal 3 star 3 - STELE       45 0 0 0 0   55 40 47.2 GHV 11.3 6.3 5       45.9446232442542 25.0201466882324     RO-SITUR VILĂ TURISTICĂ 3 - STELE 21973
15421 15421 SEAESTA MAMAIA NORD POOL AND SPA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   80 0 7.0 CRA 0.1 0.1 225     NR. 6G , ET. P , AP. 17 44.3174024 23.8000483 26.08.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 43724
15428 15428 CASUȚA DE LA MUNTE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   45 10 66.4 Câmpia Turzii Air Base 32.4 0.7 17 Com. Albac, Sat Albac ALBA STR. Strada Horea , NR. 55A 46.3624812 23.0436858 11.02.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 45639
15473 15473 MOARA TITULUI RO stay self_catering_villas self_catering normal 3 star 3 - STELE 9 2   45 0 0 0 0   45 0 78.6 CLJ 37.9 0.5 100 Com. Arieşeni, Sat Arieşeni ALBA NR. 1F 46.4739594 22.7624819 02.11.2021   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 27179
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
15520 15520 DEALUL FLORILOR RO stay self_catering_villas self_catering normal 3 star 3 - STELE 8 2   45 0 0 0 0   30 10 80.9 CLJ 37.8 2.2 85 Com. Arieşeni, Sat Galbena ALBA NR. 468A 46.4711678 22.7300433 11.02.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 45623
15538 15538 CASA SUFLETULUI 1 RO stay self_catering_villas self_catering normal 3 star 3 - STELE 6 1   45 0 0 0 0   30 20 80.7 CLJ 30.1 2.3 8 Com. Avram Iancu, Sat Călugăreşti ALBA NR. 277 46.4037656 22.7876464 19.12.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 37358
15553 15553 MELANIA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 2   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 APARTAMENTE DE ÎNCHIRIAT 3 - STELE 30243
15555 15555 RALPH CABIN RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   45 10 60.5 Câmpia Turzii Air Base 33.6 0.3 6 Com. Bucium, Sat Bucium ALBA STR. Strada Bucium , NR. 51 A 46.2652812 23.1763247 28.05.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 42770
15585 15585 ACASĂ LA AMERICANU RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   55 10 39.4 Câmpia Turzii Air Base 14.8 0.3 9 Com. Galda de Jos, Sat Benic ALBA STR. Strada Meteșeasca , NR. 3 46.2110291 23.5927968 09.02.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 45608
15626 15626 EMOŢIA MUNŢILOR RO stay self_catering_villas self_catering normal 3 star 3 - STELE 6 1   45 0 0 0 0   45 10 66.3 CLJ 41.0 2.1 51 Com. Horea, Sat Fericet ALBA NR. 231 46.4868374 22.9340922 05.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 35986
15642 15642 BLACK ROOF RO stay self_catering_villas self_catering normal 3 star 3 - STELE 6 1   45 0 0 0 0   55 10 68.0 Câmpia Turzii Air Base 26.7 0.4 13 Com. Horea, Sat Mătişeşti ALBA NR. 408/C 46.2769696 23.0615514 25.03.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 46282
15646 15646 CASĂ DE VACANȚĂ - CLARA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 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. 505 46.5069962 22.9061388 04.02.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 45586
15653 15653 MONTESSE CHALET RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   45 10 66.8 CLJ 43.4 3.7 32 Com. Horea, Sat Mătişeşti ALBA NR. 448 46.5144826 22.9052382 28.02.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 33724
15656 15656 DOR DE APUSENI RO stay self_catering_villas self_catering normal 3 star 3 - STELE 8 1   45 0 0 0 0   55 20 46.1 Câmpia Turzii Air Base 10.1 2.2 11 Com. Horea, Sat Preluca ALBA NR. 551A 46.1558924 23.5556121 18.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 36080
15662 15662 CASA GROSU RO stay self_catering_villas self_catering normal 3 star 3 - STELE 8 1   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. 441G 46.12337 23.5311306 05.09.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 32098
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
15689 15689 CASA LUI MOȘU RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   55 30 39.8 Câmpia Turzii Air Base 14.6 1.3 0 Com. Mihalţ, Sat Mihalţ ALBA NR. 665 46.1612206 23.7275736 17.12.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 41030
15722 15722 CĂSUŢA CU ALUNE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   55 20 36.7 Câmpia Turzii Air Base 16.5 2.1 10 Com. Râmeţ, Sat Valea Mănăstirii ALBA NR. 50A 46.3015557 23.5065476 21.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 36119
15724 15724 RELAX AND SMILE RÂMEȚ RO stay self_catering_villas self_catering normal 3 star 3 - STELE 16 4   45 0 0 0 0   55 10 35.9 Câmpia Turzii Air Base 15.6 1.1 10 Com. Râmeţ, Sat Valea Mănăstirii ALBA NR. 8A 46.3022901 23.51891 05.08.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 43495
15747 15747 COZY PLACE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   70 10 23.3 Câmpia Turzii Air Base 18.3 3.2 37 Com. Rimetea, Sat Rimetea ALBA   46.4758229 23.5837654 22.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 36154
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
15792 15792 PRATUM RO stay self_catering_villas self_catering normal 3 star 3 - STELE 14 7   45 0 0 0 0   55 10 35.8 Câmpia Turzii Air Base 11.8 0.2 8 Com. Stremţ, Sat Geoagiu de Sus ALBA STR. Strada Mănăstirii , NR. 343 46.2529017 23.5917174 21.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 36151
15838 15838 CASA RAREȘ ȚOC RO stay self_catering_villas self_catering normal 3 star 3 - STELE 8 1   45 0 0 0 0   55 10 75.0 CLJ 28.4 1.7 17 Com. Vidra, Sat Lunca ALBA NR. 187A 46.3734607 22.9091343 05.09.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 39449
15847 15847 AFRAME ALEXANDRU & FILIP RO stay self_catering_villas self_catering normal 3 star 3 - STELE 14 2   45 0 0 0 0   55 10 77.0 CLJ 27.1 0.4 16 Com. Vidra, Sat Vidra ALBA NR. 7B 46.3670051 22.8833842 05.09.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 39451
15852 15852 CASA CU SOARE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   65 10 53.0 SBZ 9.2 1.9 6 Com. Vinţu de Jos, Sat Pârâu lui Mihai ALBA NR. 24F 46.0121343 23.4836634 05.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 35975
15857 15857 SURÂSUL MUNTELUI RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   55 10 49.2 GHV 27.2 0.8 15 Dragoslavele ALBA   45.3415002 25.164822 08.12.2015   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 29284
15859 15859 CASA DEBRE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   80 10 24.9 Câmpia Turzii Air Base 0.1 0.1 17 Mun. Aiud ALBA STR. Strada Băilor , NR. 11 46.3095501 23.7209685 27.11.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 37022
15869 15869 209 RO stay self_catering_villas self_catering normal 3 star 3 - STELE 3 1   45 0 0 0 0   65 0 51.5 SBZ 2.0 2.0 170 Mun. Alba Iulia ALBA STR. Strada Vasile Goldiş , NR. 22A , BL. 12 , ET. 2 , AP. 109 46.0680258 23.5580337 28.05.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 42768
15870 15870 ALBA APARTMENT RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.0 SBZ 1.3 1.3 186 Mun. Alba Iulia ALBA STR. Strada Anghel Saligny , NR. 2K , ET. 4 , AP. 16 46.0780513 23.5789006 21.10.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 44585
15872 15872 ALBA CENTER RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   65 0 50.6 SBZ 0.9 0.9 187 Mun. Alba Iulia ALBA STR. Strada Tudor Vladimirescu , NR. 5 , BL. V2a , AP. 4 46.0742481 23.5800918 24.11.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 36974
15874 15874 ALBA PARC RESIDENCE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.2 SBZ 1.5 1.5 172 Mun. Alba Iulia ALBA STR. Bulevardul 1 Decembrie 1918 , BL. M5 , AP. 31 46.068115 23.5643187 13.11.2020   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 22232
15876 15876 ALEXANDRA RESIDENCE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 10 50.9 SBZ 2.0 2.0 169 Mun. Alba Iulia ALBA STR. Strada Brânduşei , NR. 49A , ET. 3 , AP. 32 46.0595631 23.5588274 23.03.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 46228
15881 15881 APARTAMENT 209 RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.5 SBZ 2.0 2.0 170 Mun. Alba Iulia ALBA STR. Strada Vasile Goldiş , NR. 22A , BL. 12 , AP. 109 46.0680258 23.5580337 05.09.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 39468
15886 15886 BEAR S APARTAMENT 2 ALBA IULIA RO stay self_catering_villas self_catering normal 3 flower 3 - MARGARETE 4 1   45 0 0 0 0   65 0 51.2 SBZ 1.5 1.5 172 Mun. Alba Iulia ALBA STR. Bulevardul 1 Decembrie 1918 , NR. 25 , BL. M3 , ET. 5 , AP. 17 46.0689557 23.5643593 05.09.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - MARGARETE 39469
15887 15887 BEAR S APARTMENT ALBA IULIA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 6 1   45 0 0 0 0   65 0 51.2 SBZ 1.5 1.5 171 Mun. Alba Iulia ALBA STR. Bulevardul 1 Decembrie 1918 , NR. 23 , BL. M2 , ET. 5 , AP. 19 46.0683286 23.5640397 05.09.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 39470
15889 15889 BLOOM RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.3 SBZ 1.4 1.4 172 Mun. Alba Iulia ALBA STR. Bulevardul Horea , NR. 30 , ET. 1 , AP. 1 46.0713142 23.5658919 02.12.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 40791
15890 15890 BOULEVARD FLAT RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.4 SBZ 1.6 1.6 171 Mun. Alba Iulia ALBA STR. Strada Arnsberg , NR. 1 , BL. B2 , AP. 42 46.07058 23.562967 07.12.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 32834
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
15892 15892 CAROLINA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.1 SBZ 1.2 1.2 191 Mun. Alba Iulia ALBA STR. Strada Septimius Severus , NR. 2B , ET. Parter , AP. 2 46.074562 23.5724877 28.05.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 42772
15894 15894 CAROLINE RESIDENCE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   65 0 50.6 SBZ 1.1 1.1 172 Mun. Alba Iulia ALBA STR. Strada Apulum , NR. 4 , BL. AC 26 , ET. 2 , AP. 12 46.0645218 23.568919 29.05.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 34663
15896 15896 CASA CAROLINA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 6 1   45 0 0 0 0   65 0 50.4 SBZ 1.8 1.8 171 Mun. Alba Iulia ALBA STR. Strada George Sand , NR. 6B 46.0566583 23.5645854 20.10.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 44525
15902 15902 CETĂŢII ALBA IULIA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.1 SBZ 1.2 1.2 191 Mun. Alba Iulia ALBA STR. Strada Septimius Severus , NR. 2B , ET. 2 , AP. 11 46.074562 23.5724877 07.12.2022   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 32828
15904 15904 CITADEL GARDEN RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 2   45 0 0 0 0   65 0 50.6 SBZ 1.3 1.3 172 Mun. Alba Iulia ALBA STR. Bulevardul Încoronării , NR. 59 46.0631585 23.5674175 28.04.2026   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 46533
15907 15907 COZEE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 10 48.8 SBZ 2.4 2.1 180 Mun. Alba Iulia ALBA STR. Strada Energiei , NR. 17 , BL. CE2 , ET. 2 , AP. 8 46.0756133 23.6118956 04.09.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 35893
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
15910 15910 CRIS RESIDENCE RO stay self_catering_villas self_catering normal 3 star 3 - STELE 4 1   45 0 0 0 0   65 0 51.3 SBZ 1.9 1.8 185 Mun. Alba Iulia ALBA STR. Strada Emil Racoviţă , NR. 31 , BL. 8 , ET. 3 , AP. 23 46.0837875 23.5800359 28.05.2025   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 42774
15913 15913 DERBY AH RO stay self_catering_villas self_catering normal 3 star 3 - STELE 12 6   45 0 0 0 0   65 0 50.2 SBZ 0.6 0.6 191 Mun. Alba Iulia ALBA STR. Strada Octavian Goga , NR. 27A 46.0641163 23.5762872 25.08.2023   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 35716
15922 15922 HERA RO stay self_catering_villas self_catering normal 3 star 3 - STELE 2 1   45 0 0 0 0   65 0 51.3 SBZ 1.4 1.4 172 Mun. Alba Iulia ALBA STR. Bulevardul Horea , NR. 30 , ET. 1 , AP. 2 46.0713142 23.5658919 02.12.2024   RO-SITUR APARTAMENTE DE ÎNCHIRIAT 3 - STELE 40794

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