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 COLMIC HI-POP 11cm 26gr Muggine

POPPER COLMIC HI-POP 11cm 26gr Muggine

arhkfp05
Stoc epuizat

63,00Lei

POPPER COLMIC HI-POP 11cm 26gr Skull

POPPER COLMIC HI-POP 11cm 26gr Skull

arhkfp04
Stoc epuizat

63,00Lei

POPPER COLMIC HI-POP 11cm 26gr White Flash

POPPER COLMIC HI-POP 11cm 26gr White Flash

arhkfp08
Stoc epuizat

63,00Lei

VOBLER COLMIC DARKO-F 14.5cm 29gr Muggine -40%

VOBLER COLMIC DARKO-F 14.5cm 29gr Muggine

arhkdw01
Stoc epuizat

48,00Lei(-40%) 28,80Lei

POPPER COLMIC HI-POP 11cm 26gr Holo Clown

POPPER COLMIC HI-POP 11cm 26gr Holo Clown

arhkfp06
Stoc epuizat

63,00Lei

VOBLER COLMIC DARKO-F 14.5cm 29gr Holo Clown -40%

VOBLER COLMIC DARKO-F 14.5cm 29gr Holo Clown

arhkdw05
Stoc epuizat

48,00Lei(-40%) 28,80Lei

VOBLER SPRO RAT BABY SOBOLAN MARO 8.3CM 16GR FLOATING

VOBLER SPRO RAT BABY SOBOLAN MARO 8.3CM 16GR FLOATING

004867-00901-00000
Stoc epuizat

86,10Lei

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Holo Clown -57%

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Holo Clown

arhklt06
Stoc epuizat

53,20Lei(-57%) 22,90Lei

VOBLER COLMIC DARKO-S 14.5cm 60gr Qda -40%

VOBLER COLMIC DARKO-S 14.5cm 60gr Qda

arhkdv03
Stoc epuizat

48,00Lei(-40%) 28,80Lei

VOBLER CARP ZOOM PREDATOR -Z BABY SIDER 5.5cm 3.8gr FLOATING 1136 -20%

VOBLER CARP ZOOM PREDATOR -Z BABY SIDER 5.5cm 3.8gr FLOATING 1136

cz1136
Stoc epuizat

12,00Lei(-20%) 9,60Lei

VOBLER SALMO POPPER 6CM F SMS

VOBLER SALMO POPPER 6CM F SMS

84466111
Stoc epuizat

35,00Lei

VOBLER COLMIC DARKO-F 14.5cm 29gr Sardine Chartreuse -40%

VOBLER COLMIC DARKO-F 14.5cm 29gr Sardine Chartreuse

arhkdw02
Stoc epuizat

48,00Lei(-40%) 28,80Lei

POPPER COLMIC POP-EY 7cm 9gr Black -30%

POPPER COLMIC POP-EY 7cm 9gr Black

arherak07a
Stoc epuizat

40,00Lei(-30%) 28,00Lei

Vobler Yo-Zuri L-Minnow F 3.3cm, 2.5gr Floating (single hook) Culoare CP 1 buc/pac
POPPER COLMIC HI-POP 11cm 26gr Flash Ayu

POPPER COLMIC HI-POP 11cm 26gr Flash Ayu

arhkfp02
Stoc epuizat

63,00Lei

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Acciuga -30%

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Acciuga

arhklt09
Stoc epuizat

76,01Lei(-30%) 53,20Lei

Vobler Salmo Slider SD10F, HGS Holografic Grey Shiner,10cm, 36g -30%

Vobler Salmo Slider SD10F, HGS Holografic Grey Shiner,10cm, 36g

qsd018
Stoc epuizat

69,95Lei(-30%) 48,97Lei

VOBLER RAPTURE NEO CRANK SQR 5CM 8GR GTS

VOBLER RAPTURE NEO CRANK SQR 5CM 8GR GTS

180-17-851
Stoc epuizat

26,00Lei

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE IMP

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE IMP

sdrs09 imp
Stoc epuizat

58,00Lei

VOBLER COLMIC DARKO-F 14.5cm 29gr Bandit -40%

VOBLER COLMIC DARKO-F 14.5cm 29gr Bandit

arhkdw06
Stoc epuizat

48,00Lei(-40%) 28,80Lei

Afişare 2661 - 2680 din 4077 (204 pagini)
Queries: 6, Total time: 103.735 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '38ff81a40078d9681be6275187'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (103.107)
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 = '3' AND (MATCH(pd.tag) AGAINST('+voblere +floating' 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.157)
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.115)
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
6 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38