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


Cutie Greys Momeala Vie Klip Lok Bait Box, 700ml

Cutie Greys Momeala Vie Klip Lok Bait Box, 700ml

1600406
Livrare imediată!

26,97Lei

Cutie Impermeabila Plano Small ABS Waterproof Case

Cutie Impermeabila Plano Small ABS Waterproof Case

pmc144930
Stoc epuizat

58,46Lei

Cutie Meiho Versus VS-820ND Clear

Cutie Meiho Versus VS-820ND Clear

mho-vs820ndc
Livrare imediată!

33,00Lei

Cutie Muste Rapture LMF Dry & Lure Box, Transparent, 18.8x10.8x1.5cm
Exclusiv online!

Cutie Muste Rapture LMF Dry & Lure Box, Transparent, 18.8x10.8x1.5cm

113-19-030
Livrare 48-72 ore

42,00Lei

Cutie Muste Rapture LMF Dry & Nymph Fly Box, Transparent, 18.8x10.8x1.5cm
Exclusiv online!

Cutie Muste Rapture LMF Dry & Nymph Fly Box, Transparent, 18.8x10.8x1.5cm

113-19-020
Livrare 48-72 ore

42,00Lei

Cutie pentru Accesorii Fox EOS Loaded Carp Tackle Box Large, 33x26x5cm

Cutie pentru Accesorii Fox EOS Loaded Carp Tackle Box Large, 33x26x5cm

cbx097
Livrare imediată!

179,96Lei

Cutie pentru Accesorii si Monturi C-Tec Rig Tackle Box, 25x14x3.5cm

Cutie pentru Accesorii si Monturi C-Tec Rig Tackle Box, 25x14x3.5cm

006405-00034-00000
Livrare imediată!

75,01Lei

Cutie pentru Momeala Daiwa D-Box MD Smoke, 26.7x16.7x9.0cm

Cutie pentru Momeala Daiwa D-Box MD Smoke, 26.7x16.7x9.0cm

d.14311.010
Livrare imediată!

60,56Lei

Cutie pentru Momeala Daiwa D-Box Mr Smoke, 26.7x16.7x4.8cm
Exclusiv online!

Cutie pentru Momeala Daiwa D-Box Mr Smoke, 26.7x16.7x4.8cm

d.14311.005
Livrare 24-48 ore

41,71Lei

Cutie pentru Viermusi Carp Zoom Maggot Dispenser 3.9x10.4cm

Cutie pentru Viermusi Carp Zoom Maggot Dispenser 3.9x10.4cm

cz0304
Livrare imediată!

15,01Lei

Cutie Plano Edge Flex 3700 Box

Cutie Plano Edge Flex 3700 Box

plase377
Livrare imediată!

202,45Lei

Cutie Plano Three Drawer Tackle System -31%

Cutie Plano Three Drawer Tackle System

pmc737002
Livrare imediată!

630,00Lei(-31%) 434,00Lei

Cutie Plano Two Tier Satchel -25%

Cutie Plano Two Tier Satchel

pmc115503
Stoc epuizat

225,01Lei(-25%) 168,00Lei

Cutie Preston Accessory Box - 4 Compartment Shallow

Cutie Preston Accessory Box - 4 Compartment Shallow

p0220127
Livrare imediată!

26,97Lei

Cutie Preston Accessory Box - 5 Compartment Shallow

Cutie Preston Accessory Box - 5 Compartment Shallow

p0220129
Livrare imediată!

38,25Lei

Cutie Sakura SK-9310 Smoke 20.5x14.5x4cm
Exclusiv online!

Cutie Sakura SK-9310 Smoke 20.5x14.5x4cm

90934btsk0093100
Livrare 48-72 ore

40,27Lei

Cutie Shakespeare Cantilever 3 Tackle Box

Cutie Shakespeare Cantilever 3 Tackle Box

1247782
Stoc epuizat

144,45Lei

Cutie Zeck S Hardbait Box 20x16.5x4.5cm
Exclusiv online!

Cutie Zeck S Hardbait Box 20x16.5x4.5cm

42505260039
Livrare 48-72 ore

50,22Lei

Suport + Cutii Momeala Korum Compact Bait Waiter Set

Suport + Cutii Momeala Korum Compact Bait Waiter Set

k0310190
Livrare imediată!

107,96Lei

Cutie Accesorii Carp Zoom Smart Accesorii Box, Small, 7.4x10.6x3cm

Cutie Accesorii Carp Zoom Smart Accesorii Box, Small, 7.4x10.6x3cm

cz1820
Livrare imediată!

16,01Lei

Afişare 721 - 740 din 1125 (57 pagini)
Queries: 4, Total time: 42.954 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = 'c02bfd32e32ce57212476cde3e'
/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 (42.597)
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('+cutii' 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.162)
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