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


LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA YANKEE 3gr White Pink -35%

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA YANKEE 3gr White Pink

arhkli12
Stoc epuizat

13,99Lei(-35%) 9,10Lei

Shad Biwaa Divinator S 13cm culoare Pearl White

Shad Biwaa Divinator S 13cm culoare Pearl White

b000232
Stoc epuizat

37,00Lei

LINGURITA OSCILANTA COLMIC HIVE 2.4gr White Pink

LINGURITA OSCILANTA COLMIC HIVE 2.4gr White Pink

arhkhiv12
Stoc epuizat

20,00Lei

LINGURITA OSCILANTA COLMIC HERAKLES RUCK SPOON 2.0gr White Pink

LINGURITA OSCILANTA COLMIC HERAKLES RUCK SPOON 2.0gr White Pink

arhkfe12
Stoc epuizat

17,01Lei

Sapca Magic Trout Trucker Cap Red White

Sapca Magic Trout Trucker Cap Red White

9788011
Stoc epuizat

44,78Lei

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr White Pink

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr White Pink

arhklm12
Stoc epuizat

22,00Lei

Lanseta Zebco Great White GWC Sensi Boat 2.35m, 850g, 2seg

Lanseta Zebco Great White GWC Sensi Boat 2.35m, 850g, 2seg

13095236
Stoc epuizat

211,28Lei

SLIM SHAD 4PREDATORS FLOATING 9CM / 5BUC / 4.3GR WHITE

SLIM SHAD 4PREDATORS FLOATING 9CM / 5BUC / 4.3GR WHITE

4p-ss9-s001
Stoc epuizat

10,00Lei

SHAD BIWAA DIVINATOR S 10cm 08 Pearl White

SHAD BIWAA DIVINATOR S 10cm 08 Pearl White

b000137
Stoc epuizat

36,00Lei

LINGURITA OSCILANTA COLMIC HERAKLES VENTO GOLD 3.5gr White Pink

LINGURITA OSCILANTA COLMIC HERAKLES VENTO GOLD 3.5gr White Pink

arhkven12
Stoc epuizat

21,00Lei

Spinnerbait Sakura Cajun 14g Kicker White

Spinnerbait Sakura Cajun 14g Kicker White

130334saplf50041/2-jc11
Stoc epuizat

37,34Lei

Spinnerbait RAPTURE WINDEX SNIPER BUZZER 14gr White

Spinnerbait RAPTURE WINDEX SNIPER BUZZER 14gr White

188-21-501
Stoc epuizat

27,00Lei

Spinnerbait Sakura Cajun 10.5g Kicker White

Spinnerbait Sakura Cajun 10.5g Kicker White

130334saplf50043/8-jc11
Stoc epuizat

35,89Lei

VOBLER SAVAGE 3D CRUCIAN CRANK 4.6CM/7G SF SR03 PEARL WHITE SILVER

VOBLER SAVAGE 3D CRUCIAN CRANK 4.6CM/7G SF SR03 PEARL WHITE SILVER

sg.53776
Stoc epuizat

38,14Lei

Fir textil Climax FIR BLADE LINE WHITE 100m 0.04mm 2.7kg

Fir textil Climax FIR BLADE LINE WHITE 100m 0.04mm 2.7kg

9421-00100-004
Stoc epuizat

51,00Lei

LINGURITA OSCILANTA COLMIC LDS 3.6gr White Pink

LINGURITA OSCILANTA COLMIC LDS 3.6gr White Pink

arhklds12
Stoc epuizat

22,00Lei

LINGURITA OSCILANTA BERTILURE CANDY TROUT NR.1 LUNGIME 28MM. CULOARE WHITE TROUT 2 GRAME
SHAD COLMIC HERAKLES ISPANIC 11.4cm White -30%

SHAD COLMIC HERAKLES ISPANIC 11.4cm White

arhkisp27
Stoc epuizat

23,00Lei(-30%) 16,10Lei

Spinnertail Biwaa Divinator Kompact 90 Pearl White 9cm 55g 1buc

Spinnertail Biwaa Divinator Kompact 90 Pearl White 9cm 55g 1buc

b001051
Stoc epuizat

57,00Lei

SAPCA DAIWA MATELASSE MESH BLACK WHITE

SAPCA DAIWA MATELASSE MESH BLACK WHITE

d.ca402415
Stoc epuizat

50,73Lei

Afişare 701 - 720 din 903 (46 pagini)
Queries: 7, Total time: 27.820 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = '84810031dfc3376eca11008129'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (22.931)
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 = '2' AND (MATCH(pd.tag) AGAINST('+white' 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 (4.362)
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 700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.108)
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
6 (0.085)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PF GERMAN EUGEN"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.082)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38