Recursos encontrados

Home NaturAsturias

Aquatic Activities

Land Activities

school trips

Family

Rentals

Naturasturias Experience

Contact

LLAGAR CASTANON SL

(Llagar Castañon SL)

From 17, 5 €

Book

+ info

Book

9,58

24 Reviews

Open map Quintueles, Villaviciosa (Asturias), España

Prices

The price includes

Activity details

Timetable

Contact

Approximate duration

Do not forget

Rules of use and safety

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-1794444505.4297": { "start": 1794444505.429687, "end": 1794444505.529196, "total_valor": 0.0995, "total": "0.0995<\/b> seg" }, "TPryDestinos_Render::setValoresPost_Int-1794444505.4315": { "start": 1794444505.431502, "end": 1794444505.477, "total_valor": 0.0455, "total": "0.0455<\/b> seg" }, "TPryDestinos_Render::getDatosFromSlug-1794444505.4662": { "start": 1794444505.466199, "end": 1794444505.467616, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "TPryDestinos_Render::getSubDestinosFromOpc-1794444505.4679": { "start": 1794444505.467865, "end": 0, "total_valor": 0, "total": 0 }, "TPryDestinos_Render::Ejecutar-1794444505.5292": { "start": 1794444505.529212, "end": 1794444506.649739, "total_valor": 1.1205, "total": "1.1205<\/b> seg", "LENTO": "LENTO<\/span>" }, "TPryDestinos_Render::loadPage-1794444505.5292": { "start": 1794444505.529222, "end": 1794444505.569365, "total_valor": 0.0401, "total": "0.0401<\/b> seg" }, "TPryDestinos_Render::renderPaginaV2-1794444505.5694": { "start": 1794444505.569378, "end": 1794444506.649718, "total_valor": 1.0803, "total": "1.0803<\/b> seg", "LENTO": "LENTO<\/span>" }, "TPryDestinos_Render::loadPage_Footer-1794444506.07": { "start": 1794444506.070047, "end": 1794444506.614716, "total_valor": 0.5447, "total": "0.5447<\/b> seg", "LENTO": "Mejorable<\/span>" }, "TPryDestinos_Render::loadPage_Sections-1794444506.074": { "start": 1794444506.074001, "end": 1794444506.614648, "total_valor": 0.5406, "total": "0.5406<\/b> seg", "subProcesos": { "SQL_Seccion--1794444506.1144": { "start": 1794444506.114352, "end": 1794444506.228722, "total_valor": 0.1144, "total": "0.1144<\/b> seg" }, "InicioSeccion_5641--1794444506.2288": { "start": 1794444506.228751, "end": 1794444506.238878, "total_valor": 0.0101, "total": "0.0101<\/b> seg" }, "InicioSeccion_3149--1794444506.2389": { "start": 1794444506.238894, "end": 1794444506.2482, "total_valor": 0.0093, "total": "0.0093<\/b> seg" }, "InicioSeccion_1852--1794444506.2482": { "start": 1794444506.248215, "end": 1794444506.27475, "total_valor": 0.0265, "total": "0.0265<\/b> seg" }, "InicioSeccion_1911--1794444506.2748": { "start": 1794444506.274767, "end": 1794444506.304472, "total_valor": 0.0297, "total": "0.0297<\/b> seg" }, "InicioSeccion_1512--1794444506.3045": { "start": 1794444506.304481, "end": 1794444506.312792, "total_valor": 0.0083, "total": "0.0083<\/b> seg" }, "InicioSeccion_1988--1794444506.3128": { "start": 1794444506.312808, "end": 1794444506.321258, "total_valor": 0.0085, "total": "0.0085<\/b> seg" }, "SQL_Elementos--1794444506.3213": { "start": 1794444506.321274, "end": 1794444506.368999, "total_valor": 0.0477, "total": "0.0477<\/b> seg" }, "Carga_Alojamientos--1794444506.369": { "start": 1794444506.369031, "end": 1794444506.369052, "total_valor": 0, "total": "0<\/b> seg", "subProcesos": [] }, "Carga_Recursos--1794444506.3691": { "start": 1794444506.369055, "end": 1794444506.372463, "total_valor": 0.0034, "total": "0.0034<\/b> seg", "subProcesos": { "TPryRecursos::getRecursosDB-1794444506.3691": { "start": 1794444506.369062, "end": 1794444506.372444, "total_valor": 0.0034, "total": "0.0034<\/b> seg", "subProcesos": { "SQL_getRecursos--1794444506.3691": { "start": 1794444506.369066, "end": 1794444506.370513, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "loadPrecioDesde--1794444506.3707": { "start": 1794444506.370715, "end": 1794444506.371131, "total_valor": 0.0004, "total": "0.0004<\/b> seg" }, "loadComentariosValoraciones--1794444506.3711": { "start": 1794444506.371134, "end": 1794444506.371506, "total_valor": 0.0004, "total": "0.0004<\/b> seg" }, "loadDestinoPadre--1794444506.3715": { "start": 1794444506.371508, "end": 1794444506.372096, "total_valor": 0.0006, "total": "0.0006<\/b> seg" }, "tipos_segmentos--1794444506.3721": { "start": 1794444506.372105, "end": 1794444506.372435, "total_valor": 0.0003, "total": "0.0003<\/b> seg" } } }, "TPryRecursos::getPrecioDesde_Exp-1794444506.3707": { "start": 1794444506.37072, "end": 1794444506.371128, "total_valor": 0.0004, "total": "0.0004<\/b> seg", "subProcesos": { "SQL_loadPrecio--1794444506.3707": { "start": 1794444506.370725, "end": 1794444506.371118, "total_valor": 0.0004, "total": "0.0004<\/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(18986,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-1794444506.3711": { "start": 1794444506.371139, "end": 1794444506.3715, "total_valor": 0.0004, "total": "0.0004<\/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(18986,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--1794444506.3725": { "start": 1794444506.372467, "end": 1794444506.37755, "total_valor": 0.0051, "total": "0.0051<\/b> seg" }, "Carga_Paginas--1794444506.3776": { "start": 1794444506.377557, "end": 1794444506.386026, "total_valor": 0.0085, "total": "0.0085<\/b> seg" }, "setElemento_En_Seccion--1794444506.386": { "start": 1794444506.38603, "end": 1794444506.386119, "total_valor": 0.0001, "total": "0.0001<\/b> seg" }, "Imagenes_TextoAlt--1794444506.3861": { "start": 1794444506.386124, "end": 1794444506.614608, "total_valor": 0.2285, "total": "0.2285<\/b> seg" }, "Unificar_Datos_Seccion--1794444506.6146": { "start": 1794444506.614622, "end": 1794444506.614641, "total_valor": 0, "total": "0<\/b> seg" } }, "LENTO": "Mejorable<\/span>" }, "TPryDestinos_Render::getPageSlug-1794444506.2842": { "start": 1794444506.284242, "end": 1794444506.304429, "total_valor": 0.0202, "total": "0.0202<\/b> seg" }, "TPryDestinos_Render::leerPaginas-1794444506.3725": { "start": 1794444506.372472, "end": 1794444506.37753, "total_valor": 0.0051, "total": "0.0051<\/b> seg" }, "TPryDestinos_Render::getMultimedia-1794444506.3776": { "start": 1794444506.377563, "end": 1794444506.38601, "total_valor": 0.0084, "total": "0.0084<\/b> seg" } }

Prices

The price includes

Activity details

Timetable

Contact

Approximate duration

Do not forget

Rules of use and safety

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