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


Vesta Utilitara Fox Rage Street Fighter

Vesta Utilitara Fox Rage Street Fighter

nlu120
Livrare imediată!

359,96Lei

Rucsac Fox Rage Street Fighter
Exclusiv online!

Rucsac Fox Rage Street Fighter

nlu116
Livrare 7-14 zile

472,47Lei

Geanta Umar Fox Rage Street Fighter
Exclusiv online!

Geanta Umar Fox Rage Street Fighter

nlu121
Livrare 7-14 zile

269,96Lei

Scaun DAM Fighter Pro Pliabil cu Spatar, Sarcina Maxima 100kg
Exclusiv online!

Scaun DAM Fighter Pro Pliabil cu Spatar, Sarcina Maxima 100kg

a8.dam.8470006
Livrare 24-48 ore

169,13Lei

Lanseta Bolognesa FL Fight River 5M

Lanseta Bolognesa FL Fight River 5M

6224171532137
Livrare imediată!

120,80Lei

Lanseta Bolognesa FL Fight River 4M

Lanseta Bolognesa FL Fight River 4M

4224175045475
Livrare imediată!

103,49Lei

Lanseta Baracuda Catfish Fighter 3002 3.00M 50-150g 2seg

Lanseta Baracuda Catfish Fighter 3002 3.00M 50-150g 2seg

catfish fighter 3002
Livrare imediată!

121,58Lei

Lanseta Baracuda Catfish Fighter 2702 2.70m 50-150g 2seg

Lanseta Baracuda Catfish Fighter 2702 2.70m 50-150g 2seg

catfish fighter 2702
Livrare imediată!

117,91Lei

Varga DAM Fighter Pro Combo T-Pole 4.00m

Varga DAM Fighter Pro Combo T-Pole 4.00m

dam.56989
Livrare imediată!

70,29Lei

Lanseta Baracuda Catfish Fighter 2402 2.40m 50-150g 2seg

Lanseta Baracuda Catfish Fighter 2402 2.40m 50-150g 2seg

catfish fighter 2402
Livrare imediată!

98,70Lei

Lanseta, Bolognesa, FL, Fight, River, 6M, 3224177698335, Lansete Bolognese 6 Metri, Lansete Bolognese 6 Metri FL., FL.
Lanseta Bolognesa FL Fight River 7M

Lanseta Bolognesa FL Fight River 7M

1224170704158
Livrare imediată!

169,90Lei

Varga DAM Fighter Pro Combo T-Pole 3.00m

Varga DAM Fighter Pro Combo T-Pole 3.00m

dam.56988
Livrare imediată!

56,67Lei

CARLIGE Delphin THORN Fighter 11x NR.8

CARLIGE Delphin THORN Fighter 11x NR.8

101001444
Stoc epuizat

22,00Lei

CARLIGE Delphin THORN Fighter 11x NR.4

CARLIGE Delphin THORN Fighter 11x NR.4

101001442
Stoc epuizat

23,00Lei

Lanseta Okuma C-Fight 3.60m 3.25lbs 2buc

Lanseta Okuma C-Fight 3.60m 3.25lbs 2buc

cf-ca-1202h
Stoc epuizat

332,11Lei

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.XXL

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.XXL

a8.sg.73892
Stoc epuizat

213,80Lei

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.M

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.M

a8.sg.73889
Stoc epuizat

134,10Lei

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 3.50M

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 3.50M

3102-3504
Stoc epuizat

103,90Lei

Vobler Filfishing Fighter Sinking, 07, 9.6g, 7cm

Vobler Filfishing Fighter Sinking, 07, 9.6g, 7cm

fil5481-07
Stoc epuizat

22,00Lei

Afişare 141 - 160 din 189 (10 pagini)
Queries: 6, Total time: 224.833 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = 'aa4f262810930a69389691ce14'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.134)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (222.810)
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 "%fight%") 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 (1.542)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.098)
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