articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Gratar Wolf Grillz Smokehouse

Gratar Wolf Grillz Smokehouse

wfcw003
Livrare imediată!

899,95Lei

Tava & Gratar Wolf Grillz Biomaster BBQ Top

Tava & Gratar Wolf Grillz Biomaster BBQ Top

wfcw002
Livrare imediată!

499,95Lei

Aragaz Wolf Grillz Biomaster Stove

Aragaz Wolf Grillz Biomaster Stove

wfcw001
Livrare imediată!

1.195,00Lei

Aragaz & Gratar Campingaz CV 3 in 1
Exclusiv online!

Aragaz & Gratar Campingaz CV 3 in 1

2000008369
Livrare 24-48 ore

779,00Lei

Aragaz Pliabil Coghlans
Exclusiv online!

Aragaz Pliabil Coghlans

c9957
Livrare 24-48 ore

73,99Lei

Aragaz & Gratar Campingaz 360 CV
Exclusiv online!

Aragaz & Gratar Campingaz 360 CV

2000038776
Livrare 24-48 ore

960,00Lei

Trolley Deluxe pentru Plancha si Gratare Campingaz
Exclusiv online!

Trolley Deluxe pentru Plancha si Gratare Campingaz

2000036959
Livrare 24-48 ore

1.640,00Lei

Incalzitor Mr. Heater Portable Buddy - MH8BXDF

Incalzitor Mr. Heater Portable Buddy - MH8BXDF

mh8bxdf
Livrare imediată!

999,01Lei

Cartus cu valva Coleman C500 Perform
Exclusiv online!

Cartus cu valva Coleman C500 Perform

3000004541
Livrare 24-48 ore

45,01Lei

Plancha, Campingaz, L, 3000005442, Aragaze / Incalzitoare, Aragaze / Incalzitoare Campingaz, Aragaze Campingaz, Incalzitoare Campingaz, Campingaz
Gratar pe Gaz si Aragaz Portabil Party Grill 400 CV Campingaz
Exclusiv online!

Gratar pe Gaz si Aragaz Portabil Party Grill 400 CV Campingaz

2000030685
Livrare 24-48 ore

800,00Lei

Grill pentru gratar Ridge Monkey Grilla BBQ Hotplate -10%

Grill pentru gratar Ridge Monkey Grilla BBQ Hotplate

rm418
Livrare imediată!

150,93Lei(-10%) 135,83Lei

Incalzitor Portabil DeWALT Buddy DXH8BX
Exclusiv online!

Incalzitor Portabil DeWALT Buddy DXH8BX

dxh8bx
Livrare 24-48 ore

999,01Lei

Incalzitor Cort Nevis 1300W
Exclusiv online!

Incalzitor Cort Nevis 1300W

1114049
Livrare 48-72 ore

225,01Lei

Gratar pe Gaz Campingaz 2181054 Compact 3 L
Exclusiv online!

Gratar pe Gaz Campingaz 2181054 Compact 3 L

2181054
Livrare 24-48 ore

2.399,00Lei

Aparatoare Arzatoare pentru Gratarele Seria 3 sau 4 Campingaz
Exclusiv online!

Aparatoare Arzatoare pentru Gratarele Seria 3 sau 4 Campingaz

5010001598
Livrare 24-48 ore

40,00Lei

Plancha Campingaz Master Plancha EX
Exclusiv online!

Plancha Campingaz Master Plancha EX

3000004801
Livrare 24-48 ore

3.450,00Lei

Gratar pe Gaz Campingaz Seria 3 Select
Exclusiv online!

Gratar pe Gaz Campingaz Seria 3 Select

2000037273
Livrare 24-48 ore

2.898,99Lei

Gratar Trakker Armolife BBQ, 43x27x23cm

Gratar Trakker Armolife BBQ, 43x27x23cm

211903
Livrare imediată!

174,95Lei

Set 1 Aparatoare Emailata + 1 Gratar Fonta Campingaz pentru Gratarele Seria 3
Exclusiv online!

Set 1 Aparatoare Emailata + 1 Gratar Fonta Campingaz pentru Gratarele Seria 3

2000033786
Livrare 24-48 ore

189,00Lei

Afişare 1 - 20 din 88 (5 pagini)
Queries: 11, Total time: 844.826 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = 'f47f0c0ccee5ca252807cbf15c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (444.219)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND ((pd.tag LIKE '%aragaze%' AND pd.tag LIKE '%/%' AND pd.tag LIKE '%incalzitoare%')) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (398.780)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND ((pd.tag LIKE '%aragaze%' AND pd.tag LIKE '%/%' AND pd.tag LIKE '%incalzitoare%')) AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.885)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
INNER JOIN `oc_manufacturer_to_store` AS m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND m2s.store_id = '3' AND p2c.category_id = '158'
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1210
7 (0.131)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '158' AND ((pd.tag LIKE '%aragaze%' AND pd.tag LIKE '%/%' AND pd.tag LIKE '%incalzitoare%')) AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
8 (0.143)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '158' AND ((pd.tag LIKE '%aragaze%' AND pd.tag LIKE '%/%' AND pd.tag LIKE '%incalzitoare%')) AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911
9 (0.107)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.102)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.111)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38