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 COLMIC FINGER 50F 4.0cm 2.5gr GREEN PERCH -30%

VOBLER COLMIC FINGER 50F 4.0cm 2.5gr GREEN PERCH

arhkih03
Stoc epuizat

32,00Lei(-30%) 22,40Lei

PLUTA MAVER WIN GREEN 2.00GR

PLUTA MAVER WIN GREEN 2.00GR

9049200
Stoc epuizat

9,00Lei

VOBLER COLMIC WT-DOG 110 SLIM 11cm 13.5gr Green Tiger

VOBLER COLMIC WT-DOG 110 SLIM 11cm 13.5gr Green Tiger

arhkdr01
Stoc epuizat

69,00Lei

HYPERVIBE COLMIC 3.5" 8.9cm GREEN PUMPKIN -40%

HYPERVIBE COLMIC 3.5" 8.9cm GREEN PUMPKIN

arhkdt04
Stoc epuizat

39,00Lei(-40%) 23,40Lei

GHOST SHAD COLMIC 10cm GREEN SHAD -40%

GHOST SHAD COLMIC 10cm GREEN SHAD

arhkau04
Stoc epuizat

34,00Lei(-40%) 20,40Lei

SWIMBAIT REAL SHAD COLMIC S 8cm 10gr GREEN AYU -30%

SWIMBAIT REAL SHAD COLMIC S 8cm 10gr GREEN AYU

arhkbg03
Stoc epuizat

53,00Lei(-30%) 37,10Lei

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.30mm Green

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.30mm Green

cz2118
Stoc epuizat

12,50Lei

VIBER SHAD COLMIC 3" 7.6cm GREEN PUMPKIN ORANGE -40%

VIBER SHAD COLMIC 3" 7.6cm GREEN PUMPKIN ORANGE

arhkem10
Stoc epuizat

22,00Lei(-40%) 13,20Lei

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.35mm Green

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.35mm Green

cz2125
Stoc epuizat

12,50Lei

FIR NASH MONOFILAMENT BULLET GREEN, 0.28mm 10lb/4.53kg -49%

FIR NASH MONOFILAMENT BULLET GREEN, 0.28mm 10lb/4.53kg

t2800
Stoc epuizat

115,99Lei(-49%) 59,48Lei

ATA MATISAJ FUJI DULL A-NOCP 100m 50 MED GREEN 004

ATA MATISAJ FUJI DULL A-NOCP 100m 50 MED GREEN 004

mftnpa0004
Stoc epuizat

21,00Lei

Ghete Delphin GATOR Marime 47 Green Black

Ghete Delphin GATOR Marime 47 Green Black

768000047
Stoc epuizat

236,00Lei

TRICOU VASS KHAKI GREEN DUNGA GALBENA MARIME S -47%

TRICOU VASS KHAKI GREEN DUNGA GALBENA MARIME S

v1802/2/s
Stoc epuizat

74,90Lei(-47%) 39,90Lei

Shad Armored Craw 10cm 04 Green Pumpkin 6/plic

Shad Armored Craw 10cm 04 Green Pumpkin 6/plic

b000448
Stoc epuizat

25,00Lei

WAGGLER BENZAR GREEN MATCH 18GR

WAGGLER BENZAR GREEN MATCH 18GR

68524180
Stoc epuizat

56,00Lei

ATA MATISAJ FUJI DULL A-NOCP 100m 50 NEON GREEN 503

ATA MATISAJ FUJI DULL A-NOCP 100m 50 NEON GREEN 503

mftnpa0503
Stoc epuizat

21,00Lei

Pantaloni FOX Collection Green And Silver Joggers Marimea L -20%

Pantaloni FOX Collection Green And Silver Joggers Marimea L

ccl021
Stoc epuizat

201,21Lei(-20%) 160,96Lei

Cutie RidgeMonkey Modular Hookbait Green 4buc/set -10%

Cutie RidgeMonkey Modular Hookbait Green 4buc/set

rm052
Stoc epuizat

72,99Lei(-10%) 65,70Lei

Opritor Trakko Rig Weights Green

Opritor Trakko Rig Weights Green

tr11684
Stoc epuizat

10,00Lei

HYPERVIBE COLMIC 3.5" 8.9cm PLUM GREEN FLK -40%

HYPERVIBE COLMIC 3.5" 8.9cm PLUM GREEN FLK

arhkdt06
Stoc epuizat

39,00Lei(-40%) 23,40Lei

Afişare 2321 - 2340 din 2793 (140 pagini)
Queries: 7, Total time: 90.641 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = 'e265b5c22997c66b50f5682dfd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (78.643)
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 (MATCH(pd.tag) AGAINST('+green' 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 (11.405)
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 2320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.140)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"VASS TEXTILES LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.117)
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
7 (0.133)
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