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 400 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


Lingura Rotativa 14gr DAM Effzett Tandem Dressed Silver Red
Exclusiv online!

Lingura Rotativa 14gr DAM Effzett Tandem Dressed Silver Red

803090080
Livrare 48-72 ore

25,39Lei

Carlig Owner 5123 No.1/0 Baitholder Hook Red

Carlig Owner 5123 No.1/0 Baitholder Hook Red

5123113
Livrare imediată!

18,66Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 60cm 5kg
Exclusiv online!

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 60cm 5kg

8610-20004-005
Livrare 48-72 ore

12,00Lei

Shad Biwaa Submission 13cm culoare Watermelon Red
Exclusiv online!

Shad Biwaa Submission 13cm culoare Watermelon Red

b000843
Livrare 48-72 ore

50,00Lei

SHAD LINEAEFFE NOMURA ORIGINAL CHART YELLOW RED 10CM/7,8G 6BUC/PL
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL CHART YELLOW RED 10CM/7,8G 6BUC/PL

f1.nm.76301610
Livrare 24-48 ore

32,59Lei

SHAD RAPTURE POWER SHAD DUAL 11.5CM RED/YLW
Exclusiv online!

SHAD RAPTURE POWER SHAD DUAL 11.5CM RED/YLW

188-00-951
Livrare 48-72 ore

27,00Lei

STRUNA Climax ULTRA PREDATOR HARDMONO 60cm 13.6kg
Exclusiv online!

STRUNA Climax ULTRA PREDATOR HARDMONO 60cm 13.6kg

8610-20007-014
Livrare 48-72 ore

11,00Lei

Lingura Rotativa 7gr DAM Effzett Minnow Red Glitter
Exclusiv online!

Lingura Rotativa 7gr DAM Effzett Minnow Red Glitter

803095138207
Livrare 48-72 ore

21,75Lei

PLUTA MOSTIRO FLEXI ELITE RED STARLET 2.5GR

PLUTA MOSTIRO FLEXI ELITE RED STARLET 2.5GR

2420550925000-bucxxx
Livrare imediată!

5,00Lei

Shad Biwaa Submission 10cm culoare Watermelon Red
Exclusiv online!

Shad Biwaa Submission 10cm culoare Watermelon Red

b000836
Livrare 48-72 ore

50,00Lei

SHAKY WORM 160mm WATERMELON RED
Exclusiv online!

SHAKY WORM 160mm WATERMELON RED

801020011
Livrare 48-72 ore

27,83Lei

Monofilament Nevis Red Carp Feeder 300m 0.25mm

Monofilament Nevis Red Carp Feeder 300m 0.25mm

3231-325
Livrare imediată!

29,00Lei

Naluca Carp Zoom PREDATOR-Z DANCING FROG 5cm 13gr
Exclusiv online!

Naluca Carp Zoom PREDATOR-Z DANCING FROG 5cm 13gr

cz3344
Livrare 48-72 ore

27,00Lei

SHAD CARP ZOOM PREDATOR-Z OPLUS LONGTAIL KILLER 10CM CZ7817
Exclusiv online!

SHAD CARP ZOOM PREDATOR-Z OPLUS LONGTAIL KILLER 10CM CZ7817

cz7817
Livrare 48-72 ore

28,00Lei

Shad Delphin BOMB Fatty/5buc 10Cm Redface

Shad Delphin BOMB Fatty/5buc 10Cm Redface

690011009
Livrare imediată!

28,00Lei

Pluta Culisanta Black Cat Somn 10gr Propeller U-Float X-Strong Neon Red UV
Exclusiv online!

Pluta Culisanta Black Cat Somn 10gr Propeller U-Float X-Strong Neon Red UV

5553010
Livrare 7-14 zile

35,78Lei

Nada Benzar Method Mix Red Krill 800g

Nada Benzar Method Mix Red Krill 800g

98005907
Livrare imediată!

24,00Lei

Carlig Owner 5123 No.4 Baitholder Hook Red
Exclusiv online!

Carlig Owner 5123 No.4 Baitholder Hook Red

5123073
Livrare 48-72 ore

18,66Lei

CARLIGE FUDO SODE RED NR.18 -59%

CARLIGE FUDO SODE RED NR.18

1204-18
Livrare imediată!

10,00Lei(-59%) 4,13Lei

STRUNA Climax ULTRA PREDATOR HARDMONO 60cm 23kg
Exclusiv online!

STRUNA Climax ULTRA PREDATOR HARDMONO 60cm 23kg

8610-20007-023
Livrare 48-72 ore

11,00Lei

Afişare 1081 - 1100 din 2686 (135 pagini)
Queries: 5, Total time: 1,226.000 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = 'be065f522db0e06d66c4096ea8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,212.448)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%red%") 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:725
4 (13.159)
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 1080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38