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


Vartej Rapid cu Anou Korda PTFE Spinner Ring XX, Nr.11, 8buc/pac

Vartej Rapid cu Anou Korda PTFE Spinner Ring XX, Nr.11, 8buc/pac

a.kmw013
Livrare imediată!

32,38Lei

Vartej Rive Cu Margea Culisanta Si Agrafa Sliding Snap, S, 6buc/plic

Vartej Rive Cu Margea Culisanta Si Agrafa Sliding Snap, S, 6buc/plic

41410810325
Livrare imediată!

20,31Lei

Agrafa Mikado Round Snap M, 10buc/plic
Exclusiv online!

Agrafa Mikado Round Snap M, 10buc/plic

ama02-090-m
Livrare 48-72 ore

7,00Lei

Vartej Carp Spirit Swivel, Nr.8, 10buc/plic
Exclusiv online!

Vartej Carp Spirit Swivel, Nr.8, 10buc/plic

acs290023
Livrare 48-72ore

9,00Lei

Vartej Carp Zoom Quick Change Round Swivels, Nr.7, 10buc/plic
Exclusiv online!

Vartej Carp Zoom Quick Change Round Swivels, Nr.7, 10buc/plic

cz2476
Livrare 48-72 ore

13,49Lei

VARTEJ PRO FL BUFFER FEEDER CONECTOR NR 10 8KG

VARTEJ PRO FL BUFFER FEEDER CONECTOR NR 10 8KG

4224244874159
Livrare imediată!

9,90Lei

Vartej Rage Strike Point Swivel Nr.5, 10buc
Exclusiv online!

Vartej Rage Strike Point Swivel Nr.5, 10buc

nac060
Livrare 7-14 zile

15,71Lei

Vartej Rapid Korda Spinner XX, Nr.11, 10buc/pac
Exclusiv online!

Vartej Rapid Korda Spinner XX, Nr.11, 10buc/pac

a.kmw012
Livrare 24-48 ore

23,11Lei

Agrafa Culisanta Stonfo Fixare Pluta Match 247, Small, 3buc/plic
Exclusiv online!

Agrafa Culisanta Stonfo Fixare Pluta Match 247, Small, 3buc/plic

8028651003197
Livrare 48-72 ore

15,51Lei

Agrafa Mikado Round Snap XXS, 10buc/plic
Exclusiv online!

Agrafa Mikado Round Snap XXS, 10buc/plic

ama02-090-xxs
Livrare 48-72 ore

7,00Lei

Agrafa Savage Gear Custom Salt Splitringsnaps, Marime L, 15buc/pac
Exclusiv online!

Agrafa Savage Gear Custom Salt Splitringsnaps, Marime L, 15buc/pac

a7.sg.77332
Livrare 24-48 ore

18,58Lei

Agrafa VMC Crank Bait 360, 10kg, Nr.000, 10buc/plic
Exclusiv online!

Agrafa VMC Crank Bait 360, 10kg, Nr.000, 10buc/plic

avm290214
Livrare 48-72ore

14,90Lei

Agrafa VMC Crank Bait 360, 15kg, Nr.00, 10buc/plic
Exclusiv online!

Agrafa VMC Crank Bait 360, 15kg, Nr.00, 10buc/plic

avm290215
Livrare 48-72ore

14,90Lei

Agrafa VMC Crank Bait 360, 17kg, Nr.0, 10buc/plic
Exclusiv online!

Agrafa VMC Crank Bait 360, 17kg, Nr.0, 10buc/plic

avm290216
Livrare 48-72ore

14,90Lei

Agrafa VMC Crank Bait 360, 20kg, Nr.1, 10buc/plic
Exclusiv online!

Agrafa VMC Crank Bait 360, 20kg, Nr.1, 10buc/plic

avm290217
Livrare 48-72ore

14,90Lei

Agrafa VMC Duo Lock Strong, 33kg, Nr.0, 10buc/plic
Exclusiv online!

Agrafa VMC Duo Lock Strong, 33kg, Nr.0, 10buc/plic

avm290206
Livrare 48-72ore

8,00Lei

Agrafa VMC Duo Lock Strong, 33kg, Nr.2, 10buc/plic
Exclusiv online!

Agrafa VMC Duo Lock Strong, 33kg, Nr.2, 10buc/plic

avm290208
Livrare 48-72ore

8,00Lei

Agrafa VMC Duo Lock Strong, 43kg, Nr.3, 10buc/plic
Exclusiv online!

Agrafa VMC Duo Lock Strong, 43kg, Nr.3, 10buc/plic

avm290209
Livrare 48-72ore

8,00Lei

Vartej Extra Carp Cu Anou Si Agrafa Rapida, Nr.8, 10buc/plic
Exclusiv online!

Vartej Extra Carp Cu Anou Si Agrafa Rapida, Nr.8, 10buc/plic

EC4324
Livrare 48-72 ore

12,50Lei

VARTEJ PRO FL BUFFER FEEDER CONECTOR NR 12 6KG

VARTEJ PRO FL BUFFER FEEDER CONECTOR NR 12 6KG

7224243568391
Livrare imediată!

9,90Lei

Afişare 981 - 1000 din 1157 (58 pagini)
Queries: 12, Total time: 23.232 ms [By time] [By id] [By file]
1 (0.158)
SELECT data
FROM `oc_session`
WHERE session_id = '2e3f28b76327c37745736e806b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (21.856)
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('+vartejuri' 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.152)
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
5 (0.097)
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.123)
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.122)
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
8 (0.126)
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
9 (0.118)
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
10 (0.117)
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
11 (0.131)
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
12 (0.129)
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