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 - spreader

Produse ce potrivesc criteriilor de căutare


Scaun pescuit Baracuda HXC029

Scaun pescuit Baracuda HXC029

scaun hxc029
Stoc epuizat

467,81Lei

UMBRELA DAIWA N ZON D 2.50M

UMBRELA DAIWA N ZON D 2.50M

d.13432.250
Stoc epuizat

264,24Lei

UMBRELA JAXON PVC CU PARASOLAR 150TX 300CM

UMBRELA JAXON PVC CU PARASOLAR 150TX 300CM

ak-plx150tx
Stoc epuizat

720,00Lei

SET LINII SENSAS PESCUIT BIG FISH 7M 5BUC/BOX

SET LINII SENSAS PESCUIT BIG FISH 7M 5BUC/BOX

a.s05058
Stoc epuizat

124,20Lei

CORT PROLOGIC INSPIRE BROLLY SYSTEM 140X240X215cm

CORT PROLOGIC INSPIRE BROLLY SYSTEM 140X240X215cm

a8.pro.64153
Stoc epuizat

2.650,00Lei

SENZOR ELECTRONIC PESCUIT DELPHIN FORZA UNI

SENZOR ELECTRONIC PESCUIT DELPHIN FORZA UNI

101001365
Stoc epuizat

120,00Lei

LANSETA TRABUCCO ACHAB XP BOAT 2.10M 200G 2SEG

LANSETA TRABUCCO ACHAB XP BOAT 2.10M 200G 2SEG

161-13-600
Stoc epuizat

139,00Lei

UMBRELA JAXON PVC CU PARASOLAR 150TV 300CM

UMBRELA JAXON PVC CU PARASOLAR 150TV 300CM

ak-plx150tv
Stoc epuizat

810,00Lei

Cort Nevis Mammut 250x250x170cm

Cort Nevis Mammut 250x250x170cm

7516-002
Stoc epuizat

1.630,00Lei

Umbrela Matrix Over The Top Super Brolly 115cm -30%

Umbrela Matrix Over The Top Super Brolly 115cm

gum004
Stoc epuizat

323,97Lei(-30%) 226,77Lei

Perna Avid Carp Comfort Pillows - Standard

Perna Avid Carp Comfort Pillows - Standard

a0450009
Stoc epuizat

134,96Lei

SUPORT LANSETA BARCA JAF BOAT ROD REST 2403

SUPORT LANSETA BARCA JAF BOAT ROD REST 2403

j1702403
Stoc epuizat

39,00Lei

SET LINII SENSAS PESCUIT CARP 7M 5BUC/BOX

SET LINII SENSAS PESCUIT CARP 7M 5BUC/BOX

a.s05231
Stoc epuizat

124,15Lei

Lanseta Mitchell Suprema Bolentino 2.70m 272-400g 2buc -44%

Lanseta Mitchell Suprema Bolentino 2.70m 272-400g 2buc

1345226
Stoc epuizat

474,50Lei(-44%) 263,53Lei

Perna Avid Carp Comfort Pillows XL

Perna Avid Carp Comfort Pillows XL

a0450010
Stoc epuizat

161,96Lei

SET LINII SENSAS PESCUIT ROACH 7M 5BUC/CUTIE

SET LINII SENSAS PESCUIT ROACH 7M 5BUC/CUTIE

a.s05056
Stoc epuizat

124,15Lei

LANSETA TELESCOPICA TRABUCCO VEKTOR MASTER BOAT 3.00M 150G

LANSETA TELESCOPICA TRABUCCO VEKTOR MASTER BOAT 3.00M 150G

168-25-300
Stoc epuizat

149,00Lei

CORT CARP ZOOM PRACTIC BIWY 255x180x130cm 1 persoana

CORT CARP ZOOM PRACTIC BIWY 255x180x130cm 1 persoana

cz7519
Stoc epuizat

429,99Lei

Set Delphin de ferestre pentru bivouacuri C3 LUX

Set Delphin de ferestre pentru bivouacuri C3 LUX

101000678
Stoc epuizat

190,00Lei

Winterskin Pentru Cort Delphin C3 Lux ClimaControl Carpath

Winterskin Pentru Cort Delphin C3 Lux ClimaControl Carpath

101000676
Stoc epuizat

879,80Lei

Afişare 741 - 760 din 822 (42 pagini)
Queries: 8, Total time: 24.983 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '057b771f78f3fe31bc1010b651'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.123)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (20.403)
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('+pescuit' 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
5 (3.848)
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 740, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.109)
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