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 Mivardi Fanatic pentru Somn 2.70m, 200-400G, 2seg

Lanseta Mivardi Fanatic pentru Somn 2.70m, 200-400G, 2seg

miv-fcf270
Livrare imediată!

225,01Lei

LANSETA SPINNING OKUMA 2SEG LUREMANIA SPIN 2,49M, 10-32G -23%

LANSETA SPINNING OKUMA 2SEG LUREMANIA SPIN 2,49M, 10-32G

o.okr.43981
Livrare imediată!

138,90Lei(-23%) 106,85Lei

LANSETA FOX HORIZON X4 ABBREVIATED HANDLE 3.90M 3.50LBS 2SEG -14%

LANSETA FOX HORIZON X4 ABBREVIATED HANDLE 3.90M 3.50LBS 2SEG

crd280
Livrare imediată!

1.394,97Lei(-14%) 1.198,90Lei

LANSETA TRABUCCO DANUBIUS CARP 2.40M, 150G, 2SEG

LANSETA TRABUCCO DANUBIUS CARP 2.40M, 150G, 2SEG

161-12-240
Livrare imediată!

210,00Lei

LANSETA SPINNING MAJOR CRAFT ARRIVAL 73L 2.21M 1.8-7g 2SEG -32%

LANSETA SPINNING MAJOR CRAFT ARRIVAL 73L 2.21M 1.8-7g 2SEG

ars-73l
Livrare imediată!

882,00Lei(-32%) 599,90Lei

Lanseta Mivardi Fanatic pentru Somn 2.40m, 200-400g, 2seg

Lanseta Mivardi Fanatic pentru Somn 2.40m, 200-400g, 2seg

miv-fcf240
Livrare imediată!

210,00Lei

Lanseta Colmic Calibra 3.00m, 70-300g, 2seg

Lanseta Colmic Calibra 3.00m, 70-300g, 2seg

caca02d
Livrare imediată!

840,00Lei

LANSETA SPINNING SAVAGE GEAR 2SEG 2,21M/3.10G
Exclusiv online!

LANSETA SPINNING SAVAGE GEAR 2SEG 2,21M/3.10G

o.sg.50172
Livrare 24-48 ore

644,40Lei

Lanseta Sportex Advancer Crap 3.96m 3.75lbs 2Seg -16%

Lanseta Sportex Advancer Crap 3.96m 3.75lbs 2Seg

ad151375
Livrare imediată!

594,00Lei(-16%) 499,00Lei

LANSETA PROLOGIC C1 ALPHA 3.90M, 3.50LB, 2SEG

LANSETA PROLOGIC C1 ALPHA 3.90M, 3.50LB, 2SEG

o.pro.57183
Livrare imediată!

338,77Lei

Lanseta Colmic Calibra 2.40m, 70-300g, 2seg

Lanseta Colmic Calibra 2.40m, 70-300g, 2seg

caca02b
Livrare imediată!

650,00Lei

Lanseta Feeder Matrix Aquos Ultra-X 3.30m 50g 2 Plus 2Seg

Lanseta Feeder Matrix Aquos Ultra-X 3.30m 50g 2 Plus 2Seg

grd137
Livrare imediată!

377,90Lei

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/28G -20%
Exclusiv online!

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/28G

nm.20502821
Livrare 24-48 ore

356,60Lei(-20%) 285,27Lei

LANSETA SPRO SKYVOLT SPINNING 2.40M 42-75GR 2SEG
Exclusiv online!

LANSETA SPRO SKYVOLT SPINNING 2.40M 42-75GR 2SEG

002040-00243-00000
Livrare 48-72 ore

290,00Lei

LANSETA SAVAGE GEAR FINEZZE SPIN 2.02M, 7-25G, 2SEG -23%

LANSETA SAVAGE GEAR FINEZZE SPIN 2.02M, 7-25G, 2SEG

o.sg.46968
Livrare imediată!

308,13Lei(-23%) 237,90Lei

Lanseta Feeder Matrix Aquos Ultra-X 3.60m 70g 2 Plus 2Seg

Lanseta Feeder Matrix Aquos Ultra-X 3.60m 70g 2 Plus 2Seg

grd138
Livrare imediată!

424,90Lei

LANSETA SPINNING MAJOR CRAFT OVER SEVEN 732L 2.21M 1.75-7g 2SEG -21%

LANSETA SPINNING MAJOR CRAFT OVER SEVEN 732L 2.21M 1.75-7g 2SEG

ars-732l
Livrare imediată!

884,00Lei(-21%) 699,90Lei

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/18G -20%
Exclusiv online!

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/18G

nm.20501821
Livrare 24-48 ore

338,72Lei(-20%) 270,97Lei

Lanseta Spod Carp Expert Spod 3.75mt/5LB/2Seg

Lanseta Spod Carp Expert Spod 3.75mt/5LB/2Seg

13390375
Livrare imediată!

384,00Lei

LANSETA SPINNING OKUMA 2SEG CLASSIC SPIN 1,98M/10-35G

LANSETA SPINNING OKUMA 2SEG CLASSIC SPIN 1,98M/10-35G

o.okr.54088
Livrare imediată!

110,90Lei

Afişare 961 - 980 din 3187 (160 pagini)
Queries: 5, Total time: 85.910 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '0b86cdc587ac79351a76bdb6a2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (73.826)
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('+2seg' 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 (11.742)
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 960, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.123)
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