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, 4156690001, Antitangle Feeder, Antitangle Feeder Browning, Browning
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

CUTIE ACCESORII CARP ZOOM 13.3x7.2x2.9cm

cz4245
Livrare imediată!

9,50Lei

POPPER COLMIC POP-EY 90 9cm 19.5Gr Bandit
Exclusiv online!

POPPER COLMIC POP-EY 90 9cm 19.5Gr Bandit

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, arhkbz04, Grub-uri, Grub-uri Colmic, Colmic -40%

GRUB, COLMIC, X35, DOUBLE, CLAW, 3.5", 8.9cm, GREEN, PUMKIN, arhkbz04, Grub-uri, Grub-uri Colmic, Colmic

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, arhkbz01, Grub-uri, Grub-uri Colmic, Colmic -40%
Exclusiv online!

GRUB, COLMIC, X35, DOUBLE, CLAW, 3.5", 8.9cm, BLACK, arhkbz01, Grub-uri, Grub-uri Colmic, Colmic

arhkbz01
Livrare 48-72 ore

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

Montura, Carp, Zoom, Pop-up, Boilie,, 19cm,, 2buc/pac, cz1380, Monturi Crap, Monturi Crap Carp Zoom, Monturi Carp Zoom, Crap Carp Zoom, Carp Zoom
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, a8.sg.54776, Genti si Borsete Spinning, Genti si Borsete Spinning Savage Gear, Savage Gear -20%
Exclusiv online!

, GEANTA, SAVAGE, M, 20X40X29CM, PLUS, 3, CUTII, a8.sg.54776, Genti si Borsete Spinning, Genti si Borsete Spinning Savage Gear, Savage Gear

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, ak-kzy111b, Scaune, Scaune Jaxon, Jaxon
GRUB, COLMIC, X35, DOUBLE, CLAW, 3.5", 8.9cm, PLUM, arhkbz03, Grub-uri, Grub-uri Colmic, Colmic -40%

GRUB, COLMIC, X35, DOUBLE, CLAW, 3.5", 8.9cm, PLUM, arhkbz03, Grub-uri, Grub-uri Colmic, Colmic

arhkbz03
Livrare imediată!

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

Afişare 281 - 300 din 1458 (73 pagini)
Queries: 10, Total time: 239.323 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'b78f94dddddef6264a9c131af3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (217.820)
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 (0.205)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (5.968)
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
6 (1.233)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.078)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.285)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (13.382)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.131)
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