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


JIG JAXON OWNER PRECISION BLACK NICKEL SLIM MICRO 4-4GR 3buc/plic -27%

JIG JAXON OWNER PRECISION BLACK NICKEL SLIM MICRO 4-4GR 3buc/plic

gj-oc0404bc
Livrare imediată!

15,01Lei(-27%) 11,00Lei

JIG JAXON SUMATO BLACK SLIM 3/0-6GR 3buc/plic

JIG JAXON SUMATO BLACK SLIM 3/0-6GR 3buc/plic

gj-sd3/006b
Livrare imediată!

12,50Lei

Leadocore CPK Free Leader, 50lb, 10m, Black Silver

Leadocore CPK Free Leader, 50lb, 10m, Black Silver

1000853
Livrare imediată!

35,00Lei

Ochelari Leech ATW1 Black

Ochelari Leech ATW1 Black

a2301a
Livrare imediată!

140,00Lei

Pluta Culisanta Black Cat Somn 30gr Reflector Boom

Pluta Culisanta Black Cat Somn 30gr Reflector Boom

5558003
Livrare imediată!

44,70Lei

Pluta pentru Tensionare Zeck Tear off Outrigger System Black
Exclusiv online!

Pluta pentru Tensionare Zeck Tear off Outrigger System Black

42105140003
Livrare 48-72 ore

66,39Lei

Rucksack Shimano Luggage Yasei, Black, 27x15x46cm -31%

Rucksack Shimano Luggage Yasei, Black, 27x15x46cm

shys06
Livrare imediată!

399,99Lei(-31%) 277,00Lei

Set tacamuri Prologic Black Fire

Set tacamuri Prologic Black Fire

a.pro.72738
Livrare imediată!

116,75Lei

Suport Trakker Butt Grabber, Large, Black, 2.5cm
Exclusiv online!

Suport Trakker Butt Grabber, Large, Black, 2.5cm

222908
Livrare 7-14 zile

39,95Lei

Teaser Black Cat Real Worm Teaser 160g Pink
Exclusiv online!

Teaser Black Cat Real Worm Teaser 160g Pink

6244162
Livrare 7-14 zile

124,70Lei

Baza PVC RAM Mounts Bond-A-Base Black Adhesive Base

Baza PVC RAM Mounts Bond-A-Base Black Adhesive Base

rap-398-blku
Livrare imediată!

273,20Lei

Briceag Multifunctional Victorinox Huntsman, Black, 9.10cm

Briceag Multifunctional Victorinox Huntsman, Black, 9.10cm

1.3713.3
Livrare imediată!

211,61Lei

Briceag Victorinox Sentinel One Hand Clip, Black, 11.00cm
Exclusiv online!

Briceag Victorinox Sentinel One Hand Clip, Black, 11.00cm

0.8416.m3
Livrare 48-72ore

178,30Lei

Carlige Gamakatsu Worm Offset EWG SL NS Black, Nr.6/0, 3buc/pac
Exclusiv online!

Carlige Gamakatsu Worm Offset EWG SL NS Black, Nr.6/0, 3buc/pac

146844-006
Livrare 48-72 ore

28,00Lei

Cupa Mikado Rezerva Prastie, Black
Exclusiv online!

Cupa Mikado Rezerva Prastie, Black

aix-kosz-01
Livrare 48-72 ore

8,00Lei

Cutie Momeala Preston Bait Tubs 2PT, Blue Black

Cutie Momeala Preston Bait Tubs 2PT, Blue Black

p0260010
Livrare imediată!

15,71Lei

Dandineta Mikado Ice Bug Tungsten, Orange Black, 0.8g, 4mm, 4buc/plic
Exclusiv online!

Dandineta Mikado Ice Bug Tungsten, Orange Black, 0.8g, 4mm, 4buc/plic

am-pod-003-4-ob
Livrare 48-72 ore

73,99Lei

Dandineta Mikado Ice Bug Violet Tungsten, Black, 0.8g, 4mm, 4buc/plic
Exclusiv online!

Dandineta Mikado Ice Bug Violet Tungsten, Black, 0.8g, 4mm, 4buc/plic

am-pod-003-4-bg
Livrare 48-72 ore

73,99Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.18mm, 17.3kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.18mm, 17.3kg, 10m

110806250014018
Livrare imediată!

7,39Lei

Fir Textil Mikado Nihonto Octa Braid Black 10m, 0.16mm, 12.9kg

Fir Textil Mikado Nihonto Octa Braid Black 10m, 0.16mm, 12.9kg

z23b-016
Livrare imediată!

15,01Lei

Afişare 2481 - 2500 din 4736 (237 pagini)
Queries: 5, Total time: 109.151 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = '17602a18ccb6e23397a9cbd708'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (108.692)
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('+black' 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:725
4 (0.110)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.120)
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