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


Plasa de Insecte FOX 60 Inch Mozzy Mesh

Plasa de Insecte FOX 60 Inch Mozzy Mesh

cum275
Livrare imediată!

223,60Lei

TUNEL PLASA PVA JAXON CU INCARCATOR 23mm 5M
Exclusiv online!

TUNEL PLASA PVA JAXON CU INCARCATOR 23mm 5M

lc-pva072
Livrare 48-72 ore

59,00Lei

TUNEL PLASA PVA JAXON SLOW CU INCARCATOR 44mm 5M
Exclusiv online!

TUNEL PLASA PVA JAXON SLOW CU INCARCATOR 44mm 5M

lc-pva073
Livrare 48-72 ore

70,00Lei

Kit Extra Carp Plasa Solubila PVA Mesh + Tija Compresie, 5m 34mm

Kit Extra Carp Plasa Solubila PVA Mesh + Tija Compresie, 5m 34mm

ec0173
Livrare imediată!

51,80Lei

TUNEL PLASA NON PVA JAXON 18mm 5M
Exclusiv online!

TUNEL PLASA NON PVA JAXON 18mm 5M

lc-nva003
Livrare 48-72 ore

48,00Lei

Plasa de rezerva Delphin ARMADA 110cm

Plasa de rezerva Delphin ARMADA 110cm

946006152
Livrare imediată!

72,00Lei

MINCIOG LINEAEFFE 1,60M.PLASA RARA

MINCIOG LINEAEFFE 1,60M.PLASA RARA

a2.m6100500
Livrare imediată!

46,45Lei

PLASA ANTITANTAR
Exclusiv online!

PLASA ANTITANTAR

uj-hl06
Livrare 48-72 ore

39,00Lei

Cap Minciog Nevis Nylon 55x45cm Plasa 20mm Rotund

Cap Minciog Nevis Nylon 55x45cm Plasa 20mm Rotund

4238-020
Livrare imediată!

75,01Lei

PLASA PVA REINCARCARE 44mm 5M JAXON
Exclusiv online!

PLASA PVA REINCARCARE 44mm 5M JAXON

lc-pva011
Livrare 48-72 ore

55,00Lei

KIT PLASA SOLUBILA PVA KORDA NEW BOILIE FUNNEL WEB SYSTEM 7M

KIT PLASA SOLUBILA PVA KORDA NEW BOILIE FUNNEL WEB SYSTEM 7M

a.kbfw
Livrare imediată!

65,01Lei

MINCIOG JAXON METAL SAFE 210F PLASA 12MM
Exclusiv online!

MINCIOG JAXON METAL SAFE 210F PLASA 12MM

pl-axmb210f
Livrare 48-72 ore

137,00Lei

PLASA PVA CARP EXPERT REFILL SIMA 25MM X 7M

PLASA PVA CARP EXPERT REFILL SIMA 25MM X 7M

30141225
Livrare imediată!

27,50Lei

MINCIOG JAXON METAL SAFE T PLASA 30MM 200F
Exclusiv online!

MINCIOG JAXON METAL SAFE T PLASA 30MM 200F

pl-axmt200f
Livrare 48-72 ore

169,00Lei

Minciog spinning Delphin SPIN-R plasa de guma 60x50cm -37%

Minciog spinning Delphin SPIN-R plasa de guma 60x50cm

942000355
Livrare imediată!

131,99Lei(-37%) 83,00Lei

Plasa de rezerva Delphin ARMADA 100cm

Plasa de rezerva Delphin ARMADA 100cm

946006151
Livrare imediată!

72,00Lei

TUNEL PLASA PVA JAXON FAST CU INCARCATOR 37mm 5M
Exclusiv online!

TUNEL PLASA PVA JAXON FAST CU INCARCATOR 37mm 5M

lc-pva075
Livrare 48-72 ore

70,00Lei

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 40X50X50CM
Exclusiv online!

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 40X50X50CM

a2.sg.50802
Livrare 24-48 ore

110,82Lei

MINCIOG JAXON METAL SAFE T PLASA 30MM 300F
Exclusiv online!

MINCIOG JAXON METAL SAFE T PLASA 30MM 300F

pl-axmt300f
Livrare 48-72 ore

190,00Lei

Cap Minciog Nevis Nylon 55x45cm Plasa 7mm Rotund

Cap Minciog Nevis Nylon 55x45cm Plasa 7mm Rotund

4238-007
Livrare imediată!

72,99Lei

Afişare 121 - 140 din 319 (16 pagini)
Queries: 12, Total time: 348.234 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '41d07472c94aaccf869327226a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (339.492)
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 = '0' AND (pd.tag LIKE "%plasa%") 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
5 (0.247)
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:1555
6 (2.655)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.848)
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
8 (0.196)
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 (4.119)
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.117)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38