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


Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 114

Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 114

fl602-sinking-allround-55mm-10.5g-114
Livrare imediată!

17,10Lei

Vobler Rapala Countdown Elite Gilded Rainbow Trout 5.5cm 5g

Vobler Rapala Countdown Elite Gilded Rainbow Trout 5.5cm 5g

cde55 gdrt
Livrare imediată!

67,00Lei

Pantaloni de trening Delphin RAWER XL

Pantaloni de trening Delphin RAWER XL

101000632
Livrare imediată!

179,00Lei

VOBLER JACKALL TN50 FULL TUNGSTEN 5.2CM 9.5G BLACK KING GILL -20%

VOBLER JACKALL TN50 FULL TUNGSTEN 5.2CM 9.5G BLACK KING GILL

ja.807126266
Livrare imediată!

102,90Lei(-20%) 82,32Lei

Elastic Rezerva Prastie Preston Matchpult Small -34%

Elastic Rezerva Prastie Preston Matchpult Small

p0190011
Livrare imediată!

17,96Lei(-34%) 11,90Lei

Croseta Avid Carp Titanium Retracta Hair Needle

Croseta Avid Carp Titanium Retracta Hair Needle

a0590004
Livrare imediată!

22,46Lei

PANTALON PROLOGIC CARPIO JOGGERS ARMY GREEN MARIME XXL
Exclusiv online!

PANTALON PROLOGIC CARPIO JOGGERS ARMY GREEN MARIME XXL

a8.pro.73862
Livrare 24-48 ore

195,01Lei

Vobler Salmo Rattlin Slider Sinking Red Wake 8cm 20g

Vobler Salmo Rattlin Slider Sinking Red Wake 8cm 20g

qrn019
Livrare imediată!

69,71Lei

Varnis Siliconic Cresta Super Stretch Silicone Tube 0.3mm 1m

Varnis Siliconic Cresta Super Stretch Silicone Tube 0.3mm 1m

004723-00401-00000
Livrare imediată!

10,00Lei

HUSA DAIWA PROREX LANSETA CU MULINETA 128CM 2SEG
Exclusiv online!

HUSA DAIWA PROREX LANSETA CU MULINETA 128CM 2SEG

d.15813.240
Livrare 24-48 ore

146,66Lei

JACHETA FLEECE KORDA KORE POLAR CHARCOAL, MARIME L

JACHETA FLEECE KORDA KORE POLAR CHARCOAL, MARIME L

a8.kcl456
Livrare imediată!

348,48Lei

PANTALONI FOX COLLECTION ORANGE BLACK LIGHTWEIGHT JOGGERS XXXL -20%

PANTALONI FOX COLLECTION ORANGE BLACK LIGHTWEIGHT JOGGERS XXXL

ccl042
Livrare imediată!

125,20Lei(-20%) 100,16Lei

Elastic Preston Pelletpult De Rezerva Pentru Prastie, Small
Exclusiv online!

Elastic Preston Pelletpult De Rezerva Pentru Prastie, Small

p0190005
Livrare 7-14 zile

17,96Lei

JACHETA Trabucco GNT-TECNIK THERMO HOODIE XXL
Exclusiv online!

JACHETA Trabucco GNT-TECNIK THERMO HOODIE XXL

049-42-400
Livrare 48-72 ore

265,00Lei

Vobler Rapala Countdown Elite Gilded Wakasagi 5.5cm 5g
Exclusiv online!

Vobler Rapala Countdown Elite Gilded Wakasagi 5.5cm 5g

cde55 gdwk
Livrare 48-72ore

67,00Lei

Husă Delphin Delphin QUEEN 360-3 145cm -26%

Husă Delphin Delphin QUEEN 360-3 145cm

101001515
Livrare imediată!

233,00Lei(-26%) 172,40Lei

Mănuși din Fleece Delphin Camp, Marime XL

Mănuși din Fleece Delphin Camp, Marime XL

750001046
Livrare imediată!

64,00Lei

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 06

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 06

fl601-sinking-deepwater-70mm-16.0g-06
Livrare imediată!

17,10Lei

LEADCORE Climax CULT CRAP 10m 35lb Dark Silt
Exclusiv online!

LEADCORE Climax CULT CRAP 10m 35lb Dark Silt

9900-10014-035
Livrare 48-72 ore

36,00Lei

JACHETA FLEECE KORDA KORE POLAR CHARCOAL, MARIME S

JACHETA FLEECE KORDA KORE POLAR CHARCOAL, MARIME S

a8.kcl454
Livrare imediată!

348,48Lei

Afişare 501 - 520 din 17595 (880 pagini)
Queries: 6, Total time: 787.644 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '2de9b3d8c319232e48f6929b80'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (719.337)
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 "%și%") 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:737
4 (67.868)
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 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.157)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.119)
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