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


Fir WFT TF8 Catfish, Brown, 48kg, 0.50mm, 220m

Fir WFT TF8 Catfish, Brown, 48kg, 0.50mm, 220m

30484150
Livrare imediată!

93,00Lei

Fir WFT TF8 Catfish, Brown, 60kg, 0.60mm, 220m

Fir WFT TF8 Catfish, Brown, 60kg, 0.60mm, 220m

30484160
Livrare imediată!

93,00Lei

Fir WFT TF8 Rapitori, Galben Fluo, 8kg , 0.12mm, 150m
Exclusiv online!

Fir WFT TF8 Rapitori, Galben Fluo, 8kg , 0.12mm, 150m

30481012
Livrare 24-48 ore

66,00Lei

FIR TEXTIL WFT STRONG GREEN 150M 0.25mm 39kg
Exclusiv online!

FIR TEXTIL WFT STRONG GREEN 150M 0.25mm 39kg

30441125
Livrare 24-48 ore

187,00Lei

Fir Textil Wft 51kg Strong Chartreuse 0.32mm 300m -20%

Fir Textil Wft 51kg Strong Chartreuse 0.32mm 300m

30443032
Livrare imediată!

358,00Lei(-20%) 286,40Lei

Fir Textil Wft 39kg Strong Chartreuse 0.25mm 300m 39.00 kg
Exclusiv online!

Fir Textil Wft 39kg Strong Chartreuse 0.25mm 300m 39.00 kg

30443025
Livrare 24-48 ore

366,00Lei

FIR, TEXTIL, WFT, STRONG, GREEN, 150M, 0.22mm, 32kg, 30441122, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT
Exclusiv online!

FIR, TEXTIL, WFT, STRONG, GREEN, 150M, 0.22mm, 32kg, 30441122, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT

30441122
Livrare 24-48 ore

171,00Lei

FIR TEXTIL WFT STRONG GREEN 300M 0.25mm 39kg
Exclusiv online!

FIR TEXTIL WFT STRONG GREEN 300M 0.25mm 39kg

30441325
Livrare 24-48 ore

317,00Lei

FIR, TEXTIL, WFT, STRONG, GREEN, 300M, 0.18mm, 22kg, 30441318, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT
FIR, TEXTIL, WFT, STRONG, GREEN, 300M, 0.22mm, 32kg, 30441322, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT
Exclusiv online!

FIR, TEXTIL, WFT, STRONG, GREEN, 300M, 0.22mm, 32kg, 30441322, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT

30441322
Livrare 24-48 ore

352,00Lei

FIR, TEXTIL, WFT, STRONG, GREEN, 150M, 0.18mm, 22kg, 30441118, Fire Textile Rapitori, Fire Textile Rapitori WFT, Fire WFT, Textile WFT, Rapitori WFT, WFT
FIR TEXTIL WFT GLISS MONOTEX TRANSPARENT 0.14mm 8.0kg 150M

FIR TEXTIL WFT GLISS MONOTEX TRANSPARENT 0.14mm 8.0kg 150M

30448014
Livrare imediată!

80,00Lei

Fir textil WFT Strong Verde 0.08mm 300m

Fir textil WFT Strong Verde 0.08mm 300m

30441308
Livrare imediată!

269,00Lei

Fir Textil WFT New Strong Orange 0.32mm 300m 51kg -20%
Exclusiv online!

Fir Textil WFT New Strong Orange 0.32mm 300m 51kg

30473032
Livrare 24-48 ore

318,00Lei(-20%) 254,40Lei

Fir Wft Gliss Chartreuse 150m 12kg 0.18mm
Exclusiv online!

Fir Wft Gliss Chartreuse 150m 12kg 0.18mm

30444018
Livrare 24-48 ore

73,99Lei

Fir, Textil, WFT, New, Strong, Multicolor, 0.12mm, 300m, 15kg, 30470012, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT -20%
Exclusiv online!

Fir, Textil, WFT, New, Strong, Multicolor, 0.12mm, 300m, 15kg, 30470012, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT

30470012
Livrare 24-48 ore

245,00Lei(-20%) 196,00Lei

Fir Textil WFT New Strong Translucid 0.32mm 300m 51kg -20%
Exclusiv online!

Fir Textil WFT New Strong Translucid 0.32mm 300m 51kg

30472032
Livrare 24-48 ore

318,00Lei(-20%) 254,40Lei

Fir Textil WFT New Strong Translucid 0.22mm 150m 32kg -20%
Exclusiv online!

Fir Textil WFT New Strong Translucid 0.22mm 150m 32kg

30471022
Livrare 24-48 ore

152,00Lei(-20%) 121,59Lei

Fir, Textil, WFT, New, Strong, Multicolor, 0.39mm, 250m, 67kg, 30470039, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT -20%
Exclusiv online!

Fir, Textil, WFT, New, Strong, Multicolor, 0.39mm, 250m, 67kg, 30470039, Fire Textile Rapitori, Fire Textile Rapitori WFT, WFT

30470039
Livrare 24-48 ore

306,00Lei(-20%) 244,79Lei

Fir Textil WFT New Strong Orange 0.25mm 300m 39kg -20%

Fir Textil WFT New Strong Orange 0.25mm 300m 39kg

30473025
Livrare imediată!

280,00Lei(-20%) 224,01Lei

Afişare 1 - 20 din 53 (3 pagini)
Queries: 10, Total time: 834.631 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '6c850a6900d416ba7f6aaa52fc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.124)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (447.273)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND ((pd.tag LIKE '%fire%' AND pd.tag LIKE '%textile%' AND pd.tag LIKE '%rapitori%' AND pd.tag LIKE '%wft%')) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (386.462)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND ((pd.tag LIKE '%fire%' AND pd.tag LIKE '%textile%' AND pd.tag LIKE '%rapitori%' AND pd.tag LIKE '%wft%')) AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.122)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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)
WHERE p2s.store_id = '3' AND ((pd.tag LIKE '%fire%' AND pd.tag LIKE '%textile%' AND pd.tag LIKE '%rapitori%' AND pd.tag LIKE '%wft%')) AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
7 (0.129)
SELECT COUNT(*) AS val, filter_group, filter_id
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)
WHERE p2s.store_id = '3' AND ((pd.tag LIKE '%fire%' AND pd.tag LIKE '%textile%' AND pd.tag LIKE '%rapitori%' AND pd.tag LIKE '%wft%')) AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911
8 (0.094)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.073)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.096)
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