Recursos encontrados

Home NaturAsturias

Aquatic Activities

Land Activities

school trips

Family

Rentals

Naturasturias Experience

Contact

LLAGAR CASTANON SL

(Llagar Castañon SL)

From 3, 00 €

Book

+ info

Book

9,22

650 Reviews

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

Prices

Timetable

Approximate duration

The price includes

Do not forget

To whom it is addressed

Activity details

Contact

Rules of use and safety

Instructions when buying a gift voucher

Gift voucher redemption instructions

Relevance

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-1787053069.2025": { "start": 1787053069.202464, "end": 1787053069.25368, "total_valor": 0.0512, "total": "0.0512<\/b> seg" }, "TPryDestinos_Render::setValoresPost_Int-1787053069.2032": { "start": 1787053069.203247, "end": 1787053069.226896, "total_valor": 0.0236, "total": "0.0236<\/b> seg" }, "TPryDestinos_Render::getDatosFromSlug-1787053069.2236": { "start": 1787053069.223615, "end": 1787053069.226091, "total_valor": 0.0025, "total": "0.0025<\/b> seg" }, "TPryDestinos_Render::getSubDestinosFromOpc-1787053069.2261": { "start": 1787053069.226113, "end": 0, "total_valor": 0, "total": 0 }, "TPryDestinos_Render::Ejecutar-1787053069.2537": { "start": 1787053069.253696, "end": 1787053069.767309, "total_valor": 0.5136, "total": "0.5136<\/b> seg", "LENTO": "Mejorable<\/span>" }, "TPryDestinos_Render::loadPage-1787053069.2537": { "start": 1787053069.253706, "end": 1787053069.318119, "total_valor": 0.0644, "total": "0.0644<\/b> seg" }, "TPryDestinos_Render::renderPaginaV2-1787053069.3181": { "start": 1787053069.31813, "end": 1787053069.767284, "total_valor": 0.4492, "total": "0.4492<\/b> seg", "LENTO": "Mejorable<\/span>" }, "TPryDestinos_Render::loadPage_Footer-1787053069.5791": { "start": 1787053069.579136, "end": 1787053069.741058, "total_valor": 0.1619, "total": "0.1619<\/b> seg" }, "TPryDestinos_Render::loadPage_Sections-1787053069.5808": { "start": 1787053069.580849, "end": 1787053069.740997, "total_valor": 0.1601, "total": "0.1601<\/b> seg", "subProcesos": { "SQL_Seccion--1787053069.5929": { "start": 1787053069.592949, "end": 1787053069.646574, "total_valor": 0.0536, "total": "0.0536<\/b> seg" }, "InicioSeccion_3152--1787053069.6466": { "start": 1787053069.646601, "end": 1787053069.655449, "total_valor": 0.0088, "total": "0.0088<\/b> seg" }, "InicioSeccion_3149--1787053069.6555": { "start": 1787053069.655465, "end": 1787053069.664125, "total_valor": 0.0087, "total": "0.0087<\/b> seg" }, "InicioSeccion_1852--1787053069.6641": { "start": 1787053069.66414, "end": 1787053069.689438, "total_valor": 0.0253, "total": "0.0253<\/b> seg" }, "InicioSeccion_1911--1787053069.6895": { "start": 1787053069.689453, "end": 1787053069.699399, "total_valor": 0.0099, "total": "0.0099<\/b> seg" }, "InicioSeccion_1512--1787053069.6994": { "start": 1787053069.699406, "end": 1787053069.708102, "total_valor": 0.0087, "total": "0.0087<\/b> seg" }, "InicioSeccion_1988--1787053069.7081": { "start": 1787053069.708117, "end": 1787053069.71759, "total_valor": 0.0095, "total": "0.0095<\/b> seg" }, "SQL_Elementos--1787053069.7176": { "start": 1787053069.717604, "end": 1787053069.719282, "total_valor": 0.0017, "total": "0.0017<\/b> seg" }, "Carga_Alojamientos--1787053069.7193": { "start": 1787053069.719299, "end": 1787053069.719316, "total_valor": 0, "total": "0<\/b> seg", "subProcesos": [] }, "Carga_Recursos--1787053069.7193": { "start": 1787053069.719319, "end": 1787053069.723715, "total_valor": 0.0044, "total": "0.0044<\/b> seg", "subProcesos": { "TPryRecursos::getRecursosDB-1787053069.7193": { "start": 1787053069.719325, "end": 1787053069.723701, "total_valor": 0.0044, "total": "0.0044<\/b> seg", "subProcesos": { "SQL_getRecursos--1787053069.7193": { "start": 1787053069.719329, "end": 1787053069.720755, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "loadPrecioDesde--1787053069.7209": { "start": 1787053069.720874, "end": 1787053069.721488, "total_valor": 0.0006, "total": "0.0006<\/b> seg" }, "loadComentariosValoraciones--1787053069.7215": { "start": 1787053069.72149, "end": 1787053069.722085, "total_valor": 0.0006, "total": "0.0006<\/b> seg" }, "loadDestinoPadre--1787053069.7221": { "start": 1787053069.722089, "end": 1787053069.72317, "total_valor": 0.0011, "total": "0.0011<\/b> seg" }, "tipos_segmentos--1787053069.7232": { "start": 1787053069.723176, "end": 1787053069.723696, "total_valor": 0.0005, "total": "0.0005<\/b> seg" } } }, "TPryRecursos::getPrecioDesde_Exp-1787053069.7209": { "start": 1787053069.720878, "end": 1787053069.721485, "total_valor": 0.0006, "total": "0.0006<\/b> seg", "subProcesos": { "SQL_loadPrecio--1787053069.7209": { "start": 1787053069.720884, "end": 1787053069.721477, "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-1787053069.7215": { "start": 1787053069.721495, "end": 1787053069.72208, "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--1787053069.7237": { "start": 1787053069.723718, "end": 1787053069.725107, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "Carga_Paginas--1787053069.7251": { "start": 1787053069.725111, "end": 1787053069.726048, "total_valor": 0.0009, "total": "0.0009<\/b> seg" }, "setElemento_En_Seccion--1787053069.726": { "start": 1787053069.72605, "end": 1787053069.726103, "total_valor": 0.0001, "total": "0.0001<\/b> seg" }, "Imagenes_TextoAlt--1787053069.7261": { "start": 1787053069.726105, "end": 1787053069.740959, "total_valor": 0.0149, "total": "0.0149<\/b> seg" }, "Unificar_Datos_Seccion--1787053069.741": { "start": 1787053069.740974, "end": 1787053069.740994, "total_valor": 0, "total": "0<\/b> seg" } } }, "TPryDestinos_Render::getPageSlug-1787053069.6986": { "start": 1787053069.698558, "end": 1787053069.699375, "total_valor": 0.0008, "total": "0.0008<\/b> seg" }, "TPryDestinos_Render::leerPaginas-1787053069.7237": { "start": 1787053069.723722, "end": 1787053069.725102, "total_valor": 0.0014, "total": "0.0014<\/b> seg" }, "TPryDestinos_Render::getMultimedia-1787053069.7251": { "start": 1787053069.725114, "end": 1787053069.726044, "total_valor": 0.0009, "total": "0.0009<\/b> seg" } }

Prices

Timetable

Approximate duration

The price includes

Do not forget

To whom it is addressed

Activity details

Contact

Rules of use and safety

Instructions when buying a gift voucher

Gift voucher redemption instructions

Relevance

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