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


Sac de Dormit JRC Rova 3 Season Sleeping Bag, 220x84cm

Sac de Dormit JRC Rova 3 Season Sleeping Bag, 220x84cm

1537842
Livrare imediată!

649,95Lei

Ancora Deriva Quantum Drift Bag L -49%

Ancora Deriva Quantum Drift Bag L

8599002
Livrare imediată!

159,70Lei(-49%) 81,90Lei

Ancora Deriva Quantum Drift Bag XL -39%

Ancora Deriva Quantum Drift Bag XL

8599003
Livrare imediată!

244,75Lei(-39%) 149,90Lei

Geanta Accesorii Matrix Ethos XL Accessories Bag

Geanta Accesorii Matrix Ethos XL Accessories Bag

glu146
Livrare imediată!

323,97Lei

Geanta din Plasa Sonik 5kg SK-Tek Air Dry Bag, Large, 26x14x26cm
Exclusiv online!

Geanta din Plasa Sonik 5kg SK-Tek Air Dry Bag, Large, 26x14x26cm

sktadbl
Livrare 48-72 ore

83,72Lei

Geanta Penn Pilk and Jig Bag, 25x20x22cm
Exclusiv online!

Geanta Penn Pilk and Jig Bag, 25x20x22cm

1543823
Livrare 7-14 zile

224,96Lei

Geanta Penn Waist Bag, Black

Geanta Penn Waist Bag, Black

1543825
Livrare imediată!

134,96Lei

Husa Juvelnice Mikado Keepnet Bag, Rotunda, 2 Compartimente, Black & Green, 63x17cm
Exclusiv online!

Husa Juvelnice Mikado Keepnet Bag, Rotunda, 2 Compartimente, Black & Green, 63x17cm

uwj-mbr2-bg
Livrare 48-72 ore

98,00Lei

Husa Lansete Zeck Rod Bag Pro 1.50m
Exclusiv online!

Husa Lansete Zeck Rod Bag Pro 1.50m

90505260007
Livrare 48-72 ore

213,61Lei

Plumb Nash Solid Bag In-Line Lead 2oz, 57g, 1buc/plic
Exclusiv online!

Plumb Nash Solid Bag In-Line Lead 2oz, 57g, 1buc/plic

t2437
Livrare 7-14 zile

9,75Lei

Geanta Mikado Enclave Accessory Bag M, 22x13x8cm
Exclusiv online!

Geanta Mikado Enclave Accessory Bag M, 22x13x8cm

uwf-021-m
Livrare 48-72 ore

69,00Lei

Geanta Prologic Element Storm Safe Bait Bag 12ltr, 38x18x22cm
Exclusiv online!

Geanta Prologic Element Storm Safe Bait Bag 12ltr, 38x18x22cm

a8.pro.72823
Livrare 24-48 ore

277,66Lei

Husa Lansete Zeck Rod Bag Pro 1.35m
Exclusiv online!

Husa Lansete Zeck Rod Bag Pro 1.35m

90505260006
Livrare 48-72 ore

213,61Lei

Plumb Nash Solid Bag In-Line Lead 1.5oz, 43g, 1buc/plic
Exclusiv online!

Plumb Nash Solid Bag In-Line Lead 1.5oz, 43g, 1buc/plic

t2436
Livrare 7-14 zile

9,75Lei

Plumb Nash Solid Bag In-Line Lead 2.5oz, 71g, 1buc/plic

Plumb Nash Solid Bag In-Line Lead 2.5oz, 71g, 1buc/plic

t2438
Livrare imediată!

9,75Lei

Geanta Plano Guide Series Tackle Bag 3700 -25%

Geanta Plano Guide Series Tackle Bag 3700

plabg370
Livrare imediată!

630,00Lei(-25%) 472,00Lei

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

nfl205
Livrare imediată!

399,00Lei

Geanta Termoizolanta Zeck Cooling Bag 27x15x12cm
Exclusiv online!

Geanta Termoizolanta Zeck Cooling Bag 27x15x12cm

90405160024
Livrare 48-72 ore

106,55Lei

Husa Juvelnic / Minciog Pro FL EVA Net Bag 60x15x50cm

Husa Juvelnic / Minciog Pro FL EVA Net Bag 60x15x50cm

64-76005
Livrare imediată!

129,90Lei

Husa Juvelnic / Minciog Pro FL EVA Net Bag 60x25x60cm

Husa Juvelnic / Minciog Pro FL EVA Net Bag 60x25x60cm

64-76012
Livrare imediată!

149,00Lei

Afişare 281 - 300 din 486 (25 pagini)
Queries: 4, Total time: 13.282 ms [By time] [By id] [By file]
1 (0.161)
SELECT data
FROM `oc_session`
WHERE session_id = '22087b5902b0af598265bc86c1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (12.830)
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('+bag' 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.169)
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