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

171 rows where country = "ES", family = "rural" and rating_value = 3

This data as json, CSV (advanced)

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

rating_value 1

group 1

family 1

  • rural · 171 ✖

country 1

  • ES · 171 ✖

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
458334 458334 Turisme Rural Can Rosich ES stay rural rural_agritourism normal 3 flower 3 Espigues 15     45 0 0 0 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Camí de la riera s/n 41.6411 2.7111     ES-CAT Turisme rural 3 Espigues PB-000105
458384 458384 Can Japet ES stay rural rural_agritourism normal 3 flower 3 Espigues 10     45 0 0 0 0   55 10 42.4 REU 11.6 3.7 52 Torrelles de Foix Alt Penedès Carrer Sant Quintí 7 41.3833 1.5667     ES-CAT Turisme rural 3 Espigues PB-000456
458400 458400 Can Fàbregas del Bosch ES stay rural rural_agritourism normal 3 flower 3 Espigues 8     45 0 0 0 0   65 10 32.2 Folgueroles Airfield 2.9 2.2 129 Ametlla del Vallès, l' Vallès Oriental Carrer Can Fàbregas del Bosc s/n 41.6641 2.345     ES-CAT Turisme rural 3 Espigues PB-000520
458557 458557 Casa Sant Andreu ES stay rural rural_agritourism normal 3 flower 3 Espigues 5     45 0 0 0 0   55 0 57.0 Folgueroles Airfield 13.5 0.0 21 Fonollosa Bages Carrer Sant Andreu s/n 41.7627 1.6684     ES-CAT Turisme rural 3 Espigues PCC-000055
458564 458564 La Rovira ES stay rural rural_agritourism normal 3 flower 3 Espigues 13     45 0 0 0 0   70 10 27.3 Folgueroles Airfield 16.2 4.5 33 Sagàs Berguedà Carrer La Rovira 44 42.0 1.9833     ES-CAT Turisme rural 3 Espigues PCC-000079
458583 458583 Torre d'en Bofill ES stay rural rural_agritourism normal 3 flower 3 Espigues 15     45 0 0 0 0   55 0 51.0 Folgueroles Airfield 23.0 1.3 76 Cardona Bages Barri Segalers 97 41.9102 1.6934     ES-CAT Turisme rural 3 Espigues PCC-000128
458594 458594 La Cabana de Castelltallat ES stay rural rural_agritourism normal 3 flower 3 Espigues 12     45 0 0 0 0   55 20 50.5 Folgueroles Airfield 11.0 4.0 16 Sant Mateu de Bages Bages Carrer Cal Marquet s/n 41.8 1.7333     ES-CAT Turisme rural 3 Espigues PCC-000152
458605 458605 PLA DE MONTPOL. PCC-174 ES stay rural rural_agritourism normal 3 flower 3 Espigues 12     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Lladurs Solsonès Cases CASA PLA DE MONTPOL s/n 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000174
458626 458626 Casa Call ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Odèn Solsonès Carrer Casa Call s/n 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000210
458646 458646 Casa Call 2 ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Odèn Solsonès Carrer Casa Call s/n 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000238
458647 458647 Casa Call 3 ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Odèn Solsonès Carrer Casa Call s/n 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000239
458687 458687 La Farraja ES stay rural rural_agritourism normal 3 flower 3 Espigues 6     45 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 3 Espigues PCC-000307
458692 458692 Cobert de la Casanova de la Salada ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Lladurs Solsonès Carretera Sant Llorenç KM 12,6 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000313
458696 458696 PLA 2. PCC-319 ES stay rural rural_agritourism normal 3 flower 3 Espigues 7     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Lladurs Solsonès Cases CASA PLA DE MONTPOL s/n 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000319
458697 458697 PLA 3. PCC-320 ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Lladurs Solsonès Cases CASA PLA DE MONTPOL s/n 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000320
458768 458768 CAL VIUDET VELL ES stay rural rural_agritourism normal 3 flower 3 Espigues 7     45 0 0 0 0   55 10 39.0 Folgueroles Airfield 10.2 4.0 49 Casserres Berguedà Disseminat Afores Cal Viudet Vell s/n 0 42.0126 1.8422     ES-CAT Turisme rural 3 Espigues PCC-000457
458776 458776 SAUQUER PCC-473 ES stay rural rural_agritourism normal 3 flower 3 Espigues 9     45 0 0 0 0   70 30 25.6 LEU 27.2 13.1 64 Lladurs Solsonès Disseminat TORRA DE MONTPOL S/N 42.1231 1.5181     ES-CAT Turisme rural 3 Espigues PCC-000473
458806 458806 Terradelles ES stay rural rural_agritourism normal 3 flower 3 Espigues 12     45 0 0 0 0   65 0 39.8 Folgueroles Airfield 4.2 0.0 114 Avià Berguedà Carrer Can Terradellas s/n 42.0667 1.85     ES-CAT Turisme rural 3 Espigues PCC-000516
458889 458889 Cal Joan Pau ES stay rural rural_agritourism normal 3 flower 3 Espigues 9     45 0 0 0 0   55 20 64.5 BCN 15.0 5.6 35 Pujalt Anoia Carrer Cal Joan Pau s/n 41.6833 1.5     ES-CAT Turisme rural 3 Espigues PCC-000745
458891 458891 Les Feixes de Coaner ES stay rural rural_agritourism normal 3 flower 3 Espigues 11     45 0 0 0 0   55 40 56.6 Folgueroles Airfield 20.0 8.4 3 Sant Mateu de Bages Bages Carretera Valls Torroella-Salo KM 4 41.8444 1.6395     ES-CAT Turisme rural 3 Espigues PCC-000747
459043 459043 Cal Teulats ES stay rural rural_agritourism normal 3 flower 3 Espigues 10     45 0 0 0 0   70 10 19.3 Folgueroles Airfield 12.2 3.4 54 Perafita Lluçanès Edifici Cal Teulats s/n 42.0451 2.1093     ES-CAT Turisme rural 3 Espigues PCC-000946
459202 459202 Can Gat Vell I-La Pallissa ES stay rural rural_agritourism normal 3 flower 3 Espigues 9     45 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 3 Espigues PG-000025
459209 459209 CAN MASSA ES stay rural rural_agritourism normal 3 flower 3 Espigues 15     45 0 0 0 0   70 10 21.9 GRO 13.5 2.8 77 Pera, la Baix Empordà Carrer Vell 2 42.0136 2.9826     ES-CAT Turisme rural 3 Espigues PG-000036
459263 459263 Allotjament rural Can Soles ES stay rural rural_agritourism normal 3 flower 3 Espigues 14     45 0 0 0 0   80 10 28.3 GRO 9.0 2.1 1772 Forallac Baix Empordà Plaça Dels Esquiladors 1 41.9776 3.0901     ES-CAT Turisme rural 3 Espigues PG-000127
459266 459266 CAL RAJOLER ES stay rural rural_agritourism normal 3 flower 3 Espigues 14     45 0 0 0 0   55 10 31.0 GRO 10.3 3.9 116 Vilademuls Pla de l'Estany Disseminat MASOS DE LESTOPERA S/N 42.1727 2.8666     ES-CAT Turisme rural 3 Espigues PG-000130
459282 459282 Can Palau ES stay rural rural_agritourism normal 3 flower 3 Espigues 8     45 0 0 0 0   55 0 38.6 PGF 17.0 0.1 56 Agullana Alt Empordà Carrer Can Palau s/n 42.3933 2.8463     ES-CAT Turisme rural 3 Espigues PG-000150
459337 459337 Can Gat Vell II-El Graner ES stay rural rural_agritourism normal 3 flower 3 Espigues 3     45 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 3 Espigues PG-000221
459398 459398 Mas Torrencito ES stay rural rural_agritourism normal 3 flower 3 Espigues 14     45 0 0 0 0   55 10 31.0 GRO 10.3 3.9 116 Vilademuls Pla de l'Estany Disseminat Torrent s/n 42.1727 2.8666     ES-CAT Turisme rural 3 Espigues PG-000310
459417 459417 MAS MOLERA TURISME RURAL SL -CASA PAIRAL ES stay rural rural_agritourism normal 3 flower 3 Espigues 10     45 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 3 Espigues PG-000337
459440 459440 Cal Duc-La Nina ES stay rural rural_agritourism normal 3 flower 3 Espigues 7     45 0 0 0 0   80 0 26.6 GRO 3.5 1.3 236 Fontcoberta Pla de l'Estany Lloc Cal Duc de Vilavenut s/n 42.1429 2.7901     ES-CAT Turisme rural 3 Espigues PG-000380
459441 459441 Cal Duc-La Nena ES stay rural rural_agritourism normal 3 flower 3 Espigues 7     45 0 0 0 0   80 0 26.6 GRO 3.5 1.3 236 Fontcoberta Pla de l'Estany Lloc Cal Duc de Vilavenut 0 42.1429 2.7901     ES-CAT Turisme rural 3 Espigues PG-000381
459442 459442 Cal Duc-La Nana ES stay rural rural_agritourism normal 3 flower 3 Espigues 8     45 0 0 0 0   80 0 26.6 GRO 3.5 1.3 236 Fontcoberta Pla de l'Estany Lloc Cal Duc de Vilavenut 0 42.1429 2.7901     ES-CAT Turisme rural 3 Espigues PG-000382
459509 459509 Bellver ES stay rural rural_agritourism normal 3 flower 3 Espigues 12     45 0 0 0 0   80 10 29.2 Folgueroles Airfield 4.2 2.9 322 Vall de Bianya, la Garrotxa Disseminat Bellver s/n 42.1569 2.5301     ES-CAT Turisme rural 3 Espigues PG-000474
459527 459527 MARISCH-LES CORTS ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   55 0 34.9 GRO 14.1 0.0 241 Ventalló Alt Empordà Plaça EMPEDRAT 1 42.1492 3.0263     ES-CAT Turisme rural 3 Espigues PG-000500
459528 459528 Can Marisch-Casa Pairal ES stay rural rural_agritourism normal 3 flower 3 Espigues 13     45 0 0 0 0   55 0 34.9 GRO 14.1 0.0 241 Ventalló Alt Empordà Plaça EMPEDRAT 1 42.1492 3.0263     ES-CAT Turisme rural 3 Espigues PG-000501
459553 459553 Mas Can Salvi ES stay rural rural_agritourism normal 3 flower 3 Espigues 7     45 0 0 0 0   70 0 27.3 GRO 15.7 1.3 264 Parlavà Baix Empordà Carrer Arrabal 8 Bis 42.0289 3.0462     ES-CAT Turisme rural 3 Espigues PG-000533
459617 459617 El Casalot ES stay rural rural_agritourism normal 3 flower 3 Espigues 8     45 0 0 0 0   55 10 32.3 GRO 10.2 3.7 118 Cabanelles Alt Empordà Barri La Palma s/n 42.1887 2.8438     ES-CAT Turisme rural 3 Espigues PG-000611
459632 459632 CAN MARISCH-LES ARCADES ES stay rural rural_agritourism normal 3 flower 3 Espigues 6     45 0 0 0 0   55 0 34.9 GRO 14.1 0.0 241 Ventalló Alt Empordà Plaça EMPEDRAT 1 42.1492 3.0263     ES-CAT Turisme rural 3 Espigues PG-000638
459804 459804 MAS RIBAS ES stay rural rural_agritourism normal 3 flower 3 Espigues 20     45 0 0 0 0   55 0 34.9 GRO 14.1 0.0 241 Ventalló Alt Empordà Disseminat CAN RIBAS 38 42.1492 3.0263     ES-CAT Turisme rural 3 Espigues PG-000864
459906 459906 PLA DE LA MOLINA ES stay rural rural_agritourism normal 3 flower 3 Espigues 6     45 0 0 0 0   55 30 37.2 Folgueroles Airfield 24.5 6.3 16 Gombrèn Ripollès Disseminat BORDA PLA DE LA MOLINA s/n 42.25 2.1     ES-CAT Turisme rural 3 Espigues PG-001012
459907 459907 CASAL DE MATAPLANA ES stay rural rural_agritourism normal 3 flower 3 Espigues 10     45 0 0 0 0   55 30 37.2 Folgueroles Airfield 24.5 6.3 16 Gombrèn Ripollès Disseminat CASAL DE MATAPLANA s/n 42.25 2.1     ES-CAT Turisme rural 3 Espigues PG-001014
459984 459984 CASA TAPIOLAS ES stay rural rural_agritourism normal 3 flower 3 Espigues 20     45 0 0 0 0   55 20 48.1 Folgueroles Airfield 22.7 6.0 44 Molló Ripollès Carrer Guardiola 12 42.3773 2.416     ES-CAT Turisme rural 3 Espigues PG-001335
460135 460135 Casa Xicot ES stay rural rural_agritourism normal 3 flower 3 Espigues 15     45 0 0 0 0   70 20 25.9 LEU 12.4 7.2 23 Alins Pallars Sobirà Carretera Tor s/n 42.571 1.3971     ES-CAT Turisme rural 3 Espigues PL-000080
460277 460277 Casa Teixidó ES stay rural rural_agritourism normal 3 flower 3 Espigues 6     45 0 0 0 0   45 20 36.5 LEU 47.8 6.0 54 Torre de Cabdella, la Pallars Jussà Carrer Cal Teixidó s/n 42.3743 0.9675     ES-CAT Turisme rural 3 Espigues PL-000352
460283 460283 Cal Albareda ES stay rural rural_agritourism normal 3 flower 3 Espigues 15     45 0 0 0 0   55 0 50.8 ILD 12.7 1.3 27 Oliola Noguera Plaça Major s/n 41.7608 1.1462     ES-CAT Turisme rural 3 Espigues PL-000367
460331 460331 La Masuca d'en Monfà ES stay rural rural_agritourism normal 3 flower 3 Espigues 6     45 0 0 0 0   55 30 37.6 REU 20.8 5.7 15 Penelles Noguera Carrer Almassor s/n 41.4667 1.3167     ES-CAT Turisme rural 3 Espigues PL-000464
460373 460373 Cal Pallerola -La Verneda ES stay rural rural_agritourism normal 3 flower 3 Espigues 8     45 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 3 Espigues PL-000542
460375 460375 Cal Camats 1 ES stay rural rural_agritourism normal 3 flower 3 Espigues 6     45 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 3 Espigues PL-000544
460425 460425 Ca la Pascola ES stay rural rural_agritourism normal 3 flower 3 Espigues 9     45 0 0 0 0   65 0 46.4 REU 9.9 0.0 46 Guimerà Urgell Carrer Bovera 30 41.5645 1.1853     ES-CAT Turisme rural 3 Espigues PL-000624
460441 460441 Cal Colomina ES stay rural rural_agritourism normal 3 flower 3 Espigues 11     45 0 0 0 0   55 30 50.9 ILD 27.6 5.3 7 Artesa de Segre Noguera Carretera Tremp s/n 41.933 1.084     ES-CAT Turisme rural 3 Espigues PL-000645
460454 460454 ALLOTJAMENT RURAL CASA SELMO ES stay rural rural_agritourism normal 3 flower 3 Espigues 4     45 0 0 0 0   55 30 33.0 ILD 24.8 5.5 13 Àger Noguera Carrer PONTET 9 41.9981 0.6996     ES-CAT Turisme rural 3 Espigues PL-000670
460461 460461 MAS SERRALLIMPIA ES stay rural rural_agritourism normal 3 flower 3 Espigues 17     45 0 0 0 0   45 10 48.0 LEU 32.8 2.7 39 Baronia de Rialb, la Noguera Disseminat Mas Serrallimpia 1 41.9404 1.1857     ES-CAT Turisme rural 3 Espigues PL-000680
460510 460510 Cal Pesolet Eco Turisme Rural ES stay rural rural_agritourism normal 3 flower 3 Espigues 9     45 0 0 0 0   55 0 30.9 LEU 25.7 0.0 224 Bellver de Cerdanya Cerdanya Carrer Cal Pesolet s/n 42.3667 1.7833     ES-CAT Turisme rural 3 Espigues PL-000746
460634 460634 MONTCEL CASA RURAL ES stay rural rural_agritourism normal 3 flower 3 Espigues 20     45 0 0 0 0   45 20 49.7 ILD 35.0 5.4 25 Castell de Mur Pallars Jussà Carrer Forn (Guàrdia de Noguera) s/n 42.1031 0.8631     ES-CAT Turisme rural 3 Espigues PL-001482
460861 460861 CAL BELLARDINO ES stay rural rural_agritourism normal 3 flower 3 Espigues 7     45 0 0 0 0   45 10 40.0 REU 34.9 3.7 43 Bisbal de Montsant, la Priorat Carrer de les Eres 7 41.2667 0.7167     ES-CAT Turisme rural 3 Espigues PT-001226
460877 460877 CAL BERTRAN ES stay rural rural_agritourism normal 3 flower 3 Espigues 10     45 0 0 0 0   55 10 44.3 REU 18.4 1.8 14 Llorac Conca de Barberà Carrer Major 22 41.5333 1.3     ES-CAT Turisme rural 3 Espigues PT-001333
463061 463061 CASONA DE NAVALMEDIO ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0                 Cercedilla   CMNO 1,5         ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-94
463070 463070 POSADA DEL CAMINO REAL ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 10 37.2 MAD 25.8 0.1 6 Torrelaguna   CALLE de San Francisco 6, 28180 40.827 -3.5376     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-106
463095 463095 LAS POSTAS ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 0 9.2 MAD 0.4 0.4 2641 Navacerrada   CTRA Nacional 601 10,200, 28491 40.4353 -3.6495     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-141
463096 463096 BALNEARIO AGUAS DE CARABAÑA ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 10 31.6 TOJ 17.6 0.4 10 Carabaña   CTRA de Tielmes-Ambite 7,700, 28560 40.2575 -3.2374     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-144
463109 463109 LAS ROZUELAS ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 20 49.3 Madrid-Cuatro Vientos Airport 14.7 2.2 8 Cercedilla   CTRA de Las Dehesas 45, 28479 40.7569 -4.0728     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-164
463111 463111 HACIENDA DE LOS ROBLES ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 0 9.2 MAD 0.4 0.4 2641 Navacerrada   AVDA de Madrid 27, 28491 40.4353 -3.6495     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-167
463112 463112 NAVA REAL ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 0 9.2 MAD 0.4 0.4 2641 Navacerrada   CALLE de las Huertas 1, 28491 40.4353 -3.6495     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-168
463120 463120 CASA JUANECA ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 40 15.4 MAD 8.8 5.7 1 Colmenar Viejo   CTRA Nacional I 30,500, 28707 40.6305 -3.594     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-178
463194 463194 EL CORZO ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   45 0 59.5 Madrid-Cuatro Vientos Airport 40.1 0.0 41 Cercedilla   CTRA M-601 Villalba-Segovia 19,200, 28470 40.3167 -4.4833     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-34
463212 463212 LA CASA ALTA ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 10 37.6 Getafe Air Base 20.7 0.0 8 Belmonte de Tajo   TRVA Barrio Alto 12, 28390 40.1316 -3.3358     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-66
463215 463215 LA CASONA DE EBOLI ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 20 16.1 TOJ 8.0 0.0 2 Santorcaz   CALLE del Embudo 6, 28818 40.4657 -3.2683     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-70
463216 463216 LUCES DEL PONIENTE ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   45 0 59.5 Madrid-Cuatro Vientos Airport 40.1 0.0 41 Cercedilla   CALLE Lina de Ávila 4, 28470 40.3167 -4.4833     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-73
463228 463228 HOSPEDERIA DE ANTONIA ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 10 5.4 TOJ 7.3 0.3 20 Ajalvir   CALLE San Blas 2, 28864 40.5329 -3.4821     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-203
463263 463263 LA BODEGA DE QUINTIN ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 20 39.0 TOJ 20.4 0.0 5 Villarejo de Salvanés   CALLE Toril 2, 28590 40.1666 -3.2728     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-354
463311 463311 LA TORRE ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   65 0 41.1 Madrid-Cuatro Vientos Airport 6.7 0.0 23 Collado Mediano   PASEO de los Rosales 48, 28450 40.6933 -4.0228     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-256
463325 463325 QUERCUS TIERRA ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 20 48.3 MAD 29.8 0.0 5 Garganta de los Montes   PLAZA de San Pedro 11, 28743 40.9199 -3.6838     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-285
467535 467535 EL LAGAR DE NEMESIO ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0                 Perales de Tajuña   CALLE Mayor Baja 32-36         ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-388
468580 468580 RETAMARES EVENTS SUITES & GOLF ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 30 15.9 TOJ 4.1 2.2 4 Valdeolmos-Alalpardo   CALLE Aldebarán 71, 28130 40.6299 -3.4749     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-396
468626 468626 SANTUI ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   45 20 65.6 TOJ 53.4 6.6 32 Horcajuelo de la Sierra   CALLE Clero 10, 28191 41.0775 -3.4553     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-435
469250 469250 HOSPEDERIA CASA PALACIO VERA Y MENDOZA ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 10 37.2 MAD 25.8 0.1 6 Torrelaguna   CALLE Mayor 9, 28180 40.827 -3.5376     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-508
469362 469362 BOX ART ALPINO ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   80 0 9.2 MAD 0.4 0.4 2641 Navacerrada   AVDA de Madrid 58 BIS, 28491 40.4353 -3.6495     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-433
469421 469421 HOTEL SPA LA CASA DEL CONVENTO ES stay rural rural_agritourism normal 3 star 3-HOJA DE ROBLE       45 0 0 0 0   55 0 30.8 Getafe Air Base 14.6 0.0 40 Chinchón   CALLE de Zurita 7, 28370 40.1402 -3.4227     ES-MAD HOTEL RURAL 3-HOJA DE ROBLE TR-142
561720 561720 LA MILOTXA ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 10     45 0 0 0 0   65 10 73.3 VLC 6.7 3.4 40 ATZÚBIA, L' ALICANTE/ALACANT PRINCIPAL N25 38.8753 -0.1712     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000521-A
561721 561721 CASA ELS PARDOS ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 8     45 0 0 0 0   70 10 24.8 CDT 25.2 4.9 21 ATZENETA DEL MAESTRAT CASTELLÓN/CASTELLÓ CL. ORDE DE MONTESA, 5 40.189 -0.2164     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000910-CS
561722 561722 CASA EL FORN D'ALCUDIA DE VEO ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 6     45 0 0 0 0   65 0 48.1 CDT 8.5 0.9 25 ALCUDIA DE VEO CASTELLÓN/CASTELLÓ C PASTORA 30 39.9186 -0.34     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000830-CS
561723 561723 CASA RURAL PUCHERO Y MANTA ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 4     45 0 0 0 0   65 0 48.1 CDT 8.5 0.9 25 ALCUDIA DE VEO CASTELLÓN/CASTELLÓ PL SAN MIGUEL 3 39.9186 -0.34     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000851-CS
561724 561724 MAS CASA VIDAL ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 6     45 0 0 0 0   65 0 62.1 ALC 7.8 0.3 22 ALBAIDA VALENCIA/VALÈNCIA BS DISEMINADOS 130 POL. 9 PARCELA 62 P 38.84 -0.5193     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000675-V
561725 561725 LA CASONA DE ALBAIDA ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 6     45 0 0 0 0   65 0 62.1 ALC 7.8 0.3 22 ALBAIDA VALENCIA/VALÈNCIA C Beato Nicolas Factor 29 38.84 -0.5193     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000472-V
561726 561726 LA CASITA ROJA ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 7     45 0 0 0 0   55 0 42.0 VLC 20.7 1.4 97 ALGIMIA DE ALMONACID CASTELLÓN/CASTELLÓ C LA FUENTE 129 39.8667 -0.4667     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000839-CS
561727 561727 MASIA SAN JUAN CASA 2 ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 4     45 0 0 0 0   55 0 40.4 VLC 25.0 0.3 97 ALTURA CASTELLÓN/CASTELLÓ PD SAN JUAN S/N 39.8513 -0.513     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000861-CS
561728 561728 MASIA SAN JUAN CASA 3 ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 6     45 0 0 0 0   55 0 40.4 VLC 25.0 0.3 97 ALTURA CASTELLÓN/CASTELLÓ PD SAN JUAN SN 39.8513 -0.513     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000859-CS
561729 561729 LA CASA DE LA BICI ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 11     45 0 0 0 0   55 10 42.0 CDT 10.6 0.8 9 ARGELITA CASTELLÓN/CASTELLÓ CALLE MAYOR 15 40.027 -0.3555     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000935-CS
561730 561730 ALOJAMIENTO RURAL BENJAMÍN ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 7     45 0 0 0 0   65 10 45.6 CDT 8.2 0.1 18 ARTANA CASTELLÓN/CASTELLÓ CALLE CONSTITUCIÓN, 46 39.8912 -0.2565     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000891-CS
561731 561731 CASA RURAL ESPADAN SUITES ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 4     45 0 0 0 0   65 10 45.6 CDT 8.2 0.1 18 ARTANA CASTELLÓN/CASTELLÓ PA OMBRIA 1 39.8912 -0.2565     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000842-CS
561732 561732 CASA RURAL EL RINCÓN DE BEATRIZ ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 10     45 0 0 0 0   55 20 48.6 CDT 11.5 0.4 1 AYÓDAR CASTELLÓN/CASTELLÓ SANTA BÁRBARA 42 - 44 39.9647 -0.3954     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000924-CS
561733 561733 HORT DE LES ORONETES ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 14     45 0 0 0 0   65 0 37.7 VLC 0.2 0.2 29 ALZIRA VALENCIA/VALÈNCIA PARAJE DE LA CASELLA PDA FRACÀ POL 57 PARCELA 320 39.1518 -0.4333     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000659-V
561734 561734 LA ISLA DE JUCAR ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 8     45 0 0 0 0   65 10 53.9 VLC 4.1 3.8 681 ALZIRA VALENCIA/VALÈNCIA C La Solana 10, La Barraca de Aguas Vivas 39.0358 -0.26     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000510-V
561735 561735 TORRE BUEN AIRE ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 7     45 0 0 0 0   55 0 51.5 VLC 26.2 0.3 55 BENAFER CASTELLÓN/CASTELLÓ C ERAS SANZ 9 39.9477 -0.5673     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000789-CS
561736 561736 MASIA RIU DELS ARBRES ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 8     45 0 0 0 0   60 0 25.6 CDT 40.4 0.0 84 BENASSAL CASTELLÓN/CASTELLÓ PD RIU DELS ARBRES SN 40.3769 -0.1397     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000834-CS
561737 561737 Mas en Calma ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 10     45 0 0 0 0   70 0 6.9 CDT 11.9 0.1 26 CABANES CASTELLÓN/CASTELLÓ Partida Toll de Cabrera, Pol 27 Parcela 62 40.1556 0.0441     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000937-CS
561738 561738 La Cueva de Miravet ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 16     45 0 0 0 0   70 20 11.8 CDT 12.7 5.3 3397 CABANES CASTELLÓN/CASTELLÓ Poligono La Ferradura 23, parcela 81 40.1354 0.1663     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000905-CS
561739 561739 VILLA PARDALOT-HABITACIONES ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 8     45 0 0 0 0   65 10 36.5 CDT 8.0 0.0 18 CÀLIG CASTELLÓN/CASTELLÓ PARCELA 90 - POLIGONO 4 40.4626 0.3552     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000913-CS
561740 561740 CA ELVIRETA ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 10     45 0 0 0 0   65 10 70.8 ALC 5.7 2.7 1308 BENISSA ALICANTE/ALACANT C Santo Domingo 25 38.6937 0.0624     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000458-A
561741 561741 CASA SEÑORIAL BENISSA ES stay rural rural_agritourism normal 3 star TRES ESTRELLAS 10     45 0 0 0 0   65 10 70.8 ALC 5.7 2.7 1308 BENISSA ALICANTE/ALACANT C/ FRANCISCO SENDRA,5 38.6937 0.0624     ES-GVA Casa rural TRES ESTRELLAS CV-ARU000482-A

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