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


POPPER JAXON HOLO SELECT F W 9CM 15GR
Exclusiv online!

POPPER JAXON HOLO SELECT F W 9CM 15GR

vj-po09fw
Livrare 48-72 ore

32,00Lei

POPPER JAXON HOLO SELECT F NS 9CM 15GR
Exclusiv online!

POPPER JAXON HOLO SELECT F NS 9CM 15GR

vj-po09fns
Livrare 48-72 ore

32,00Lei

Lingurita Oscilanta Rublex Orlac Nr.6, ANR, 6,9cm, 11g -18%

Lingurita Oscilanta Rublex Orlac Nr.6, ANR, 6,9cm, 11g

roc6anr
Livrare imediată!

28,00Lei(-18%) 22,90Lei

Shad Westin ShadTeez 9cm Fire Perch 3pcs -15%

Shad Westin ShadTeez 9cm Fire Perch 3pcs

p023-272-008
Livrare imediată!

23,50Lei(-15%) 19,98Lei

Shad Lucky John 3D Basara Soft Swim 3.5inch 8.9cm PG03 6 buc/plic

Shad Lucky John 3D Basara Soft Swim 3.5inch 8.9cm PG03 6 buc/plic

140403-pg03
Livrare imediată!

30,00Lei

VOBLER JAXON HOLO SELECT NIDOR F TR 9CM 11GR 1.5-4.0M
Exclusiv online!

VOBLER JAXON HOLO SELECT NIDOR F TR 9CM 11GR 1.5-4.0M

vj-ni09ftr
Livrare 48-72 ore

35,00Lei

VOBLER JAXON HOLO SELECT SCAMP F N 9CM 14GR -30%
Exclusiv online!

VOBLER JAXON HOLO SELECT SCAMP F N 9CM 14GR

vj-sa09fn
Livrare 48-72 ore

35,00Lei(-30%) 24,50Lei

VOBLER JAXON HOLO SELECT NIDOR F MA 9CM 11GR 1.5-4.0M
Exclusiv online!

VOBLER JAXON HOLO SELECT NIDOR F MA 9CM 11GR 1.5-4.0M

vj-ni09fma
Livrare 48-72 ore

35,00Lei

VOBLER RAPALA ORIGINAL FLOATER 9CM WAL

VOBLER RAPALA ORIGINAL FLOATER 9CM WAL

f09 wal
Livrare imediată!

46,01Lei

VOBLER JAXON ATRACT CIRUS F A 9CM 11GR
Exclusiv online!

VOBLER JAXON ATRACT CIRUS F A 9CM 11GR

vr-xha090a
Livrare 48-72 ore

17,01Lei

Lingurita Oscilanta Rublex Orlac Nr.7, ANR, 6,9cm, 20g -15%

Lingurita Oscilanta Rublex Orlac Nr.7, ANR, 6,9cm, 20g

roc7anr
Livrare imediată!

31,50Lei(-15%) 26,91Lei

VOBLER JAXON ATRACT CIRUS F I 9CM 11GR
Exclusiv online!

VOBLER JAXON ATRACT CIRUS F I 9CM 11GR

vr-xha090i
Livrare 48-72 ore

17,01Lei

Lingurita Oscilanta Lucky John Ayu 2.4g 006 2.9cm 1buc/pac
Exclusiv online!

Lingurita Oscilanta Lucky John Ayu 2.4g 006 2.9cm 1buc/pac

150924-006
Livrare 48-72ore

10,81Lei

SHAD COLMIC HERAKLES BENJO R 9CM BAIFISH
Exclusiv online!

SHAD COLMIC HERAKLES BENJO R 9CM BAIFISH

arhkber24
Livrare 48-72 ore

29,00Lei

VOBLER RAPALA ORIGINAL FLOATER 9CM ALB

VOBLER RAPALA ORIGINAL FLOATER 9CM ALB

f09 alb
Livrare imediată!

46,01Lei

SHAD COLMIC HERAKLES BENJO R 9CM CITRUS
Exclusiv online!

SHAD COLMIC HERAKLES BENJO R 9CM CITRUS

arhkber51
Livrare 48-72 ore

29,00Lei

POPPER JAXON HOLO SELECT F O 9CM 15GR
Exclusiv online!

POPPER JAXON HOLO SELECT F O 9CM 15GR

vj-po09fo
Livrare 48-72 ore

32,00Lei

Lingurita Oscilanta Rublex Orlac Nr.8,ANR, 7,9cm,15g

Lingurita Oscilanta Rublex Orlac Nr.8,ANR, 7,9cm,15g

roc8anr
Livrare imediată!

29,50Lei

Lingurita Oscilanta Rublex Orlac Nr.8, ONR, 7.9cm, 15g -15%

Lingurita Oscilanta Rublex Orlac Nr.8, ONR, 7.9cm, 15g

roc8onr
Livrare imediată!

34,00Lei(-15%) 28,91Lei

VOBLER JAXON HOLO SELECT SCAMP F KSN 9CM 14GR -30%
Exclusiv online!

VOBLER JAXON HOLO SELECT SCAMP F KSN 9CM 14GR

vj-sa09fksn
Livrare 48-72 ore

35,00Lei(-30%) 24,50Lei

Afişare 441 - 460 din 1360 (68 pagini)
Queries: 6, Total time: 63.923 ms [By time] [By id] [By file]
1 (0.170)
SELECT data
FROM `oc_session`
WHERE session_id = '8244c339cb5a05b0d9c6946ae9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (54.720)
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('+9cm' 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 (8.704)
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 440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.127)
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.121)
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