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

Nieuwe producten Schneider

1 - 4 van 4
Sorteer op:
SCHNEIDER amarone wijdte C - 118_426
object(stdClass)#168 (46) { ["id"]=> string(2) "24" ["children"]=> string(1) "0" ["photoid"]=> string(2) "36" ["serial_number"]=> string(0) "" ["article_number"]=> string(7) "118_426" ["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(36) "SCHNEIDER amarone wijdte C - 118_426" ["keyname"]=> string(16) "amarone-wijdte-c" ["label"]=> string(0) "" ["path"]=> string(27) "/dames/instappers-trotteurs" ["manufacturer_id"]=> string(4) "1330" ["manufacturer_name"]=> string(10) "Schneider " ["manufacturer_keyname"]=> string(9) "schneider" ["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" }
Schneider SCHNEIDER amarone wijdte C - 118_426
€ 229,95
SCHNEIDER wijdte C - 233_437
object(stdClass)#163 (46) { ["id"]=> string(2) "42" ["children"]=> string(1) "0" ["photoid"]=> string(2) "62" ["serial_number"]=> string(0) "" ["article_number"]=> string(7) "233_437" ["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(28) "SCHNEIDER wijdte C - 233_437" ["keyname"]=> string(8) "wijdte-c" ["label"]=> string(0) "" ["path"]=> string(31) "/dames/klittenband-bandschoenen" ["manufacturer_id"]=> string(4) "1330" ["manufacturer_name"]=> string(10) "Schneider " ["manufacturer_keyname"]=> string(9) "schneider" ["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" }
Schneider SCHNEIDER wijdte C - 233_437
€ 229,95
SCHNEIDER wijdte C - 172_426
object(stdClass)#168 (46) { ["id"]=> string(2) "26" ["children"]=> string(1) "0" ["photoid"]=> string(2) "40" ["serial_number"]=> string(0) "" ["article_number"]=> string(7) "172_426" ["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(28) "SCHNEIDER wijdte C - 172_426" ["keyname"]=> string(8) "wijdte-c" ["label"]=> string(0) "" ["path"]=> string(27) "/dames/instappers-trotteurs" ["manufacturer_id"]=> string(4) "1330" ["manufacturer_name"]=> string(10) "Schneider " ["manufacturer_keyname"]=> string(9) "schneider" ["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" }
Schneider SCHNEIDER wijdte C - 172_426
€ 229,95
SCHNEIDER wijdte C - 174_815
object(stdClass)#163 (46) { ["id"]=> string(2) "39" ["children"]=> string(1) "0" ["photoid"]=> string(2) "58" ["serial_number"]=> string(0) "" ["article_number"]=> string(7) "174_815" ["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(28) "SCHNEIDER wijdte C - 174_815" ["keyname"]=> string(8) "wijdte-c" ["label"]=> string(0) "" ["path"]=> string(27) "/dames/instappers-trotteurs" ["manufacturer_id"]=> string(4) "1330" ["manufacturer_name"]=> string(10) "Schneider " ["manufacturer_keyname"]=> string(9) "schneider" ["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" }
Schneider SCHNEIDER wijdte C - 174_815
€ 229,95