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


Nada Claumar Special Betaina Galben 1KG

Nada Claumar Special Betaina Galben 1KG

clm0520
Livrare imediată!

12,89Lei

Boilies Claumar Birdfood Semi-Solubil Squid & Capsuna 24mm 800Gr

Boilies Claumar Birdfood Semi-Solubil Squid & Capsuna 24mm 800Gr

clm218520
Livrare imediată!

18,90Lei

Carp Zoom NADA WET METHOD FEEDER 850gr Chocolate Orange
Exclusiv online!

Carp Zoom NADA WET METHOD FEEDER 850gr Chocolate Orange

cz5201
Livrare 48-72 ore

27,00Lei

STOPER-OVAL TRABUCCO RUBBER STOPPER MARIME SS 9BUC/PLIC

STOPER-OVAL TRABUCCO RUBBER STOPPER MARIME SS 9BUC/PLIC

101-65-520
Livrare imediată!

10,00Lei

SET TRABUCCO ROLLING W/PEARL BEADS STOPPERS MARIME M 4SET/PLIC

SET TRABUCCO ROLLING W/PEARL BEADS STOPPERS MARIME M 4SET/PLIC

104-51-520
Livrare imediată!

11,00Lei

Varf Rezerva Benzar No Limit Feeder 4oz Fibra De Sticla Rosu 1.35x520x4.1 Mm -20%
Exclusiv online!

Varf Rezerva Benzar No Limit Feeder 4oz Fibra De Sticla Rosu 1.35x520x4.1 Mm

12344102
Livrare 24-48 ore

25,00Lei(-20%) 20,00Lei

Lanterna Cap Energoteam Outdoor Pandora

Lanterna Cap Energoteam Outdoor Pandora

74991520
Livrare imediată!

88,00Lei

Varf Rezerva Benzar No Limit Feeder 4oz Fibra De Sticla Rosu 1.0x520x4.1 Mm -20%

Varf Rezerva Benzar No Limit Feeder 4oz Fibra De Sticla Rosu 1.0x520x4.1 Mm

12344103
Livrare imediată!

25,00Lei(-20%) 20,00Lei

Jig Germina Thorn Nr.2/0 3g 3buc/plic
Exclusiv online!

Jig Germina Thorn Nr.2/0 3g 3buc/plic

hjt-0520-03
Livrare 48-72 ore

8,90Lei

Mulineta Preston Magnitude 520

Mulineta Preston Magnitude 520

p0010022
Livrare imediată!

697,46Lei

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER LEMONI 80m 0.082m 1.42lb
Exclusiv online!

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER LEMONI 80m 0.082m 1.42lb

v5208025
Livrare 48-72 ore

42,00Lei

Husa Delphin HAZARD 150CM -55%

Husa Delphin HAZARD 150CM

101001520
Livrare imediată!

303,00Lei(-55%) 135,01Lei

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER LEMONI 80m 0.091m 1.75lb
Exclusiv online!

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER LEMONI 80m 0.091m 1.75lb

v5208003
Livrare 48-72 ore

42,00Lei

Mulineta Sakura Ginaka 2.0 2007 FD

Mulineta Sakura Ginaka 2.0 2007 FD

30234saprf70252007
Livrare imediată!

215,38Lei

Scaun Nash Indulgence Daddy Long Legs Auto Recline 57x50cm -11%

Scaun Nash Indulgence Daddy Long Legs Auto Recline 57x50cm

t9520
Livrare imediată!

980,00Lei(-11%) 869,90Lei

CAP MINCIOG TRABUCCO XDS EASY SCOOP MONO 45CM / adancime 35/35h
Exclusiv online!

CAP MINCIOG TRABUCCO XDS EASY SCOOP MONO 45CM / adancime 35/35h

083-69-520
Livrare 48-72 ore

88,00Lei

LANTERNA CAP CORMORAN COR 1

LANTERNA CAP CORMORAN COR 1

a8.85.45201
Livrare imediată!

60,43Lei

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER LEMONI 80m 0.105m 2.3lb
Exclusiv online!

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER LEMONI 80m 0.105m 2.3lb

v5208004
Livrare 48-72 ore

42,00Lei

Montura FL Leadcore Plumb Inline Pasta Tip Fox 80 Gr Carlig C(classic boilie) Nr 6

Montura FL Leadcore Plumb Inline Pasta Tip Fox 80 Gr Carlig C(classic boilie) Nr 6

64-3520
Livrare imediată!

15,51Lei

Carlige Avid Armorok Hooks Snag nr.6
Exclusiv online!

Carlige Avid Armorok Hooks Snag nr.6

a0520032
Livrare 7-14 zile

26,97Lei

Afişare 1 - 20 din 615 (31 pagini)
Queries: 13, Total time: 188.612 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = '8fc827637caee226b12eb43e0e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.079)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (179.137)
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 "%520%") 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.130)
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 (2.521)
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.743)
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:1202
8 (0.086)
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:1221
9 (0.155)
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 (5.346)
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.098)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.077)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.087)
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