SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'new' AND categoryid = 0 AND manufacturerid = 1349 LIMIT 1
Filter

Nieuwe producten Gijs

1 - 8 van 8
Sorteer op:
GIJS Go men - 2054_208_9956 wijdte K
object(stdClass)#167 (46) { ["id"]=> string(4) "5634" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6491" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2054_208_9956 wijdte K" ["price"]=> string(6) "239.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(36) "GIJS Go men - 2054_208_9956 wijdte K" ["keyname"]=> string(6) "go-men" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "239.95" }
GijsGIJS Go men - 2054_208_9956 wijdte K
€ 239,95
GIJS GO men - 2112_205_0308 wijdte H
object(stdClass)#162 (46) { ["id"]=> string(4) "5641" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6495" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2112_205_0308 wijdte H" ["price"]=> string(6) "249.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(36) "GIJS GO men - 2112_205_0308 wijdte H" ["keyname"]=> string(6) "go-men" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "249.95" }
GijsGIJS GO men - 2112_205_0308 wijdte H
€ 249,95
GIJS D blauw - 2054_208_0241 wijdte K
object(stdClass)#167 (46) { ["id"]=> string(4) "3956" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5171" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2054_208_0241 wijdte K" ["price"]=> string(6) "239.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(37) "GIJS D blauw - 2054_208_0241 wijdte K" ["keyname"]=> string(7) "d-blauw" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "239.95" }
GijsGIJS D blauw - 2054_208_0241 wijdte K
€ 239,95
GIJS Wijdte H - 2190_905_0396 wijdte H
object(stdClass)#162 (46) { ["id"]=> string(4) "3884" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5103" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2190_905_0396 wijdte H" ["price"]=> string(6) "269.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(38) "GIJS Wijdte H - 2190_905_0396 wijdte H" ["keyname"]=> string(8) "wijdte-h" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "269.95" }
GijsGIJS Wijdte H - 2190_905_0396 wijdte H
€ 269,95
GIJS Wijdte H - 2079_205_9066 wijdte H
object(stdClass)#167 (46) { ["id"]=> string(4) "3880" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5099" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2079_205_9066 wijdte H" ["price"]=> string(6) "229.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(38) "GIJS Wijdte H - 2079_205_9066 wijdte H" ["keyname"]=> string(8) "wijdte-h" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "229.95" }
GijsGIJS Wijdte H - 2079_205_9066 wijdte H
€ 229,95
GIJS Karel - 2061_205_8038 wijdte H
object(stdClass)#162 (46) { ["id"]=> string(4) "3190" ["children"]=> string(1) "0" ["photoid"]=> string(4) "4410" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2061_205_8038 wijdte H" ["price"]=> string(6) "239.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(35) "GIJS Karel - 2061_205_8038 wijdte H" ["keyname"]=> string(5) "karel" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "239.95" }
GijsGIJS Karel - 2061_205_8038 wijdte H
€ 239,95
GIJS Wijdte H - 2085_205_8923 wijdte H
object(stdClass)#167 (46) { ["id"]=> string(4) "2660" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3824" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2085_205_8923 wijdte H" ["price"]=> string(6) "219.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(38) "GIJS Wijdte H - 2085_205_8923 wijdte H" ["keyname"]=> string(8) "wijdte-h" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "219.95" }
GijsGIJS Wijdte H - 2085_205_8923 wijdte H
€ 219,95
GIJS Piuma lux d blauw - 2085_205_9183 wijdte H
object(stdClass)#162 (46) { ["id"]=> string(4) "2191" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3253" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "2085_205_9183 wijdte H" ["price"]=> string(6) "219.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(47) "GIJS Piuma lux d blauw - 2085_205_9183 wijdte H" ["keyname"]=> string(17) "piuma-lux-d-blauw" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1349" ["manufacturer_name"]=> string(4) "Gijs" ["manufacturer_keyname"]=> string(4) "gijs" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "219.95" }
GijsGIJS Piuma lux d blauw - 2085_205_9183 wijdte H
€ 219,95