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


Lanterna De Cap Ledlenser EXH6R, 250L, Reincarcabila, Black/Yellow
Exclusiv online!

Lanterna De Cap Ledlenser EXH6R, 250L, Reincarcabila, Black/Yellow

a8.z502041
Livrare 24-48 ore

799,68Lei

Naluca Mikado Sicario 8.5Cm/Yellow Lime - 5Buc
Exclusiv online!

Naluca Mikado Sicario 8.5Cm/Yellow Lime - 5Buc

pmsc-8.5-yl
Livrare 48-72 ore

45,01Lei

Naluca Power Bait Power Flail, Black Snsne Yellow, 9cm, 8buc/plic

Naluca Power Bait Power Flail, Black Snsne Yellow, 9cm, 8buc/plic

1609963
Livrare imediată!

35,96Lei

Naluca Power Bait Power Flail, Spring Green Snsne Yellow, 5cm, 12buc/plic

Naluca Power Bait Power Flail, Spring Green Snsne Yellow, 5cm, 12buc/plic

1609954
Livrare imediată!

35,96Lei

Ochelari Leech ATW6 Yellow
Exclusiv online!

Ochelari Leech ATW6 Yellow

a2006c
Livrare 48-72ore

130,00Lei

Pop Up - Zig Rig -Eva 12Mm - Yellow Black - 9 Buc
Exclusiv online!

Pop Up - Zig Rig -Eva 12Mm - Yellow Black - 9 Buc

amc-017-y/b
Livrare 48-72 ore

16,01Lei

Pop-Up Fhp 12Mm Yellow Porumb 40G
Exclusiv online!

Pop-Up Fhp 12Mm Yellow Porumb 40G

fppup-12yp
Livrare 48-72 ore

26,00Lei

Pop-Up Fhp 8Mm Yellow Ananas 40G
Exclusiv online!

Pop-Up Fhp 8Mm Yellow Ananas 40G

fppup-8ya
Livrare 48-72 ore

26,00Lei

Senzor Mikado Bait Indicator - Carp - Cfl Ii - Yellow
Exclusiv online!

Senzor Mikado Bait Indicator - Carp - Cfl Ii - Yellow

ams08-cfl2-y
Livrare 48-72 ore

126,00Lei

Shad Savage Gear Craft Bleak, Green Pearl Yellow, 7.0cm, 2.5g, 5buc/pac
Exclusiv online!

Shad Savage Gear Craft Bleak, Green Pearl Yellow, 7.0cm, 2.5g, 5buc/pac

f1.sg.1609102
Livrare 24-48 ore

28,43Lei

Twister Mikado Grub, Yellow, 3.8cm, 10buc/pac
Exclusiv online!

Twister Mikado Grub, Yellow, 3.8cm, 10buc/pac

PMTBT-38-YE
Livrare 48-72 ore

15,01Lei

Twister Mikado Grub, Yellow, 5.1cm, 8buc/pac
Exclusiv online!

Twister Mikado Grub, Yellow, 5.1cm, 8buc/pac

PMTBT-51-YE
Livrare 48-72 ore

15,01Lei

Twister Mikado Grub, Yellow, 6.4cm, 6buc/pac
Exclusiv online!

Twister Mikado Grub, Yellow, 6.4cm, 6buc/pac

PMTBT-64-YE
Livrare 48-72 ore

15,01Lei

Vobler Abu Garcia Svartzonker McHybrid, Yellow Fin Perch, 100g, 20cm
Exclusiv online!

Vobler Abu Garcia Svartzonker McHybrid, Yellow Fin Perch, 100g, 20cm

1531905
Livrare 7-14 zile

111,96Lei

Vobler Abu Garcia Svartzonker McHybrid, Yellow Fin Perch, 74g, 16.5cm
Exclusiv online!

Vobler Abu Garcia Svartzonker McHybrid, Yellow Fin Perch, 74g, 16.5cm

1531897
Livrare 7-14 zile

95,96Lei

Vobler Live Target Frog Propper, Green / Yellow, 6.5cm, 7g -20%
Exclusiv online!

Vobler Live Target Frog Propper, Green / Yellow, 6.5cm, 7g

lt.fgp65t500
Livrare 24-48 ore

38,51Lei(-20%) 30,81Lei

Vobler Live Target Frog Propper, Green / Yellow, 7.5cm, 14g -20%
Exclusiv online!

Vobler Live Target Frog Propper, Green / Yellow, 7.5cm, 14g

lt.fgp75t500
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Wafters MAINLINE Match Dumbell Hookers Big River Barbel, Yellow, Essential Cell, 15x18mm, 150ml
Exclusiv online!

Wafters MAINLINE Match Dumbell Hookers Big River Barbel, Yellow, Essential Cell, 15x18mm, 150ml

a0.m.mm4503
Livrare 24-48 ore

42,13Lei

Wafters Senzor Method Enterprise Tackle Dumbells, Fluo Yellow, 6mm, 10buc/pac

Wafters Senzor Method Enterprise Tackle Dumbells, Fluo Yellow, 6mm, 10buc/pac

snz99228
Livrare imediată!

22,00Lei

Fir monofilament Sufix Ultra Knot 0,28mm/5,7 kg/1380m Opaque Yellow
Exclusiv online!

Fir monofilament Sufix Ultra Knot 0,28mm/5,7 kg/1380m Opaque Yellow

ds1uk028053pbu
Livrare 48-72ore

89,00Lei

Afişare 261 - 280 din 1060 (53 pagini)
Queries: 7, Total time: 30.380 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'f95c78892e89bc6f6af06f4ba0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (24.915)
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('+yellow' 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 (4.839)
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 260, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.129)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (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
7 (0.145)
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