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


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

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

101-65-530
Livrare imediată!

10,00Lei

STOPER TRABUCCO LARGE BLACK MARIME L 15BUC/PLIC

STOPER TRABUCCO LARGE BLACK MARIME L 15BUC/PLIC

105-65-030
Livrare imediată!

5,00Lei

Jacheta Savage Gear SG2 Hybrid Slate Green Marime XL -40%
Exclusiv online!

Jacheta Savage Gear SG2 Hybrid Slate Green Marime XL

a8.sg.73721
Livrare 24-48 ore

586,38Lei(-40%) 351,83Lei

STOPER-STICK TRABUCCO RUBBER STOPPER MARIME SSS 9BUC/PLIC

STOPER-STICK TRABUCCO RUBBER STOPPER MARIME SSS 9BUC/PLIC

101-65-410
Livrare imediată!

9,00Lei

ELASTIC TRABUCCO POWER CORE HW MARIMEA 5-8 1.8mm 3m
Exclusiv online!

ELASTIC TRABUCCO POWER CORE HW MARIMEA 5-8 1.8mm 3m

102-05-180
Livrare 48-72 ore

69,00Lei

SET TRABUCCO DIAMOND ROLLING W/GREEN BEADS STOPPERS MARIME S 4SET/PLIC

SET TRABUCCO DIAMOND ROLLING W/GREEN BEADS STOPPERS MARIME S 4SET/PLIC

104-51-610
Livrare imediată!

11,00Lei

VESTA VERNEY-CARRON GROUSE KAKI MARIME M
Exclusiv online!

VESTA VERNEY-CARRON GROUSE KAKI MARIME M

lvc.phgi002k.m
Livrare 24-48 ore

301,75Lei

Jacheta Savage Gear SG2 Hybrid Slate Green Marime M -40%
Exclusiv online!

Jacheta Savage Gear SG2 Hybrid Slate Green Marime M

a8.sg.73719
Livrare 24-48 ore

586,38Lei(-40%) 351,83Lei

Jacheta Savage Gear SG2 Hybrid Slate Green Marime S -40%
Exclusiv online!

Jacheta Savage Gear SG2 Hybrid Slate Green Marime S

a8.sg.73718
Livrare 24-48 ore

586,38Lei(-40%) 351,83Lei

ELASTIC TRABUCCO POWER CORE HW MARIMEA 6-10 2.1mm 3m
Exclusiv online!

ELASTIC TRABUCCO POWER CORE HW MARIMEA 6-10 2.1mm 3m

102-05-210
Livrare 48-72 ore

69,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

ELASTIC TRABUCCO POWER CORE HW MARIMEA 3-5 1.2mm 4m
Exclusiv online!

ELASTIC TRABUCCO POWER CORE HW MARIMEA 3-5 1.2mm 4m

102-05-120
Livrare 48-72 ore

79,00Lei

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

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

101-65-510
Livrare imediată!

10,00Lei

ELASTIC TRABUCCO POWER CORE HW MARIMEA 4-6 1.5mm 4m
Exclusiv online!

ELASTIC TRABUCCO POWER CORE HW MARIMEA 4-6 1.5mm 4m

102-05-150
Livrare 48-72 ore

79,00Lei

VESTA VERNEY-CARRON GROUSE KAKI MARIME S
Exclusiv online!

VESTA VERNEY-CARRON GROUSE KAKI MARIME S

lvc.phgi002k.s
Livrare 24-48 ore

301,75Lei

STOPER-STICK TRABUCCO RUBBER STOPPER MARIME SSSS 9BUC/PLIC

STOPER-STICK TRABUCCO RUBBER STOPPER MARIME SSSS 9BUC/PLIC

101-65-400
Livrare imediată!

9,00Lei

Pantaloni Scurti Fox Camo Shorts, Marime M

Pantaloni Scurti Fox Camo Shorts, Marime M

cfx026
Livrare imediată!

179,96Lei

Hanorac NASH TACKLE Hoody, Geen, Marime 12-14 Ani -12%

Hanorac NASH TACKLE Hoody, Geen, Marime 12-14 Ani

c1128
Livrare imediată!

195,99Lei(-12%) 172,90Lei

Cosulet Feeder DAM Detek Flex Deschis cu Vartej, Marime L, 80g, 1buc/pac -30%

Cosulet Feeder DAM Detek Flex Deschis cu Vartej, Marime L, 80g, 1buc/pac

a.dam.66011
Livrare imediată!

19,28Lei(-30%) 13,49Lei

Afişare 121 - 140 din 4702 (236 pagini)
Queries: 9, Total time: 1,047.523 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '648b41d0f04a317430c3136d64'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
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 (444.891)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%marime%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
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
5 (0.171)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%marime%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014
6 (601.772)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%marime%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923
7 (0.135)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.125)
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