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 Colmic Herakles Black Weapon Revenge Cast 2.05m 7-21g 1Seg
Exclusiv online!

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.05m 7-21g 1Seg

cahkbwr52
Livrare 48-72 ore

1.000,00Lei

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.03m 3-17g 1Seg
Exclusiv online!

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.03m 3-17g 1Seg

cahkbwr51
Livrare 48-72 ore

959,00Lei

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.20m 10-42g 1Seg
Exclusiv online!

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.20m 10-42g 1Seg

cahkbwr54
Livrare 48-72 ore

980,00Lei

Minciog Prologic C-Series Black 1.80m 1seg

Minciog Prologic C-Series Black 1.80m 1seg

a2.pro.65033
Livrare imediată!

218,37Lei

MINCIOG DAIWA BLACK WIDOW 1.81M 100X100CM 1SEG

MINCIOG DAIWA BLACK WIDOW 1.81M 100X100CM 1SEG

a2.m11579.185
Livrare imediată!

316,16Lei

Maner Minciog Crap Mivardi Easy 1Seg 1.80M

Maner Minciog Crap Mivardi Easy 1Seg 1.80M

miv-lnhea180
Livrare imediată!

79,00Lei

MINCIOG DAIWA BLACK WIDOW 1.82M 100X100CM 1SEG -23%
Exclusiv online!

MINCIOG DAIWA BLACK WIDOW 1.82M 100X100CM 1SEG

a2.m11579.180
Livrare 48-72 ore

294,64Lei(-23%) 226,90Lei

Lanseta, Daiwa, Steez, AGS, 6101MHFB, Baitcast, 2.08M, 7-28g, 1SEG, d.stzags6101mhfbbf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

Lanseta, Daiwa, Steez, AGS, 6101MHFB, Baitcast, 2.08M, 7-28g, 1SEG, d.stzags6101mhfbbf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.stzags6101mhfbbf
Livrare 24-48 ore

1.205,39Lei

Lanseta, Daiwa, Tatula, Baitcast, 701MRBAF, 2.13M, 7-21g, 1SEG, d.tat701mrbaf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -20%
Exclusiv online!

Lanseta, Daiwa, Tatula, Baitcast, 701MRBAF, 2.13M, 7-21g, 1SEG, d.tat701mrbaf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.tat701mrbaf
Livrare 24-48 ore

726,96Lei(-20%) 581,64Lei

Lanseta Airrus Stargate Casting H 2.13m 10.50-42gr 1seg
Exclusiv online!

Lanseta Airrus Stargate Casting H 2.13m 10.50-42gr 1seg

asg701mxf-s
Livrare 48-72 ore

1.370,00Lei

Lanseta, Daiwa, Tatula, 6101, MXS, 2.08M, 5-21g, 1SEG, d.tat6101mxsaf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -20%
Exclusiv online!

Lanseta, Daiwa, Tatula, 6101, MXS, 2.08M, 5-21g, 1SEG, d.tat6101mxsaf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.tat6101mxsaf
Livrare 24-48 ore

768,55Lei(-20%) 614,84Lei

MINCIOG DAIWA CROSSCAST 1.80M 100X100CM 1SEG -12%

MINCIOG DAIWA CROSSCAST 1.80M 100X100CM 1SEG

a2.m11561.175
Livrare imediată!

362,53Lei(-12%) 318,90Lei

Lanseta Airrus Stargate Casting H 2.13m 10.5-42g 1seg
Exclusiv online!

Lanseta Airrus Stargate Casting H 2.13m 10.5-42g 1seg

asg701hxf-c
Livrare 48-72 ore

1.370,00Lei

Lanseta Airrus Stargate Casting 1.98M 7-17.5g 1seg
Exclusiv online!

Lanseta Airrus Stargate Casting 1.98M 7-17.5g 1seg

asg661mf-c
Livrare 48-72 ore

1.370,00Lei

Minciog Prologic Avenger Camo 1.80m 1seg -30%

Minciog Prologic Avenger Camo 1.80m 1seg

a2.pro.65004
Livrare imediată!

229,86Lei(-30%) 160,90Lei

MINCIOG PROLOGIC C3 RIDGID FRAMED CAMO RUBBER 1SEG 120CM -22%

MINCIOG PROLOGIC C3 RIDGID FRAMED CAMO RUBBER 1SEG 120CM

a2.pro.64999
Livrare imediată!

385,20Lei(-22%) 299,00Lei

Lanseta, Daiwa, Steez, AGS, 2.08m, 7-28g, 1seg, d.stzags6101mhfbcf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -20%
Exclusiv online!

Lanseta, Daiwa, Steez, AGS, 2.08m, 7-28g, 1seg, d.stzags6101mhfbcf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.stzags6101mhfbcf
Livrare 24-48 ore

1.694,49Lei(-20%) 1.355,59Lei

LANSETA GRAPHITELEADER VELOCE 21GVELUC-65ML R-FAST 1.96M 21G 1seg
Exclusiv online!

LANSETA GRAPHITELEADER VELOCE 21GVELUC-65ML R-FAST 1.96M 21G 1seg

g18206
Livrare 48-72 ore

1.230,00Lei

Minciog DAM Floating Landing Net XL, 1seg, 45x55x45, 110cm
Exclusiv online!

Minciog DAM Floating Landing Net XL, 1seg, 45x55x45, 110cm

a2.dam.65798
Livrare 24-48 ore

164,01Lei

LANSETA GRAPHITELEADER VELOCE 21GVELUS-610ML R-FAST 2.09M 10.5G 1seg
Exclusiv online!

LANSETA GRAPHITELEADER VELOCE 21GVELUS-610ML R-FAST 2.09M 10.5G 1seg

g18212
Livrare 48-72 ore

1.290,00Lei

Afişare 121 - 140 din 225 (12 pagini)
Queries: 4, Total time: 192.069 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = 'a70b63cbea405246be50b90d58'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (191.679)
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 "%1seg%") 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
4 (0.144)
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