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 300 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


Agrafa Montata Browning 9cm S Feeder Link Pro

Agrafa Montata Browning 9cm S Feeder Link Pro

4156690001
Livrare imediată!

4,59Lei

ACCESORIU RAPITOR DAIWA GRIP PROREX CU CANTAR 29CM/28LB -23%

ACCESORIU RAPITOR DAIWA GRIP PROREX CU CANTAR 29CM/28LB

a.15409.020
Livrare imediată!

258,52Lei(-23%) 198,90Lei

CUTIE, ACCESORII, CARP, ZOOM, 13.3x7.2x2.9cm, cz4245, Cutii, Cutii Carp Zoom, Carp Zoom

CUTIE, ACCESORII, CARP, ZOOM, 13.3x7.2x2.9cm, cz4245, Cutii, Cutii Carp Zoom, Carp Zoom

cz4245
Livrare imediată!

9,50Lei

POPPER, COLMIC, POP-EY, 90, 9cm, 19.5Gr, Bandit, arhkdc02, Voblere Floating, Voblere Floating Colmic, Colmic
Exclusiv online!

POPPER, COLMIC, POP-EY, 90, 9cm, 19.5Gr, Bandit, arhkdc02, Voblere Floating, Voblere Floating Colmic, Colmic

arhkdc02
Livrare 48-72 ore

59,00Lei

CUTIE FLAMBEAU JAXON ANTI COROZIVA SATCHEL 38X35X9cm
Exclusiv online!

CUTIE FLAMBEAU JAXON ANTI COROZIVA SATCHEL 38X35X9cm

rf-9007
Livrare 48-72 ore

161,00Lei

SALTEA PRIMIRE CRAP NGT CRADLE 104X62X39CM
Exclusiv online!

SALTEA PRIMIRE CRAP NGT CRADLE 104X62X39CM

ngt-fu-cradle-404
Livrare 48-72 ore

634,00Lei

MASA CORT CARP ZOOM ROLL-TOP 53x51x49cm -21%

MASA CORT CARP ZOOM ROLL-TOP 53x51x49cm

cz2324
Livrare imediată!

251,99Lei(-21%) 197,90Lei

CUTIT MIGUEL NIETO SPANIA MINER LEMN,LAMA=110MM,MANER=9CM
Exclusiv online!

CUTIT MIGUEL NIETO SPANIA MINER LEMN,LAMA=110MM,MANER=9CM

h.n4402
Livrare 24-48 ore

299,78Lei

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm CHARTREUSE PEPPER -40%
Exclusiv online!

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm CHARTREUSE PEPPER

arhkbz06
Livrare 48-72 ore

25,00Lei(-40%) 15,01Lei

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm GREEN PUMKIN -40%

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm GREEN PUMKIN

arhkbz04
Livrare imediată!

25,00Lei(-40%) 15,01Lei

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm WATERMELON RED -40%

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm WATERMELON RED

arhkbz02
Livrare imediată!

25,00Lei(-40%) 15,01Lei

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm BLACK -40%
Exclusiv online!

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm BLACK

arhkbz01
Livrare 48-72 ore

25,00Lei(-40%) 15,01Lei

Montura Carp Zoom Pop-up Boilie, 19cm, 2buc/pac
Exclusiv online!

Montura Carp Zoom Pop-up Boilie, 19cm, 2buc/pac

cz1380
Livrare 48-72 ore

15,40Lei

GEANTA COLMIC JUVELNIC DUBLU CU BUZUNAR SERIA RED 65x9+9+9cm
Exclusiv online!

GEANTA COLMIC JUVELNIC DUBLU CU BUZUNAR SERIA RED 65x9+9+9cm

bo214
Livrare 48-72 ore

230,00Lei

Husa Carp Zoom pentru mulineta 18x20x9cm

Husa Carp Zoom pentru mulineta 18x20x9cm

cz3482
Livrare imediată!

39,00Lei

GEANTA SAVAGE M 20X40X29CM PLUS 3 CUTII -20%
Exclusiv online!

GEANTA SAVAGE M 20X40X29CM PLUS 3 CUTII

a8.sg.54776
Livrare 24-48 ore

332,40Lei(-20%) 265,92Lei

GEANTA COLMIC JUVELNIC SERIA RED 65x9cm
Exclusiv online!

GEANTA COLMIC JUVELNIC SERIA RED 65x9cm

bo212
Livrare 48-72 ore

160,00Lei

VOBLER, SALMO, THRILL, 9CM, SGH, 84539523, Voblere Sinking, Voblere Sinking Salmo, Salmo

VOBLER, SALMO, THRILL, 9CM, SGH, 84539523, Voblere Sinking, Voblere Sinking Salmo, Salmo

84539523
Livrare imediată!

48,00Lei

SCAUN JAXON PLIANT ALUMINIU CU TAVA 57x47x45 79cm 2.7kg 22mm

SCAUN JAXON PLIANT ALUMINIU CU TAVA 57x47x45 79cm 2.7kg 22mm

ak-kzy111b
Livrare imediată!

299,00Lei

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm PLUM -40%

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm PLUM

arhkbz03
Livrare imediată!

25,00Lei(-40%) 15,01Lei

Afişare 281 - 300 din 1458 (73 pagini)
Queries: 5, Total time: 203.076 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = '7b446198468625640e0432ef85'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (196.894)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%9cm%") 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:698
4 (5.899)
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 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.107)
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