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 300 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 - Carlige Rapitor

Produse ce potrivesc criteriilor de căutare


AVERTIZOR NGT VX2 BITE ALARM

AVERTIZOR NGT VX2 BITE ALARM

ngt-fba-vx2
Livrare imediată!

53,00Lei

Husa Swingeri Delphin Area BITE Carpath

Husa Swingeri Delphin Area BITE Carpath

420220273
Livrare imediată!

36,00Lei

AVERTIZOR, ELECTRONIC, , K-KARP, DRAKE, XTR, BITE, ALARM, 9V, , , YELLOW, 019-25-903, Avertizoare Electronice, Avertizoare Electronice K-Karp, K-Karp
Spirala Spro Softbite 5.4cm, 6buc/pac -27%

Spirala Spro Softbite 5.4cm, 6buc/pac

004628-00108-00000
Livrare imediată!

14,90Lei(-27%) 10,90Lei

Solar Line Biter -10%

Solar Line Biter

lb1
Livrare imediată!

55,50Lei(-10%) 49,94Lei

Vobler, Owner, Bite, Marker, 28mm, 1.7gr, 33, Purple, White, Berry, Eye, 5224, TMT-28SP, 804020034, Voblere Suspending, Voblere Suspending Owner, Owner
BATERIE EnergoTeam IBITE 311

BATERIE EnergoTeam IBITE 311

74942313
Livrare imediată!

4,80Lei

Avertizor NGT Angling Pursuits JHA Bite Alarm

Avertizor NGT Angling Pursuits JHA Bite Alarm

ngt-ap-fba-jha
Livrare imediată!

39,00Lei

Vobler Owner Bite Marker 28mm 1.7gr 30 Persimmon Berry Eye 5224 TMT-28SP

Vobler Owner Bite Marker 28mm 1.7gr 30 Persimmon Berry Eye 5224 TMT-28SP

804020032
Livrare imediată!

98,35Lei

CARLIGE, VARIVAS, OFFSET, NOGALES, SECOND, BITE, MONSTER, NR.1/0, vc94sbm1/0, Carlige Rapitor, Carlige Rapitor Varivas, Varivas
Exclusiv online!

CARLIGE, VARIVAS, OFFSET, NOGALES, SECOND, BITE, MONSTER, NR.1/0, vc94sbm1/0, Carlige Rapitor, Carlige Rapitor Varivas, Varivas

vc94sbm1/0
Livrare 48-72 ore

17,01Lei

Snag Bars Delkim Safe-D Carbon v2 pentru Avertizori Txi-D Bite Alarm

Snag Bars Delkim Safe-D Carbon v2 pentru Avertizori Txi-D Bite Alarm

a.de.dd009
Livrare imediată!

91,80Lei

Vobler, Owner, Bite, Marker, 28mm, 1.7gr, 35, Pink, Berry, Eye, 5224, TMT-28SP, 804020035, Voblere Suspending, Voblere Suspending Owner, Owner
CARLIGE VARIVAS OFFSET NOGALES SECOND BITE MONSTER NR.2 -24%

CARLIGE VARIVAS OFFSET NOGALES SECOND BITE MONSTER NR.2

vc94sbm02
Livrare imediată!

17,01Lei(-24%) 12,90Lei

CARLIGE, VARIVAS, OFFSET, NOGALES, SECOND, BITE, MONSTER, NR.1, vc94sbm01, Carlige Rapitor, Carlige Rapitor Varivas, Varivas -24%

CARLIGE, VARIVAS, OFFSET, NOGALES, SECOND, BITE, MONSTER, NR.1, vc94sbm01, Carlige Rapitor, Carlige Rapitor Varivas, Varivas

vc94sbm01
Livrare imediată!

17,01Lei(-24%) 12,90Lei

Vobler, Owner, Bite, Marker, 28mm, 1.7gr, 27, Olive, Berry, Eye, 5224, TMT-28SP, 804020030, Voblere Suspending, Voblere Suspending Owner, Owner
CARLIGE, VARIVAS, OFFSET, NOGALES, SECOND, BITE, MONSTER, NR.2/0, vc82m2/0, Carlige Rapitor, Carlige Rapitor Varivas, Varivas -22%

CARLIGE, VARIVAS, OFFSET, NOGALES, SECOND, BITE, MONSTER, NR.2/0, vc82m2/0, Carlige Rapitor, Carlige Rapitor Varivas, Varivas

vc82m2/0
Livrare imediată!

14,49Lei(-22%) 11,31Lei

Vobler, Owner, Bite, Marker, 28mm, 1.7gr, 28, Green, Gold, Berry, Eye, 5224, TMT-28SP, 804020031, Voblere Suspending, Voblere Suspending Owner, Owner
INDICATOR CARP ACADEMY LINE BITER 2BUC/PLIC

INDICATOR CARP ACADEMY LINE BITER 2BUC/PLIC

8100-196
Livrare imediată!

17,50Lei

HANGER KORUM XL NEO MAG BITE INDICATOR KIT

HANGER KORUM XL NEO MAG BITE INDICATOR KIT

k0360040
Livrare imediată!

67,46Lei

Lingura Oscilanta Jackall T-GROVEL 2,0CM/1,7G BITE RED -20%
Exclusiv online!

Lingura Oscilanta Jackall T-GROVEL 2,0CM/1,7G BITE RED

f3.ja.418083678
Livrare 24-48 ore

37,06Lei(-20%) 29,65Lei

Afişare 61 - 80 din 135 (7 pagini)
Queries: 10, Total time: 219.892 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '14d4c56d56120338ec2f8a35b4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (216.657)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%bite%") 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:698
4 (0.124)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.866)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.289)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.133)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.114)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (1.367)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38