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


Pelete Flotante CPK Feeder, Usturoi & Squid, 6mm

Pelete Flotante CPK Feeder, Usturoi & Squid, 6mm

1000779
Livrare imediată!

20,00Lei

Pelete Umectate Feeder Bait, Halibut, 2mm, 600g
Exclusiv online!

Pelete Umectate Feeder Bait, Halibut, 2mm, 600g

fb28-3
Livrare 48-72 ore

30,00Lei

SCAUN MODULAR PRESTON INCEPTION 3D 150
Exclusiv online!

SCAUN MODULAR PRESTON INCEPTION 3D 150

p0120013
Livrare 7-14 zile

2.474,96Lei

SET 2BUC PRO FL METHOD FEEDER DOUBLE CHANCE 40G

SET 2BUC PRO FL METHOD FEEDER DOUBLE CHANCE 40G

64-26444
Livrare imediată!

19,90Lei

Set Momitoare Carp Expert Method Feeder Compactor L, 4buc/set

Set Momitoare Carp Expert Method Feeder Compactor L, 4buc/set

58707060
Livrare imediată!

36,96Lei

Set Momitoare Carp Expert Pro Method XL 50g Plus Matrita Silicon GO, 2buc/set

Set Momitoare Carp Expert Pro Method XL 50g Plus Matrita Silicon GO, 2buc/set

58705050
Livrare imediată!

39,84Lei

Sezut Pliabil Mikado Rotary 51x45x38cm
Exclusiv online!

Sezut Pliabil Mikado Rotary 51x45x38cm

is15-tb050
Livrare 48-72 ore

382,00Lei

Suport Lanseta Filex, 32cm

Suport Lanseta Filex, 32cm

fil9199
Livrare imediată!

57,00Lei

Suport Lansete Filfishing Filex EVA, 47cm
Exclusiv online!

Suport Lansete Filfishing Filex EVA, 47cm

4240775-2267
Livrare 48-72 ore

22,43Lei

Tambur de Rezerva Team Feeder By Dome Carp Fighter Pro 6000

Tambur de Rezerva Team Feeder By Dome Carp Fighter Pro 6000

2532-460-01
Livrare imediată!

49,90Lei

Tava Laterala Filfishing Feeder Cu 2 Cutii, 37x37x8cm

Tava Laterala Filfishing Feeder Cu 2 Cutii, 37x37x8cm

fil9090
Livrare imediată!

199,99Lei

Tava Laterala Genlog cu Umbrar si 2 Picioare telescopice, 65x45.5cm
Exclusiv online!

Tava Laterala Genlog cu Umbrar si 2 Picioare telescopice, 65x45.5cm

gpwc-01
Livrare 48-72 ore

363,00Lei

Tava Laterala Nytro Impax Comfibox, 41x32cm
Exclusiv online!

Tava Laterala Nytro Impax Comfibox, 41x32cm

21000001
Livrare 48-72 ore

144,18Lei

Tub Anti Tangle Nevis 10cm, 3buc/pac

Tub Anti Tangle Nevis 10cm, 3buc/pac

8100-293
Livrare imediată!

4,90Lei

Varf Feeder Team Feeder Heavy pt. Lanseta 1842-330
Exclusiv online!

Varf Feeder Team Feeder Heavy pt. Lanseta 1842-330

1842-330-h
Livrare 48-72 ore

46,30Lei

Varf Guru A Class Distance Feeder 2oz
Exclusiv online!

Varf Guru A Class Distance Feeder 2oz

gu.gac070
Livrare 24-48 ore

69,45Lei

Varf OKUMA Feeder Solid Tip MHC Carbon, Portocaliu
Exclusiv online!

Varf OKUMA Feeder Solid Tip MHC Carbon, Portocaliu

feeder-tip-mhc
Livrare 48-72ore

99,00Lei

Varf Rezerva Trabucco Selektor XS Distance Method Light
Exclusiv online!

Varf Rezerva Trabucco Selektor XS Distance Method Light

152-64-001
Livrare 48-72 ore

79,00Lei

Varf Rezerva Trabucco Spectrum XTD Dynamic Feeder N3
Exclusiv online!

Varf Rezerva Trabucco Spectrum XTD Dynamic Feeder N3

150-83-003
Livrare 48-72 ore

110,00Lei

Vartej Mikado Jaws Double Swivels, 35kg, 10buc/plic
Exclusiv online!

Vartej Mikado Jaws Double Swivels, 35kg, 10buc/plic

ama-j-003-02
Livrare 48-72 ore

12,00Lei

Afişare 2521 - 2540 din 12464 (624 pagini)
Queries: 7, Total time: 348.136 ms [By time] [By id] [By file]
1 (0.165)
SELECT data
FROM `oc_session`
WHERE session_id = 'a03add9a079758166cf1abaa9d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (300.076)
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('+feeder' 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:724
5 (47.347)
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 2520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.177)
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.127)
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