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


SET JAXON 3 BACURI EVA 4L 2.5L 1L

SET JAXON 3 BACURI EVA 4L 2.5L 1L

re-101
Livrare imediată!

215,00Lei

Suport cu Bac nada Korum Any Chair Groundbait Bowl
Exclusiv online!

Suport cu Bac nada Korum Any Chair Groundbait Bowl

k0300017
Livrare 7-14 zile

188,96Lei

Tava Laterala Garbolino XXL cu 2 Bacuri Rectangulare si Cort
Exclusiv online!

Tava Laterala Garbolino XXL cu 2 Bacuri Rectangulare si Cort

995040002
Livrare 48-72 ore

912,31Lei

Suport Garbolino pentru Bac Multigrip Open
Exclusiv online!

Suport Garbolino pentru Bac Multigrip Open

90830gomej3625
Livrare 48-72 ore

130,40Lei

SET 2 BACURI EVA MAVER REALITY DOUBLE SQUARE
Exclusiv online!

SET 2 BACURI EVA MAVER REALITY DOUBLE SQUARE

6108017
Livrare 48-72 ore

159,00Lei

BAC DE NADA PLIABIL PRESTON OFFBOX 36 EVA GROUNDBAIT BOWL & HOOP LARGE

BAC DE NADA PLIABIL PRESTON OFFBOX 36 EVA GROUNDBAIT BOWL & HOOP LARGE

p0110088
Livrare imediată!

202,45Lei

VAS DE NADA PRESTON OFFBOX 36 EVA GROUNDBAIT BOWL & HOOP LARGE

VAS DE NADA PRESTON OFFBOX 36 EVA GROUNDBAIT BOWL & HOOP LARGE

p0110083
Livrare imediată!

179,96Lei

Set 6 Bacuri Garbolino 1 cu Fermoar 6 Deschise EVA Pro Box Bait Set
Exclusiv online!

Set 6 Bacuri Garbolino 1 cu Fermoar 6 Deschise EVA Pro Box Bait Set

42330gomll3605-set1
Livrare 48-72 ore

331,59Lei

Vas cu Suport Team Feeder by Dome 25cm

Vas cu Suport Team Feeder by Dome 25cm

7327-012
Livrare imediată!

87,00Lei

Geanta Mikado EVA Cu Bacuri 34x28x10cm
Exclusiv online!

Geanta Mikado EVA Cu Bacuri 34x28x10cm

uwi-mf-009-set
Livrare 48-72 ore

248,00Lei

Set 3 Bacuri Garbolino Rotunde cu Fermoar diametre 24,32,36cm EVA Pro Bowl Zipped
Exclusiv online!

Set 3 Bacuri Garbolino Rotunde cu Fermoar diametre 24,32,36cm EVA Pro Bowl Zipped

42330gomll3640-set
Livrare 48-72 ore

401,68Lei

Set Rive 2 Bacuri Nada EVA M+L
Exclusiv online!

Set Rive 2 Bacuri Nada EVA M+L

370353
Livrare 48-72 ore

160,84Lei

Suport cu Bac Trabucco GNT X36 XL

Suport cu Bac Trabucco GNT X36 XL

116-26-200
Livrare imediată!

190,00Lei

Suport Lateral Nevis cu Bol pentru Apa 25cm
Exclusiv online!

Suport Lateral Nevis cu Bol pentru Apa 25cm

7327-017
Livrare 48-72 ore

82,00Lei

Suport cu Vas Nada Trabucco GNT X-Connect

Suport cu Vas Nada Trabucco GNT X-Connect

116-26-180
Livrare imediată!

125,00Lei

Suport cu Vas Nada Mivardi pt picior de scaun 25-36 mm

Suport cu Vas Nada Mivardi pt picior de scaun 25-36 mm

m-sbahwb2
Livrare imediată!

60,00Lei

Suport Lateral CARP ZOOM cu Bol

Suport Lateral CARP ZOOM cu Bol

cz3637
Livrare imediată!

109,00Lei

Suport cu Vas Filex Quick Change System pentru Picior de Scaun 25, 30, 36mm
Exclusiv online!

Suport cu Vas Filex Quick Change System pentru Picior de Scaun 25, 30, 36mm

fil9588
Livrare 48-72 ore

89,99Lei

Vas Rive D36 Pentru Spalare Maini, Black
Exclusiv online!

Vas Rive D36 Pentru Spalare Maini, Black

90810104061
Livrare 48-72 ore

151,07Lei

SUPORT NEVIS CU VAS NADA PENTRU SCAUN 25CM

SUPORT NEVIS CU VAS NADA PENTRU SCAUN 25CM

7325-007
Stoc epuizat

68,00Lei

Afişare 1 - 20 din 22 (2 pagini)
Queries: 13, Total time: 192.226 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '90eca9b19add1f96933d8c3f19'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (190.362)
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 "%bacuri%") 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:697
5 (0.153)
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:1547
6 (0.350)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.271)
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:1204
8 (0.093)
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:1223
9 (0.067)
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:982
10 (0.310)
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:904
11 (0.088)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.101)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.123)
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