SELECT DISTINCT(t1.id) FROM alojamientos as t1, administradores_alojamientos as t0, portalesfns_categorias_alojamientos as t2 WHERE t1.visible = '0' AND t1.id=t0.alojamientos_id AND t0.members_id = 1705 AND t1.id=t2.alojamiento_id AND t2.categoria_id = '11' ORDER BY t1.nombre LIMIT 0,200
SELECT DISTINCT(t1.id) FROM alojamientos as t1, administradores_alojamientos as t0, portalesfns_categorias_alojamientos as t2 WHERE t1.id=t0.alojamientos_id AND t0.members_id = 1705 AND t1.id=t2.alojamiento_id AND t2.categoria_id = '11' ORDER BY t1.nombre
This typical 17 th century house conserves the characteristic features of traditional Asturian architecture. Stone walls furnished inside with chestnut galleries and corridors. Situated , in the beautiful, verdant valley Cuna y Cenera, at a 6 Km fr ...
Rural hotel situated in a magnificent natural landscape, on the banks of river Cabra, at a 3 Km&apostrofe;s distance from La Franca beach, into which it flows. The hotel, with 8 double rooms with bath and hairdryer, TV, telephone and heating, is loca ...
This charming hotel is located in the Real Sitio de Covadonga, within the National Park Picos de Europa, in a lovely area of natural beauty.
With over 100 years of history and recently refurbished, comprises a total of 52 rooms, including 2 suites, ...
Modern 4**** Hotel completely renovated in 2010 offers a wealth of possibilities. Wellness center ( Spa & Gymnasium), outdoor swimming pool, tennis court, Golf partner, playground, playroom, wi-fi and air-conditioning, business center, room servic ...
This charming hotel situated in a refurbished 16th-century palace lies 50 km east of the capital of the Principality, in a valley surrounded by two exceptional witnesses: the Picos de Europa and the Sueve Range. Its owners have wisely given it the fl ...
The Palace of Merás is a palace of the year 1525, in the center of Villa de Tineo, it is completely restored recovering in this way one of the most emblematic urban palaces of Asturias. The care in the details and the use of high quality materials m ...
HOTEL PALACIO DE LUCES 5* GL OVERVIEW Situated in the very heart of Asturias (Spain) between the magnificent Sierra del Sueve and the Cantabrico Sea, the Hotel is well connected with the most importants towns in the region by a modern motorway: ...
WILL YOU DARE TO RELAX?
A place to get away within the charming village of Caleao, amidst the Redes Natural Park, reservation of the Biosphere since 2001. A lodging isolated from noise, which nonetheless offers multiple choices and plans. Feel the n ...
The Hotel Mar del Sueve is a romantic hotel located in Colunga, between the sea and the mountains of Asturias, this lovely small hotel, refurbished in 2003, offers ten incredible attractive rooms. The decor of the Hotel Mar del Sueve in Asturias i ...
A place to relax in Asturias
Hotel Naranjo de Bulnes in Arenas de Cabrales (Asturias): The ideal place to enjoy a pleasant stay in the National Park Picos de Europa, where you can visit and discover the Natural Paradise that surrounds us. Come and ...
This website uses cookies to ensure you get the best experience on our website. Read the Cookies Policy. By clicking any link on this page you are giving your consent for us to set cookies.
