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

Produse ce potrivesc criteriilor de căutare


FIR LEADER CARP ZOOM FLUOROCARBON FEEDER 25m 0.20mm 3.54kg -21%

FIR LEADER CARP ZOOM FLUOROCARBON FEEDER 25m 0.20mm 3.54kg

cz2591
Livrare imediată!

21,50Lei(-21%) 16,90Lei

JIG FUDO 3.5GR CARLIG NR 1/0 8BUC

JIG FUDO 3.5GR CARLIG NR 1/0 8BUC

jfb-1/0-035
Livrare imediată!

15,01Lei

Antene Pluta Colmic 3.5mm 80mm
Exclusiv online!

Antene Pluta Colmic 3.5mm 80mm

ant3580
Livrare 48-72 ore

17,01Lei

Suport Maver EVA pentru monturi 4x3.5cm
Exclusiv online!

Suport Maver EVA pentru monturi 4x3.5cm

1262008
Livrare 48-72 ore

4,20Lei

Lanseta Fox EOS Pro 3.90M 3.5lb 2seg

Lanseta Fox EOS Pro 3.90M 3.5lb 2seg

crd328
Livrare imediată!

380,21Lei

PILKER JAXON MIX B 5.0GR 3.5CM 5/SET

PILKER JAXON MIX B 5.0GR 3.5CM 5/SET

bp-jb035mix
Livrare imediată!

98,00Lei

VIBER CRAW COLMIC 3.5" 8.9cm GREEN PUMPKIN -40%
Exclusiv online!

VIBER CRAW COLMIC 3.5" 8.9cm GREEN PUMPKIN

arhkcg05
Livrare 48-72 ore

37,00Lei(-40%) 22,21Lei

Lanseta Carp Expert Black Shadow Carp 3.60m 3.5lbs 3buc
Exclusiv online!

Lanseta Carp Expert Black Shadow Carp 3.60m 3.5lbs 3buc

13399360
Livrare 24-48 ore

224,01Lei

Lanseta Nevis Amethyst 3.60M 3.50lbs 2SEG
Exclusiv online!

Lanseta Nevis Amethyst 3.60M 3.50lbs 2SEG

1767-360
Livrare 48-72 ore

323,00Lei

VOBLER DAIWA PROREX MINNOW 13.5CM/18G FIRETIGER -23%

VOBLER DAIWA PROREX MINNOW 13.5CM/18G FIRETIGER

f3.d15414.001
Livrare imediată!

65,00Lei(-23%) 50,03Lei

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.18MM 13.50 KG
Exclusiv online!

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.18MM 13.50 KG

ec2672
Livrare 48-72 ore

9,00Lei

HYPERVIBE COLMIC 3.5" 8.9cm BLACK RED FLK -40%
Exclusiv online!

HYPERVIBE COLMIC 3.5" 8.9cm BLACK RED FLK

arhkdt03
Livrare 48-72 ore

39,00Lei(-40%) 23,40Lei

JIG FUDO 3.5GR CARLIG NR 1 8BUC

JIG FUDO 3.5GR CARLIG NR 1 8BUC

jfb-1-035
Livrare imediată!

15,01Lei

JIG FUDO 3.5GR CARLIG NR 5/0 6BUC

JIG FUDO 3.5GR CARLIG NR 5/0 6BUC

jfb-5/0-035
Livrare imediată!

15,01Lei

HYPERVIBE COLMIC 3.5" 8.9cm PB J -40%
Exclusiv online!

HYPERVIBE COLMIC 3.5" 8.9cm PB J

arhkdt01
Livrare 48-72 ore

39,00Lei(-40%) 23,40Lei

VIBER CRAW COLMIC 3.5" 8.9cm ROOTBEAR -40%
Exclusiv online!

VIBER CRAW COLMIC 3.5" 8.9cm ROOTBEAR

arhkcg06
Livrare 48-72 ore

37,00Lei(-40%) 22,21Lei

Lanseta Sportex COMPETITION CRAP CS-4 12FT 3.65M 3.50lbs

Lanseta Sportex COMPETITION CRAP CS-4 12FT 3.65M 3.50lbs

cc144352
Livrare imediată!

780,00Lei

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 02 Black Pearl

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 02 Black Pearl

804020070
Livrare imediată!

40,83Lei

Jig Jackson QuOn BF Cover 3.5g culoare SST
Exclusiv online!

Jig Jackson QuOn BF Cover 3.5g culoare SST

bf3.5-sst
Livrare 48-72ore

29,50Lei

Plumbi Colmic Herakles MDJ Sinker 3.5gr
Exclusiv online!

Plumbi Colmic Herakles MDJ Sinker 3.5gr

pohkmd02
Livrare 48-72 ore

12,99Lei

Afişare 521 - 540 din 1791 (90 pagini)
Queries: 11, Total time: 605.189 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '1701f0cc456f6fd2749b798d44'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.055)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (573.172)
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 (pd.tag LIKE "%3.5%") 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.321)
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 (10.731)
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 520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (2.844)
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:1248
8 (0.131)
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:1270
9 (0.642)
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:1035
10 (16.965)
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:949
11 (0.113)
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