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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


TUB OVAL JAXON 155CM 5.00Cmx7.00Cm

TUB OVAL JAXON 155CM 5.00Cmx7.00Cm

aj-tu5070155v
Stoc epuizat

79,00Lei

TUB PROTECTIE NOD JAXON 40mm Verde

TUB PROTECTIE NOD JAXON 40mm Verde

ac-pc123cm
Stoc epuizat

9,00Lei

TUB ANTITANGLE MAVER

TUB ANTITANGLE MAVER

1538000
Stoc epuizat

7,70Lei

Kit Plasa Solubila CPK Slow Melt PVA cu Tub si Presa 10m 35 mm

Kit Plasa Solubila CPK Slow Melt PVA cu Tub si Presa 10m 35 mm

999765
Stoc epuizat

41,00Lei

Carp Zoom Tub PVA Mesh 37mm
Exclusiv online!

Carp Zoom Tub PVA Mesh 37mm

cz8832
Livrare 48-72 ore

58,00Lei

TUB PVA CARP ZOOM LONG CAST MESH 18MM 5m
Exclusiv online!

TUB PVA CARP ZOOM LONG CAST MESH 18MM 5m

cz8175
Livrare 48-72 ore

48,00Lei

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 145x11cm

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 145x11cm

uj-xar110145
Stoc epuizat

220,00Lei

CUTIE COLMIC SET TUB SILICON 0.3-0.5-0.7-1mm 4M

CUTIE COLMIC SET TUB SILICON 0.3-0.5-0.7-1mm 4M

sicp1
Stoc epuizat

51,00Lei

TUB PVA CARP ZOOM DEEP WATER MESH 37MM 5m
Exclusiv online!

TUB PVA CARP ZOOM DEEP WATER MESH 37MM 5m

cz8182
Livrare 48-72 ore

73,99Lei

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 145x9cm

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 145x9cm

uj-xar90145
Stoc epuizat

215,00Lei

TUB Sportex RIGID LANSETE VIII 150CM Grey
Exclusiv online!

TUB Sportex RIGID LANSETE VIII 150CM Grey

s308158
Livrare 48-72 ore

390,00Lei

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 2.4mm Clear
Exclusiv online!

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 2.4mm Clear

9900-00020-240
Livrare 48-72 ore

22,00Lei

TUB PROLOGIC ANTI TANGLE MIMICRY 2M

TUB PROLOGIC ANTI TANGLE MIMICRY 2M

a.pro.54420
Stoc epuizat

19,80Lei

STARLITE Carp Zoom SUPORT VARF + TUB 4.5x39mm
Exclusiv online!

STARLITE Carp Zoom SUPORT VARF + TUB 4.5x39mm

cz2714
Livrare 48-72 ore

3,00Lei

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 1.6mm Black
Exclusiv online!

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 1.6mm Black

9900-00019-160
Livrare 48-72 ore

22,00Lei

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 160x9cm

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 160x9cm

uj-xar90160
Stoc epuizat

228,00Lei

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 2.4mm Black
Exclusiv online!

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 2.4mm Black

9900-00019-240
Livrare 48-72 ore

22,00Lei

TUB Sportex RIGID BAITCAST SUPER SAFE XI 212CM Grey

TUB Sportex RIGID BAITCAST SUPER SAFE XI 212CM Grey

s308218
Stoc epuizat

489,99Lei

Tub Silicon DAM MAD Silicone Tube 0.5mm Green

Tub Silicon DAM MAD Silicone Tube 0.5mm Green

4030952115
Stoc epuizat

16,01Lei

Carp Zoom Tub PVA Mesh 23mm
Exclusiv online!

Carp Zoom Tub PVA Mesh 23mm

cz8863
Livrare 48-72 ore

52,00Lei

Afişare 421 - 440 din 497 (25 pagini)
Queries: 6, Total time: 18.672 ms [By time] [By id] [By file]
1 (0.071)
SELECT data
FROM `oc_session`
WHERE session_id = 'da240581e7fc4232b4c07b098d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.150)
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 = '3' AND (MATCH(pd.tag) AGAINST('+tub' 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 (0.144)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.107)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.090)
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