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

307 rows where country = "RO", family = "camping" and rating_value = 2

This data as json, CSV (advanced)

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

rating_value 1

group 1

family 1

  • camping · 307 ✖

country 1

  • RO · 307 ✖

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
15494 15494 VARTOP RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 46 23   45 0 0 0 0   30 10 81.3 CLJ 41.1 4.7 97 Com. Arieşeni, Sat Bubeşti ALBA NR. 88A 46.4994983 22.7065417 18.04.2011   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 5613/3760
15523 15523 RAL RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 23 10   35 0 0 0 0   30 10 80.9 CLJ 37.8 2.2 85 Com. Arieşeni, Sat Galbena ALBA NR. 396 46.4711678 22.7300433 27.03.2012   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 1700
15671 15671 BODROGENI RO stay camping camping normal 2 star 2 - STELE 24 8   35 0 0 0 0   70 10 26.5 Câmpia Turzii Air Base 10.9 0.2 7 Com. Livezile, Sat Poiana Aiudului ALBA NR. 106 A 46.3643505 23.6033375 26.11.2018   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 19188
15794 15794 COLEV RO stay camping camping normal 2 star 2 - STELE 2 1   35 0 0 0 0   55 10 36.1 Câmpia Turzii Air Base 11.3 1.1 10 Com. Stremţ, Sat Stremţ ALBA NR. 24 46.2265952 23.6368859 03.12.2018   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 19209
15834 15834 TABĂRA RECREATIVĂ VADU MOŢILOR RO stay camping camping normal 2 star 2 - STELE 12 3   35 0 0 0 0   45 10 70.0 CLJ 32.3 0.6 14 Com. Vadu Moţilor, Sat Vadu Moţilor ALBA NR. 291 46.3944349 22.9684367 19.05.2022   RO-SITUR CAMPING 2 - STELE 24817
15878 15878 ANTIK NO 6 ALBA IULIA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 4 1   35 0 0 0 0   65 0 50.5 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA STR. Strada Alcala de Henares , BL. 1 , ET. 6 , AP. 27 46.0732725 23.5804886 07.12.2022   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 32839
16074 16074 AMERICAN STAR 2 RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 12 6   35 0 0 0 0   45 20 56.6 ARW 47.4 1.0 1 Com. Bârzava, Sat Bârzava ARAD NR. 435 46.1104382 21.9925191 05.03.2014   RO-SITUR BUNGALOURI 2 - STELE 15223
16083 16083 WINE ROAD GLAMPING RO stay camping camping normal 2 star 2 - STELE 24 6   35 0 0 0 0   70 10 24.9 ARW 20.9 0.5 7 Com. Ghioroc, Sat Cuvin ARAD NR. 544 46.1701004 21.587274 29.09.2023   RO-SITUR CAMPING 2 - STELE 36285
16102 16102 CĂSUŢELE VÂNĂTORULUI RO stay camping camping normal 2 star 2 - STELE 8 4   35 0 0 0 0   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa, Sat Moneasa ARAD STR. Strada Şmelţ , NR. 77 46.4603468 22.2535709 14.04.2025   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 37110
16382 16382 BAILE LIPOVA RO stay camping camping normal 2 star 2 - STELE 98 37 wedding 55 0 0 0 0   45 10 34.5 ARW 30.9 0.8 11 Oraş Lipova ARAD STR. Strada Lugojului , NR. 50 46.0841416 21.6918276 06.11.2009   RO-SITUR CAMPING 2 - STELE 6536/6423
16433 16433 CĂLĂREŢII LUI ŢEPEŞ RO stay camping camping normal 2 star 2 - STELE 20 10   35 0 0 0 0   55 0 67.6 SBZ 20.6 0.8 96 Com. Arefu, Sat Arefu ARGEŞ   45.3174955 24.6396893 15.09.2016   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 30128
16439 16439 CUMPĂNA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 70 35   45 0 0 0 0   55 10 63.0 SBZ 26.1 3.7 51 Com. Arefu, Sat Arefu ARGEŞ   45.366579 24.6307214 28.10.2016   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 15994
16481 16481 DRACULA RO stay camping camping normal 2 star 2 - STELE 32 16   45 0 0 0 0   55 0 65.9 SBZ 22.5 0.2 88 Com. Arefu, Sat Căpăţânenii Ungureni ARGEŞ   45.3346043 24.6357864 20.12.2018   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 18072
16580 16580 CASA LĂZĂROIU RO stay camping camping normal 2 star 2 - STELE 30 15   45 0 0 0 0   55 0 71.2 SBZ 16.8 0.5 66 Com. Corbeni, Sat Corbeni ARGEŞ   45.2846283 24.6553387 15.04.2021   RO-SITUR POPAS TURISTIC 2 - STELE 28603
16608 16608 HAN DUMBRAVA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 20 6   35 0 0 0 0   55 0 71.4 SBZ 16.4 0.8 64 Com. Corbeni, Sat Rotunda ARGEŞ NR. 155B 45.2814394 24.6536911 20.06.2012   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 18077
16639 16639 BRUSTUREŢ RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 20 10   35 0 0 0 0   55 10 34.8 GHV 12.3 2.5 49 Com. Dâmbovicioara, Sat Dâmbovicioara ARGEŞ   45.4715192 25.2256217 02.04.2025   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 25747
16752 16752 CRISTAL RO stay camping camping normal 2 star 2 - STELE 12 6   35 0 0 0 0   40 20 81.3 OTP 21.5 0.5 2 Com. Negraşi, Sat Bârlogu ARGEŞ   44.6228126 25.0784961 24.10.2013   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 27359
16975 16975 CORNUL VÂNĂTORULUI RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 27 9   35 0 0 0 0   50 10 95.8 CRA 2.4 2.2 152 Mun. Piteşti ARGEŞ STR. Strada Trivale , NR. 75 44.8539111 24.8360768 12.08.2010   RO-SITUR BUNGALOURI 2 - STELE 5345/3322
17060 17060 CARUNTA RO stay camping camping normal 2 star 2 - STELE 20 10   35 0 0 0 0   65 10 40.0 BCM 3.4 0.3 11 Com. Asău, Sat Asău BACĂU   46.4399466 26.400959 06.11.2023   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 36756
17159 17159 IONELA RO stay camping camping normal 2 star 2 - STELE 8 4   35 0 0 0 0   65 30 33.3 BCM 6.9 3.5 1 Com. Zemeş, Sat Zemeş BACĂU STR. Strada Lacului , NR. 1 46.536921 26.475623 06.12.2022   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 32753
17360 17360 GREEN KUB ALBATROSS RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 4 1   35 0 0 0 0   55 0 46.9 BCM 22.2 0.3 111 Oraş Slănic Moldova BACĂU STR. Strada Nicolae Bălcescu , NR. 89 46.2233919 26.47849 15.09.2025   RO-SITUR BUNGALOURI 2 - STELE 44000
17552 17552 TRANSILVANIA GLAMPING RO stay camping camping normal 2 star 2 - STELE 8 2   35 0 0 0 0   45 30 60.4 OMR 45.1 5.1 19 Com. Bulz, Sat Remeţi BIHOR NR. 141 46.840418 22.6499308 09.12.2021   RO-SITUR CAMPING 2 - STELE 24220
17652 17652 CETATILE PONORULUI RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 48 16   45 0 0 0 0   45 40 79.1 CLJ 48.2 10.6 12 Com. Pietroasa, Sat Pietroasa BIHOR   46.5632814 22.7016335 26.04.2010   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 7347/6647
17665 17665 TURUL RO stay camping camping normal 2 star 2 - STELE 204 51 wedding 65 0 0 0 0   45 20 46.6 OMR 47.4 0.5 3 Com. Remetea, Sat Remetea BIHOR NR. 8 46.7344677 22.3440694 12.05.2014   RO-SITUR CAMPING 2 - STELE 27885
17671 17671 CĂSUŢA DE LA DUD RO stay camping camping normal 2 star 2 - STELE 2 1   35 0 0 0 0   45 20 42.9 OMR 43.2 2.6 9 Com. Roşia, Sat Roşia BIHOR NR. 266 C 46.8190421 22.3803114 13.05.2014   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 27890
17672 17672 CĂSUŢA DE LA STELE RO stay camping camping normal 2 star 2 - STELE 4 1   35 0 0 0 0   45 20 42.9 OMR 43.2 2.6 9 Com. Roşia, Sat Roşia BIHOR NR. 266 C 46.8190421 22.3803114 13.05.2014   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 27891
17705 17705 CARMENA RO stay camping camping normal 2 star 2 - STELE 24 8   35 0 0 0 0   80 0 7.7 OMR 8.4 1.3 404 Com. Sânmartin, Sat Băile Felix BIHOR NR. 53 46.9861477 21.9858969 28.12.2021   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 9707/6057
17836 17836 CAII DIN VALE RO stay camping camping normal 2 star 2 - STELE 30 6   45 0 0 0 0   70 10 11.4 OMR 12.1 2.5 305 Com. Sânmartin, Sat Betfia BIHOR NR. 75 E 46.9646949 22.0244903 31.10.2018   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 19093
18029 18029 DOLINA GLAMPING RO stay camping camping normal 2 star 2 - STELE 16 4   35 0 0 0 0   45 40 46.7 OMR 44.7 5.8 2 Com. Şuncuiuş, Sat Zece Hotare BIHOR NR. 97 46.8928144 22.4859114 31.08.2023   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 35833
18323 18323 ROBINSON RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   80 10 5.6 OMR 3.0 3.0 362 Mun. Oradea BIHOR STR. Strada Marin Preda , NR. 17 47.068491061341 21.9405073153442 10.10.2024   RO-SITUR SPAȚII DE CAMPARE 2 - STELE 40005
18324 18324 ROBINSON RO stay camping camping normal 2 star 2 - STELE 10 5   35 0 0 0 0   80 10 5.6 OMR 3.0 3.0 365 Mun. Oradea BIHOR STR. Strada Marin Preda , NR. 17 47.0684326 21.9404644 10.10.2024   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 40002
18463 18463 COLIBIŢA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 16 7   35 0 0 0 0   30 0 87.7 TGM 32.6 1.6 69 Com. Bistriţa Bârgăului, Sat Bistriţa Bârgăului BISTRIŢA-NĂSĂUD   47.1734134 24.9275811 21.02.2014   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 27669
18497 18497 COLIBIŢA RO stay camping camping normal 2 star 2 - STELE 24 6   35 0 0 0 0   30 0 87.7 TGM 32.6 1.6 69 Com. Bistriţa Bârgăului, Sat Colibiţa BISTRIŢA-NĂSĂUD   47.1734134 24.9275811 07.12.2016   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 30366
18536 18536 DEALU NEGRU RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 21 11   35 0 0 0 0   65 10 73.2 TGM 9.9 0.1 8 Com. Cetate BISTRIŢA-NĂSĂUD   47.1097 24.6261 21.02.2014   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 27670
18550 18550 ALUNEASA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 13 6   35 0 0 0 0   55 10 68.9 TGM 11.8 0.1 7 Com. Dumitriţa, Sat Dumitriţa BISTRIŢA-NĂSĂUD   47.0702444 24.6259778 21.02.2014   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 27667
18639 18639 STAR SILVA FIAD RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 19 9   35 0 0 0 0   55 30 79.6 BAY 22.4 4.5 3 Com. Telciu, Sat Telciu BISTRIŢA-NĂSĂUD   47.4884589 24.4949042 21.02.2014   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 27672
18661 18661 COMPLEX LORENA RO stay camping camping normal 2 star 2 - STELE 27 10   35 0 0 0 0   55 10 55.1 CLJ 18.1 0.2 6 Com. Uriu, Sat Cristeştii Ciceului BISTRIŢA-NĂSĂUD NR. 1/C/1 47.1936603 24.0979775 04.04.2022   RO-SITUR CAMPING 2 - STELE 24616
18732 18732 COLDĂU RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 8 4   35 0 0 0 0   55 0 57.2 CLJ 23.2 1.0 37 Oraş Beclean BISTRIŢA-NĂSĂUD   47.1800681 24.1704031 21.02.2014   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 27668
18837 18837 LOTCA FERMECATĂ RO stay camping camping normal 2 star 2 - STELE 8 8   35 0 0 0 0   65 0 64.2 TCE 1.9 1.9 92 Com. Cazasu, Sat Cazasu BRĂILA STR. RAMNICU SĂRAT , NR. 5 45.2710253 27.9504236 20.01.2025   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 12729/8744
19231 19231 CĂSUŢELE KLEIN RO stay camping camping normal 2 star 2 - STELE 6 3   35 0 0 0 0   55 20 59.3 GHV 21.2 4.7 16 Com. Buneşti, Sat Mesendorf BRAŞOV NR. 42 46.0866054 24.9874877 28.09.2023   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 36270
19382 19382 ECO-SCOUT COPĂCEL RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   55 0 40.8 GHV 12.4 0.7 206 Com. Hârseni, Sat Copăcel BRAŞOV NR. 710 45.7408443 24.9996169 14.11.2023   RO-SITUR CAMPING 2 - STELE 36902
19890 19890 CRI RO stay camping camping normal 2 star 2 - STELE 18 9   35 0 0 0 0   80 0 19.2 GHV 5.0 1.8 38 Com. Tărlungeni, Sat Tărlungeni BRAŞOV NR. 104557 45.6486162 25.7557016 08.08.2024   RO-SITUR SPAȚII DE CAMPARE 2 - STELE 39185
19948 19948 FESTUNG RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   55 10 39.0 GHV 22.1 1.0 20 Com. Vama Buzăului, Sat Vama Buzăului BRAŞOV NR. 585B 45.575554 25.9890842 01.07.2022   RO-SITUR CAMPING 2 - STELE 25188bis
19949 19949 FESTUNG RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   55 10 39.0 GHV 22.1 1.0 20 Com. Vama Buzăului, Sat Vama Buzăului BRAŞOV NR. 585B 45.575554 25.9890842 01.07.2022   RO-SITUR CAMPING 2 - STELE 25188
20404 20404 DRACHENHAUS URBAN VILLAGE RO stay camping camping normal 2 star 2 - STELE 32 16   45 0 0 0 0   80 0 8.7 GHV 1.7 1.7 1173 Mun. Braşov BRAŞOV NR. 18 45.6412422 25.5873088 24.05.2021   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 23155
20485 20485 GREEN PARK RO stay camping camping normal 2 star 2 - STELE 12 3   35 0 0 0 0   80 10 14.4 GHV 4.4 4.4 221 Mun. Braşov BRAŞOV STR. Calea Bucureşti , NR. 310 E 45.6152541 25.655091 30.03.2016   RO-SITUR CAMPING 2 - STELE 29709
20568 20568 JULIUS ROMER-POSTAVARU RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 76 25   45 0 0 0 0   80 20 15.0 GHV 8.2 5.4 224 Mun. Braşov BRAŞOV   45.5721453 25.5545826 05.03.2014   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 11441
21428 21428 GARBOVA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 40 16   45 0 0 0 0   70 10 27.6 GHV 17.3 3.4 257 Oraş Predeal BRAŞOV   45.462027 25.5894756 20.12.2010   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 4793/3166
21705 21705 BIVUAC CAMP RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   80 10 20.2 GHV 2.5 2.5 180 Oraş Zărneşti BRAŞOV STR. Strada Tămaş , NR. 6C 45.573604 25.343769 27.06.2024   RO-SITUR SPAȚII DE CAMPARE 2 - STELE 38773
21706 21706 CĂLINEŢ RO stay camping camping normal 2 star 2 - STELE 6 1   35 0 0 0 0   80 20 26.9 GHV 9.3 6.8 27 Oraş Zărneşti BRAŞOV STR. Strada Tămaş , NR. 8 45.5991402 25.2121971 04.05.2023   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 34377
21714 21714 CASA CRAITA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 12 3   35 0 0 0 0   65 20 30.6 GHV 9.8 8.7 26 Oraş Zărneşti BRAŞOV STR. Strada Tămaş , NR. 20 45.5566676 25.1917546 17.08.2011   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 15413A
21749 21749 DIANTHUS RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 38 16   45 0 0 0 0   80 20 29.4 GHV 8.9 8.3 27 Oraş Zărneşti BRAŞOV STR. Strada Garofiţa Pietrei Craiului , NR. 4 45.5639769 25.2033056 03.04.2023   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 12097
21787 21787 PLAIUL FOII RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 32 15   45 0 0 0 0   80 20 29.9 GHV 9.4 8.6 27 Oraş Zărneşti BRAŞOV STR. Strada Garofiţa Pietrei Craiului 45.5623513 25.1966929 04.07.2023   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 6525/7268
21789 21789 POPASUL ALPINISTULUI RO stay camping camping normal 2 star 2 - STELE 20 5   35 0 0 0 0   80 20 29.8 GHV 9.2 8.4 27 Oraş Zărneşti BRAŞOV   45.5620755 25.1993892 18.12.2023   RO-SITUR CAMPING 2 - STELE 37339
21820 21820 BALTA ALBĂ RO stay camping camping normal 2 star 2 - STELE 42 14   45 0 0 0 0   55 20 30.5 Boboc Air Base 25.7 0.8 3 Com. Balta Alba, Sat Balta Alba BUZĂU STR. Strada Staţiunii , NR. 32 45.2926751 27.3524473 02.07.2019   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 14242
21877 21877 SALCÂMILOR RO stay camping camping normal 2 star 2 - STELE 12 2   35 0 0 0 0   55 10 33.4 Boboc Air Base 25.0 2.1 23 Com. Măgura, Sat Măgura BUZĂU STR. Strada Vizitii , NR. 5 45.2626621 26.5576327 02.03.2023   RO-SITUR CAMPING 2 - STELE 33683
22183 22183 TREI APE 1 RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 22 8   35 0 0 0 0   70 0 23.0 CSB 20.9 0.5 31 Com. Brebu Nou, Sat Brebu Nou CARAŞ-SEVERIN   45.230076 22.1370769 10.05.2024   RO-SITUR BUNGALOURI 2 - STELE 11633/8433
22242 22242 HERCULES RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   45 0 58.9 CSB 37.5 0.5 213 Com. Mehadia, Sat Mehadia CARAŞ-SEVERIN NR. 837 44.8971573 22.3695645 10.11.2011   RO-SITUR CAMPING 2 - STELE 16084
22259 22259 PRIGOREL RO stay camping camping normal 2 star 2 - STELE 12 6   35 0 0 0 0   45 20 55.2 CSB 44.6 0.6 2 Com. Prigor, Sat Prigor CARAŞ-SEVERIN NR. 192 44.933333 22.116667 27.06.2012   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 18093
22456 22456 7 IZVOARE RO stay camping camping normal 2 star 2 - STELE 140 40 wedding 55 0 0 0 0   45 20 57.3 CSB 36.8 5.0 26 Oraş Băile Herculane CARAŞ-SEVERIN   44.9225867 22.4448299 06.09.2011   RO-SITUR CAMPING 2 - STELE 15456
22518 22518 FLORIANA RO stay camping camping normal 2 star 2 - STELE 12 6   35 0 0 0 0   45 0 61.6 CSB 33.6 0.4 215 Oraş Băile Herculane CARAŞ-SEVERIN NR. 11 44.878859 22.4179192 12.07.2012   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 18149
22534 22534 LA TANTI MARIA RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   45 0 60.7 CSB 34.1 1.3 215 Oraş Băile Herculane CARAŞ-SEVERIN STR. Strada Valea Cernei , NR. 6 44.8877498 22.4250162 05.10.2023   RO-SITUR CAMPING 2 - STELE 36444
22535 22535 LACUL PRISACA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 30 15   45 0 0 0 0   45 0 62.6 CSB 33.0 1.0 215 Oraş Băile Herculane CARAŞ-SEVERIN STR. Strada Valea Cernei , NR. 27 44.8681802 22.4085127 20.05.2019   RO-SITUR BUNGALOURI 2 - STELE 12700/8760
22663 22663 CASA A RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 8 4   35 0 0 0 0   55 30 35.8 CLJ 29.7 9.3 16 Com. Băişoara, Sat Muntele Băişorii CLUJ NR. 58 46.5624551 23.3485652 03.02.2012   RO-SITUR BUNGALOURI 2 - STELE 16549
22770 22770 CĂPUȘ RO stay camping camping normal 2 star 2 - STELE 8 4   35 0 0 0 0   55 10 30.4 CLJ 24.0 1.4 10 Com. Căpuşu Mare, Sat Căpuşu Mare CLUJ   46.792374 23.2864917 29.07.2025   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 43381
22908 22908 MILENIUM RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 36 18   45 0 0 0 0   70 10 27.4 CLJ 20.8 2.7 25 Com. Gilău, Sat Gilău CLUJ STR. Strada Dermata 46.7678236 23.3267619 24.05.2011   RO-SITUR CABANĂ TURISTICĂ 2 - STELE 8760/7709A
22976 22976 VĂLUL MIRESEI RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 28 11   35 0 0 0 0   45 30 65.8 CLJ 56.9 5.0 16 Com. Mărgău, Sat Răchiţele CLUJ NR. 224B 46.7107962 22.8295526 25.08.2022   RO-SITUR BUNGALOURI 2 - STELE 32051
23018 23018 DE OUDE WALNOOT RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   80 0 10.2 Câmpia Turzii Air Base 3.0 1.6 85 Com. Mihai Viteazu, Sat Mihai Viteazu CLUJ NR. 15 N 46.5424943 23.7659097 12.05.2021   RO-SITUR CAMPING 2 - STELE 23114
23945 23945 BAILE BAITA RO stay camping camping normal 2 star 2 - STELE 38 16   45 0 0 0 0   65 10 30.9 CLJ 2.3 2.3 31 Mun. Gherla CLUJ STR. Strada Clujului , NR. 26 47.027122 23.8875094 19.05.2010   RO-SITUR POPAS TURISTIC 2 - STELE 9145/6719
24139 24139 CASA GOLF RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 12 6   35 0 0 0 0   70 10 14.6 CND 11.4 3.0 48 Com. Corbu, Sat Corbu CONSTANŢA   44.4096897 28.6592871 11.07.2025   RO-SITUR BUNGALOURI 2 - STELE 27133
24144 24144 CASA PESCĂREASCĂ RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 38 19   45 0 0 0 0   70 10 14.6 CND 11.4 3.0 48 Com. Corbu, Sat Corbu CONSTANŢA   44.4096897 28.6592871 11.07.2025   RO-SITUR BUNGALOURI 2 - STELE 27132
24540 24540 PERLA LAND RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 57 21   45 0 0 0 0   55 0 47.9 CND 15.1 0.6 814 Com. Costineşti, Sat Costineşti CONSTANŢA   43.9448073 28.6362195 02.08.2013   RO-SITUR BUNGALOURI 2 - STELE 12278/7365
24650 24650 AZUR RO stay camping camping normal 2 star 2 - STELE 22 10   35 0 0 0 0   55 0 47.7 CND 14.8 0.2 821 Com. Costineşti, Sat Schitu CONSTANŢA STR. Strada Şcolii , NR. 15B 43.9446331 28.6274121 02.05.2019   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 19710
24992 24992 COMPLEX PRIA RO stay camping camping normal 2 star 2 - STELE 12 6   35 0 0 0 0   65 10 51.0 Balchik Airfield 3.9 3.9 734 Com. Limanu, Sat 2 Mai CONSTANŢA STR. Strada Falezei , NR. 16C 43.7809968 28.5792619 18.12.2023   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 37254
25005 25005 HACIENDA RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   65 10 51.3 Balchik Airfield 3.2 3.2 832 Com. Limanu, Sat 2 Mai CONSTANŢA NR. 2 43.7870776 28.5736104 06.09.2022   RO-SITUR CAMPING 2 - STELE 32180
25007 25007 HACIENDA RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   65 10 51.8 Balchik Airfield 2.9 2.9 831 Com. Limanu, Sat 2 Mai CONSTANŢA STR. Strada Mihail Kogălniceanu , NR. 478 43.7903754 28.5773423 06.09.2022   RO-SITUR CAMPING 2 - STELE 32178
25008 25008 HACIENDA 2 RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   65 10 51.6 Balchik Airfield 3.1 3.1 834 Com. Limanu, Sat 2 Mai CONSTANŢA STR. Strada Mihail Kogălniceanu , NR. 464 43.7880291 28.5789795 07.08.2024   RO-SITUR SPAȚII DE CAMPARE 2 - STELE 39177
25052 25052 AURORA RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   65 20 48.3 Balchik Airfield 7.0 6.1 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7529244 28.5725487 28.10.2020   RO-SITUR CAMPING 2 - STELE 21967
25066 25066 CAMP SOPHIA RO stay camping camping normal 2 star 2 - STELE 20 10   35 0 0 0 0   65 20 48.1 Balchik Airfield 7.0 5.8 376 Com. Limanu, Sat Vama Veche CONSTANŢA STR. Strada Nichita Stănescu , NR. 21 43.7540194 28.567816 12.05.2016   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 29883
25072 25072 CASA ANA MARIA RO stay camping camping normal 2 star 2 - STELE 16 8   35 0 0 0 0   65 20 48.3 Balchik Airfield 7.2 6.3 375 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7517039 28.5738618 02.05.2018   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 31549
25073 25073 CASA ANA MARIA 1 RO stay camping camping normal 2 star 2 - STELE 16 8   35 0 0 0 0   65 20 48.2 Balchik Airfield 7.2 6.3 375 Com. Limanu, Sat Vama Veche CONSTANŢA STR. Strada Plajei , NR. 7 43.7514609 28.5727891 16.07.2018   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 18709
25149 25149 LA RULOTE RO stay camping camping normal 2 star 2 - STELE 95 40 wedding 55 0 0 0 0   65 20 48.6 Balchik Airfield 6.7 5.9 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7557312 28.5735783 09.07.2018   RO-SITUR CAMPING 2 - STELE 18700
25169 25169 NIRVAMA RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   65 20 47.8 Balchik Airfield 7.5 6.4 375 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7490278 28.5690682 28.10.2020   RO-SITUR CAMPING 2 - STELE 21968
25860 25860 S RO stay camping camping normal 2 star 2 - STELE 949 259 wedding 65 0 0 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463 03.04.2012   RO-SITUR CAMPING 2 - STELE 6077/3813
26079 26079 CURACAO SUMMER RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 20 10   35 0 0 0 0   65 0 56.7 CND 5.4 1.3 776 Mun. Mangalia, Loc. Jupiter CONSTANŢA   43.8597476 28.6057809 18.01.2016   RO-SITUR BUNGALOURI 2 - STELE 5573/3813
26082 26082 ELIXIRUM RO stay camping camping normal 2 star 2 - STELE 320 80 wedding 65 0 0 0 0   65 0 56.5 CND 5.3 1.2 791 Mun. Mangalia, Loc. Jupiter CONSTANŢA STR. Strada Gala Galaction , NR. 45 43.8602306 28.6006971 14.09.2020   RO-SITUR CAMPING 2 - STELE 21047
26083 26083 ELODIE ZODIAC EST RO stay camping camping normal 2 star 2 - STELE 500 125 wedding 65 0 0 0 0   65 0 56.6 CND 5.1 1.3 806 Mun. Mangalia, Loc. Jupiter CONSTANŢA   43.859513 28.598617 29.08.2017   RO-SITUR CAMPING 2 - STELE 6528/3876
26281 26281 "3R" RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 10 4   35 0 0 0 0   65 0 53.8 Balchik Airfield 0.2 0.2 776 Mun. Mangalia, Loc. Saturn CONSTANŢA   43.8152436 28.5741496 21.07.2009   RO-SITUR BUNGALOURI 2 - STELE 7134/6225
26437 26437 PALACE VENUS RO stay camping camping normal 2 star 2 - STELE 96 24 wedding 55 0 0 0 0   65 10 57.2 Balchik Airfield 3.3 3.2 983 Mun. Mangalia, Loc. Venus CONSTANŢA STR. Strada Principesa Elena , NR. 5 43.843659 28.5924802 29.09.2025   RO-SITUR CAMPING 2 - STELE 28756
26447 26447 RUXANDRA 1 RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 25 10   35 0 0 0 0   65 10 57.6 Balchik Airfield 3.7 2.8 1007 Mun. Mangalia, Loc. Venus CONSTANŢA   43.8461809 28.5959003 24.04.2019   RO-SITUR BUNGALOURI 2 - STELE 9044/7897
26448 26448 RUXANDRA 2 RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 25 10   35 0 0 0 0   65 10 57.6 Balchik Airfield 3.7 2.8 1007 Mun. Mangalia, Loc. Venus CONSTANŢA   43.8461809 28.5959003 24.04.2019   RO-SITUR BUNGALOURI 2 - STELE 19697
27132 27132 BRIZA MĂRII RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 42 20   45 0 0 0 0   55 0 38.5 CND 16.1 0.5 1163 Oraş Eforie, Loc. Eforie Sud CONSTANŢA STR. Aleea Mercur , NR. 1 44.0361891 28.6496796 31.07.2025   RO-SITUR BUNGALOURI 2 - STELE 9038/5731
27133 27133 BRIZA MARII B4 RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 44 20   45 0 0 0 0   55 0 38.5 CND 16.1 0.5 1163 Oraş Eforie, Loc. Eforie Sud CONSTANŢA STR. Aleea Mercur , NR. 1 44.0361891 28.6496796 31.07.2025   RO-SITUR BUNGALOURI 2 - STELE 13998
27237 27237 MARA RO stay camping camping normal 2 star 2 - STELE 10 5   35 0 0 0 0   55 0 40.2 CND 17.9 0.4 549 Oraş Eforie, Loc. Eforie Sud CONSTANŢA STR. Strada Carmen Silva , NR. 8 44.0201699 28.6528763 19.05.2026   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 20318
28297 28297 LEBĂDA RO stay camping chalet_bungalow_hut normal 2 star 2 - STELE 84 28 wedding 55 0 0 0 0   80 0 12.3 CND 2.2 0.2 2267 Oraş Năvodari CONSTANŢA STR. Strada Vacanţei , NR. 1 44.3134487 28.6269773 26.11.2012   RO-SITUR BUNGALOURI 2 - STELE 9758/6172
29485 29485 FISHING & RELAX RO stay camping camping normal 2 star 2 - STELE 12 6   35 0 0 0 0   55 0 51.6 GHV 23.5 0.3 44 Com. Bixad, Sat Bixad COVASNA   46.1026791 25.8674939 05.02.2025   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 41256
29546 29546 MALTEZ MICFALĂU RO stay camping camping normal 2 star 2 - STELE 28 7   35 0 0 0 0   55 20 45.6 GHV 21.2 0.2 3 Com. Micfalău, Sat Micfalău COVASNA   46.0537529 25.8352125 26.10.2022   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 32579
29591 29591 PERLA BALVANYOS RO stay camping camping normal 2 star 2 - STELE 24 6   35 0 0 0 0   55 30 56.5 GHV 18.3 7.4 16 Com. Turia, Sat Turia COVASNA   46.1123597 25.9608288 18.08.2011   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 15421A
29624 29624 BENEDEK MEZO RO stay camping camping normal 2 star 2 - STELE 40 10   45 0 0 0 0   80 0 26.9 GHV 0.8 0.8 63 Mun. Sfântu Gheorghe COVASNA   45.8609375 25.7885796 23.11.2016   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 30334
29692 29692 BOTIMI RO stay camping camping normal 2 star 2 - STELE 16 4   35 0 0 0 0   55 0 52.1 GHV 17.5 1.6 62 Oraş Covasna COVASNA STR. Strada Gábor Áron , NR. 2 45.8436814 26.1643995 21.11.2017   RO-SITUR CĂSUȚE TIP CAMPING 2 - STELE 31087

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