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









Nieuwe producten
201 - 209 van 209
Sorteer op:

object(stdClass)#216 (46) {
["id"]=>
string(3) "128"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "189"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(7) "Picador"
["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(37) "AMBIORIX Picador jeans grey - Picador"
["keyname"]=>
string(18) "picador-jeans-grey"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(1) "5"
["manufacturer_name"]=>
string(8) "AMBIORIX"
["manufacturer_keyname"]=>
string(8) "ambiorix"
["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"
}
AMBIORIXAMBIORIX Picador jeans grey - Picador€ 269,95

object(stdClass)#211 (46) {
["id"]=>
string(3) "119"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "176"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(33) "Pierson_Sup_New box Fumo Wijdte K"
["price"]=>
string(6) "259.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(52) "AMBIORIX Pierson - Pierson_Sup_New box Fumo Wijdte K"
["keyname"]=>
string(7) "pierson"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(1) "5"
["manufacturer_name"]=>
string(8) "AMBIORIX"
["manufacturer_keyname"]=>
string(8) "ambiorix"
["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) "259.95"
}
AMBIORIXAMBIORIX Pierson - Pierson_Sup_New box Fumo Wijdte K€ 259,95

object(stdClass)#216 (46) {
["id"]=>
string(1) "1"
["children"]=>
string(1) "0"
["photoid"]=>
string(1) "1"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(5) "20598"
["price"]=>
string(5) "89.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) "TIMBERLAND zz K band - 20598"
["keyname"]=>
string(9) "zz-k-band"
["label"]=>
string(0) ""
["path"]=>
string(22) "/heren/muilen-slippers"
["manufacturer_id"]=>
string(1) "1"
["manufacturer_name"]=>
string(10) "Timberland"
["manufacturer_keyname"]=>
string(10) "timberland"
["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(5) "89.95"
}
TimberlandTIMBERLAND zz K band - 20598€ 89,95

object(stdClass)#211 (46) {
["id"]=>
string(3) "150"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "227"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(14) "NORMAN_New Box"
["price"]=>
string(6) "259.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(39) "AMBIORIX New box black - NORMAN_New Box"
["keyname"]=>
string(13) "new-box-black"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(1) "5"
["manufacturer_name"]=>
string(8) "AMBIORIX"
["manufacturer_keyname"]=>
string(8) "ambiorix"
["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) "259.95"
}
AMBIORIXAMBIORIX New box black - NORMAN_New Box€ 259,95

object(stdClass)#216 (46) {
["id"]=>
string(2) "37"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "54"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(10) "8057-01-61"
["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(32) "KOPS KOPS VARESE 9+ - 8057-01-61"
["keyname"]=>
string(14) "kops-varese-9+"
["label"]=>
string(0) ""
["path"]=>
string(22) "/heren/boots-ongevoerd"
["manufacturer_id"]=>
string(2) "38"
["manufacturer_name"]=>
string(4) "Kops"
["manufacturer_keyname"]=>
string(4) "kops"
["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"
}
KopsKOPS KOPS VARESE 9+ - 8057-01-61€ 249,95

object(stdClass)#211 (46) {
["id"]=>
string(3) "146"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "222"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(6) "K73260"
["price"]=>
string(6) "134.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(15) "ROCKPORT K73260"
["keyname"]=>
string(6) "k73260"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(1) "4"
["manufacturer_name"]=>
string(8) "Rockport"
["manufacturer_keyname"]=>
string(8) "rockport"
["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) "134.95"
}
RockportROCKPORT K73260€ 134,95

object(stdClass)#216 (46) {
["id"]=>
string(2) "42"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "62"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(12) "7056-F126.09"
["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(17) "KOPS 7056-F126.09"
["keyname"]=>
string(11) "7056-f12609"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "38"
["manufacturer_name"]=>
string(4) "Kops"
["manufacturer_keyname"]=>
string(4) "kops"
["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"
}
KopsKOPS 7056-F126.09€ 229,95

object(stdClass)#211 (46) {
["id"]=>
string(2) "44"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "63"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(10) "7056-04.53"
["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(26) "KOPS Wijdte H - 7056-04.53"
["keyname"]=>
string(8) "wijdte-h"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "38"
["manufacturer_name"]=>
string(4) "Kops"
["manufacturer_keyname"]=>
string(4) "kops"
["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"
}
KopsKOPS Wijdte H - 7056-04.53€ 249,95

object(stdClass)#216 (46) {
["id"]=>
string(3) "125"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "185"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(5) "KLASS"
["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(14) "AMBIORIX KLASS"
["keyname"]=>
string(5) "klass"
["label"]=>
string(0) ""
["path"]=>
string(23) "/heren/klittenband-gesp"
["manufacturer_id"]=>
string(1) "5"
["manufacturer_name"]=>
string(8) "AMBIORIX"
["manufacturer_keyname"]=>
string(8) "ambiorix"
["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"
}
AMBIORIXAMBIORIX KLASS€ 249,95