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


Extensie Fox Frontier Deluxe Extension System 250x150x145cm

Extensie Fox Frontier Deluxe Extension System 250x150x145cm

cum333
Livrare imediată!

2.474,96Lei

Fir Inaintas Monofilament FOX Exocet Pro Leader Low Vis Green, 100m, 60lb/27.3kg, 0.70mm
Exclusiv online!

Fir Inaintas Monofilament FOX Exocet Pro Leader Low Vis Green, 100m, 60lb/27.3kg, 0.70mm

cml198
Livrare 7-14 zile

62,96Lei

Fir Textil cu Camasa Fox Naturals Coretex, Verde Inchis, 20m, 20lb/9.1kg

Fir Textil cu Camasa Fox Naturals Coretex, Verde Inchis, 20m, 20lb/9.1kg

cac815
Livrare imediată!

85,00Lei

Galeata Fox Spomb Square Bucket, 17l

Galeata Fox Spomb Square Bucket, 17l

dbt001
Livrare imediată!

80,96Lei

Hanger Fox Black Label Dinky Bobbin, Alb -23%
Exclusiv online!

Hanger Fox Black Label Dinky Bobbin, Alb

cbi130
Livrare 7-14 zile

71,96Lei(-23%) 55,67Lei

HUSA FL CARP 3 LANSETE PLUS MULINETE 215CM

HUSA FL CARP 3 LANSETE PLUS MULINETE 215CM

64-2065x
Livrare imediată!

178,90Lei

Husa Minciog Fox Welded Stink Bag, 150x22cm
Exclusiv online!

Husa Minciog Fox Welded Stink Bag, 150x22cm

ccc062
Livrare 7-14 zile

98,96Lei

Rucsac Fox Rage Street Fighter
Exclusiv online!

Rucsac Fox Rage Street Fighter

nlu116
Livrare 7-14 zile

472,47Lei

Spikey Shad Fox Rage UV - Blue Guts, 9cm

Spikey Shad Fox Rage UV - Blue Guts, 9cm

npk031
Livrare imediată!

4,95Lei

Swimbait FOX Rage Replicant Wobble UV - Natural Perch, 7.5cm, 10g, 2buc/blister

Swimbait FOX Rage Replicant Wobble UV - Natural Perch, 7.5cm, 10g, 2buc/blister

nre102
Livrare imediată!

29,21Lei

Vesta Fox Rage Heated gilet Large

Vesta Fox Rage Heated gilet Large

npr419
Livrare imediată!

652,47Lei

Vesta Fox Rage Heated gilet XXXXL
Exclusiv online!

Vesta Fox Rage Heated gilet XXXXL

npr423
Livrare 7-14 zile

652,47Lei

Agrafa Rapida si Manson Fox Edges Rig Link and Tungsten Sleeve, 10buc/pac

Agrafa Rapida si Manson Fox Edges Rig Link and Tungsten Sleeve, 10buc/pac

cac880
Livrare imediată!

21,55Lei

Cort Fox Voyager 1 Person Bivvy + Inner Dome, 235x295x165cm
Exclusiv online!

Cort Fox Voyager 1 Person Bivvy + Inner Dome, 235x295x165cm

cum314
Livrare 7-14 zile

2.654,96Lei

Costum FOX Rage Winter suit - XXL -16%

Costum FOX Rage Winter suit - XXL

npr414
Livrare imediată!

939,30Lei(-16%) 790,01Lei

Fir Textil Fox Naturals Submerge Leader, 10m, 40lb/18.1k

Fir Textil Fox Naturals Submerge Leader, 10m, 40lb/18.1k

cac824
Livrare imediată!

89,96Lei

Geanta Fox Rage Chest Pack, Black
Exclusiv online!

Geanta Fox Rage Chest Pack, Black

nlu123
Livrare 7-14 zile

179,96Lei

Hanger Fox Black Label Dinky Bobbin, Mov -23%
Exclusiv online!

Hanger Fox Black Label Dinky Bobbin, Mov

cbi129
Livrare 7-14 zile

71,96Lei(-23%) 55,67Lei

Hanger Fox Black Label Indicator Slik Bobbin, Gunsmoke -23%
Exclusiv online!

Hanger Fox Black Label Indicator Slik Bobbin, Gunsmoke

cbi057
Livrare 7-14 zile

80,96Lei(-23%) 62,62Lei

Inele Despicate Fox Rage Srike Point Stainless Steel Small, 10buc
Exclusiv online!

Inele Despicate Fox Rage Srike Point Stainless Steel Small, 10buc

nac043
Livrare 7-14 zile

13,46Lei

Afişare 1541 - 1560 din 2721 (137 pagini)
Queries: 5, Total time: 92.120 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '51ab306b043fd6e9b7ea3a761b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.064)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (81.889)
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 (MATCH(pd.tag) AGAINST('+fox' IN BOOLEAN MODE)) 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:737
4 (9.947)
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 1540, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.119)
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