Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

FIR TRABUCCO TOUR TOUGH SPECIAL SEA 300M 1.00 MM 61.50Kg

052-36-100

Livrare imediată!

125,00Lei

FIR, TRABUCCO, TOUR, TOUGH, SPECIAL, SEA, 300M, 0.80, MM, 41.70Kg, 052-36-080, Fire Somn, Fire Somn Trabucco, Trabucco

052-36-080

Livrare imediată!

98,00Lei

Exclusiv online!

FIR KORDA BAIT FLOSS SPECIAL PENTRU LEGARE POP UP 30 m

a.kbf

Livrare 24-48 ore

30,15Lei

POP UP 3D CPK DUMBELL SPECIAL FRUITS 10MM

1000144

Livrare imediată!

18,00Lei

Exclusiv online!

NADA TRABUCCO GNT MATCH EXPERT SPECIAL FIUME 1Kg

060-08-180

Livrare 48-72 ore

17,01Lei

CARLIGE COBRA FEEDER SPECIALIST Nr.4 10buc/plic

cf203-004

Livrare imediată!

6,00Lei

CARLIGE COBRA FEEDER SPECIALIST Nr.10 10buc/plic

cf203-010

Livrare imediată!

6,00Lei

Dumbells C&B Pop-Ups Special C&B 6mm

6427416146032

Livrare imediată!

23,00Lei

Wafters C&B Fumigena, Special, 6/8mm, 40g

6427416145943

Livrare imediată!

27,00Lei

Exclusiv online!

Mulineta Sensas Pezon&Michel Specialist FXC FV 4500

spm.09251

Livrare 24-48 ore

507,54Lei

Fir monofilament Gardner Sure Pro Special E. Purple 12lb 0.30mm 1320m

spro12p

Livrare imediată!

79,00Lei

Fir monofilament Gardner Sure Pro Special E. Purple 10lb 0.28mm 1540m

spro10p

Livrare imediată!

79,00Lei

Nada Claumar Special Universal TTX 3kg

clm220486

Livrare imediată!

25,00Lei

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

d.11172.390

Livrare imediată!

1.368,50Lei

Varga FL Fine Special 6M

1244151595766

Livrare imediată!

145,91Lei

Fir Monofilament Trabucco T-Force Special Feeder, 0.18mm, 4.60kg, 150m

051-40-180

Livrare imediată!

31,00Lei

Exclusiv online!

Lanseta Daiwa N'Zon Distance Special Feeder 3.90m, 120g, 3+3seg

d.11171.390

Livrare 24-48 ore

1.348,64Lei

Boilies Tare de Carlig CPK Fluoroattract + Special Fruits, Marime S, 16/20mm

1000759

Livrare imediată!

18,00Lei

Exclusiv online!

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.22mm, 6.73kg, 600m

33554022

Livrare 24-48 ore

55,00Lei

Fir Monofilament Trabucco T-Force Special Feeder, 0.22mm, 6.95kg, 150m

051-40-220

Livrare imediată!

31,00Lei

Afişare 41 - 60 din 707 (36 pagini)

Queries: 10, Total time: 1,645.708 ms [By time] [By id] [By file]

1 (0.091)

SELECT data
FROM `oc_session`
WHERE session_id = 'f70e71f21098fad2bde0eb11f9'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.092)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.084)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (704.798)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%special%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555

5 (404.957)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%special%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 40, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (0.186)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%special%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014

7 (535.208)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%special%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923

8 (0.107)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.085)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (0.099)

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare