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


Avertizor Spro C-Tec Clip On, Blue

Avertizor Spro C-Tec Clip On, Blue

004706-00009-00000
Livrare imediată!

37,00Lei

Lanseta Spro C-Tec Governor Carp 3.30m, 2seg, 2.50lbs

Lanseta Spro C-Tec Governor Carp 3.30m, 2seg, 2.50lbs

002968-00330-00000
Livrare imediată!

196,80Lei

Cap Minciog Spro C-TEC cu Flotor si Plasa Cauciucata, 55x45x30cm
Exclusiv online!

Cap Minciog Spro C-TEC cu Flotor si Plasa Cauciucata, 55x45x30cm

003230-00107-00000
Livrare 48-72 ore

101,80Lei

Cap Minciog Spro C-Tec Prion, Large, 55x45cm

Cap Minciog Spro C-Tec Prion, Large, 55x45cm

003230-00113-00000
Livrare imediată!

37,00Lei

Cutie C-TEC Carp Tackle Box System
Exclusiv online!

Cutie C-TEC Carp Tackle Box System

006405-00019-00000
Livrare 48-72 ore

107,00Lei

Cutie Magnetica pentru Accesorii C-Tec Session Box, 24x13x4cm
Exclusiv online!

Cutie Magnetica pentru Accesorii C-Tec Session Box, 24x13x4cm

006405-00035-00000
Livrare 48-72 ore

75,01Lei

Kit Montura Plumb Pierdut Spro C-Tec Anti Tangle Rig Kit, Brown, 3 Monturi
Exclusiv online!

Kit Montura Plumb Pierdut Spro C-Tec Anti Tangle Rig Kit, Brown, 3 Monturi

008620-00013-00000
Livrare 48-72 ore

11,20Lei

Cap Minciog Spro C-Tec Prion, Small, 45x35cm
Exclusiv online!

Cap Minciog Spro C-Tec Prion, Small, 45x35cm

003230-00111-00000
Livrare 48-72 ore

32,00Lei

Kit Montura Spro C-Tec Terminal Tackle Box, 8 Monturi + Cutie Dubla
Exclusiv online!

Kit Montura Spro C-Tec Terminal Tackle Box, 8 Monturi + Cutie Dubla

008620-00025-00000
Livrare 48-72 ore

27,00Lei

Lanseta Spro C-Tec Pantera Feeder Composite Feeder MA 3.60, 80g, 3+2seg -29%
Exclusiv online!

Lanseta Spro C-Tec Pantera Feeder Composite Feeder MA 3.60, 80g, 3+2seg

002460-00360-00000
Livrare 48-72 ore

179,00Lei(-29%) 127,90Lei

Saltea de Primire Spro C-Tec Mat 115x65cm

Saltea de Primire Spro C-Tec Mat 115x65cm

006540-00024-00000
Livrare imediată!

131,99Lei

Bait Crusher C-Tec
Exclusiv online!

Bait Crusher C-Tec

008620-00026-00000
Livrare 48-72 ore

39,00Lei

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 C-Tec Ready Rig Box cu 6 Role EVA pentru Monturi

Cutie C-Tec Ready Rig Box cu 6 Role EVA pentru Monturi

006405-00024-00000
Livrare imediată!

24,00Lei

Cap Minciog Spro C-Tec Prion, Medium, 50x40cm

Cap Minciog Spro C-Tec Prion, Medium, 50x40cm

003230-00112-00000
Livrare imediată!

33,40Lei

Fir monofilament Spro C-Tec Sediment Bicolor 0.40mm 1000m

Fir monofilament Spro C-Tec Sediment Bicolor 0.40mm 1000m

005309-00040-00000
Stoc epuizat

59,00Lei

Fir Monofilament Spro C-Tec Sediment Bicolor, 0.25mm, 1000m

Fir Monofilament Spro C-Tec Sediment Bicolor, 0.25mm, 1000m

005309-00025-00000
Stoc epuizat

59,00Lei

Manusi DAM Neo Tec Half Finger Black XL

Manusi DAM Neo Tec Half Finger Black XL

8100976660
Stoc epuizat

70,20Lei

LANSETA C-TEC GOVERNOR CARP 3.6M 3.25LBS 2seg

LANSETA C-TEC GOVERNOR CARP 3.6M 3.25LBS 2seg

2968-362
Stoc epuizat

240,00Lei

Manusi DAM Neo Tec Half Finger Black L

Manusi DAM Neo Tec Half Finger Black L

8100976659
Stoc epuizat

70,20Lei

Afişare 181 - 200 din 231 (12 pagini)
Queries: 4, Total time: 6.850 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'a93ad7d1a2f94dcb0575e0a4d3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (6.425)
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 = '2' AND (MATCH(pd.tag) AGAINST('+tec' 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.187)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38