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


Pluta Culisanta Black Cat Somn 15gr Vibro Underwater Float

Pluta Culisanta Black Cat Somn 15gr Vibro Underwater Float

5565001
Livrare imediată!

17,78Lei

CARLIGE TRABUCCO HISASHI HOOK 3282 nr 4
Exclusiv online!

CARLIGE TRABUCCO HISASHI HOOK 3282 nr 4

024-14-040
Livrare 48-72 ore

12,00Lei

CARLIGE TRABUCCO HISASHI 10026 nr 4

CARLIGE TRABUCCO HISASHI 10026 nr 4

024-04-040
Livrare imediată!

13,99Lei

Teaser Somn Madcat A-Static Silent Nr.3/0, 17cm, 150g, Black
Exclusiv online!

Teaser Somn Madcat A-Static Silent Nr.3/0, 17cm, 150g, Black

mad.60156
Livrare 24-48 ore

89,55Lei

Carlig Owner CF-3 No.8/0
Exclusiv online!

Carlig Owner CF-3 No.8/0

12100256966-80
Livrare 48-72 ore

33,03Lei

Carlige Fudo Soi with Ring (SOIW-BN) nr.5/0 BN - Black Nickel 5 buc/plic

Carlige Fudo Soi with Ring (SOIW-BN) nr.5/0 BN - Black Nickel 5 buc/plic

3401-5/0
Livrare imediată!

10,00Lei

Carlig Owner Worm 5100 Nr.1

Carlig Owner Worm 5100 Nr.1

5100006
Livrare imediată!

18,75Lei

Teaser Somn Madcat A-Static Propeller Nr.3/0, 26cm, 150g, Firetiger UV
Exclusiv online!

Teaser Somn Madcat A-Static Propeller Nr.3/0, 26cm, 150g, Firetiger UV

mad.60239
Livrare 24-48 ore

119,80Lei

Lanseta Sportex NEPTOON BOAT 215 50lbs
Exclusiv online!

Lanseta Sportex NEPTOON BOAT 215 50lbs

jo2136
Livrare 48-72 ore

783,00Lei

Pluta Culisanta Black Cat Somn 20gr 10cm EVA U-Float Black

Pluta Culisanta Black Cat Somn 20gr 10cm EVA U-Float Black

5560010
Livrare imediată!

13,28Lei

Pluta Culisanta Black Cat Somn 40gr Propeller U-Float Silent
Exclusiv online!

Pluta Culisanta Black Cat Somn 40gr Propeller U-Float Silent

5528140
Livrare 7-14 zile

62,78Lei

CARLIG OWNER 50355 Nr.3/0 Negru Crom cu Anou

CARLIG OWNER 50355 Nr.3/0 Negru Crom cu Anou

5035501
Livrare imediată!

11,23Lei

CARLIGE TRABUCCO HISASHI 11014 06

CARLIGE TRABUCCO HISASHI 11014 06

024-02-060
Livrare imediată!

13,99Lei

Mulineta Black Cat Catextreme 65 FD
Exclusiv online!

Mulineta Black Cat Catextreme 65 FD

0373065
Livrare 7-14 zile

764,78Lei

Pluta Culisanta Black Cat Somn 40gr Dead Float Black
Exclusiv online!

Pluta Culisanta Black Cat Somn 40gr Dead Float Black

5530040
Livrare 7-14 zile

53,78Lei

CARLIGE TRABUCCO HISASHI 10026 nr 2 -27%

CARLIGE TRABUCCO HISASHI 10026 nr 2

024-04-020
Livrare imediată!

15,01Lei(-27%) 10,90Lei

Lanseta Sportex NEPTOON JIGGING 215 20lbs
Exclusiv online!

Lanseta Sportex NEPTOON JIGGING 215 20lbs

jo2122
Livrare 48-72 ore

783,00Lei

Pluta Culisanta Black Cat Somn 60gr Reflex Float -40%

Pluta Culisanta Black Cat Somn 60gr Reflex Float

411225557003
Livrare imediată!

26,30Lei(-40%) 15,90Lei

Lanseta Black Cat Perfect Passion XH-S, 2.40m, 600g, 2seg

Lanseta Black Cat Perfect Passion XH-S, 2.40m, 600g, 2seg

16577240
Livrare imediată!

368,78Lei

Pluta Culisanta Black Cat Somn 20gr Propeller U-Float Silent

Pluta Culisanta Black Cat Somn 20gr Propeller U-Float Silent

5528120
Livrare imediată!

62,78Lei

Afişare 1201 - 1220 din 2571 (129 pagini)
Queries: 4, Total time: 75.697 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = 'b743d0976d5e61119f49f73300'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (75.300)
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('+somn' 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.161)
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