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

Produse ce potrivesc criteriilor de căutare


Vobler Raid Level Minnow Plus Floating, 013 Onion Bait, 14g, 12.5cm, 1buc/pac
Vobler Raid Level Minnow Plus Floating, 014 Uruko, 14g, 12.5cm, 1buc/pac

Vobler Raid Level Minnow Plus Floating, 014 Uruko, 14g, 12.5cm, 1buc/pac

raid22200
Stoc epuizat

112,00Lei

Set Avertizoare Dunare Delphin Roler Shock 4 Plus 1 -35%

Set Avertizoare Dunare Delphin Roler Shock 4 Plus 1

900022602
Stoc epuizat

426,00Lei(-35%) 275,00Lei

Cort Fox Retreat Plus Ripstop 2man Plus inner dome -12%

Cort Fox Retreat Plus Ripstop 2man Plus inner dome

cum206
Stoc epuizat

4.364,96Lei(-12%) 3.847,90Lei

LANSETA CARP ZOOM CRAP FANATIC PLUS 50 12FT 3.66m 3.50lbs -40%

LANSETA CARP ZOOM CRAP FANATIC PLUS 50 12FT 3.66m 3.50lbs

cz1633
Stoc epuizat

463,01Lei(-40%) 278,00Lei

Vobler Lucky John Pro Series Haira Tiny Plus One 33LBF 3.3cm 4gr 506 1 buc/pac

Vobler Lucky John Pro Series Haira Tiny Plus One 33LBF 3.3cm 4gr 506 1 buc/pac

lj-hat33lbf-506
Stoc epuizat

37,00Lei

LANSETA ENERGOTEAM BENZAR METHOD FEEDER 3.60M 150G 3 plus 5BUC

LANSETA ENERGOTEAM BENZAR METHOD FEEDER 3.60M 150G 3 plus 5BUC

12343360
Stoc epuizat

333,00Lei

Cort Coleman Darwin 2 Plus

Cort Coleman Darwin 2 Plus

2000012148
Stoc epuizat

599,00Lei

AVERTIZOR ELECTRONIC DELKIM TX-I PLUS GALBEN

AVERTIZOR ELECTRONIC DELKIM TX-I PLUS GALBEN

a.de.dp027
Stoc epuizat

729,10Lei

Lanseta Delphin RIVER Trophy Feeder X-TRA Plus 4 varfuri 3.60m 200g -32%

Lanseta Delphin RIVER Trophy Feeder X-TRA Plus 4 varfuri 3.60m 200g

130382310
Stoc epuizat

410,00Lei(-32%) 279,50Lei

COMBO SPINNING LANSETA PLUS MULINETA TICA MARIME 20

COMBO SPINNING LANSETA PLUS MULINETA TICA MARIME 20

icerod combo gv-003
Stoc epuizat

172,90Lei

Cort Carp Zoom Adventure Bivvy 3 plus 1 persoane 390x330x165cm

Cort Carp Zoom Adventure Bivvy 3 plus 1 persoane 390x330x165cm

cz6810
Stoc epuizat

2.950,00Lei

LANSETA FEEDER TRABUCCO PRECISION RPL FEEDER PLUS 3.90MT 3VARFURI MEDIUM HEAVY 90GR
Set Avertizoare FOX Micron MX Plus Statie 3 Plus 1 -17%

Set Avertizoare FOX Micron MX Plus Statie 3 Plus 1

cei192
Stoc epuizat

1.619,96Lei(-17%) 1.350,00Lei

LANSETA CARP ZOOM CRAP FANATIC PLUS 50 12FT 3.66m 3.00lbs -40%

LANSETA CARP ZOOM CRAP FANATIC PLUS 50 12FT 3.66m 3.00lbs

cz1626
Stoc epuizat

449,00Lei(-40%) 269,00Lei

CORT FOX R-SERIES 1-MAN BIVVY XL PLUS INNER DOME KHAKI 235X295X165CM -17%

CORT FOX R-SERIES 1-MAN BIVVY XL PLUS INNER DOME KHAKI 235X295X165CM

cum243
Stoc epuizat

2.204,96Lei(-17%) 1.822,16Lei

Lada frigorifica electrica Campingaz Powerbox Plus 36l -7%

Lada frigorifica electrica Campingaz Powerbox Plus 36l

2000024957
Stoc epuizat

749,00Lei(-7%) 698,99Lei

Set Statie Avertizoare Delphin BRITON 3 Plus 1 -36%

Set Statie Avertizoare Delphin BRITON 3 Plus 1

900022431
Stoc epuizat

706,00Lei(-36%) 449,00Lei

SET AVERTIZOARE FOX RX MICRON 3 PLUS 1 -13%

SET AVERTIZOARE FOX RX MICRON 3 PLUS 1

cei157
Stoc epuizat

3.779,96Lei(-13%) 3.299,99Lei

Fir Monofilament Subdue Vision Plus Yellow 0.20mm/300m/4.70kg -63%

Fir Monofilament Subdue Vision Plus Yellow 0.20mm/300m/4.70kg

5305130744219
Stoc epuizat

27,00Lei(-63%) 9,90Lei

Afişare 581 - 600 din 755 (38 pagini)
Queries: 9, Total time: 24.274 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '9a3cbf4addd0e493bdf9c548bb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (20.294)
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('+plus' 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.276)
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 580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.112)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FOX INDISPONIBIL2(IULIA)"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CAMTICOM S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.118)
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