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


JIG JAXON OWNER SILVER NR 4/0-20GR 3/PLIC
Exclusiv online!

JIG JAXON OWNER SILVER NR 4/0-20GR 3/PLIC

gj-ow4/020n
Livrare 48-72 ore

18,50Lei

Offset-Jig Owner 5164 Nr.10/0-1/2 Flashy Swimmer Blade
Exclusiv online!

Offset-Jig Owner 5164 Nr.10/0-1/2 Flashy Swimmer Blade

5164080
Livrare 48-72 ore

36,71Lei

Carlig Owner OH SSW 5115 Nr.1/0
Exclusiv online!

Carlig Owner OH SSW 5115 Nr.1/0

5115006
Livrare 48-72 ore

14,04Lei

Inele Despicate Owner 52811 Nr 3 Split Ring Regular

Inele Despicate Owner 52811 Nr 3 Split Ring Regular

410020062
Livrare imediată!

16,98Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 13 Baby bass
Exclusiv online!

Vobler Owner Rip n Minnow 65mm 6.0gr 13 Baby bass

804020303
Livrare 48-72 ore

47,87Lei

Ancora Owner ST66 TN Nr.1
Exclusiv online!

Ancora Owner ST66 TN Nr.1

5666109
Livrare 48-72 ore

69,37Lei

Vartej Owner Rolling Dublu W Crane 52457, No.18, 12.1kg, 12buc/plic

Vartej Owner Rolling Dublu W Crane 52457, No.18, 12.1kg, 12buc/plic

410020004
Livrare imediată!

23,40Lei

Carlig Owner Cp 50674 Argintiu Patrat Nr 3 - 15buc/pac

Carlig Owner Cp 50674 Argintiu Patrat Nr 3 - 15buc/pac

5067401
Livrare imediată!

13,05Lei

Carlig Owner Seigo 50610 Nr.1/0

Carlig Owner Seigo 50610 Nr.1/0

5061003
Livrare imediată!

10,00Lei

Vartej Agrafa Owner Amaz 72459 Sinker Hook W Crane, 12.4kg, Nr.16, 10buc/plic

Vartej Agrafa Owner Amaz 72459 Sinker Hook W Crane, 12.4kg, Nr.16, 10buc/plic

410260022
Livrare imediată!

21,12Lei

Vartej Agrafa Owner 52459 Nr 18 Sinker Hook W Crane
Exclusiv online!

Vartej Agrafa Owner 52459 Nr 18 Sinker Hook W Crane

410020013
Livrare 48-72 ore

27,99Lei

JAXON JIG OWNER BLACK NICKEL NR 5/0-8GR
Exclusiv online!

JAXON JIG OWNER BLACK NICKEL NR 5/0-8GR

gj-ob5/008bc
Livrare 48-72 ore

20,50Lei

Carlig Owner Mosquito Hook 5177 Nr.2 9buc/plic

Carlig Owner Mosquito Hook 5177 Nr.2 9buc/plic

5177007
Livrare imediată!

11,73Lei

Carlige Owner Mutu Light Wire 5114, Nr.8, 11buc/plic

Carlige Owner Mutu Light Wire 5114, Nr.8, 11buc/plic

5114011
Livrare imediată!

18,75Lei

JIG JAXON OWNER SILVER NR 3/0-14GR 3/PLIC
Exclusiv online!

JIG JAXON OWNER SILVER NR 3/0-14GR 3/PLIC

gj-ow3/014n
Livrare 48-72 ore

15,51Lei

CARLIG OWNER CPS 5106 Nr.2 Negru Rotund Anou -27%

CARLIG OWNER CPS 5106 Nr.2 Negru Rotund Anou

5106003
Livrare imediată!

15,96Lei(-27%) 11,65Lei

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 13 Baby Bass
Exclusiv online!

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 13 Baby Bass

804020072
Livrare 48-72 ore

40,83Lei

Carlig Owner OH SSW 5115 Nr.7/0

Carlig Owner OH SSW 5115 Nr.7/0

5115011
Livrare imediată!

15,03Lei

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 24 Lime Chart
Exclusiv online!

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 24 Lime Chart

804020075
Livrare 48-72 ore

40,83Lei

Carlig Owner C-3 Carp Tsuyoshi Nr.6

Carlig Owner C-3 Carp Tsuyoshi Nr.6

5000026
Livrare imediată!

13,54Lei

Afişare 501 - 520 din 1689 (85 pagini)
Queries: 5, Total time: 47.013 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = '5dcbb313c06d868e9c9eba2d31'
/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 (39.929)
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('+owner' 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 (6.638)
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 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.182)
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