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 400 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


Lanseta DAM Yagi Light Spoon 1.90m 3-6gr

Lanseta DAM Yagi Light Spoon 1.90m 3-6gr

2040970663
Stoc epuizat

225,39Lei

CAMASA BLASER HERREN LIGHT HEMD DIEG MARIME S

CAMASA BLASER HERREN LIGHT HEMD DIEG MARIME S

bl.120027.087.s
Stoc epuizat

287,15Lei

FOX LIGHTWEIGHT CAMO WADERS 41

FOX LIGHTWEIGHT CAMO WADERS 41

cfw110
Stoc epuizat

449,96Lei

Lanseta bolognesa Maver Superlithium Light MX 6m

Lanseta bolognesa Maver Superlithium Light MX 6m

5794600
Stoc epuizat

2.240,00Lei

Lanseta DAM Yagi Light Spoon 1.90m 1-4gr

Lanseta DAM Yagi Light Spoon 1.90m 1-4gr

2040970661
Stoc epuizat

222,85Lei

PANTALONI SHORT FOX BLACK & ORANGE LIGHTWEIGHT SHORTS S -20%

PANTALONI SHORT FOX BLACK & ORANGE LIGHTWEIGHT SHORTS S

ccl049
Stoc epuizat

93,89Lei(-20%) 75,11Lei

PANTALONI SHORT FOX BLACK & ORANGE LIGHTWEIGHT SHORTS L -20%

PANTALONI SHORT FOX BLACK & ORANGE LIGHTWEIGHT SHORTS L

ccl051
Stoc epuizat

93,89Lei(-20%) 75,11Lei

LANSETA SPORTEX NEOWAVE SUPER ULTRA LIGHT 240 0.1-5gr -33%

LANSETA SPORTEX NEOWAVE SUPER ULTRA LIGHT 240 0.1-5gr

aw2400
Stoc epuizat

1.669,00Lei(-33%) 1.122,00Lei

LANSETA SPORTEX NEOWAVE SUPER ULTRA LIGHT 270 0.1-5gr -33%

LANSETA SPORTEX NEOWAVE SUPER ULTRA LIGHT 270 0.1-5gr

aw2700
Stoc epuizat

1.809,00Lei(-33%) 1.216,00Lei

PANTALONI SHORT FOX GREEN AND SILVER LIGHTWEIGHT SHORTS S -20%

PANTALONI SHORT FOX GREEN AND SILVER LIGHTWEIGHT SHORTS S

ccl055
Stoc epuizat

93,90Lei(-20%) 75,01Lei

FOX LIGHTWEIGHT CAMO WADERS 43

FOX LIGHTWEIGHT CAMO WADERS 43

cfw112
Stoc epuizat

449,96Lei

FOX LIGHTWEIGHT CAMO WADERS 46

FOX LIGHTWEIGHT CAMO WADERS 46

cfw115
Stoc epuizat

449,96Lei

FOX LIGHTWEIGHT CAMO WADERS 42

FOX LIGHTWEIGHT CAMO WADERS 42

cfw111
Stoc epuizat

449,96Lei

Pantaloni RidgeMonkey Dropback Lightweight Hydrophobic Green XXL

Pantaloni RidgeMonkey Dropback Lightweight Hydrophobic Green XXL

rm209
Stoc epuizat

220,45Lei

Lanseta DAM Yagi Light Spoon 2.10m 1-4g

Lanseta DAM Yagi Light Spoon 2.10m 1-4g

2040970664
Stoc epuizat

227,56Lei

FOX LIGHTWEIGHT CAMO WADERS 45

FOX LIGHTWEIGHT CAMO WADERS 45

cfw114
Stoc epuizat

449,96Lei

Hanorac Nash Lightweight Hoody, Marime L

Hanorac Nash Lightweight Hoody, Marime L

c5692
Stoc epuizat

245,00Lei

FOX LIGHTWEIGHT CAMO WADERS 44

FOX LIGHTWEIGHT CAMO WADERS 44

cfw113
Stoc epuizat

449,96Lei

FIR TEXTIL VARIVAS AVANI SLJ SUPER LIGHT JIGGING MAX POWER PE X8 150m 10.1lb 10m x 5 culori
Lanseta Fox Rage Prism X Versatile Light Casting Rod 210cm 10-40gr 2seg -14%

Lanseta Fox Rage Prism X Versatile Light Casting Rod 210cm 10-40gr 2seg

nrd368
Stoc epuizat

539,96Lei(-14%) 464,06Lei

Afişare 1021 - 1040 din 1295 (65 pagini)
Queries: 9, Total time: 697.141 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '8134c853e6c0a9312fc066bdfe'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (687.119)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%light%") 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:724
4 (9.259)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.113)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.105)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.091)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.128)
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