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


Lanseta Telescopica EnergoTeam Kamasaki Thunder 3.50m 50-100g

Lanseta Telescopica EnergoTeam Kamasaki Thunder 3.50m 50-100g

13592350
Livrare imediată!

63,00Lei

GEANTA, FOX, CAMOLITE, BARROW, BAG,, 57X31X35CM, clu285, Genti Universale, Genti Universale Fox, Fox

GEANTA, FOX, CAMOLITE, BARROW, BAG,, 57X31X35CM, clu285, Genti Universale, Genti Universale Fox, Fox

clu285
Livrare imediată!

598,46Lei

LANSETA COLMIC MALIB TELEBOAT 3.00M 50-150GR
Exclusiv online!

LANSETA COLMIC MALIB TELEBOAT 3.00M 50-150GR

cama91b
Livrare 48-72 ore

379,00Lei

Lanseta Benzar Universal Feeder 3.90m 20-120g 3+5buc

Lanseta Benzar Universal Feeder 3.90m 20-120g 3+5buc

12329390
Livrare imediată!

382,00Lei

GEANTA K-KARP COMBI CARRYALL
Exclusiv online!

GEANTA K-KARP COMBI CARRYALL

193-10-120
Livrare 48-72 ore

369,99Lei

Geanta Delphin Area Carry Carpath XL -30%

Geanta Delphin Area Carry Carpath XL

420220270
Livrare imediată!

254,01Lei(-30%) 179,00Lei

Lanseta EnergoTeam Goldstar Start 2.70m 40-80 g

Lanseta EnergoTeam Goldstar Start 2.70m 40-80 g

12055270
Livrare imediată!

39,00Lei

GEANTA DAIWA BLACK WIDOW CARRYALL 60X32X40CM -23%

GEANTA DAIWA BLACK WIDOW CARRYALL 60X32X40CM

d.18705.070
Livrare imediată!

315,56Lei(-23%) 242,90Lei

SUPORT U UNIVERSAL PT.LANSETE PROLOGIC

SUPORT U UNIVERSAL PT.LANSETE PROLOGIC

a6.pro.47361
Livrare imediată!

31,84Lei

LANSETA JAXON INTENSA GTX POWER TIP BOAT 2.70M 40-120GR
Exclusiv online!

LANSETA JAXON INTENSA GTX POWER TIP BOAT 2.70M 40-120GR

wj-ixv270120
Livrare 48-72 ore

237,00Lei

Geanta, Fox, Camolite, Low, Level, Carryall, clu298, Genti Universale, Genti Universale Fox, Genti Fox, Universale Fox, Fox
Exclusiv online!

Geanta, Fox, Camolite, Low, Level, Carryall, clu298, Genti Universale, Genti Universale Fox, Genti Fox, Universale Fox, Fox

clu298
Livrare 7-14 zile

517,46Lei

Varf Lanseta Trabucco Precision Feeder Universal 1oz

Varf Lanseta Trabucco Precision Feeder Universal 1oz

152-88-010
Livrare imediată!

38,00Lei

Lanseta EnergoTeam Goldstar Start 2.10m
Exclusiv online!

Lanseta EnergoTeam Goldstar Start 2.10m

12055210
Livrare 24-48 ore

32,00Lei

Geanta Mivardi Easy

Geanta Mivardi Easy

m-ccaea
Livrare imediată!

199,99Lei

Lanseta GOLD STAR TGV BOAT PICKER 2.10m -20%

Lanseta GOLD STAR TGV BOAT PICKER 2.10m

14088210
Livrare imediată!

103,99Lei(-20%) 83,20Lei

GEANTA CARP SPIRIT CARRYALL MARIME L

GEANTA CARP SPIRIT CARRYALL MARIME L

acs070054
Livrare imediată!

469,00Lei

JRC Cocoon 2G Universal Porch

JRC Cocoon 2G Universal Porch

1404479
Livrare imediată!

1.449,96Lei

LANSETA TELESCOPICA LINEAEFFE BLUE WAVE WWG 3.90M 220G

LANSETA TELESCOPICA LINEAEFFE BLUE WAVE WWG 3.90M 220G

l.2269839
Livrare imediată!

131,14Lei

LANSETA TELESCOPICA LINEAEFFE POWER DRIVE WWG 3.90M 250G -20%

LANSETA TELESCOPICA LINEAEFFE POWER DRIVE WWG 3.90M 250G

l.2268539
Livrare imediată!

259,75Lei(-20%) 207,80Lei

Lanseta, Telescopica, Baracuda, Gladiator, 2704,, 2.70m,, 50-150g,, 4seg, gladiator 2704, Lansete Universale, Lansete Universale Baracuda, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
Afişare 221 - 240 din 729 (37 pagini)
Queries: 8, Total time: 235.529 ms [By time] [By id] [By file]
1 (0.161)
SELECT data
FROM `oc_session`
WHERE session_id = 'd008cece624bddc358f70172e5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
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 (231.370)
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 = '3' AND (pd.tag LIKE "%universal%") 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:698
5 (3.477)
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 220, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.083)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.091)
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