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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


LANSETA DAIWA NINJA X CARP 3.90M/3.5LBS 4SEG

LANSETA DAIWA NINJA X CARP 3.90M/3.5LBS 4SEG

d.11596.397
Stoc epuizat

439,09Lei

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.35mm 20.3lbs

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.35mm 20.3lbs

500623035
Stoc epuizat

43,99Lei

MINCIOG CARP ZOOM LIVE BAIT PREDATOR Z OPLUS 17x14.5 30cm

MINCIOG CARP ZOOM LIVE BAIT PREDATOR Z OPLUS 17x14.5 30cm

cz3932
Stoc epuizat

13,99Lei

Fir Delphin FIN Carp ARMADA 1200m Camuflaj 0.30mm 15.9lbs

Fir Delphin FIN Carp ARMADA 1200m Camuflaj 0.30mm 15.9lbs

500623430
Stoc epuizat

87,00Lei

NADA CARP ZOOM SUPER SWEET 1KG SWEET FISH

NADA CARP ZOOM SUPER SWEET 1KG SWEET FISH

cz9844
Stoc epuizat

15,00Lei

NADA CARP ZOOM CARP FIESTA 3KG AROMA MIERE

NADA CARP ZOOM CARP FIESTA 3KG AROMA MIERE

cz7194
Stoc epuizat

31,00Lei

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.40mm 25.3lbs

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.40mm 25.3lbs

500623040
Stoc epuizat

49,00Lei

CARLIG GAMAKATSU A1 G-CARP CAMOUGREEN SPEC.X Nr.2 10buc/plic

CARLIG GAMAKATSU A1 G-CARP CAMOUGREEN SPEC.X Nr.2 10buc/plic

gk.149322.2
Stoc epuizat

33,11Lei

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.30mm

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.30mm

34055030
Stoc epuizat

18,00Lei

Montura Carp Spirit Fluorocarbon 'D' Rig Barbed Nr: 4 20lbs

Montura Carp Spirit Fluorocarbon 'D' Rig Barbed Nr: 4 20lbs

acs340051
Stoc epuizat

15,01Lei

Geaca Carp Zoom Polar Full Zip XL

Geaca Carp Zoom Polar Full Zip XL

cz7244
Stoc epuizat

136,01Lei

LANSETA DAIWA 2BUC. EMCAST CARP 3,60M/3,5LBS

LANSETA DAIWA 2BUC. EMCAST CARP 3,60M/3,5LBS

d.11581.366
Stoc epuizat

419,30Lei

SALTEA DE CANTARIRE FOX Safety Carp Sack inc mini H-block

SALTEA DE CANTARIRE FOX Safety Carp Sack inc mini H-block

ccc027
Stoc epuizat

164,21Lei

MONTURA CARP ZOOM METHOD FC-571 NR10 SPIN 10mm 8cm 0.18mm

MONTURA CARP ZOOM METHOD FC-571 NR10 SPIN 10mm 8cm 0.18mm

cz6711
Stoc epuizat

12,00Lei

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.18MM

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.18MM

34060018
Stoc epuizat

16,01Lei

Lanseta Delphin ARMADA CARP BlackWay 2Seg 3.00m 3.00lbs

Lanseta Delphin ARMADA CARP BlackWay 2Seg 3.00m 3.00lbs

121210420
Stoc epuizat

241,11Lei

GEANTA CARP ZOOM PREDATOR-Z OPLUS-N SPINNING 33x18x28cm

GEANTA CARP ZOOM PREDATOR-Z OPLUS-N SPINNING 33x18x28cm

cz2569
Stoc epuizat

129,00Lei

Momitor CARP EXPERT DELUXE METHOD LONGCAST 65 G

Momitor CARP EXPERT DELUXE METHOD LONGCAST 65 G

58699265
Stoc epuizat

12,99Lei

PELETE CARP ZOOM RAPID METHOD MICRO 300gr 1.5mm Sausage-Garlic

PELETE CARP ZOOM RAPID METHOD MICRO 300gr 1.5mm Sausage-Garlic

cz1616
Stoc epuizat

16,50Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.26mm 5.70kg Fluo Pink -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.26mm 5.70kg Fluo Pink

cz6995
Stoc epuizat

65,00Lei(-25%) 48,80Lei

Afişare 6881 - 6900 din 7362 (369 pagini)
Queries: 9, Total time: 236.355 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '0258724e141adc932e9067c7b9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.094)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (235.328)
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('+carp' 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
5 (0.199)
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.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.183)
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