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


SHAD COLMIC HERAKLES T-SHAD CHARTREUSE BLOODY 12CM 2BUCATI/PLIC

SHAD COLMIC HERAKLES T-SHAD CHARTREUSE BLOODY 12CM 2BUCATI/PLIC

arhkbb05
Livrare imediată!

33,00Lei

SHAD CARP ZOOM PREDATOR-Z OPLUS LONGTAIL KILLER 10CM CZ7817
Exclusiv online!

SHAD CARP ZOOM PREDATOR-Z OPLUS LONGTAIL KILLER 10CM CZ7817

cz7817
Livrare 48-72 ore

28,00Lei

Shad BIG HAMMER SWIMBAIT HPS30004 CULOARE 04 7.5CM -33%

Shad BIG HAMMER SWIMBAIT HPS30004 CULOARE 04 7.5CM

hps30004
Livrare imediată!

24,00Lei(-33%) 16,07Lei

Shad Biwaa Deus 13cm 304 Pink Ice 5/plic -23%

Shad Biwaa Deus 13cm 304 Pink Ice 5/plic

b001222
Livrare imediată!

26,00Lei(-23%) 19,90Lei

Shad Delphin BOMB Fatty/5buc 10Cm Redface

Shad Delphin BOMB Fatty/5buc 10Cm Redface

690011009
Livrare imediată!

28,00Lei

SHAD JAXON EXTREME SOFT TG-B 7.5CM D -30%
Exclusiv online!

SHAD JAXON EXTREME SOFT TG-B 7.5CM D

tg-b075d
Livrare 48-72 ore

21,00Lei(-30%) 14,70Lei

Shad Owner Jr Minnow JRM88 88mm Ayu
Exclusiv online!

Shad Owner Jr Minnow JRM88 88mm Ayu

801025587240
Livrare 48-72 ore

24,47Lei

Shad Lucky John Pro Series Long John 3.1inch 7.9cm PA03 Green Pumpkin 8 buc/plic
Shad Biwaa Deus 7.5cm culoare 304 Pink Ice -8%

Shad Biwaa Deus 7.5cm culoare 304 Pink Ice

b001176
Livrare imediată!

26,00Lei(-8%) 24,00Lei

SHAD LINEAEFFE NOMURA KOI 5CM/0,97G GLOWING GHOST 10BUC/PL -30%
Exclusiv online!

SHAD LINEAEFFE NOMURA KOI 5CM/0,97G GLOWING GHOST 10BUC/PL

f1.nm.71803205
Livrare 24-48 ore

20,31Lei(-30%) 14,22Lei

SHAD JAXON EXTREME SOFT TG-A 9.5CM B -30%
Exclusiv online!

SHAD JAXON EXTREME SOFT TG-A 9.5CM B

tg-a095b
Livrare 48-72 ore

15,01Lei(-30%) 10,50Lei

Shad BIWAA TailGunR Swimbait 4.5", 310 Kaleido Star, 11.50cm, 5buc/pac
Exclusiv online!

Shad BIWAA TailGunR Swimbait 4.5", 310 Kaleido Star, 11.50cm, 5buc/pac

b001452
Livrare 48-72 ore

26,00Lei

Shad Biwaa Tailgunr Swimbait 3.5 9cm 302 Alburno 7/plic

Shad Biwaa Tailgunr Swimbait 3.5 9cm 302 Alburno 7/plic

b001430
Livrare imediată!

26,00Lei

SHAD BIWAA DIVINATOR S 6cm 04 Ivory -20%

SHAD BIWAA DIVINATOR S 6cm 04 Ivory

b000234
Livrare imediată!

35,00Lei(-20%) 27,91Lei

SHAD JAXON EXTREME SOFT DROP SHOT 5D 8.5CM -25%
Exclusiv online!

SHAD JAXON EXTREME SOFT DROP SHOT 5D 8.5CM

td-05d
Livrare 48-72 ore

11,00Lei(-25%) 8,29Lei

SHAD JAXON EXTREME SOFT TG-B 9.5CM C -30%
Exclusiv online!

SHAD JAXON EXTREME SOFT TG-B 9.5CM C

tg-b095c
Livrare 48-72 ore

15,01Lei(-30%) 10,50Lei

Shad Manns Soft 8cm FluoYellow 5 buc

Shad Manns Soft 8cm FluoYellow 5 buc

88010383
Livrare imediată!

11,00Lei

Shad Storm So-Run Spike Tail 12.5cm/10g culoare LM

Shad Storm So-Run Spike Tail 12.5cm/10g culoare LM

ssrst05 lm
Livrare imediată!

13,99Lei

SHAD RAPTURE POWER SHAD DUAL 11.5CM APPLE MINT
Exclusiv online!

SHAD RAPTURE POWER SHAD DUAL 11.5CM APPLE MINT

188-00-884
Livrare 48-72 ore

27,00Lei

Shad Lucky John Pro Series Tioga, 7.4cm, 033 Ocean Pearl, 7buc/pac

Shad Lucky John Pro Series Tioga, 7.4cm, 033 Ocean Pearl, 7buc/pac

140103-033
Stoc epuizat

20,00Lei

Afişare 1621 - 1640 din 7336 (367 pagini)
Queries: 6, Total time: 669.248 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'c74727f19e033ec3bfa5e0fc09'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (668.650)
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 (pd.tag LIKE "%shad-uri%") 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.129)
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
5 (0.110)
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.126)
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