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

847 rows where country = "ES", family = "rural" and rating_value = 2

This data as json, CSV (advanced)

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

rating_value 1

group 1

family 1

  • rural · 847 ✖

country 1

  • ES · 847 ✖

common_areas 0

best_for 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
458380 458380 Casa Batlles ES stay rural rural_agritourism normal 2 flower 2 Espigues 5     35 0 0 0 0   65 0 30.6 Folgueroles Airfield 7.8 0.0 61 Bigues i Riells del Fai del Fai Vallès Oriental Carrer Cal Batlles s/n 41.6833 2.2333     ES-CAT Turisme rural 2 Espigues PB-000407
458518 458518 Masia Casa Nova de n'Illa ES stay rural rural_agritourism normal 2 flower 2 Espigues 8     35 0 0 0 0   80 0 27.1 Folgueroles Airfield 5.9 0.0 104 Fogars de Montclús Vallès Oriental Disseminat CASA NOVA de NILLA 112 41.7333 2.45     ES-CAT Turisme rural 2 Espigues PB-001591
458569 458569 Cal Masover del Codinach ES stay rural rural_agritourism normal 2 flower 2 Espigues 10     35 0 0 0 0   70 10 20.4 Folgueroles Airfield 10.3 3.9 68 Sant Agustí de Lluçanès Osona Disseminat El Codinach s/n 42.0833 2.1333     ES-CAT Turisme rural 2 Espigues PCC-000088
458596 458596 Les Corts de Cal Farrés ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   55 10 64.5 BCN 17.7 4.9 262 Calonge de Segarra Anoia Carrer Cal Farrés s/n 41.7364 1.5729     ES-CAT Turisme rural 2 Espigues PCC-000155
458613 458613 Casa Nova del Codinach ES stay rural rural_agritourism normal 2 flower 2 Espigues 7     35 0 0 0 0   70 10 19.3 Folgueroles Airfield 12.2 3.4 54 Sant Agustí de Lluçanès Osona Disseminat El Codinach s/n 42.0451 2.1093     ES-CAT Turisme rural 2 Espigues PCC-000194
458628 458628 Cal Terrisco ES stay rural rural_agritourism normal 2 flower 2 Espigues 7     35 0 0 0 0   70 10 18.0 Folgueroles Airfield 14.6 0.0 8 Olost Lluçanès Carrer Cal Terrisco s/n 41.9853 2.0944     ES-CAT Turisme rural 2 Espigues PCC-000213
458785 458785 La Tina de Betlem ES stay rural rural_agritourism normal 2 flower 2 Espigues 5     35 0 0 0 0   55 0 57.0 Folgueroles Airfield 13.5 0.0 21 Fonollosa Bages Carrer Cal Betlem s/n 41.7627 1.6684     ES-CAT Turisme rural 2 Espigues PCC-000487
458904 458904 La Casa Xica del Codinach ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   70 10 19.3 Folgueroles Airfield 12.2 3.4 54 Sant Agustí de Lluçanès Osona Disseminat El Codinach s/n 42.0451 2.1093     ES-CAT Turisme rural 2 Espigues PCC-000762
458905 458905 Cal Sabata -Eixam- ES stay rural rural_agritourism normal 2 flower 2 Espigues 8     35 0 0 0 0   70 30 18.6 Folgueroles Airfield 13.6 6.1 6 Estany, l' Moianès Carrer Major 15 41.8692 2.1122     ES-CAT Turisme rural 2 Espigues PCC-000763
459065 459065 Cal Sabata -LA BRESCA- ES stay rural rural_agritourism normal 2 flower 2 Espigues 3     35 0 0 0 0   70 30 18.6 Folgueroles Airfield 13.6 6.1 6 Estany, l' Moianès Carrer Major 15 41.8692 2.1122     ES-CAT Turisme rural 2 Espigues PCC-001017
459066 459066 Cal Sabata -EL BUC- ES stay rural rural_agritourism normal 2 flower 2 Espigues 2     35 0 0 0 0   70 30 18.6 Folgueroles Airfield 13.6 6.1 6 Estany, l' Moianès Carrer Major 15 41.8692 2.1122     ES-CAT Turisme rural 2 Espigues PCC-001018
459372 459372 MAS EL CONTALLER ES stay rural rural_agritourism normal 2 flower 2 Espigues 5     35 0 0 0 0   80 10 26.1 Folgueroles Airfield 8.0 4.4 171 Sant Feliu de Pallerols Garrotxa Urbanització Veïnat dels Bastons (el Contaller) 10 42.1167 2.5333     ES-CAT Turisme rural 2 Espigues PG-000277
459373 459373 MAS EL CONTALLER ES stay rural rural_agritourism normal 2 flower 2 Espigues 10     35 0 0 0 0   80 10 26.1 Folgueroles Airfield 8.0 4.4 171 Sant Feliu de Pallerols Garrotxa Urbanització dels Bastons 10 42.1167 2.5333     ES-CAT Turisme rural 2 Espigues PG-000278
459535 459535 MAS MOLERA TURISME RURAL SL MASOVERIA PIC DE LES BRUIXES ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   65 10 33.7 Folgueroles Airfield 4.7 2.2 47 Sant Joan les Fonts Garrotxa Barri MOLERA s/n 42.2016 2.5393     ES-CAT Turisme rural 2 Espigues PG-000508
459536 459536 MAS MOLERA TURISME RURAL,SL MASOVERIA BASSEGODA ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   65 10 33.7 Folgueroles Airfield 4.7 2.2 47 Sant Joan les Fonts Garrotxa Barri MOLERA s/n 42.2016 2.5393     ES-CAT Turisme rural 2 Espigues PG-000509
459808 459808 Can Gat Vell III - La Solana ES stay rural rural_agritourism normal 2 flower 2 Espigues 2     35 0 0 0 0   70 10 28.2 GRO 14.0 3.6 119 Saus, Camallera i Llampaies Alt Empordà Carrer Puig 3 42.1225 2.9361     ES-CAT Turisme rural 2 Espigues PG-000868
460199 460199 Cal Serni ES stay rural rural_agritourism normal 2 flower 2 Espigues 15     35 0 0 0 0   70 10 6.0 LEU 15.2 2.4 109 Valls de Valira, les Alt Urgell Plaça MAJOR 1 42.3798 1.4572     ES-CAT Turisme rural 2 Espigues PL-000207
460208 460208 Casa Artigues I ES stay rural rural_agritourism normal 2 flower 2 Espigues 8     35 0 0 0 0   70 10 6.0 LEU 15.2 2.4 109 Valls de Valira, les Alt Urgell Carrer Major s/n 42.3798 1.4572     ES-CAT Turisme rural 2 Espigues PL-000219
460209 460209 Casa Artigues II ES stay rural rural_agritourism normal 2 flower 2 Espigues 8     35 0 0 0 0   70 10 6.0 LEU 15.2 2.4 109 Valls de Valira, les Alt Urgell Carrer Major s/n 42.3798 1.4572     ES-CAT Turisme rural 2 Espigues PL-000220
460363 460363 ALLOTJAMENT RURAL CASA ROS 2 ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   55 30 33.0 ILD 24.8 5.5 13 Àger Noguera Carrer ARRABAL S/N 41.9981 0.6996     ES-CAT Turisme rural 2 Espigues PL-000521
460372 460372 Cal Roset 2 ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   60 10 26.5 LEU 32.9 4.5 237 Rialp Pallars Sobirà Carrer Cal Roset s/n 42.4533 1.1265     ES-CAT Turisme rural 2 Espigues PL-000541
460374 460374 Cal Pallerola -La Serra ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   70 20 17.5 LEU 27.1 7.7 23 Vansa i Fórnols, la Alt Urgell Carrer Cal Pallerola s/n 42.2333 1.5667     ES-CAT Turisme rural 2 Espigues PL-000543
460376 460376 Cal Camats 2 ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   55 30 50.9 ILD 27.6 5.3 7 Artesa de Segre Noguera Carrer Afores s/n 41.933 1.084     ES-CAT Turisme rural 2 Espigues PL-000545
460427 460427 CASA COIX 1 PEDRA ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   60 10 26.5 LEU 32.9 4.5 237 Rialp Pallars Sobirà Carrer CASA COIX (PEDRA) 1 42.4533 1.1265     ES-CAT Turisme rural 2 Espigues PL-000626
460430 460430 L'Hort del Metge 1 ES stay rural rural_agritourism normal 2 flower 2 Espigues 7     35 0 0 0 0   70 20 29.3 LEU 25.1 8.4 51 Vall de Cardós Pallars Sobirà Carretera Tavascan s/n 42.564 1.225     ES-CAT Turisme rural 2 Espigues PL-000630
460431 460431 L'Hort del Metge 2 ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   55 30 34.0 LEU 25.5 13.9 50 Vall de Cardós Pallars Sobirà Carretera Tavascan s/n 42.6205 1.2497     ES-CAT Turisme rural 2 Espigues PL-000631
460460 460460 Franch ES stay rural rural_agritourism normal 2 flower 2 Espigues 8     35 0 0 0 0   45 0 37.6 LEU 36.4 0.0 129 Espot Pallars Sobirà Carrer Ratera 7 42.5784 1.0867     ES-CAT Turisme rural 2 Espigues PL-000679
460549 460549 Cal Camats 3 ES stay rural rural_agritourism normal 2 flower 2 Espigues 4     35 0 0 0 0   55 30 50.9 ILD 27.6 5.3 7 Artesa de Segre Noguera Camí Afores s/n 41.933 1.084     ES-CAT Turisme rural 2 Espigues PL-000790
461913 461913 Casa De Los Camellos ES stay rural rural_agritourism normal 2 star 2 Palmeras 24 12   35 0 0 0 0   80 20 6.6 LPA 0.1 0.1 1 Aguimes Gran Canaria Progreso (El), - Esq. Retama, 12 27.906132 -15.446871     ES-CAN Hotel Rural 2 Palmeras  
461915 461915 Hacienda Del Buen Suceso (La) ES stay rural rural_agritourism normal 2 star 2 Palmeras 35 18   45 0 0 0 0   80 20 25.9 LPA 1.1 1.1 2 Arucas Gran Canaria Carretera De Arucas A Bañaderos, Km. 1, 28.126361 -15.532036     ES-CAN Hotel Rural 2 Palmeras  
461916 461916 Cortijo De San Ignacio Golf ES stay rural rural_agritourism normal 2 star 2 Palmeras 34 18   45 0 0 0 0   80 30 9.9 LPA 4.0 4.0 3 Telde Gran Canaria Autopista Del Sur Gc-1, Km.6,4, 28.020804 -15.393899     ES-CAN Hotel Rural 2 Palmeras  
461920 461920 Mahoh ES stay rural rural_agritourism normal 2 star 2 Palmeras 18 9   35 0 0 0 0   80 40 19.3 FUE 2.1 2.1 0 La Oliva Fuerteventura Francisco Bordón Méndez, 1 28.620956 -13.910687     ES-CAN Hotel Rural 2 Palmeras  
461921 461921 Los Rugama ES stay rural rural_agritourism normal 2 star 2 Palmeras 26 13   35 0 0 0 0   80 50 10.4 FUE 9.6 9.2 0 Puerto Del Rosario Fuerteventura Sitio De Dª Isabel Rugama, S/N 28.491591 -13.960927     ES-CAN Hotel Rural 2 Palmeras  
461925 461925 Finca De La Florida ES stay rural rural_agritourism normal 2 star 2 Palmeras 30 15   45 0 0 0 0   80 20 7.5 ACE 2.0 2.0 1 San Bartolome Lanzarote El Islote, 90 29.00911 -13.631267     ES-CAN Hotel Rural 2 Palmeras  
461926 461926 Finca De Las Salinas ES stay rural rural_agritourism normal 2 star 2 Palmeras 38 19   45 0 0 0 0   80 20 15.4 ACE 0.3 0.3 1 Yaiza Lanzarote La Cuesta, 17 28.954635 -13.762764     ES-CAN Hotel Rural 2 Palmeras  
461927 461927 Embajador Del Atlantico, El ES stay rural rural_agritourism normal 2 star 2 Palmeras 26 13   35 0 0 0 0   70 0 23.5 ACE 12.1 0.2 21 Yaiza Lanzarote La Tegala, 30 28.862409 -13.827421     ES-CAN Hotel Rural 2 Palmeras  
461932 461932 Finca Salamanca ES stay rural rural_agritourism normal 2 star 2 Palmeras 39 20   45 0 0 0 0   80 20 19.8 TFN 1.1 1.1 3 Guimar Tenerife Ctra. Guimar - El Puertito, Km.1,5, 28.312932 -16.401251     ES-CAN Hotel Rural 2 Palmeras  
461933 461933 San Miguel ES stay rural rural_agritourism normal 2 star 2 Palmeras 32 16   45 0 0 0 0   80 20 7.5 TFS 0.3 0.3 4 San Miguel De Abona Tenerife C/ Las Morales, 2, 2-4 28.097054 -16.619558     ES-CAN Hotel Rural 2 Palmeras  
461934 461934 Patio, El ES stay rural rural_agritourism normal 2 star 2 Palmeras 38 18   45 0 0 0 0   65 20 40.4 TFS 2.7 2.4 6 Garachico Tenerife Finca Malpais, 11, 11 28.376434 -16.739065     ES-CAN Hotel Rural 2 Palmeras  
461935 461935 Victoria ES stay rural rural_agritourism normal 2 star 2 Palmeras 28 14   35 0 0 0 0   80 0 20.8 TFN 0.3 0.3 69 La Orotava Tenerife Hermano Apolinar, 8, 8 28.388255 -16.525202     ES-CAN Hotel Rural 2 Palmeras  
461937 461937 Ohana ES stay rural rural_agritourism normal 2 star 2 Palmeras 20 7   35 0 0 0 0   80 40 6.7 TFN 6.4 6.0 2 El Rosario Tenerife C/ Preventorio, 17, 17 28.429233 -16.37289     ES-CAN Hotel Rural 2 Palmeras  
461938 461938 La Raya 1866 ES stay rural rural_agritourism normal 2 star 2 Palmeras 15 6   35 0 0 0 0   80 20 20.0 TFN 1.0 1.0 3 Guimar Tenerife C/. La Raya, 25 (Barrio De La Hoya) , 28.316723 -16.420253     ES-CAN Hotel Rural 2 Palmeras  
461939 461939 Finca San Juan ES stay rural rural_agritourism normal 2 star 2 Palmeras 16 8   35 0 0 0 0   65 20 31.2 TFN 5.9 0.7 1 San Juan De La Rambla Tenerife C/ Mazape 28.391005 -16.643748     ES-CAN Hotel Rural 2 Palmeras  
461940 461940 Caserio Los Partidos ES stay rural rural_agritourism normal 2 star 2 Palmeras 21 11   35 0 0 0 0   55 30 37.1 TFS 10.0 3.4 2 El Tanque Tenerife C/ Los Partidos De Franquis, 4 , 28.316109 -16.791982     ES-CAN Hotel Rural 2 Palmeras  
461943 461943 Costa Magica Suites &Amp; Spa ES stay rural rural_agritourism normal 2 star 2 Palmeras 22 12   35 0 0 0 0   80 40 8.1 TFN 7.6 5.2 1 San Cristobal De La Laguna Tenerife Cmno. La Costa, S/N. (Finca Oasis), 28.542595 -16.388754     ES-CAN Hotel Rural 2 Palmeras  
461945 461945 Quinta Roja, La ES stay rural rural_agritourism normal 2 star 2 Palmeras 40 20   45 0 0 0 0   65 10 41.1 TFS 5.1 0.1 8 Garachico Tenerife Glorieta San Francisco, S/N., S/N 28.373423 -16.764264     ES-CAN Hotel Rural 2 Palmeras  
461947 461947 Cañas, Las ES stay rural rural_agritourism normal 2 star 2 Palmeras 12 7   35 0 0 0 0   80 10 26.5 TFN 0.2 0.2 17 Los Realejos Tenerife C/. Del Medio Arriba, 21, 40 28.378436 -16.585293     ES-CAN Hotel Rural 2 Palmeras  
461948 461948 Casablanca ES stay rural rural_agritourism normal 2 star 2 Palmeras 40 20   45 0 0 0 0   80 30 29.4 TFN 3.3 3.3 5 Los Realejos Tenerife C/ Real, 146, 146 28.381918 -16.619211     ES-CAN Hotel Rural 2 Palmeras  
461950 461950 Finca El Navio ES stay rural rural_agritourism normal 2 star 2 Palmeras 15 8   35 0 0 0 0   65 20 31.2 TFS 4.8 3.2 13 Guia Isora Tenerife Prolongación Avda. Los Pescadores, S/N, S/N 28.211437 -16.828331     ES-CAN Hotel Rural 2 Palmeras  
461957 461957 Hotel Escuela Rural Casa De Los Herrera ES stay rural rural_agritourism normal 2 star 2 Palmeras 16 8   35 0 0 0 0                 Hermigua La Gomera Ctra. General Tf-711,Barrio De La Encarnación,         ES-CAN Hotel Rural 2 Palmeras  
463071 463071 MONTE DEL TEJO ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   45 20 66.9 TOJ 55.1 8.6 32 Montejo de la Sierra   CALLE del Pozo 23, 28190 41.0885 -3.4174     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-108
463073 463073 EL PONTIFICAL ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   80 20 17.3 TOJ 7.4 0.0 2 Santos de la Humosa, Los   CALLE del Río Henares 3, 28817 40.4997 -3.2533     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-113
463075 463075 CAPELLANIA DE MENDOZA ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   45 30 50.3 MAD 34.7 5.8 11 Puentes Viejas   CTRA del Berrueco 9,200, 28754 40.9448 -3.6017     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-115
463079 463079 EL JARDIN ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   55 20 35.8 Madrid-Cuatro Vientos Airport 16.7 0.0 4 Aldea del Fresno   CTRA Madrid 12, 28620 40.3236 -4.2032     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-119
463093 463093 CASA RURAL ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   55 0 30.8 Getafe Air Base 14.6 0.0 40 Chinchón   CALLE de la Sociedad de Cosecheros 5, 28370 40.1402 -3.4227     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-139
463098 463098 SIERRA DE ORIENTE ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0                 Guadarrama   AVIA A-6 51,500         ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-147
463104 463104 EL YELMO ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   55 10 35.7 MAD 11.0 0.0 15 Manzanares el Real   AVDA de la Pedriza 67, 28410 40.7263 -3.8627     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-159
463115 463115 LAS CONCHAS ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   80 10 28.2 Getafe Air Base 2.9 2.9 78 San Martín de Valdeiglesias   CALLE Ancha 7, 28680 40.057 -3.6048     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-171
463185 463185 CASTILLO DE MARIBEL ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   45 30 50.3 MAD 34.7 5.8 11 Puentes Viejas   CTRA del Berrueco 9,200, 28754 40.9448 -3.6017     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-22
463205 463205 MIRADOR LA MALICIOSA ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   55 10 35.7 MAD 11.0 0.0 15 Manzanares el Real   AVDA de la Pedriza 60, 28410 40.7263 -3.8627     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-51
463249 463249 LOS CORRALES DE SOTO ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   55 20 33.7 MAD 10.5 0.0 4 Soto del Real   AVDA de España 3, 28791 40.7526 -3.7802     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-338
463291 463291 TORREBLANCA ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   65 10 42.3 Madrid-Cuatro Vientos Airport 8.3 0.0 14 Guadarrama   CALLE Doctor Gómez Ruiz 7, 28440 40.6727 -4.0895     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-220
463335 463335 LUNA LLENA ES stay rural rural_agritourism normal 2 star 2-HOJA DE ROBLE       35 0 0 0 0   70 0 28.8 MAD 17.8 1.0 24 Torremocha de Jarama   PLAZA de Tercia 1, 28189 40.7516 -3.5956     ES-MAD HOTEL RURAL 2-HOJA DE ROBLE TR-301
560936 560936 CA EVARISTA I ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   65 10 73.3 VLC 6.7 3.4 40 ATZÚBIA, L' ALICANTE/ALACANT C LA PLAZA S/N 38.8753 -0.1712     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000183-A
560937 560937 CA EVARISTA II ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   65 10 73.3 VLC 6.7 3.4 40 ATZÚBIA, L' ALICANTE/ALACANT C LA PLAZA S/N 38.8753 -0.1712     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000184-A
560938 560938 LA RUTA NARANJA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 12     35 0 0 0 0   65 10 73.3 VLC 6.7 3.4 40 ATZÚBIA, L' ALICANTE/ALACANT PD FOIES, POLIGONO 3, PARCELA 175 S/N 38.8753 -0.1712     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000452-A
560939 560939 CASA CARMEN ATZENETA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ C VERDUNC 1 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000824-CS
560940 560940 CAL MASOVER ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 6     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ CR Xodos, km 3, 4, Mas El Mangranar 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000131-CS
560941 560941 CASA DAMIÁ ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 14     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ MAS DEL MAGRANAR S/N 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000130-CS
560942 560942 EL COLOMER ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 8     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ MAS DEL MAGRANAR S/N 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000129-CS
560943 560943 LA ROQUETA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ MAS DEL MAGRANAR S/N 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000132-CS
560944 560944 MASIA DE ATALAYA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 2     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ MS DE ATALAYA (BUZÓN 8) 4 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000739-CS
560945 560945 MAS DELS CANALISOS ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 8     35 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ PD Meanes s/n 40.189 -0.2164     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000689-CS
560946 560946 CA LA BASTERA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 8     35 0 0 0 0   45 0 39.1 TEV 35.0 0.1 23 ADEMUZ VALENCIA/VALÈNCIA ALDEA MAS DEL OLMO Nº 209 40.0626 -1.2862     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000667-V
560947 560947 LA CRIBA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 6     35 0 0 0 0   45 0 39.1 TEV 35.0 0.1 23 ADEMUZ VALENCIA/VALÈNCIA C EMPEDRADO 25 40.0626 -1.2862     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000561-V
560948 560948 CASA GARRIDO ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 10     35 0 0 0 0   45 0 39.1 TEV 35.0 0.1 23 ADEMUZ VALENCIA/VALÈNCIA C Solano 6 40.0626 -1.2862     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000077-V
560949 560949 CASA DEL PASTOR ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 2     35 0 0 0 0   45 0 39.1 TEV 35.0 0.1 23 ADEMUZ VALENCIA/VALÈNCIA C Vallado 74 40.0626 -1.2862     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000320-V
560950 560950 CASA RURAL ANA MARIA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 6     35 0 0 0 0   65 0 48.1 CDT 8.5 0.9 25 AÍN CASTELLÓN/CASTELLÓ C SARAGOSSA 1 39.9186 -0.34     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000846-CS
560951 560951 Allotjament Rural Mar de Fonts ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   65 0 48.1 CDT 8.5 0.9 25 AÍN CASTELLÓN/CASTELLÓ Carrer de L'Aigua 41 39.9186 -0.34     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000876-CS
560952 560952 L'AMAGATALL ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 7     35 0 0 0 0   65 0 48.1 CDT 8.5 0.9 25 AÍN CASTELLÓN/CASTELLÓ CARRER MAJOR 8 39.9186 -0.34     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000872-CS
560953 560953 CASA RURAL MARMALLO - AIN ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   65 0 48.1 CDT 8.5 0.9 25 AÍN CASTELLÓN/CASTELLÓ CL ENMIG 9 - PB 39.9186 -0.34     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000875-CS
560954 560954 EL BALCON DE LA SAFOR ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 15     35 0 0 0 0   65 0 66.5 VLC 5.5 0.0 54 ADOR VALENCIA/VALÈNCIA C ERMITA 46 38.9267 -0.2203     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000463-V
560955 560955 EL RIURAU DE SECUNDINA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 4     35 0 0 0 0   65 10 72.8 ALC 6.8 3.5 3319 ADOR VALENCIA/VALÈNCIA PD COLLADO NÚM. 2, POL. 7, PARC 70 S/N 38.6912 0.0952     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000515-V
560956 560956 CASA CARMEN ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 9     35 0 0 0 0   65 10 55.5 ALC 9.1 0.4 17 AGRES ALICANTE/ALACANT C FUERA 4 38.7801 -0.516     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000074-A
560957 560957 CASA ASSUT ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 6     35 0 0 0 0   65 10 55.5 ALC 9.1 0.4 17 AGRES ALICANTE/ALACANT C JAUME MIQUEL 21 38.7801 -0.516     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000044-A
560958 560958 CASA ANTOLI II ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 6     35 0 0 0 0   65 10 55.5 ALC 9.1 0.4 17 AGRES ALICANTE/ALACANT C VERGE D'AGRES 2-APTO-1-2 38.7801 -0.516     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000432-A
560959 560959 MASIA SAN JOAQUÍN II ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 15     35 0 0 0 0   65 10 55.5 ALC 9.1 0.4 17 AGRES ALICANTE/ALACANT CR AGRES-MURO K7 38.7801 -0.516     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000172-A
560960 560960 MASÍA SAN JOAQUÍN ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 12     35 0 0 0 0   65 10 55.5 ALC 9.1 0.4 17 AGRES ALICANTE/ALACANT MASÍA SAN JOAQUÍN 38.7801 -0.516     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000071-A
560961 560961 JAUME I ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 8     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C Jaume I 27 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000641-CS
560962 560962 CA MIQUELET ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 15     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C major 5 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000399-CS
560963 560963 CASA EL PASSADIS ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 8     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C SAN PABLO 13 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000105-CS
560964 560964 CASA LA TORRE ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 8     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C SAN PABLO 15 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000106-CS
560965 560965 CASA MARI CARMEN ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 6     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C Tras La Iglesia 12 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000015-CS
560966 560966 CASA SALES ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 7     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C TRAS LA IGLESIA 22 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000011-CS
560967 560967 LA VILETA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 7     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ C VILETA 22 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000378-CS
560968 560968 CASA VIRGINIA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 10     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ CALLE VIRGEN DEL PILAR 2 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000907-CS
560969 560969 MAS D'EN CAMANYES ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 10     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ MAS D'EN CAMANYES 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000021-CS
560970 560970 MAS D'EN CAMANYES B ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 12     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ MAS D'EN CAMANYES S7N 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000218-CS
560971 560971 MAS DE LA SEMOLA ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 12     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ MS MAS DE LA SÉMOLA 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000022-CS
560972 560972 MAS DE SANT PAU ES stay rural rural_agritourism normal 2 star DOS ESTRELLAS 14     35 0 0 0 0   60 0 15.5 CDT 33.5 0.0 23 ALBOCÀSSER CASTELLÓN/CASTELLÓ PD SANT PAU S/N 40.35 0.0333     ES-GVA Casa rural DOS ESTRELLAS CV-ARU000165-CS

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