Recursos encontrados

Home NaturAsturias

Aquatic Activities

Land Activities

school trips

Family

Rentals

Naturasturias Experience

Contact

LLAGAR CASTANON SL

(Llagar Castañon SL)

From 15, 00 €

Book

+ info

Book

9,59

29 Reviews

Open map Villaviciosa (Asturias), España

Activity details

Prices

Details

Approximate duration

Timetable

Do not forget

Contact

We use cookies to ensure we give us the best experience on our website. If you continue to use this site, we will assume that you are happy with this.

{ "TPryDestinos_Render::__construct-1787053894.5237": { "start": 1787053894.523687, "end": 1787053894.572853, "total_valor": 0.0492, "total": "0.0492<\/b> seg" }, "TPryDestinos_Render::setValoresPost_Int-1787053894.5245": { "start": 1787053894.524534, "end": 1787053894.541325, "total_valor": 0.0168, "total": "0.0168<\/b> seg" }, "TPryDestinos_Render::getDatosFromSlug-1787053894.5379": { "start": 1787053894.537868, "end": 1787053894.540437, "total_valor": 0.0026, "total": "0.0026<\/b> seg" }, "TPryDestinos_Render::getSubDestinosFromOpc-1787053894.5405": { "start": 1787053894.540451, "end": 1787053894.541318, "total_valor": 0.0009, "total": "0.0009<\/b> seg" }, "TPryDestinos_Render::Ejecutar-1787053894.5729": { "start": 1787053894.572868, "end": 1787053895.098141, "total_valor": 0.5253, "total": "0.5253<\/b> seg", "LENTO": "Mejorable<\/span>" }, "TPryDestinos_Render::loadPage-1787053894.5729": { "start": 1787053894.572878, "end": 1787053894.613055, "total_valor": 0.0402, "total": "0.0402<\/b> seg" }, "TPryDestinos_Render::renderPaginaV2-1787053894.6131": { "start": 1787053894.613065, "end": 1787053895.098117, "total_valor": 0.4851, "total": "0.4851<\/b> seg", "LENTO": "Mejorable<\/span>" }, "TPryDestinos_Render::loadPage_Footer-1787053894.8807": { "start": 1787053894.880696, "end": 1787053895.061536, "total_valor": 0.1808, "total": "0.1808<\/b> seg" }, "TPryDestinos_Render::loadPage_Sections-1787053894.8823": { "start": 1787053894.882302, "end": 1787053895.061483, "total_valor": 0.1792, "total": "0.1792<\/b> seg", "subProcesos": { "SQL_Seccion--1787053894.8969": { "start": 1787053894.89693, "end": 1787053894.949997, "total_valor": 0.0531, "total": "0.0531<\/b> seg" }, "InicioSeccion_3152--1787053894.95": { "start": 1787053894.950025, "end": 1787053894.958345, "total_valor": 0.0083, "total": "0.0083<\/b> seg" }, "InicioSeccion_3149--1787053894.9584": { "start": 1787053894.958361, "end": 1787053894.966885, "total_valor": 0.0085, "total": "0.0085<\/b> seg" }, "InicioSeccion_1852--1787053894.9669": { "start": 1787053894.9669, "end": 1787053894.993818, "total_valor": 0.0269, "total": "0.0269<\/b> seg" }, "InicioSeccion_1911--1787053894.9938": { "start": 1787053894.993833, "end": 1787053895.009628, "total_valor": 0.0158, "total": "0.0158<\/b> seg" }, "InicioSeccion_1512--1787053895.0096": { "start": 1787053895.009636, "end": 1787053895.018955, "total_valor": 0.0093, "total": "0.0093<\/b> seg" }, "InicioSeccion_1988--1787053895.019": { "start": 1787053895.01897, "end": 1787053895.028089, "total_valor": 0.0091, "total": "0.0091<\/b> seg" }, "SQL_Elementos--1787053895.0281": { "start": 1787053895.028103, "end": 1787053895.029812, "total_valor": 0.0017, "total": "0.0017<\/b> seg" }, "Carga_Alojamientos--1787053895.0298": { "start": 1787053895.029831, "end": 1787053895.029849, "total_valor": 0, "total": "0<\/b> seg", "subProcesos": [] }, "Carga_Recursos--1787053895.0299": { "start": 1787053895.029851, "end": 1787053895.034484, "total_valor": 0.0046, "total": "0.0046<\/b> seg", "subProcesos": { "TPryRecursos::getRecursosDB-1787053895.0299": { "start": 1787053895.029859, "end": 1787053895.034469, "total_valor": 0.0046, "total": "0.0046<\/b> seg", "subProcesos": { "SQL_getRecursos--1787053895.0299": { "start": 1787053895.029862, "end": 1787053895.031326, "total_valor": 0.0015, "total": "0.0015<\/b> seg" }, "loadPrecioDesde--1787053895.0314": { "start": 1787053895.031446, "end": 1787053895.032039, "total_valor": 0.0006, "total": "0.0006<\/b> seg" }, "loadComentariosValoraciones--1787053895.032": { "start": 1787053895.032042, "end": 1787053895.032693, "total_valor": 0.0007, "total": "0.0007<\/b> seg" }, "loadDestinoPadre--1787053895.0327": { "start": 1787053895.032697, "end": 1787053895.033881, "total_valor": 0.0012, "total": "0.0012<\/b> seg" }, "tipos_segmentos--1787053895.0339": { "start": 1787053895.03389, "end": 1787053895.034463, "total_valor": 0.0006, "total": "0.0006<\/b> seg" } } }, "TPryRecursos::getPrecioDesde_Exp-1787053895.0315": { "start": 1787053895.03145, "end": 1787053895.032036, "total_valor": 0.0006, "total": "0.0006<\/b> seg", "subProcesos": { "SQL_loadPrecio--1787053895.0315": { "start": 1787053895.031457, "end": 1787053895.032028, "total_valor": 0.0006, "total": "0.0006<\/b> seg", "datosAdd": { "Query": "\/*TPryRecursos::getPrecioDesde_Exp*\/ SELECT \n p.id_experiencia, \n p.id_productos, \n MIN(pt.precio) AS precio_desde\n FROM experiencias.exp_experiencia_productos p \n INNER JOIN experiencias.exp_experiencia_producto_tarifas pt ON(pt.id_productos=p.id_productos) \n WHERE p.id_experiencia IN(19596,20809) \n AND p.precio_desde=1 \n AND p.no_visible_motor=0\n AND p.opcion_adicional=0\n AND pt.precio>0 \n GROUP BY p.id_experiencia " } } } }, "TPryRecursos::loadComentariosValoraciones-1787053895.032": { "start": 1787053895.032047, "end": 1787053895.032681, "total_valor": 0.0006, "total": "0.0006<\/b> seg", "datosAdd": { "Query": "\/*TPryRecursos::loadComentariosValoraciones*\/ SELECT \n vr.*,\n ve.id_casa AS id_elemento,\n ve.tipo_elemento,\n ve.nombre_cliente\n FROM ruralgest30.valoracion_respuesta vr \n INNER JOIN ruralgest30.valoracion_email ve USING(id_valoracion_email) \n WHERE ve.id_casa IN(19596,20809)\n AND ve.tipo_elemento=2 \n\t\t\t\tAND vr.fecha>DATE_SUB(CURDATE(),INTERVAL 2 MONTH)\n ORDER BY vr.fecha DESC \n limit 5 " } } } }, "Carga_Paginas--1787053895.0345": { "start": 1787053895.034487, "end": 1787053895.035912, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "Carga_Paginas--1787053895.0359": { "start": 1787053895.035916, "end": 1787053895.036819, "total_valor": 0.0009, "total": "0.0009<\/b> seg" }, "setElemento_En_Seccion--1787053895.0368": { "start": 1787053895.036821, "end": 1787053895.036872, "total_valor": 0.0001, "total": "0.0001<\/b> seg" }, "Imagenes_TextoAlt--1787053895.0369": { "start": 1787053895.036875, "end": 1787053895.061438, "total_valor": 0.0246, "total": "0.0246<\/b> seg" }, "Unificar_Datos_Seccion--1787053895.0615": { "start": 1787053895.061454, "end": 1787053895.06148, "total_valor": 0, "total": "0<\/b> seg" } } }, "TPryDestinos_Render::getPageSlug-1787053895.0038": { "start": 1787053895.003774, "end": 1787053895.009593, "total_valor": 0.0058, "total": "0.0058<\/b> seg" }, "TPryDestinos_Render::leerPaginas-1787053895.0345": { "start": 1787053895.034491, "end": 1787053895.035905, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "TPryDestinos_Render::getMultimedia-1787053895.0359": { "start": 1787053895.03592, "end": 1787053895.036812, "total_valor": 0.0009, "total": "0.0009<\/b> seg" } }

Activity details

Prices

Details

Approximate duration

Timetable

Do not forget

Contact

GROUP AND CORPORATE TRAVEL

SCHOOL TRIPS

CAMPS IN THE ASTURIAN COAST: Surfing, Multiadventure and Nature for all ages.

NATURASTURIAS EXPERIENCE :: Discover Asturias: Nature, Culture and Gastronomy

GROUP AND CORPORATE TRAVEL

SCHOOL TRIPS

CAMPS IN THE ASTURIAN COAST: Surfing, Multiadventure and Nature for all ages.

NATURASTURIAS EXPERIENCE :: Discover Asturias: Nature, Culture and Gastronomy

Contact

Aviso legal

Privacy Policy

Cookies Policy

Customize Cookies

Contact

Aviso legal

Privacy Policy

Cookies Policy

Customize Cookies