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


Swinger, Carp, Academy, V-Head, Albastru, 6363-403, Swingere Hangere, Swingere Hangere Carp Academy, Carp Academy
Swinger, Carp, Academy, Endless, Galben, 6363-204, Swingere Hangere, Swingere Hangere Carp Academy, Carp Academy
CROSETA, LEADCORE, CARP, ACADEMY, SPLICE, NEEDLE, 8100-208, Crosete si Burghie , Crosete si Burghie Carp Academy, Carp Academy
Buzzbar Carp Academy 2 Posturi 30cm
Exclusiv online!

Buzzbar Carp Academy 2 Posturi 30cm

6227-600
Livrare 48-72 ore

24,80Lei

Swinger, Carp, Academy, Mojo, Rosu, 6363-102, Swingere Hangere, Swingere Hangere Carp Academy, Carp Academy
Buzzbar Carp Academy 3 Posturi 30cm

Buzzbar Carp Academy 3 Posturi 30cm

6227-608
Livrare imediată!

24,80Lei

Swinger, Carp, Academy, V-Head, Verde, 6363-401, Swingere Hangere, Swingere Hangere Carp Academy, Carp Academy
Tub Silicon Carp Academy 0.5mm

Tub Silicon Carp Academy 0.5mm

8100-251
Livrare imediată!

7,10Lei

Swinger, Carp, Academy, V-Head, Rosu, 6363-402, Swingere Hangere, Swingere Hangere Carp Academy, Carp Academy
Spuma flotanta Carp Academy 6mm

Spuma flotanta Carp Academy 6mm

8100-162
Livrare imediată!

9,70Lei

Spuma flotanta Carp Academy 8mm

Spuma flotanta Carp Academy 8mm

8100-167
Livrare imediată!

9,70Lei

INDICATOR CARP ACADEMY LINE BITER 2BUC/PLIC

INDICATOR CARP ACADEMY LINE BITER 2BUC/PLIC

8100-196
Livrare imediată!

17,50Lei

Tub Silicon Carp Academy 0.3mm

Tub Silicon Carp Academy 0.3mm

8100-250
Livrare imediată!

7,10Lei

Tub Silicon Carp Academy 1mm

Tub Silicon Carp Academy 1mm

8100-253
Livrare imediată!

7,50Lei

Tub Silicon Carp Academy 0.75mm

Tub Silicon Carp Academy 0.75mm

8100-252
Livrare imediată!

7,10Lei

Cap Suport Carp Academy Lanseta Cu Siguranta

Cap Suport Carp Academy Lanseta Cu Siguranta

8100-106
Livrare imediată!

21,00Lei

SWINGER, CARP, ACADEMY, THUNDER, , 6362-001, Swingere Hangere, Swingere Hangere Carp Academy, Carp Academy
Croseta Carp Academy Boilies Fluorescent -10%
Exclusiv online!

Croseta Carp Academy Boilies Fluorescent

8100-238
Livrare 48-72 ore

7,20Lei(-10%) 6,50Lei

Rod Pod Carp Academy Deluxe
Exclusiv online!

Rod Pod Carp Academy Deluxe

6133-002
Livrare 48-72 ore

660,00Lei

Pichet Carp Academy EX Strong, 70-120cm
Exclusiv online!

Pichet Carp Academy EX Strong, 70-120cm

6129-110
Livrare 48-72 ore

32,50Lei

Afişare 301 - 320 din 460 (23 pagini)
Queries: 5, Total time: 257.087 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = '479545359fbb55c4a22d54e1d4'
/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:427
3 (254.664)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%academy%") 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:698
4 (2.124)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.140)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38