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


Pop-up Steg Smoke Ball 8-10mm 20gr SP6 -5%

Pop-up Steg Smoke Ball 8-10mm 20gr SP6

sp170910
Livrare imediată!

18,50Lei(-5%) 17,51Lei

Pop-up Steg Smoke Ball 8-10mm 20gr Ananas

Pop-up Steg Smoke Ball 8-10mm 20gr Ananas

sp170901
Livrare imediată!

17,51Lei

Agrafa Orange Quick Snap No.000, 10buc/pac

Agrafa Orange Quick Snap No.000, 10buc/pac

41441ap1704
Livrare imediată!

9,78Lei

Agrafa Orange Quick Snap No.1, 10buc/pac

Agrafa Orange Quick Snap No.1, 10buc/pac

41441ap1701
Livrare imediată!

9,78Lei

Agrafa, Orange, Quick, Snap, No.0,, 10buc/pac, 41441ap1702, Agrafe si Vartejuri Rapitor, Agrafe si Vartejuri Rapitor Orange, Agrafe Orange, Vartejuri Orange, Rapitor Orange, Orange
Agrafa, Orange, Quick, Snap, No.00,, 10buc/pac, 41441ap1703, Agrafe si Vartejuri Rapitor, Agrafe si Vartejuri Rapitor Orange, Agrafe Orange, Vartejuri Orange, Rapitor Orange, Orange
SHAD STRIKE PRO PIGLET 10CM 7GR GREEN ICE
Exclusiv online!

SHAD STRIKE PRO PIGLET 10CM 7GR GREEN ICE

sp.sp172e.c018
Livrare 24-48 ore

53,17Lei

SHAD, STRIKE, PRO, PIGLET, 10CM, 7GR, FIRE, PERCH, sp.sp172e.c015, Shad-uri, Shad-uri Strike Pro, Strike Pro
Exclusiv online!

SHAD, STRIKE, PRO, PIGLET, 10CM, 7GR, FIRE, PERCH, sp.sp172e.c015, Shad-uri, Shad-uri Strike Pro, Strike Pro

sp.sp172e.c015
Livrare 24-48 ore

53,17Lei

SHAD STRIKE PRO PIGLET 10CM 7GR ICE SHAD -20%

SHAD STRIKE PRO PIGLET 10CM 7GR ICE SHAD

sp.sp172e.c014
Livrare imediată!

53,17Lei(-20%) 42,54Lei

SHAD STRIKE PRO PIG JR 15CM
Exclusiv online!

SHAD STRIKE PRO PIG JR 15CM

sp.sp172d.c018
Livrare 24-48 ore

53,17Lei

SHAD STRIKE PRO PIGLET 10CM ALCATRAZ C012 6BUC/PLIC

SHAD STRIKE PRO PIGLET 10CM ALCATRAZ C012 6BUC/PLIC

sp.sp172e.c012
Livrare imediată!

53,17Lei

SHAD STRIKE PRO PIGLET 10CM ALCATRAZ C001 6BUC/PLIC
Exclusiv online!

SHAD STRIKE PRO PIGLET 10CM ALCATRAZ C001 6BUC/PLIC

sp.sp172e.c001
Livrare 24-48 ore

53,17Lei

SHAD STRIKE PRO PIG JR 15CM Culoare:117 2BUC/PLIC
Exclusiv online!

SHAD STRIKE PRO PIG JR 15CM Culoare:117 2BUC/PLIC

sp.sp172d.117
Livrare 24-48 ore

53,17Lei

SHAD STRIKE PRO PIGLET C026 10CM 6BUC/PLIC
Exclusiv online!

SHAD STRIKE PRO PIGLET C026 10CM 6BUC/PLIC

sp.sp172e.c026
Livrare 24-48 ore

53,17Lei

Lingurita Oscilanta Colmic Herakles K1 Fat ADP176, 2.1g
Exclusiv online!

Lingurita Oscilanta Colmic Herakles K1 Fat ADP176, 2.1g

arhkk121f176
Livrare 48-72 ore

27,00Lei

Pop-up Steg Smoke Ball 8-10mm 20gr Sweet Spicy

Pop-up Steg Smoke Ball 8-10mm 20gr Sweet Spicy

sp170936
Stoc epuizat

19,00Lei

Pop-up Steg Smoke Ball 8-10mm 20gr Mango -5%

Pop-up Steg Smoke Ball 8-10mm 20gr Mango

sp170938
Stoc epuizat

18,50Lei(-5%) 17,51Lei

Pop-up Steg Smoke Ball 8-10mm 20gr Miere

Pop-up Steg Smoke Ball 8-10mm 20gr Miere

sp170923
Stoc epuizat

18,50Lei

Pop-up Steg Smoke Ball 8-10mm 20gr Sweet Dream

Pop-up Steg Smoke Ball 8-10mm 20gr Sweet Dream

sp170960
Stoc epuizat

19,00Lei

Pop-up Steg Smoke Ball 8-10mm 20gr Usturoi-Migdale

Pop-up Steg Smoke Ball 8-10mm 20gr Usturoi-Migdale

sp170952
Stoc epuizat

18,50Lei

Afişare 1 - 20 din 29 (2 pagini)
Queries: 13, Total time: 186.765 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '3cd322901ce4d9e3ae9985f736'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (184.708)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
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)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%p17%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:697
5 (0.112)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1547
6 (0.404)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
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 match_filters = 1 AND pd.language_id = '2'
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:181
7 (0.220)
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_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1204
8 (0.118)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1223
9 (0.107)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:982
10 (0.451)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:904
11 (0.108)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.107)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38