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


Lopata Coghlans pliabila

Lopata Coghlans pliabila

c9065
Livrare imediată!

108,00Lei

BAC NADA CARP ZOOM AVIX PLIABIL 31x25cm
Exclusiv online!

BAC NADA CARP ZOOM AVIX PLIABIL 31x25cm

cz6215
Livrare 48-72 ore

72,00Lei

Geanta Sportex EVA Pliabila, XL
Exclusiv online!

Geanta Sportex EVA Pliabila, XL

s321011
Livrare 48-72 ore

260,00Lei

GALEATA PLIABILA AVID CARP STORM SHIELD 10L

GALEATA PLIABILA AVID CARP STORM SHIELD 10L

a0430042
Livrare imediată!

94,46Lei

Minciog, Pliabil, Savage, Gear, M, 52x45x43cm, 64CM, a2.sg.71111, Mincioguri Rapitor, Mincioguri Rapitor Savage Gear, Savage Gear
Bac Mikado Pliabil Method Feeder Rotund 003, 35x17cm
Exclusiv online!

Bac Mikado Pliabil Method Feeder Rotund 003, 35x17cm

uwi-mf-003
Livrare 48-72 ore

75,01Lei

Scaun Pliabil Shakespeare Folding Stool

Scaun Pliabil Shakespeare Folding Stool

1154485
Livrare imediată!

89,96Lei

GALEATA PLIABILA PRO FL 10L CU SFOARA

GALEATA PLIABILA PRO FL 10L CU SFOARA

64-7603
Livrare imediată!

44,90Lei

Bidon Pliabil cu Robinet Coghlans 7.5l

Bidon Pliabil cu Robinet Coghlans 7.5l

c9737
Livrare imediată!

135,01Lei

Scaun DAM Fighter Pro Pliabil cu Spatar, Sarcina Maxima 100kg
Exclusiv online!

Scaun DAM Fighter Pro Pliabil cu Spatar, Sarcina Maxima 100kg

a8.dam.8470006
Livrare 24-48 ore

169,13Lei

Scaun, Pliabil, Mivardi, Simplu, 100kg, m-chsim, Scaune, Scaune Mivardi, Scaune Mivardi, Mivardi

Scaun, Pliabil, Mivardi, Simplu, 100kg, m-chsim, Scaune, Scaune Mivardi, Scaune Mivardi, Mivardi

m-chsim
Livrare imediată!

62,00Lei

Scaun Pliabil Shakespeare Folding Backrest Stool 58x44x44cm

Scaun Pliabil Shakespeare Folding Backrest Stool 58x44x44cm

1154486
Livrare imediată!

107,96Lei

Bac Rive Pentru Apa Pliabil, 20x20x24.5cm
Exclusiv online!

Bac Rive Pentru Apa Pliabil, 20x20x24.5cm

42310370320
Livrare 48-72 ore

117,45Lei

Cutit Pliabil Spro Universal, 20.3cm

Cutit Pliabil Spro Universal, 20.3cm

004702-00092-00000
Livrare imediată!

75,01Lei

Foarfeca Pliabila Coghlans
Exclusiv online!

Foarfeca Pliabila Coghlans

c7600
Livrare 24-48 ore

20,00Lei

Bac Pliabil Mikado Pentru Apa, Dark Green
Exclusiv online!

Bac Pliabil Mikado Pentru Apa, Dark Green

amc-021
Livrare 48-72 ore

69,00Lei

GALEATA PLIABILA PRO FL 5L CU SFOARA

GALEATA PLIABILA PRO FL 5L CU SFOARA

64-76029
Livrare imediată!

36,90Lei

Geantă Penn pliabilă EVA pentru barcă

Geantă Penn pliabilă EVA pentru barcă

1543826
Livrare imediată!

179,96Lei

Bidon Pliabil cu Robinet Coghlans 18.9l

Bidon Pliabil cu Robinet Coghlans 18.9l

c1205
Livrare imediată!

143,00Lei

Bidon Pliabil cu Robinet 7.5l Coghlans
Exclusiv online!

Bidon Pliabil cu Robinet 7.5l Coghlans

c9223
Livrare 24-48 ore

164,01Lei

Afişare 61 - 80 din 120 (6 pagini)
Queries: 10, Total time: 212.079 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '48e021dacea15e1ef393e2a482'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (208.951)
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 = '3' AND (pd.tag LIKE "%pliabil%") 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.186)
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 (0.837)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.341)
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.122)
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.120)
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 (1.142)
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.139)
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