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

216 rows where country = "ES", family = "self_catering_villas" and rating_value = 2

This data as json, CSV (advanced)

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

rating_value 1

group 1

family 1

  • self_catering_villas · 216 ✖

country 1

  • ES · 216 ✖

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
375808 375808 Sense especificar ES stay self_catering_villas self_catering normal 2 key 2 claus 6     35 0 0 0 0   55 0 33.9 Folgueroles Airfield 13.3 0.0 22 Navàs Bages Carrer Sant Jordi 13 41.798 1.9543     ES-CAT Habitatges d'ús turístic 2 claus HUTCC-078604
383221 383221 Sense especificar ES stay self_catering_villas self_catering normal 2 key 2 claus       35 0 0 0 0   80 0 25.4 GRO 0.3 0.3 1423 Blanes Selva Carrer Pi 21 41.6767 2.788     ES-CAT Habitatges d'ús turístic 2 claus HUTG-008453
453945 453945 CALS IAIOS ES stay self_catering_villas self_catering normal 2 key 2 claus 9     35 0 0 0 0   45 0 63.0 REU 35.0 0.0 22 Vilalba dels Arcs Terra Alta Carrer ESGLESIA 4 41.1167 0.4167     ES-CAT Habitatges d'ús turístic 2 claus HUTTE-066773
469690 469690 MILENIO ES stay self_catering_villas self_catering normal 2 star 2 71     45 0 0 0 0   80 10 3.0 VIT 2.6 2.6 53 Vitoria-Gasteiz Araba/Álava   42.8627155804156 -2.69923823209798     ES-EUS Apartamentos 2 TVI00002
469691 469691 MUGARRI ES stay self_catering_villas self_catering normal 2 star 2 32     45 0 0 0 0   80 20 18.1 BIO 7.8 2.5 8 Muskiz Bizkaia   43.3452886841736 -3.12638645711353     ES-EUS Apartamentos 2 TBI00004
469695 469695 SOLAR DE QUINTANO ES stay self_catering_villas self_catering normal 2 star 2 22     35 0 0 0 0   55 20 33.0 VIT 16.4 0.1 5 Labastida/Bastida Araba/Álava   42.5905461096349 -2.79516516094751     ES-EUS Apartamentos 2 TVI00005
469880 469880 MUNDAKA ES stay self_catering_villas self_catering normal 2 star 2 0     35 0 0 0 0   80 0 20.6 BIO 2.5 0.3 33 Mundaka Bizkaia   43.4053157862084 -2.7000174444629     ES-EUS Apartamentos 2 TBI00005
469942 469942 TALAIMENDI ES stay self_catering_villas self_catering normal 2 star 2 34     45 0 0 0 0   65 0 30.3 EAS 1.6 1.6 104 Zarautz Gipuzkoa   43.2822777533009 -2.15062898566287     ES-EUS Apartamentos 2 TSS00008
469962 469962 DREAM PARK ES stay self_catering_villas self_catering normal 2 star 2 191   wedding 65 0 0 0 0   80 0 7.1 VIT 1.8 1.8 49 Vitoria-Gasteiz Araba/Álava   42.850100103165 -2.65018405095321     ES-EUS Apartamentos 2 TVI00009
470001 470001 RINCON DE AIARA ES stay self_catering_villas self_catering normal 2 star 2 12     35 0 0 0 0   70 30 26.5 BIO 10.5 7.8 8 Ayala/Aiara Araba/Álava   43.0949358065535 -3.07333983620966     ES-EUS Apartamentos 2 TVI00010
470012 470012 IRENAZ VITORIA ES stay self_catering_villas self_catering normal 2 star 2 208   wedding 65 0 0 0 0   80 10 3.1 VIT 2.5 2.5 53 Vitoria-Gasteiz Araba/Álava   42.8653011183222 -2.69498900655657     ES-EUS Apartamentos 2 TVI00012
470024 470024 LARRAGO ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   80 0 19.3 BIO 4.8 0.2 31 Busturia Bizkaia   43.3814995385958 -2.69845360540528     ES-EUS Apartamentos 2 TBI00010
470054 470054 SPIRIT APARTAMENTOS ATXURI ES stay self_catering_villas self_catering normal 2 star 2 222   wedding 65 0 0 0 0   80 0 5.8 BIO 0.6 0.6 180 Bilbao Bizkaia   43.2493799858494 -2.92024751993812     ES-EUS Apartamentos 2 TBI00011
470065 470065 ENDARA ES stay self_catering_villas self_catering normal 2 star 2 20     35 0 0 0 0   80 0 7.8 EAS 2.6 1.7 32 Lezo Gipuzkoa   43.325926558089 -1.87725696858255     ES-EUS Apartamentos 2 TSS00011
470105 470105 URETA ES stay self_catering_villas self_catering normal 2 star 2 24     35 0 0 0 0   80 10 17.7 BIO 5.4 1.9 16 Bakio Bizkaia   43.4320139113427 -2.78624754236884     ES-EUS Apartamentos 2 TBI00013
470117 470117 MAÑARINEGI ES stay self_catering_villas self_catering normal 2 star 2 21     35 0 0 0 0   80 10 28.6 EAS 6.0 3.2 35 Aia Gipuzkoa   43.2500188751622 -2.11240656714834     ES-EUS Apartamentos 2 TSS00016
470126 470126 MENDIZABAL ESTUDIOAK ES stay self_catering_villas self_catering normal 2 star 2 33     45 0 0 0 0   55 10 46.7 VIT 14.6 0.2 16 Lazkao Gipuzkoa   43.0308957615853 -2.18706912642902     ES-EUS Apartamentos 2 TSS00017
470131 470131 LUSARBE ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   80 10 25.4 EAS 6.3 3.2 38 Orio Gipuzkoa   43.2948754356547 -2.09279004148785     ES-EUS Apartamentos 2 TSS00018
470139 470139 LA PIKURUTZA ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   70 20 23.5 RJL 18.3 0.1 4 Bernedo Araba/Álava   42.6269767069231 -2.4992279626098     ES-EUS Apartamentos 2 TVI00016
470140 470140 LAGAR DE ELCIEGO ES stay self_catering_villas self_catering normal 2 star 2 12     35 0 0 0 0   70 10 25.0 RJL 14.7 0.2 15 Elciego Araba/Álava   42.5142041656825 -2.61823941628041     ES-EUS Apartamentos 2 TVI00017
470157 470157 CABAÑAS EN LOS ARBOLES ES stay self_catering_villas self_catering normal 2 star 2 22     35 0 0 0 0   70 20 18.8 VIT 14.4 3.0 6 Zeanuri Bizkaia   43.0502667129939 -2.69595253116242     ES-EUS Apartamentos 2 TBI00016
470181 470181 BAPS ES stay self_catering_villas self_catering normal 2 star 2 25     35 0 0 0 0   80 0 5.1 BIO 0.7 0.7 185 Bilbao Bizkaia   43.256777179899 -2.92840720189953     ES-EUS Apartamentos 2 TBI00018
470360 470360 ERMITABARRI ES stay self_catering_villas self_catering normal 2 star 2 16     35 0 0 0 0   80 30 18.3 BIO 9.4 4.3 4 Zeberio Bizkaia   43.1466869974287 -2.83349101428186     ES-EUS Apartamentos 2 TBI00022
470366 470366 ANDRA MARI ES stay self_catering_villas self_catering normal 2 star 2 20     35 0 0 0 0   80 0 20.3 BIO 0.0 0.0 27 Bermeo Bizkaia   43.4207532747114 -2.72104172479875     ES-EUS Apartamentos 2 TBI00024
470370 470370 ELAI ETXEA BIRDING HOUSE ES stay self_catering_villas self_catering normal 2 star 2 13     35 0 0 0 0   70 40 17.8 VIT 13.0 9.2 5 Erriberagoitia/Ribera Alta Araba/Álava   42.8002538330046 -2.91087069859467     ES-EUS Apartamentos 2 TVI00021
470377 470377 SALBIDE APARTAMENTUAK ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 32.2 EAS 0.5 0.5 111 Zarautz Gipuzkoa   43.2828034961353 -2.17536741396686     ES-EUS Apartamentos 2 TSS00061
470385 470385 LEGAZPIDOCE ES stay self_catering_villas self_catering normal 2 star 2 24     35 0 0 0 0   80 0 16.0 EAS 1.2 1.2 200 Donostia / San Sebastián Gipuzkoa   43.3218567648845 -1.98236763111937     ES-EUS Apartamentos 2 TSS00065
470400 470400 BILBAO MUSEUMS APARTMENTS ES stay self_catering_villas self_catering normal 2 star 2 26     35 0 0 0 0   80 0 4.2 BIO 0.8 0.8 190 Bilbao Bizkaia   43.2673256435024 -2.93334301132024     ES-EUS Apartamentos 2 TBI00032
470401 470401 APARTAMENTOS DIVAN ES stay self_catering_villas self_catering normal 2 star 2 160   wedding 65 0 0 0 0   80 10 3.5 VIT 2.1 2.1 53 Vitoria-Gasteiz Araba/Álava   42.8614682078712 -2.69352205146485     ES-EUS Apartamentos 2 TVI00020
470406 470406 URAIN ES stay self_catering_villas self_catering normal 2 star 2 20     35 0 0 0 0   55 10 41.9 EAS 10.2 4.1 35 Deba Gipuzkoa   43.2742632327615 -2.29570359910193     ES-EUS Apartamentos 2 TSS00069
470414 470414 GANEXA HOME ZARAUTZ ES stay self_catering_villas self_catering normal 2 star 2 7     35 0 0 0 0   65 0 32.2 EAS 0.5 0.5 111 Zarautz Gipuzkoa   43.2825920381049 -2.17543216408172     ES-EUS Apartamentos 2 TSS00062
470433 470433 Museum Zarautz ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 32.3 EAS 0.6 0.6 107 Zarautz Gipuzkoa   43.2846665050249 -2.17741500163146     ES-EUS Apartamentos 2 TSS00075
470468 470468 ZARAUTZ ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 32.3 EAS 0.6 0.6 108 Zarautz Gipuzkoa   43.2843334533597 -2.17690887567771     ES-EUS Apartamentos 2 TSS00104
470478 470478 CASERIO MONTEHERMOSO ES stay self_catering_villas self_catering normal 2 star 2 11     35 0 0 0 0   70 30 29.6 VIT 24.6 3.9 3 Valdegovía/Gaubea Araba/Álava   42.8817875437622 -3.08795039106658     ES-EUS Apartamentos 2 TVI00026
470498 470498 SATIA BERRI ES stay self_catering_villas self_catering normal 2 star 2 24     35 0 0 0 0   70 30 26.0 BIO 11.4 7.8 8 Ayala/Aiara Araba/Álava   43.1100982021395 -3.09531410622345     ES-EUS Apartamentos 2 TVI00028
470507 470507 MIROTZA APARTMENTS ES stay self_catering_villas self_catering normal 2 star 2 38     45 0 0 0 0   80 0 28.6 EAS 3.7 0.3 89 Orio Gipuzkoa   43.2763200889235 -2.12619933250938     ES-EUS Apartamentos 2 TSS00105
470544 470544 RUMIN ENEA ES stay self_catering_villas self_catering normal 2 star 2 15     35 0 0 0 0   70 20 27.0 RJL 20.0 1.4 2 Lagrán Araba/Álava   42.6242436135869 -2.56663625580953     ES-EUS Apartamentos 2 TVI00030
470547 470547 HONDARMENDI ES stay self_catering_villas self_catering normal 2 star 2 16     35 0 0 0 0   80 0 19.8 BIO 1.5 1.2 27 Kortezubi Bizkaia   43.32452491957 -2.66753173638562     ES-EUS Apartamentos 2 TBI00050
470561 470561 ISAGA ES stay self_catering_villas self_catering normal 2 star 2 31     45 0 0 0 0   65 0 31.7 EAS 0.1 0.1 111 Zarautz Gipuzkoa   43.2854588629001 -2.16961905037396     ES-EUS Apartamentos 2 TSS00115
470562 470562 GOZAMENA ZARAUTZ ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 31.5 EAS 0.3 0.3 115 Zarautz Gipuzkoa   43.2834913529466 -2.16706167997257     ES-EUS Apartamentos 2 TSS00113
470563 470563 HATOR ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 32.3 EAS 0.5 0.5 109 Zarautz Gipuzkoa   43.2836595419448 -2.17657596414711     ES-EUS Apartamentos 2 TSS00112
470570 470570 LIMEHOME SAN SEBASTIAN ZUBIETA KALEA 3 ES stay self_catering_villas self_catering normal 2 star 2 30     45 0 0 0 0   80 0 16.4 EAS 1.0 1.0 207 Donostia / San Sebastián Gipuzkoa   43.3164356216516 -1.98625961555087     ES-EUS Apartamentos 2 TSS00132
470589 470589 KAIXO BILBAO ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   80 0 5.3 BIO 0.9 0.9 185 Bilbao Bizkaia   43.2554021855868 -2.93002618579118     ES-EUS Apartamentos 2 TBI00061
470623 470623 ANA ISABEL VERGARA SOPEÑA ES stay self_catering_villas self_catering normal 2 star 2 5     35 0 0 0 0   80 0 15.8 EAS 2.3 0.7 111 Astigarraga Gipuzkoa   43.278767284222 -1.95354708497126     ES-EUS Apartamentos 2 TSS00093
470662 470662 KANTABRIKO BERRI ZARAUTZ ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 32.3 EAS 0.6 0.6 109 Zarautz Gipuzkoa   43.283501630726 -2.17738882453177     ES-EUS Apartamentos 2 TSS00140
470665 470665 MANTULENE - BASQUE STAY ES stay self_catering_villas self_catering normal 2 star 2 34     45 0 0 0 0   80 0 17.2 EAS 1.9 1.9 228 Donostia / San Sebastián Gipuzkoa   43.2989396475408 -1.98806202575796     ES-EUS Apartamentos 2 TSS00141
470678 470678 MUNDAKAPORT ES stay self_catering_villas self_catering normal 2 star 2 36     45 0 0 0 0   80 0 20.9 BIO 2.4 0.0 33 Mundaka Bizkaia   43.4078361156338 -2.69829080721227     ES-EUS Apartamentos 2 TBI00067
470680 470680 ZORROZA BILBAO APARTAMENTOS ES stay self_catering_villas self_catering normal 2 star 2 4     35 0 0 0 0   80 10 5.7 BIO 2.5 2.5 183 Bilbao Bizkaia   43.2772140519458 -2.97276027832025     ES-EUS Apartamentos 2 TBI00069
470681 470681 B48 Abando ES stay self_catering_villas self_catering normal 2 star 2 34     45 0 0 0 0   80 0 4.6 BIO 0.2 0.2 187 Bilbao Bizkaia   43.2615399642574 -2.92657266127631     ES-EUS Apartamentos 2 TBI00070
470707 470707 ITSASO APARTAMENTUAK ES stay self_catering_villas self_catering normal 2 star 2 5     35 0 0 0 0   65 0 34.1 EAS 3.6 0.1 93 Getaria Gipuzkoa   43.302568761109 -2.2060210873487     ES-EUS Apartamentos 2 TSS00142
470708 470708 3KABI ES stay self_catering_villas self_catering normal 2 star 2 12     35 0 0 0 0   65 0 32.2 EAS 0.6 0.6 107 Zarautz Gipuzkoa   43.2863606333172 -2.17651290004752     ES-EUS Apartamentos 2 TSS00128
470716 470716 ARAOTZEKO OSTATUA ES stay self_catering_villas self_catering normal 2 star 2 19     35 0 0 0 0   80 30 25.0 VIT 8.5 5.9 7 Oñati Gipuzkoa   42.9917361433555 -2.45596301514379     ES-EUS Apartamentos 2 TSS00143
470717 470717 APARTAMENTOS IPARRAGUIRRE ES stay self_catering_villas self_catering normal 2 star 2 18     35 0 0 0 0   55 0 32.8 BIO 14.5 0.9 21 Ispaster Bizkaia   43.35951358 -2.5135792     ES-EUS Apartamentos 2 TBI00080
470719 470719 Kresala Tourist Apartments ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   65 0 32.1 EAS 0.4 0.4 111 Zarautz Gipuzkoa   43.28249055 -2.17441742     ES-EUS Apartamentos 2 TSS00144
470726 470726 SAGARMINTXE ES stay self_catering_villas self_catering normal 2 star 2 16     35 0 0 0 0   55 10 36.5 BIO 14.4 0.6 14 Berriatua Bizkaia   43.31416321 -2.45993881     ES-EUS Apartamentos 2 TBI00081
470738 470738 APARTAMENTOS TURISTICOS VASCO GALLEGA ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   70 0 23.6 RJL 14.4 0.3 23 Laguardia Araba/Álava   42.55240223 -2.58244511     ES-EUS Apartamentos 2 TVI00032
470764 470764 DORRE LUZEA APARTAMENTUAK ES stay self_catering_villas self_catering normal 2 star 2 12     35 0 0 0 0   65 0 32.0 EAS 0.4 0.4 111 Zarautz Gipuzkoa   43.2860624301486 -2.17399884715969     ES-EUS Apartamentos 2 TSS00151
470767 470767 TALAIA ETA OTORIO APARTAMENTU TURISTIKOAK ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   55 10 33.3 BIO 15.1 0.3 19 Lekeitio Bizkaia   43.3634496 -2.50845307     ES-EUS Apartamentos 2 TBI00094
470779 470779 SOLATSU BASERRIA ES stay self_catering_villas self_catering normal 2 star 2 20     35 0 0 0 0   65 10 30.6 VIT 7.3 1.8 8 Elorrio Bizkaia   43.13136553 -2.5620122     ES-EUS Apartamentos 2 TBI00099
470799 470799 APARTAMENTOS ITURRIONDO ES stay self_catering_villas self_catering normal 2 star 2 12     35 0 0 0 0   80 0 18.4 BIO 0.7 0.7 29 Gernika-Lumo Bizkaia   43.31000848 -2.68331355     ES-EUS Apartamentos 2 TBI00110
470804 470804 LOS OJOS DEL ALAI ES stay self_catering_villas self_catering normal 2 star 2 14     35 0 0 0 0   55 20 33.2 VIT 16.7 0.3 5 Labastida/Bastida Araba/Álava   42.58866889 -2.79186704     ES-EUS Apartamentos 2 TVI00034
470808 470808 TRAVESÍA APARTMENTS ES stay self_catering_villas self_catering normal 2 star 2 12     35 0 0 0 0   80 0 3.7 BIO 0.7 0.7 191 Bilbao Bizkaia   43.2687892 -2.92230559     ES-EUS Apartamentos 2 TBI00114
470815 470815 COPLA BILBAO ES stay self_catering_villas self_catering normal 2 star 2 165   wedding 65 0 0 0 0   80 0 4.4 BIO 0.5 0.5 190 Bilbao Bizkaia   43.26472986 -2.93048095     ES-EUS Apartamentos 2 TBI00118
470818 470818 LURBERI APARTAMENTUAK ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   80 0 18.8 BIO 0.7 0.7 29 Gernika-Lumo Bizkaia   43.31116467 -2.67820412     ES-EUS Apartamentos 2 TBI00121
470820 470820 SAGARDOTEGI ASTELARRA, S.L. ES stay self_catering_villas self_catering normal 2 star 2 22     35 0 0 0 0   80 0 18.3 BIO 3.8 0.8 27 Muxika Bizkaia   43.28231672 -2.68572575     ES-EUS Apartamentos 2 TBI00122
470836 470836 APARTAMENTOS AMALURRA ES stay self_catering_villas self_catering normal 2 star 2 28     35 0 0 0 0   70 20 26.1 BIO 16.4 4.3 7 Artzentales Bizkaia   43.2355496406319 -3.21946274034203     ES-EUS Apartamentos 2 TBI00044
470845 470845 BE10 SUITES APARTMENTS ES stay self_catering_villas self_catering normal 2 star 2 41     45 0 0 0 0   80 0 20.2 BIO 0.1 0.1 28 Bermeo Bizkaia   43.42018571 -2.72235499     ES-EUS Apartamentos 2 TBI00086
470846 470846 BILBAO LOFT APARTMENTS ES stay self_catering_villas self_catering normal 2 star 2 8     35 0 0 0 0   80 0 4.0 BIO 0.4 0.4 189 Bilbao Bizkaia   43.26586777 -2.92189018     ES-EUS Apartamentos 2 TBI00092
470863 470863 ITXASLEMA ES stay self_catering_villas self_catering normal 2 star 2 6     35 0 0 0 0   65 0 32.3 EAS 0.6 0.6 108 Zarautz Gipuzkoa   43.28451848 -2.17681095     ES-EUS Apartamentos 2 TSS00153
470875 470875 MADDIOLA ES stay self_catering_villas self_catering normal 2 star 2 20     35 0 0 0 0   80 10 25.4 EAS 6.4 3.1 38 Orio Gipuzkoa   43.2936814510303 -2.0923987504438     ES-EUS Apartamentos 2 TSS00063
470886 470886 SAN FERMIN ES stay self_catering_villas self_catering normal 2 star 2 58     45 0 0 0 0   80 10 2.8 VIT 2.8 2.8 52 Vitoria-Gasteiz Araba/Álava   42.8648002339327 -2.70064355619577     ES-EUS Apartamentos 2 TVI00001
470893 470893 UHARTE SUITES, GERNIKA ES stay self_catering_villas self_catering normal 2 star 2 9     35 0 0 0 0   80 0 19.1 BIO 0.7 0.7 28 Gernika-Lumo Bizkaia   43.31903876 -2.67572172     ES-EUS Apartamentos 2 TBI00108
470899 470899 ZENITAN RELAX ES stay self_catering_villas self_catering normal 2 star 2 24     35 0 0 0 0   65 10 32.2 VIT 6.1 1.1 8 Elorrio Bizkaia   43.13922144 -2.53973072     ES-EUS Apartamentos 2 TBI00129
562547 562547 MAGALLUF PLAYA III ES stay self_catering_villas self_catering normal 2 key 2 claus 189 54 wedding 65 0 0 0 0   80 0 18.3 PMI 6.6 0.2 112 Magaluf CALVIÀ GALIO, 9. 07182 Magaluf, CALVIÀ, Mallorca 39.50994596009981 2.5329193699624604     ES-BAL Apartaments turístics 2 claus AT/1046
562549 562549 PARQUE MAR ES stay self_catering_villas self_catering normal 2 key 2 claus 544 150 wedding 65 0 0 0 0   55 0 47.1 PMI 13.8 1.8 82 Cala D´Or SANTANYÍ PARC DE LA MAR, S/N. 07660 Cala D´Or, SANTANYÍ, Mallorca 39.36244870707152 3.229977371452841     ES-BAL Apartaments turístics 2 claus AT/1048
562551 562551 SALAS I ES stay self_catering_villas self_catering normal 2 key 2 claus 24 4   35 0 0 0 0   55 10 44.7 PMI 15.9 4.7 33 Cala Figuera SANTANYÍ Carrer TOMARINAR, 15. 07659 Cala Figuera, SANTANYÍ, Mallorca 39.32778743039851 3.170743483200681     ES-BAL Apartaments turístics 2 claus AT/1115
562552 562552 LAS PALOMAS APARTAMENTOS ECONOTELS ES stay self_catering_villas self_catering normal 2 key 2 claus 135 64 wedding 55 0 0 0 0   80 0 17.8 PMI 5.9 0.8 114 Palmanova CALVIÀ Carrer DUC D´EXTREMERA-SON MATIAS, 7. 07181 Palmanova, CALVIÀ, Mallorca 39.518148896074564 2.5354956253042378     ES-BAL Apartaments turístics 2 claus AT/1117
562554 562554 PONENT ES stay self_catering_villas self_catering normal 2 key 2 claus 40 8   45 0 0 0 0   55 0 64.2 PMI 26.6 0.3 100 Cala Rajada CAPDEPERA VIA MENORCA, 2. 07590 Cala Rajada, CAPDEPERA, Mallorca 39.71142029804171 3.459837694366632     ES-BAL Apartaments turístics 2 claus AT/1144
562558 562558 Nura Houses Magaluf ES stay self_catering_villas self_catering normal 2 key 2 claus 64 9   45 0 0 0 0   80 0 18.4 PMI 7.1 0.7 105 Magaluf CALVIÀ Avinguda MAGALLUF, 2. 07182 Magaluf, CALVIÀ, Mallorca 39.505224628324136 2.5323880522630122     ES-BAL Apartaments turístics 2 claus AT/1162
562560 562560 LEO ES stay self_catering_villas self_catering normal 2 key 2 claus 45 9   45 0 0 0 0   65 0 49.7 PMI 6.9 0.6 53 Port De Pollença POLLENÇA GOMMAR, S/N. 07470 Port De Pollença, POLLENÇA, Mallorca 39.909378875246 3.0879577540581464     ES-BAL Apartaments turístics 2 claus AT/1166
562564 562564 ESTANQUES ES stay self_catering_villas self_catering normal 2 key 2 claus 44 9   45 0 0 0 0                 Colònia De Sant Jordi SES SALINES ESTANCS, 33-35. 07638 Colònia De Sant Jordi, SES SALINES, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1207
562572 562572 CALA BLANCA ES stay self_catering_villas self_catering normal 2 key 2 claus 84 30 wedding 55 0 0 0 0   80 0 17.7 PMI 6.1 0.6 113 Palmanova CALVIÀ DUC D´EXTREMERA, 8. 07181 Palmanova, CALVIÀ, Mallorca 39.51666417040613 2.5368509684666054     ES-BAL Apartaments turístics 2 claus AT/1258
562576 562576 HELIOS ES stay self_catering_villas self_catering normal 2 key 2 claus 108 36 wedding 55 0 0 0 0                 Can Pastilla PALMA CARABELA S/N, S/N         ES-BAL Apartaments turístics 2 claus AT/1266
562585 562585 LAS PIRAMIDES ES stay self_catering_villas self_catering normal 2 key 2 claus 282 94 wedding 65 0 0 0 0   65 0 45.7 PMI 1.8 0.4 98 Port D´Alcúdia ALCÚDIA Carrer MINERVA, 24. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca 39.83730938828573 3.122658315207254     ES-BAL Apartaments turístics 2 claus AT/1309
562588 562588 DRAC ES stay self_catering_villas self_catering normal 2 key 2 claus 24 5   35 0 0 0 0   55 10 42.8 PMI 15.4 3.1 30 Cala Santanyí SANTANYÍ SA COSTA DE DRAC, 15. 07659 SANTANYÍ, Mallorca 39.33082621725635 3.146700294731968     ES-BAL Apartaments turístics 2 claus AT/1331
562589 562589 ALDEA CALA FORNELLS II ES stay self_catering_villas self_catering normal 2 key 2 claus 120 40 wedding 55 0 0 0 0   80 0 25.1 PMI 6.1 0.2 105 Peguera CALVIÀ Carrer L´ESPIGA, 9. 07160 Peguera, CALVIÀ, Mallorca 39.536011613577024 2.4464639853493497     ES-BAL Apartaments turístics 2 claus AT/1335
562594 562594 APARTAMENTOS FALCÓ ES stay self_catering_villas self_catering normal 2 key 2 claus 54 9   45 0 0 0 0   65 0 48.1 PMI 5.5 1.1 57 Port De Pollença POLLENÇA Carrer DES FALCÓ, 21. 07470 Port De Pollença, POLLENÇA, Mallorca 39.89933017222917 3.0733023428580144     ES-BAL Apartaments turístics 2 claus AT/1356
562595 562595 SIESTA I ES stay self_catering_villas self_catering normal 2 key 2 claus 436 166 wedding 65 0 0 0 0   65 0 44.3 PMI 2.8 1.1 104 Port D´Alcúdia ALCÚDIA Avinguda PERE MAS REUS, 23. 07400 Port D´Alcúdia, ALCÚDIA, Mallorca 39.830035491474796 3.1089855441052863     ES-BAL Apartaments turístics 2 claus AT/1357
562596 562596 VICTORIA ES stay self_catering_villas self_catering normal 2 key 2 claus 86 27 wedding 55 0 0 0 0                 Port D´Alcúdia ALCÚDIA Avinguda Minerva, 13. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1360
562597 562597 APARTAMENTOS MAC SURFING PLAYA ES stay self_catering_villas self_catering normal 2 key 2 claus 222 74 wedding 65 0 0 0 0                 Santa Ponça CALVIÀ Avinguda REI JAUME I, 83. 07180 Santa Ponça, CALVIÀ, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1362
562603 562603 Apartamentos Cristina I ES stay self_catering_villas self_catering normal 2 key 2 claus 160 40 wedding 65 0 0 0 0   55 0 55.1 PMI 15.0 0.7 123 Cala Millor SON SERVERA Carrer S´AMETLER, 21. 07560 Cala Millor, SON SERVERA, Mallorca 39.60426457958191 3.3782139456157725     ES-BAL Apartaments turístics 2 claus AT/1427
562604 562604 Apartamentos Cristina II ES stay self_catering_villas self_catering normal 2 key 2 claus 168 34 wedding 65 0 0 0 0   55 0 55.1 PMI 15.0 0.7 123 Cala Millor SON SERVERA Carrer S´AMETLER, 21. 07560 Cala Millor, SON SERVERA, Mallorca 39.60426457958191 3.3782139456157725     ES-BAL Apartaments turístics 2 claus AT/1428
562606 562606 DON QUIJOTE ES stay self_catering_villas self_catering normal 2 key 2 claus 124 24 wedding 55 0 0 0 0   55 0 61.1 PMI 23.4 0.9 99 Cala Rajada CAPDEPERA CALA AGULLA, 117. 07590 Cala Rajada, CAPDEPERA, Mallorca 39.69703116581444 3.4273579135649506     ES-BAL Apartaments turístics 2 claus AT/1460
562607 562607 Apartamentos R2 Cala Millor ES stay self_catering_villas self_catering normal 2 key 2 claus 111 20 wedding 55 0 0 0 0   55 0 55.5 PMI 15.3 0.6 122 Cala Millor SON SERVERA Carrer SOL NAIXENT, S/N, S/N. 07560 Cala Millor, SON SERVERA, Mallorca 39.60067058961981 3.383389488649412     ES-BAL Apartaments turístics 2 claus AT/1462
562610 562610 APARTAMENTOS MARINA PALMANOVA ES stay self_catering_villas self_catering normal 2 key 2 claus 96 20 wedding 55 0 0 0 0   80 0 17.7 PMI 5.6 0.5 114 Palmanova CALVIÀ GERMANS MONCADA, 11. 07181 Palmanova, CALVIÀ, Mallorca 39.52073368489146 2.536095309801492     ES-BAL Apartaments turístics 2 claus AT/1490
562613 562613 OLIVE BEACH ES stay self_catering_villas self_catering normal 2 key 2 claus 50 20   45 0 0 0 0   65 0 45.8 PMI 1.6 0.6 96 Port D´Alcúdia ALCÚDIA DIANA, 8. 07400 ALCÚDIA, Mallorca 39.83893737516358 3.1219351711029923     ES-BAL Apartaments turístics 2 claus AT/1521
562614 562614 FERRER TAMARINDOS ES stay self_catering_villas self_catering normal 2 key 2 claus 88 44 wedding 55 0 0 0 0   65 0 45.5 PMI 1.8 0.3 98 Port D´Alcúdia ALCÚDIA Carrer CIBELES, 1. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca 39.83688332737392 3.12059066706489     ES-BAL Apartaments turístics 2 claus AT/1522
562620 562620 CASA VIDA ES stay self_catering_villas self_catering normal 2 key 2 claus 109 45 wedding 55 0 0 0 0   80 0 22.5 PMI 6.2 0.7 157 Santa Ponça CALVIÀ VIA REY SANCHO,10, S/N. 07180 Santa Ponça, CALVIÀ, Mallorca 39.5132828925812 2.4815259506025833     ES-BAL Apartaments turístics 2 claus AT/1544
562621 562621 BELLAMAR ES stay self_catering_villas self_catering normal 2 key 2 claus 81 27 wedding 55 0 0 0 0   65 0 48.1 PMI 5.8 1.2 56 Port De Pollença POLLENÇA Passeig LONDRES, 56. 07470 Port De Pollença, POLLENÇA, Mallorca 39.89677546122196 3.0785280176501035     ES-BAL Apartaments turístics 2 claus AT/1546
562623 562623 CALA DOR PARK ES stay self_catering_villas self_catering normal 2 key 2 claus 218 73 wedding 65 0 0 0 0   55 0 46.7 PMI 12.7 0.4 93 Cala D´Or SANTANYÍ RAVELL, S/N, S/N. 07660 Cala D´Or, SANTANYÍ, Mallorca 39.375327992834116 3.23252197725693     ES-BAL Apartaments turístics 2 claus AT/1550

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