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


Geanta Lucky John Sling Bag Cu 1 Cutie, 20x31x15cm

Geanta Lucky John Sling Bag Cu 1 Cutie, 20x31x15cm

lj125b
Stoc epuizat

228,00Lei

Geanta NGT AP Multipocket Carryall 850, 60x35x40cm

Geanta NGT AP Multipocket Carryall 850, 60x35x40cm

ngt-ap-carryall-850
Stoc epuizat

119,00Lei

Geanta Nytro Sublime Feeder Bag 19.8L, 30x30x22cm

Geanta Nytro Sublime Feeder Bag 19.8L, 30x30x22cm

22400032
Stoc epuizat

280,74Lei

Geanta Nytro Sublime Feeder Box Bag 46L, 40x32x36cm

Geanta Nytro Sublime Feeder Box Bag 46L, 40x32x36cm

22400033
Stoc epuizat

331,74Lei

Geanta Power Catcher Monturi Spinning, 13x4x21cm

Geanta Power Catcher Monturi Spinning, 13x4x21cm

006208-00050-00000
Stoc epuizat

54,00Lei

Geanta Rapala Sportmans

Geanta Rapala Sportmans

46012-2
Stoc epuizat

159,00Lei

GEANTA ENERGOTEAM PENTRU MULINETE OUTDOOR XXL 40X30X10CM

GEANTA ENERGOTEAM PENTRU MULINETE OUTDOOR XXL 40X30X10CM

73201099
Stoc epuizat

131,00Lei

Rapala Limited Series Sling Bag -6%

Rapala Limited Series Sling Bag

46006-1
Stoc epuizat

309,00Lei(-6%) 289,00Lei

GEANTA PROLOGIC CRUZADE RIG STATION 36X28X21CM CU MASA

GEANTA PROLOGIC CRUZADE RIG STATION 36X28X21CM CU MASA

a8.pro.54440
Stoc epuizat

425,60Lei

GEANTA JAXON PILKER TEAM 42X22X22CM

GEANTA JAXON PILKER TEAM 42X22X22CM

uj-xtz02
Stoc epuizat

227,00Lei

BORSETA PLANO 2 CUTII INCLUSE -22%

BORSETA PLANO 2 CUTII INCLUSE

4475-00
Stoc epuizat

349,00Lei(-22%) 272,51Lei

GEANTA ACCESORII FOX CAMOLITE LARGE

GEANTA ACCESORII FOX CAMOLITE LARGE

clu303
Stoc epuizat

94,46Lei

Rapala Limited Series Sling Bag Big

Rapala Limited Series Sling Bag Big

46006-lk
Stoc epuizat

269,00Lei

Geanta Carp Spirit (30x42x23 cm)

Geanta Carp Spirit (30x42x23 cm)

144600360
Stoc epuizat

189,00Lei

Geanta NGT Jumbo Carryall Green, 93ltr, 83x35x34cm

Geanta NGT Jumbo Carryall Green, 93ltr, 83x35x34cm

ngt-fla-carryall-093 l
Stoc epuizat

215,00Lei

GEANTA JAGUAR PVC THERMO COLMIC 36X25X36cm -30%

GEANTA JAGUAR PVC THERMO COLMIC 36X25X36cm

boxeva08
Stoc epuizat

264,00Lei(-30%) 185,00Lei

GEANTA ACCESORII FOX CAMOLITE SMALL

GEANTA ACCESORII FOX CAMOLITE SMALL

clu301
Stoc epuizat

56,22Lei

Geanta Fox Camolite Low Level Carryall

Geanta Fox Camolite Low Level Carryall

clu298
Stoc epuizat

517,46Lei

GEANTA COLMIC ARNO COOLER SERIA RED 36x25x27cm Frigorific

GEANTA COLMIC ARNO COOLER SERIA RED 36x25x27cm Frigorific

bo205
Stoc epuizat

310,00Lei

Rucsac Plus 3 Cutii Savage Gear Lure Specialist 40x38x23cm

Rucsac Plus 3 Cutii Savage Gear Lure Specialist 40x38x23cm

a8.sg.54773
Stoc epuizat

338,40Lei

Afişare 741 - 760 din 952 (48 pagini)
Queries: 9, Total time: 25.621 ms [By time] [By id] [By file]
1 (0.173)
SELECT data
FROM `oc_session`
WHERE session_id = '742d5856a828290a6321f08572'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.134)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (24.513)
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 = '2' AND (MATCH(pd.tag) AGAINST('+genti' IN BOOLEAN MODE)) 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 (0.175)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.139)
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.118)
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
7 (0.121)
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
8 (0.131)
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
9 (0.117)
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