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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Scaun Modular Rive St8 2.0 Black -4%
Exclusiv online!

Scaun Modular Rive St8 2.0 Black

90810118007
Livrare 48-72 ore

4.000,01Lei(-4%) 3.822,24Lei

Scaun Nash Bank Life Moon Chair Camo, 100x100x40cm -14%

Scaun Nash Bank Life Moon Chair Camo, 100x100x40cm

t1250
Livrare imediată!

590,00Lei(-14%) 509,30Lei

Scaun Nash Indulgence Daddy Long Legs Auto Recline 57x50cm -10%

Scaun Nash Indulgence Daddy Long Legs Auto Recline 57x50cm

t9520
Livrare imediată!

980,00Lei(-10%) 885,51Lei

Scaun Pescuit Fox Duralite Chair 32x47x52cm -25%

Scaun Pescuit Fox Duralite Chair 32x47x52cm

cbc101
Livrare imediată!

719,96Lei(-25%) 538,79Lei

Scaun Pivotant + Baza Matrix F25 System Swivel Seat -11%
Exclusiv online!

Scaun Pivotant + Baza Matrix F25 System Swivel Seat

gmb117
Livrare 7-14 zile

719,96Lei(-11%) 642,49Lei

Scaun Preston Inception Feeder Chair -12%
Exclusiv online!

Scaun Preston Inception Feeder Chair

p0120005
Livrare 7-14 zile

1.034,96Lei(-12%) 905,85Lei

Secțiunea Fox Horizon X4 Stalker Butt -18%
Exclusiv online!

Secțiunea Fox Horizon X4 Stalker Butt

crd323
Livrare 7-14 zile

187,80Lei(-18%) 154,69Lei

Set 4 Swingere 4 Culori Fl Cu Lumina Si Tensionare -8%
Exclusiv online!

Set 4 Swingere 4 Culori Fl Cu Lumina Si Tensionare

fl-jy-sw-27t
Livrare 24-48 ore

229,00Lei(-8%) 210,36Lei

Set Avertizoare Fl Feeder 3 Plus Statie -8%

Set Avertizoare Fl Feeder 3 Plus Statie

fl-ju-68-3
Livrare imediată!

419,89Lei(-8%) 386,27Lei

Set Avertizoare Prologic Fulcrum Pro Bite 3 Plus Statie Multicolor -29%

Set Avertizoare Prologic Fulcrum Pro Bite 3 Plus Statie Multicolor

a.pro.65013
Livrare imediată!

1.635,70Lei(-29%) 1.165,23Lei

Set Avertizoare Wireless Cu Statie Prologic Custom Smx Mkii Wts 4 Plus 1 -29%

Set Avertizoare Wireless Cu Statie Prologic Custom Smx Mkii Wts 4 Plus 1

a.pro.64136
Livrare imediată!

1.536,62Lei(-29%) 1.094,71Lei

Set Cadou Nash Christmas Mystery Box -49%

Set Cadou Nash Christmas Mystery Box

t7004
Livrare imediată!

490,00Lei(-49%) 250,12Lei

Set Croseta + Stoppere One More Cast Tweakers Wormurai Sprig Stop Kit -14%
Exclusiv online!

Set Croseta + Stoppere One More Cast Tweakers Wormurai Sprig Stop Kit

omcwmi
Livrare 48-72ore

35,50Lei(-14%) 30,40Lei

Set Fl 4 Hangere Iluminate Jy-sw-10b -7%
Exclusiv online!

Set Fl 4 Hangere Iluminate Jy-sw-10b

fl-jy-sw-10b
Livrare 24-48 ore

109,90Lei(-7%) 102,58Lei

Set Fl Hangere Pe Lant 4buc Jy-sw-25t -7%

Set Fl Hangere Pe Lant 4buc Jy-sw-25t

fl-jy-sw-25t
Livrare imediată!

142,90Lei(-7%) 133,08Lei

Set Fl Swingere 4buc Jy-sw-26t -7%

Set Fl Swingere 4buc Jy-sw-26t

fl-jy-sw-26t
Livrare imediată!

124,90Lei(-7%) 115,80Lei

Set Jaxon 3 Bacuri Eva 4l 2.5l 1l -21%

Set Jaxon 3 Bacuri Eva 4l 2.5l 1l

re-101
Livrare imediată!

215,00Lei(-21%) 169,69Lei

Set Manere Korum S23 Arm Rest Kit Pentru Scaun S23 Standard Accesory Chair -49%
Exclusiv online!

Set Manere Korum S23 Arm Rest Kit Pentru Scaun S23 Standard Accesory Chair

k0300026
Livrare 7-14 zile

188,97Lei(-49%) 97,07Lei

Set Picheti Shakespeare Standard Bank Stick Selection, 6buc/set -31%

Set Picheti Shakespeare Standard Bank Stick Selection, 6buc/set

1155127
Livrare imediată!

123,17Lei(-31%) 85,29Lei

Set Prologic Farfurie Plus Tacamuri Black Fire -28%

Set Prologic Farfurie Plus Tacamuri Black Fire

svs72739
Livrare imediată!

177,66Lei(-28%) 127,07Lei

Afişare 2201 - 2220 din 9304 (466 pagini)
Queries: 6, Total time: 732.216 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '8d6df7b0081d53a6129d15f280'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (333.078)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (398.640)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 2200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.166)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ONE MORE CAST"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37