SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'home' AND categoryid = 0 AND manufacturerid = 0 LIMIT 1

Welkom bij Pijnenburg Schoenen

Pijnenburg Schoenen is het vertrouwde adres voor dames-, heren en kinderschoenen en gespecialiseerd in wijdtematen. Voor kwaliteit, zorgvuldigheid en service bent u bij Pijnenburg Schoenen aan het juiste adres.

Xsensible
XSENSIBLE Wijdte GX Rainbow - 33011.3.915_GX Rainbow
object(stdClass)#178 (46) { ["id"]=> string(4) "5185" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5975" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "33011.3.915_GX Rainbow" ["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(52) "XSENSIBLE Wijdte GX Rainbow - 33011.3.915_GX Rainbow" ["keyname"]=> string(17) "wijdte-gx-rainbow" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(2) "81" ["manufacturer_name"]=> string(9) "XSensible" ["manufacturer_keyname"]=> string(9) "xsensible" ["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" }
XSensibleXSENSIBLE Wijdte GX Rainbow - 33011.3.915_GX Rainbow
€ 269,95
XSENSIBLE Wijdte GX Rainbow - 33011.3.915_GX Rainbow
object(stdClass)#182 (46) { ["id"]=> string(4) "5185" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5975" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "33011.3.915_GX Rainbow" ["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(52) "XSENSIBLE Wijdte GX Rainbow - 33011.3.915_GX Rainbow" ["keyname"]=> string(17) "wijdte-gx-rainbow" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(2) "81" ["manufacturer_name"]=> string(9) "XSensible" ["manufacturer_keyname"]=> string(9) "xsensible" ["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" }
XSensibleXSENSIBLE Wijdte GX Rainbow - 33011.3.915_GX Rainbow
€ 269,95
XSENSIBLE Grenoble HX - 30215.3.219  HX Grenoble
object(stdClass)#184 (46) { ["id"]=> string(4) "4330" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5302" ["serial_number"]=> string(0) "" ["article_number"]=> string(24) "30215.3.219 HX Grenoble" ["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(48) "XSENSIBLE Grenoble HX - 30215.3.219 HX Grenoble" ["keyname"]=> string(11) "grenoble-hx" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(2) "81" ["manufacturer_name"]=> string(9) "XSensible" ["manufacturer_keyname"]=> string(9) "xsensible" ["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" }
XSensibleXSENSIBLE Grenoble HX - 30215.3.219 HX Grenoble
€ 229,95
XSENSIBLE Wijdte GX Golden gate - 33000.3.003_GX_Golden Gate
object(stdClass)#186 (46) { ["id"]=> string(4) "5104" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5919" ["serial_number"]=> string(0) "" ["article_number"]=> string(26) "33000.3.003_GX_Golden Gate" ["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(60) "XSENSIBLE Wijdte GX Golden gate - 33000.3.003_GX_Golden Gate" ["keyname"]=> string(21) "wijdte-gx-golden-gate" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(2) "81" ["manufacturer_name"]=> string(9) "XSensible" ["manufacturer_keyname"]=> string(9) "xsensible" ["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" }
XSensibleXSENSIBLE Wijdte GX Golden gate - 33000.3.003_GX_Golden Gate
€ 249,95
XSENSIBLE LIMA Wijdte HX - 30204_2_220_ HX_LIMA
object(stdClass)#188 (46) { ["id"]=> string(4) "5191" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5979" ["serial_number"]=> string(0) "" ["article_number"]=> string(20) "30204_2_220_ HX_LIMA" ["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(47) "XSENSIBLE LIMA Wijdte HX - 30204_2_220_ HX_LIMA" ["keyname"]=> string(14) "lima-wijdte-hx" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(2) "81" ["manufacturer_name"]=> string(9) "XSensible" ["manufacturer_keyname"]=> string(9) "xsensible" ["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" }
XSensibleXSENSIBLE LIMA Wijdte HX - 30204_2_220_ HX_LIMA
€ 239,95