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


NALUCA SAVAGE 4D PIKE 20CM/65G SS01 -20%

NALUCA SAVAGE 4D PIKE 20CM/65G SS01

f1.sg.61786
Stoc epuizat

58,83Lei(-20%) 47,06Lei

Shad EnergoTeam Wizard Magnet 15cm Black Koi

Shad EnergoTeam Wizard Magnet 15cm Black Koi

86964605
Stoc epuizat

12,99Lei

SHAD JAXON EXCELL SOFT J 8.5CM

SHAD JAXON EXCELL SOFT J 8.5CM

tj-ax85j
Stoc epuizat

19,80Lei

SHAD JAXON EXCELL SOFT K 11CM

SHAD JAXON EXCELL SOFT K 11CM

tj-ax110k
Stoc epuizat

19,00Lei

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

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

ssrst05 ss
Stoc epuizat

13,99Lei

SHAD JAXON EXTREME SOFT TG-A 5.5CM H -30%

SHAD JAXON EXTREME SOFT TG-A 5.5CM H

tg-a055h
Stoc epuizat

22,00Lei(-30%) 15,40Lei

SHAD JAXON EXCELL SOFT L 11CM

SHAD JAXON EXCELL SOFT L 11CM

tj-ax110l
Stoc epuizat

19,00Lei

SET NALUCI SAVAGE SI ACCESORII DROPSHOT PRO 22BUC

SET NALUCI SAVAGE SI ACCESORII DROPSHOT PRO 22BUC

f1.sg.57628
Stoc epuizat

77,20Lei

Shad Lucky John Nayada 5cm - 071 (LIME CHARTREUSE) 9buc/plic -7%

Shad Lucky John Nayada 5cm - 071 (LIME CHARTREUSE) 9buc/plic

140154-071
Stoc epuizat

20,00Lei(-7%) 18,50Lei

VOBLER RAPALA SCATTER RAP SHAD 7CM PEL

VOBLER RAPALA SCATTER RAP SHAD 7CM PEL

scrs07 pel
Stoc epuizat

45,01Lei

Rig Somn Black Cat 6/0 20gr Shad Claw Rig

Rig Somn Black Cat 6/0 20gr Shad Claw Rig

3122020
Stoc epuizat

35,78Lei

SHAD BASS ASSASSIN TURBO SHAD RAINBOW TROUT 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD RAINBOW TROUT 10CM 10BUC/PLIC

091538303329
Stoc epuizat

32,00Lei

SHAD DELPHIN BOMB FATTY 10CM SPRING

SHAD DELPHIN BOMB FATTY 10CM SPRING

690011005
Stoc epuizat

28,00Lei

SHAD CARP ZOOM PREDATOR-Z OPLUS RIBBED KILLER 9.5cm CZ7800

SHAD CARP ZOOM PREDATOR-Z OPLUS RIBBED KILLER 9.5cm CZ7800

cz7800
Stoc epuizat

19,00Lei

VOBLER COLMIC HERAKLES RABID 130SP 13cm 21gr Silver Shad

VOBLER COLMIC HERAKLES RABID 130SP 13cm 21gr Silver Shad

arhkbm01
Stoc epuizat

58,00Lei

SHAD DELPHIN BOMB FATTY 12CM CAROT

SHAD DELPHIN BOMB FATTY 12CM CAROT

690011201
Stoc epuizat

31,00Lei

VOBLER COLMIC HERAKLES STRIKE 90SK 9cm 11gr Silver Shad

VOBLER COLMIC HERAKLES STRIKE 90SK 9cm 11gr Silver Shad

arhkbl02
Stoc epuizat

48,00Lei

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 Westin ShadTeez 9cm Bass Orange

Shad Westin ShadTeez 9cm Bass Orange

p021-021-008
Stoc epuizat

6,90Lei

SHAD BIWAA DIVINATOR MINI 9.5cm 9gr CULOARE BUBBLE GUM

SHAD BIWAA DIVINATOR MINI 9.5cm 9gr CULOARE BUBBLE GUM

b000925
Stoc epuizat

37,00Lei

Afişare 6461 - 6480 din 8381 (420 pagini)
Queries: 9, Total time: 211.612 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = 'a4e01e8875ec55b051f6659874'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (210.600)
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('+shad' 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 (0.141)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.128)
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.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.134)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.103)
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
9 (0.163)
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