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 TEAM FEEDER BY DOME MASTER CARP PRO 420 H 50-160GR

LANSETA TEAM FEEDER BY DOME MASTER CARP PRO 420 H 50-160GR

1844-420
Stoc epuizat

488,99Lei

Vobler Lucky John Pro Series Haira Tiny Plus One 33LBF 3.3cm 4gr 506 1 buc/pac

Vobler Lucky John Pro Series Haira Tiny Plus One 33LBF 3.3cm 4gr 506 1 buc/pac

lj-hat33lbf-506
Stoc epuizat

37,00Lei

MULINETA CORMORAN PRO CARP SLO 5PIF 5000 4RUL -30%

MULINETA CORMORAN PRO CARP SLO 5PIF 5000 4RUL

c.19.51500
Stoc epuizat

312,65Lei(-30%) 218,86Lei

LANSETA OKUMA FINA PRO 2.10M/10-35G/2SEG

LANSETA OKUMA FINA PRO 2.10M/10-35G/2SEG

o.okr.48264
Stoc epuizat

97,15Lei

SUPORT LANSETA PROLOGIC ANTIALUNECARE 1BUC/PLIC

SUPORT LANSETA PROLOGIC ANTIALUNECARE 1BUC/PLIC

a6.pro.48399
Stoc epuizat

39,48Lei

SALTEA CANTARIRE PROLOGIC GREEN PLUTITOR

SALTEA CANTARIRE PROLOGIC GREEN PLUTITOR

a.pro.43897
Stoc epuizat

176,91Lei

LANSETA CARP ZOOM MESH PRO CARP 13ft 3.9m 3.5lb 3 SEGMENTE

LANSETA CARP ZOOM MESH PRO CARP 13ft 3.9m 3.5lb 3 SEGMENTE

cz8861
Stoc epuizat

355,00Lei

Mulineta Black Cat Passion Pro FD 680 -32%

Mulineta Black Cat Passion Pro FD 680

0345080
Stoc epuizat

494,79Lei(-32%) 336,90Lei

LANSETA TEAM FEEDER BY DOME MASTER CARP PRO 360 MH 20-80GR

LANSETA TEAM FEEDER BY DOME MASTER CARP PRO 360 MH 20-80GR

1844-360
Stoc epuizat

403,01Lei

Lanseta Colmic Herakles Calida Pro Evolution Spin 2.13m/3-14g

Lanseta Colmic Herakles Calida Pro Evolution Spin 2.13m/3-14g

cahkcp02
Stoc epuizat

286,00Lei

Mulineta Black Cat Passion Pro FD 6100

Mulineta Black Cat Passion Pro FD 6100

0345100
Stoc epuizat

584,78Lei

Rod Pod Aluminiu Prologic Tri-Lux, 4 posturi

Rod Pod Aluminiu Prologic Tri-Lux, 4 posturi

a6.pro.54356
Stoc epuizat

890,06Lei

LANSETA TEAM FEEDER BY DOME MASTER CARP PRO 390 MH 30-90GR

LANSETA TEAM FEEDER BY DOME MASTER CARP PRO 390 MH 30-90GR

1844-390
Stoc epuizat

422,00Lei

LANSETA CARP ZOOM MESH PRO CARP 13ft 3.9m 3.5lb 2 SEGMENTE INEL 50MM

LANSETA CARP ZOOM MESH PRO CARP 13ft 3.9m 3.5lb 2 SEGMENTE INEL 50MM

cz8885
Stoc epuizat

345,00Lei

FIR TEXTIL SUFIX MATRIX PRO 135M 0.40MM 100LB 45.0KG MID.GREEN

FIR TEXTIL SUFIX MATRIX PRO 135M 0.40MM 100LB 45.0KG MID.GREEN

ds1wt08011tb1p
Stoc epuizat

99,00Lei

HUSA PROLOGIC CDX PT 4 LANSETE 3,90M 212x40x22cm

HUSA PROLOGIC CDX PT 4 LANSETE 3,90M 212x40x22cm

a8.pro.57166
Stoc epuizat

427,00Lei

LANSETA CARP ZOOM MESH PRO CARP 12ft 3.6m 3.5lb 2 SEGMENTE INEL 50MM

LANSETA CARP ZOOM MESH PRO CARP 12ft 3.6m 3.5lb 2 SEGMENTE INEL 50MM

cz8878
Stoc epuizat

335,00Lei

MARKER TELESCOPIC JAXON PRO CARP CU LUMINA 6M

MARKER TELESCOPIC JAXON PRO CARP CU LUMINA 6M

al-bsk02
Stoc epuizat

426,00Lei

VARGA COLMIC EMPEROR PRO ALBORELLA 2.5M

VARGA COLMIC EMPEROR PRO ALBORELLA 2.5M

caem50b
Stoc epuizat

267,00Lei

Lanseta telescopica Lineaeffe Drago/Pro Lord 2.10m/20-50g

Lanseta telescopica Lineaeffe Drago/Pro Lord 2.10m/20-50g

l.2024210
Stoc epuizat

44,87Lei

Afişare 3001 - 3020 din 3893 (195 pagini)
Queries: 6, Total time: 117.836 ms [By time] [By id] [By file]
1 (0.448)
SELECT data
FROM `oc_session`
WHERE session_id = '16ba09e41fba2ad27717e8b22c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.271)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (116.798)
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('+pro' 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.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.106)
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.097)
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