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 Wizard Vertix Boat Catfish, 1.27m, 8 lbs, 1seg
Exclusiv online!

Lanseta Wizard Vertix Boat Catfish, 1.27m, 8 lbs, 1seg

14520127
Livrare 24-48 ore

185,00Lei

Pluta Ex - Catfish 010 - 300G
Exclusiv online!

Pluta Ex - Catfish 010 - 300G

smct-010-300
Livrare 48-72 ore

59,00Lei

Tricou Zeck Catfish 23 T-Shirt, Marimea XXL
Exclusiv online!

Tricou Zeck Catfish 23 T-Shirt, Marimea XXL

80805281547
Livrare 48-72 ore

157,02Lei

Atractant Lichid BENZAR MIX Catfish Spray, Bloody Fermented Schrimp Octopus, 50ml
Exclusiv online!

Atractant Lichid BENZAR MIX Catfish Spray, Bloody Fermented Schrimp Octopus, 50ml

93740064
Livrare 24-48 ore

28,00Lei

Geanta Impermeabila Zeck L Tackle Container Pro Catfish, 40x26x25cm
Exclusiv online!

Geanta Impermeabila Zeck L Tackle Container Pro Catfish, 40x26x25cm

90405160020
Livrare 48-72 ore

424,16Lei

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea L
Exclusiv online!

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea L

80305170226
Livrare 48-72 ore

263,53Lei

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea M
Exclusiv online!

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea M

80305170225
Livrare 48-72 ore

263,53Lei

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea XL
Exclusiv online!

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea XL

80305170227
Livrare 48-72 ore

263,53Lei

Lanseta Somn Wizard Vertic Guide Catfish, 50-150g, 2.10m, 2seg
Exclusiv online!

Lanseta Somn Wizard Vertic Guide Catfish, 50-150g, 2.10m, 2seg

13148213
Livrare 24-48 ore

275,00Lei

Lanseta Wizard Vertix Boat Catfish, 1.65m, 12 lbs, 1seg
Exclusiv online!

Lanseta Wizard Vertix Boat Catfish, 1.65m, 12 lbs, 1seg

14520165
Livrare 24-48 ore

198,00Lei

Lanseta Wizard Vertix Boat Jig Catfish, 1.68m, 200-300g, 1+1seg
Exclusiv online!

Lanseta Wizard Vertix Boat Jig Catfish, 1.68m, 200-300g, 1+1seg

14525168
Livrare 24-48 ore

190,00Lei

Lanseta Wizard Vertix Boat Jig Catfish, 1.80m, 200-300g, 1+1seg
Exclusiv online!

Lanseta Wizard Vertix Boat Jig Catfish, 1.80m, 200-300g, 1+1seg

14525180
Livrare 24-48 ore

205,00Lei

Montura Catfish - Mono Set I-Adjustable Combi Rig 10G-200Cm-100Kg - Ancora: 2/0 -
Exclusiv online!

Montura Catfish - Mono Set I-Adjustable Combi Rig 10G-200Cm-100Kg - Ancora: 2/0 -

HIC093-2/0
Livrare 48-72 ore

87,00Lei

Montura, Catfish, -, Mono, Set, Iii, -, Big, Bait, Ready, Rig, 10G-200Cm-100Kg, -, Ancora:, 2/0, Carlig, Nr, 4/0, HIC095-2/0, Monturi Somn, Monturi Somn Mikado, Monturi Mikado, Somn Mikado, Mikado
Pantaloni Impermeabili Zeck Rain Trousers Catfish, Marime M
Exclusiv online!

Pantaloni Impermeabili Zeck Rain Trousers Catfish, Marime M

80405170333
Livrare 48-72 ore

168,28Lei

Pantaloni Impermeabili Zeck Rain Trousers Catfish, Marime M
Exclusiv online!

Pantaloni Impermeabili Zeck Rain Trousers Catfish, Marime M

80405170334
Livrare 48-72 ore

166,28Lei

Pluta Ex - Catfish 009 - 280G
Exclusiv online!

Pluta Ex - Catfish 009 - 280G

smct-009-280
Livrare 48-72 ore

39,00Lei

Ruleta Masurare Somn -Catfish Tape - 3M
Exclusiv online!

Ruleta Masurare Somn -Catfish Tape - 3M

am-sum-004
Livrare 48-72 ore

33,00Lei

Mulineta Energo Team Specialist Catfish 8000

Mulineta Energo Team Specialist Catfish 8000

20422999
Livrare imediată!

208,00Lei

LANSETA SOMN KOOS CATFISH SHADOW 2.20MT 500-700GR

LANSETA SOMN KOOS CATFISH SHADOW 2.20MT 500-700GR

17393220
Livrare imediată!

256,00Lei

Afişare 61 - 80 din 374 (19 pagini)
Queries: 5, Total time: 179.689 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = '4ce8997a9338a11709eab2a5e0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (177.683)
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 "%catfish%") 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.666)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.119)
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