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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Lingura oscilanta Rapala antibradis RMS06 FYBT 6cm/10gr

Lingura oscilanta Rapala antibradis RMS06 FYBT 6cm/10gr

rms06 fybt
Livrare imediată!

34,00Lei

VOBLER RAPALA JOINTED SHALLOW SHAD RAP 5CM / 7GR SSD

VOBLER RAPALA JOINTED SHALLOW SHAD RAP 5CM / 7GR SSD

jssr05 ssd
Livrare imediată!

42,00Lei

VOBLERA RAPALA F07 FT ORIGINAL FLOATER 7cm

VOBLERA RAPALA F07 FT ORIGINAL FLOATER 7cm

f07 ft
Livrare imediată!

46,01Lei

Vobler Rapala BX Jointed Shad Floating, Culoare P, 6cm, 7g

Vobler Rapala BX Jointed Shad Floating, Culoare P, 6cm, 7g

bxjsd06 p
Livrare imediată!

59,00Lei

VOBLER RAPALA ULTRA LIGHT MINNOW 6CM / 4GR CH

VOBLER RAPALA ULTRA LIGHT MINNOW 6CM / 4GR CH

ulm06 ch
Livrare imediată!

42,00Lei

Vobler Rapala X-Rap Countdown Culoare TRL 5cm 4g

Vobler Rapala X-Rap Countdown Culoare TRL 5cm 4g

xrcd05 trl
Livrare imediată!

52,00Lei

Vobler Rapala Jointed Shad Rap, Culoare PRT, 4cm, 5g

Vobler Rapala Jointed Shad Rap, Culoare PRT, 4cm, 5g

jsr04 prt
Livrare imediată!

42,00Lei

VOBLER RAPALA DIVES-TO 6CM / 17GR FT

VOBLER RAPALA DIVES-TO 6CM / 17GR FT

dt10 ft
Livrare imediată!

54,00Lei

VOBLER RAPALA J09 S JOINTED

VOBLER RAPALA J09 S JOINTED

j09 s
Livrare imediată!

53,00Lei

VOBLER RAPALA ULTRA LIGHT CRANK 3CM / 4GR SB

VOBLER RAPALA ULTRA LIGHT CRANK 3CM / 4GR SB

ulc03 sb
Livrare imediată!

42,99Lei

Vobler Rapala BX Brat 06, Culoare ROC, 5cm, 11g

Vobler Rapala BX Brat 06, Culoare ROC, 5cm, 11g

bxb06 roc
Livrare imediată!

59,00Lei

Lingura oscilanta Rapala antibradis RMS07 FYGT 7cm/15gr

Lingura oscilanta Rapala antibradis RMS07 FYGT 7cm/15gr

rms07 fygt
Livrare imediată!

39,00Lei

Vobler Rapala BX Brat 06, Culoare S, 5cm, 11g

Vobler Rapala BX Brat 06, Culoare S, 5cm, 11g

bxb06 s
Livrare imediată!

59,00Lei

VOBLER RAPALA RIPPIN RAP CULOARE SML 6CM 14G

VOBLER RAPALA RIPPIN RAP CULOARE SML 6CM 14G

rpr06 sml
Livrare imediată!

46,01Lei

Vobler Rapala Husky Jerk, Culoare GBM, 10cm, 10g

Vobler Rapala Husky Jerk, Culoare GBM, 10cm, 10g

hj10 gbm
Livrare imediată!

42,00Lei

Vobler Rapala Jointed Shad Rap, Culoare CLS, 7cm, 13g

Vobler Rapala Jointed Shad Rap, Culoare CLS, 7cm, 13g

jsr07 cls
Livrare imediată!

48,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE MRC 17CM 40G

VOBLER RAPALA X-RAP OTUS CULOARE MRC 17CM 40G

xrou17 mrc
Livrare imediată!

84,00Lei

Vobler Rapala Ultra Light Crank Culoare GAU 3cm 4g

Vobler Rapala Ultra Light Crank Culoare GAU 3cm 4g

ulc03 gau
Livrare imediată!

42,99Lei

VOBLER RAPALA SHALLOW SHAD FP

VOBLER RAPALA SHALLOW SHAD FP

ssr07 fp
Livrare imediată!

47,01Lei

Vobler Rapala Jointed Shad Rap, Culoare PRT, 7cm, 13g

Vobler Rapala Jointed Shad Rap, Culoare PRT, 7cm, 13g

jsr07 prt
Livrare imediată!

48,00Lei

Afişare 181 - 200 din 1806 (91 pagini)
Queries: 7, Total time: 53.004 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '349454174178fd8402fe913492'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (42.433)
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('+rapala' 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 (9.979)
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 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.115)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=10283'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
6 (0.104)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=10281'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
7 (0.126)
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