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


ANTENA COLMIC PLUTE 3.5mm

ANTENA COLMIC PLUTE 3.5mm

ant3565
Livrare imediată!

17,01Lei

INELE, JAXON, , VARF, ALU, OXYD, NR, 10, 3.5MM, , ok-61035, Inele de Lanseta, Inele de Lanseta Jaxon, Jaxon
Exclusiv online!

INELE, JAXON, , VARF, ALU, OXYD, NR, 10, 3.5MM, , ok-61035, Inele de Lanseta, Inele de Lanseta Jaxon, Jaxon

ok-61035
Livrare 48-72 ore

38,00Lei

Pastila SIC Zebco Ring Insert 23.5mm

Pastila SIC Zebco Ring Insert 23.5mm

1671025
Livrare imediată!

22,28Lei

Inele Despicate Colmic Herakles Area Flat Split 3.5mm 20buc/plic

Inele Despicate Colmic Herakles Area Flat Split 3.5mm 20buc/plic

gmhksp35
Livrare imediată!

10,00Lei

Antene Pluta Colmic 3.5mm 80mm
Exclusiv online!

Antene Pluta Colmic 3.5mm 80mm

ant3580
Livrare 48-72 ore

17,01Lei

VARF JAXON FEEDER CARBON 3.5mm 50cm Medium
Exclusiv online!

VARF JAXON FEEDER CARBON 3.5mm 50cm Medium

ak-sww350b
Livrare 48-72 ore

33,00Lei

VARF JAXON FEEDER CARBON 3.5mm 50cm Soft

VARF JAXON FEEDER CARBON 3.5mm 50cm Soft

ak-sww350a
Livrare imediată!

33,00Lei

INELE, JAXON, , VARF, SIC/TS, NR, 12, 3.5MM, , ok-a1235, Inele de Lanseta, Inele de Lanseta Jaxon, Jaxon
VARF SENSAS PT. FEEDER BLACK ARROW 800 CARBON 4OZ/3.5MM
Exclusiv online!

VARF SENSAS PT. FEEDER BLACK ARROW 800 CARBON 4OZ/3.5MM

s.33110
Livrare 24-48 ore

188,81Lei

VARF JAXON FEEDER GLASS 3.5mm 50cm Medium
Exclusiv online!

VARF JAXON FEEDER GLASS 3.5mm 50cm Medium

ak-sws350b
Livrare 48-72 ore

25,00Lei

VARF JAXON FEEDER GLASS 3.5mm 50cm Super Soft
Exclusiv online!

VARF JAXON FEEDER GLASS 3.5mm 50cm Super Soft

ak-sws350aa
Livrare 48-72 ore

25,00Lei

VARF JAXON FEEDER GLASS 3.5mm 50cm Soft

VARF JAXON FEEDER GLASS 3.5mm 50cm Soft

ak-sws350a
Livrare imediată!

25,00Lei

VARF JAXON FEEDER GLASS 3.5mm 50cm Strong
Exclusiv online!

VARF JAXON FEEDER GLASS 3.5mm 50cm Strong

ak-sws350c
Livrare 48-72 ore

25,00Lei

SUPORT DAIWA TELESCOPIC 120CM 25X25X3.5MM
Exclusiv online!

SUPORT DAIWA TELESCOPIC 120CM 25X25X3.5MM

a6.pi257190
Livrare 24-48 ore

176,79Lei

Inele Despicate Rapture 3.5mm 8Kg 20buc

Inele Despicate Rapture 3.5mm 8Kg 20buc

188-95-003
Livrare imediată!

10,00Lei

Oscilanta, DAM, Effzett, Pro, Trout, Black, Blue, No.6, 33.5mm, 3.3g, 13042960195, Lingurite Pastrav, Lingurite Pastrav DAM, DAM
Exclusiv online!

Oscilanta, DAM, Effzett, Pro, Trout, Black, Blue, No.6, 33.5mm, 3.3g, 13042960195, Lingurite Pastrav, Lingurite Pastrav DAM, DAM

13042960195
Livrare 48-72 ore

10,56Lei

PRASTIE MATRIX SLIK CATAPULTS Large - X-Heavy Elastic 3.5mm

PRASTIE MATRIX SLIK CATAPULTS Large - X-Heavy Elastic 3.5mm

gpt006
Livrare imediată!

71,50Lei

Varf, Garbolino, Essential, Feeder, Carbon,, 70cm,, 5oz/142g,, 3.5mm,, 6, inele, 20530gofrf8445-c-5, Varfuri Feeder, Varfuri Feeder Garbolino, Garbolino
SET INELE BROWNING 30MM 3.5MM
Exclusiv online!

SET INELE BROWNING 30MM 3.5MM

v.bo.dfmbr0303
Livrare 24-48 ore

371,26Lei

VARF PRESTON QUIVERTIP PENTRU LANSETE ASCENSION FEEDER 2.5oz 3.5mm

VARF PRESTON QUIVERTIP PENTRU LANSETE ASCENSION FEEDER 2.5oz 3.5mm

p0070037
Stoc epuizat

107,96Lei

Afişare 21 - 40 din 49 (3 pagini)
Queries: 10, Total time: 179.630 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = '135aea3cdcb99db32a1f5be9c3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (177.332)
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 "%3.5mm%") 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 (0.240)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.499)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.252)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.149)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.137)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (0.586)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.185)
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