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


LANSETA FEEDER FL CLASSIC COMMERCIAL 3.90M 20-120G 5VARFURI

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.90M 20-120G 5VARFURI

64-1647
Stoc epuizat

289,00Lei

Lanseta Daiwa Ninja X Feeder 3.60m, 220g, 3+3seg

Lanseta Daiwa Ninja X Feeder 3.60m, 220g, 3+3seg

d.11607.365
Stoc epuizat

419,00Lei

Lanseta Benzar Concourse Method Feeder 4.20m, 30-120g, 3+3seg

Lanseta Benzar Concourse Method Feeder 4.20m, 30-120g, 3+3seg

12345420
Stoc epuizat

1.224,00Lei

Lanseta Jaxon Zaffira Method Feeder RT, 3.60m, 20-60g, 3+2seg

Lanseta Jaxon Zaffira Method Feeder RT, 3.60m, 20-60g, 3+2seg

wj-zfi36060
Stoc epuizat

220,00Lei

Brat Trabucco GNT X-Connect Ripple Cross Arm

Brat Trabucco GNT X-Connect Ripple Cross Arm

116-26-010
Stoc epuizat

99,00Lei

Lanseta Colmic Mirage S31 Special Carp MH, 3.30m, 70g, 2+2seg

Lanseta Colmic Mirage S31 Special Carp MH, 3.30m, 70g, 2+2seg

cami83c
Stoc epuizat

790,01Lei

Lanseta Feeder Colmic Mirage S31 Still Water ML, 3.30m, 50g, 3+3seg

Lanseta Feeder Colmic Mirage S31 Still Water ML, 3.30m, 50g, 3+3seg

cami81a
Stoc epuizat

830,00Lei

Lanseta Okuma Custom Black Feeder MH, 12' 360cm, 40-80g, 3+3seg MG/MLG/LG -28%

Lanseta Okuma Custom Black Feeder MH, 12' 360cm, 40-80g, 3+3seg MG/MLG/LG

cb-f-1203mh40-80
Stoc epuizat

413,10Lei(-28%) 299,00Lei

Lanseta Trabucco Spectrum XTD Dynamic Feeder 3.60m, M-60g, 3+3seg

Lanseta Trabucco Spectrum XTD Dynamic Feeder 3.60m, M-60g, 3+3seg

150-83-360
Stoc epuizat

650,00Lei

Tronson 02 Trabucco Precision RPL Carp Feeder 3.90m, 120g

Tronson 02 Trabucco Precision RPL Carp Feeder 3.90m, 120g

152-36-390-r02
Stoc epuizat

74,97Lei

Brat Trabucco GNT X-Connect Ripple Side Rest

Brat Trabucco GNT X-Connect Ripple Side Rest

116-26-030
Stoc epuizat

120,00Lei

Lanseta Feeder Daiwa 3+3seg Ninja X, 3,90m, 220g

Lanseta Feeder Daiwa 3+3seg Ninja X, 3,90m, 220g

d.11607.395
Stoc epuizat

443,00Lei

Lanseta Ryobi Amazon Feeder 3.60m, 180g, 3+3seg

Lanseta Ryobi Amazon Feeder 3.60m, 180g, 3+3seg

17311360
Stoc epuizat

352,00Lei

Lanseta Ryobi Amazon Feeder 3.90m, 80g, 3+3seg

Lanseta Ryobi Amazon Feeder 3.90m, 80g, 3+3seg

17309390
Stoc epuizat

354,00Lei

Suport Feeder Colmic EVA Double, 25cm

Suport Feeder Colmic EVA Double, 25cm

ap61e
Stoc epuizat

250,00Lei

Suport Lateral Lansete Trabucco GNT X-Connect

Suport Lateral Lansete Trabucco GNT X-Connect

116-26-260
Stoc epuizat

195,01Lei

Lanseta Daiwa Ninja X Stalker Feeder 2.70m, 100g, 2+2seg

Lanseta Daiwa Ninja X Stalker Feeder 2.70m, 100g, 2+2seg

d.11605.270
Stoc epuizat

306,00Lei

Lanseta Feeder Colmic Mirage S31 Still Water ML, 3.60m, 50g, 3+3seg

Lanseta Feeder Colmic Mirage S31 Still Water ML, 3.60m, 50g, 3+3seg

cami81b
Stoc epuizat

890,00Lei

Lanseta Guru X-Change Bait-Up 3.60m, 280g, 2seg

Lanseta Guru X-Change Bait-Up 3.60m, 280g, 2seg

gu.grd257
Stoc epuizat

648,37Lei

Lanseta Ryobi Amazon Feeder 3.00m, 80g, 3+3seg

Lanseta Ryobi Amazon Feeder 3.00m, 80g, 3+3seg

17309300
Stoc epuizat

296,00Lei

Afişare 1401 - 1420 din 1497 (75 pagini)
Queries: 5, Total time: 54.532 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = 'a25f0b5db91a7d1eff2bc0fb4b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (54.086)
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('+lansete +feeder' 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.132)
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
5 (0.098)
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