SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'new' AND categoryid = 0 AND manufacturerid = 79 LIMIT 1
Filter
![BERKELMANS Sotsji - Q110_Sotsji_dark brown](upload/products/167/1773/sotsji.jpg)
![BERKELMANS 18N__BLACK Combi](upload/products/167/1255/18n__black-combi.jpg)
![BERKELMANS 22N_navy serra print](upload/products/167/967/22n_navy-serra-print.jpg)
![BERKELMANS 12N D.Brown Gravado](upload/products/167/807/12n-dbrown-gravado.jpg)
![BERKELMANS Setter croco - 15_N_Setter Croco](upload/products/167/811/setter-croco.jpg)
![BERKELMANS 18N__BLACK](upload/products/167/815/18n__black.jpg)
![BERKELMANS brown wash - 1003_Brown](upload/products/167/455/brown-wash.jpg)
Kleur
Maat
Prijs
t/m
Nieuwe producten BERKELMANS
1 - 7 van 7
Sorteer op:
![BERKELMANS Sotsji - Q110_Sotsji_dark brown](upload/products/167/1773/sotsji.jpg)
object(stdClass)#152 (46) {
["id"]=>
string(4) "1126"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "1773"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(22) "Q110_Sotsji_dark brown"
["price"]=>
string(6) "129.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(42) "BERKELMANS Sotsji - Q110_Sotsji_dark brown"
["keyname"]=>
string(6) "sotsji"
["label"]=>
string(0) ""
["path"]=>
string(22) "/heren/boots-ongevoerd"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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) "129.95"
}
BERKELMANSBERKELMANS Sotsji - Q110_Sotsji_dark brown€ 129,95
![BERKELMANS 18N__BLACK Combi](upload/products/167/1255/18n__black-combi.jpg)
object(stdClass)#147 (46) {
["id"]=>
string(3) "781"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "1255"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(16) "18N__BLACK Combi"
["price"]=>
string(6) "119.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(27) "BERKELMANS 18N__BLACK Combi"
["keyname"]=>
string(16) "18n__black-combi"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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) "119.95"
}
BERKELMANSBERKELMANS 18N__BLACK Combi€ 119,95
![BERKELMANS 22N_navy serra print](upload/products/167/967/22n_navy-serra-print.jpg)
object(stdClass)#152 (46) {
["id"]=>
string(3) "602"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "967"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(20) "22N_navy serra print"
["price"]=>
string(6) "119.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(31) "BERKELMANS 22N_navy serra print"
["keyname"]=>
string(20) "22n_navy-serra-print"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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) "119.95"
}
BERKELMANSBERKELMANS 22N_navy serra print€ 119,95
![BERKELMANS 12N D.Brown Gravado](upload/products/167/807/12n-dbrown-gravado.jpg)
object(stdClass)#147 (46) {
["id"]=>
string(3) "507"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "807"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(19) "12N D.Brown Gravado"
["price"]=>
string(6) "124.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(30) "BERKELMANS 12N D.Brown Gravado"
["keyname"]=>
string(18) "12n-dbrown-gravado"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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) "124.95"
}
BERKELMANSBERKELMANS 12N D.Brown Gravado€ 124,95
![BERKELMANS Setter croco - 15_N_Setter Croco](upload/products/167/811/setter-croco.jpg)
object(stdClass)#152 (46) {
["id"]=>
string(3) "510"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "811"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(17) "15_N_Setter Croco"
["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(43) "BERKELMANS Setter croco - 15_N_Setter Croco"
["keyname"]=>
string(12) "setter-croco"
["label"]=>
string(0) ""
["path"]=>
string(22) "/heren/boots-ongevoerd"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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"
}
BERKELMANSBERKELMANS Setter croco - 15_N_Setter Croco€ 134,95
![BERKELMANS 18N__BLACK](upload/products/167/815/18n__black.jpg)
object(stdClass)#147 (46) {
["id"]=>
string(3) "512"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "815"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(10) "18N__BLACK"
["price"]=>
string(6) "119.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(21) "BERKELMANS 18N__BLACK"
["keyname"]=>
string(10) "18n__black"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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) "119.95"
}
BERKELMANSBERKELMANS 18N__BLACK€ 119,95
![BERKELMANS brown wash - 1003_Brown](upload/products/167/455/brown-wash.jpg)
object(stdClass)#152 (46) {
["id"]=>
string(3) "300"
["children"]=>
string(1) "0"
["photoid"]=>
string(3) "455"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(10) "1003_Brown"
["price"]=>
string(6) "124.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(34) "BERKELMANS brown wash - 1003_Brown"
["keyname"]=>
string(10) "brown-wash"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "79"
["manufacturer_name"]=>
string(10) "BERKELMANS"
["manufacturer_keyname"]=>
string(10) "berkelmans"
["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) "124.95"
}
BERKELMANSBERKELMANS brown wash - 1003_Brown€ 124,95