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.

AQA
AQA SHOES Valencia - A8536_A11B56
object(stdClass)#168 (46) { ["id"]=> string(4) "4232" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5336" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8536_A11B56" ["price"]=> string(6) "139.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(33) "AQA SHOES Valencia - A8536_A11B56" ["keyname"]=> string(8) "valencia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "139.95" }
AQA SHOESAQA SHOES Valencia - A8536_A11B56
€ 139,95
AQA SHOES Valencia - A8537_A75B80
object(stdClass)#173 (46) { ["id"]=> string(4) "4238" ["children"]=> string(1) "0" ["photoid"]=> string(4) "5340" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8537_A75B80" ["price"]=> string(6) "149.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(33) "AQA SHOES Valencia - A8537_A75B80" ["keyname"]=> string(8) "valencia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "149.95" }
AQA SHOESAQA SHOES Valencia - A8537_A75B80
€ 149,95
AQA SHOES Road Elmwood - A8465_A85_Road Elmwood
object(stdClass)#175 (46) { ["id"]=> string(4) "3741" ["children"]=> string(1) "0" ["photoid"]=> string(4) "4914" ["serial_number"]=> string(0) "" ["article_number"]=> string(22) "A8465_A85_Road Elmwood" ["price"]=> string(6) "139.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) "AQA SHOES Road Elmwood - A8465_A85_Road Elmwood" ["keyname"]=> string(12) "road-elmwood" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "139.95" }
AQA SHOESAQA SHOES Road Elmwood - A8465_A85_Road Elmwood
€ 139,95
AQA SHOES Road nero - A8663_B16_Western
object(stdClass)#177 (46) { ["id"]=> string(4) "5306" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6180" ["serial_number"]=> string(0) "" ["article_number"]=> string(17) "A8663_B16_Western" ["price"]=> string(6) "159.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) "AQA SHOES Road nero - A8663_B16_Western" ["keyname"]=> string(9) "road-nero" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "159.95" }
AQA SHOESAQA SHOES Road nero - A8663_B16_Western
€ 159,95
AQA SHOES Velvet Black - A8486_A26_Western
object(stdClass)#179 (46) { ["id"]=> string(4) "3689" ["children"]=> string(1) "0" ["photoid"]=> string(4) "4862" ["serial_number"]=> string(0) "" ["article_number"]=> string(17) "A8486_A26_Western" ["price"]=> string(6) "159.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) "AQA SHOES Velvet Black - A8486_A26_Western" ["keyname"]=> string(12) "velvet-black" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "159.95" }
AQA SHOESAQA SHOES Velvet Black - A8486_A26_Western
€ 159,95
Greve
Greve Deventer H - 5550.16_3286_Deventer wijdte H
object(stdClass)#172 (46) { ["id"]=> string(4) "5338" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6204" ["serial_number"]=> string(0) "" ["article_number"]=> string(30) "5550.16_3286_Deventer 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(49) "Greve Deventer H - 5550.16_3286_Deventer wijdte H" ["keyname"]=> string(10) "deventer-h" ["label"]=> string(0) "" ["path"]=> string(22) "/heren/boots-ongevoerd" ["manufacturer_id"]=> string(4) "1998" ["manufacturer_name"]=> string(5) "Greve" ["manufacturer_keyname"]=> string(5) "greve" ["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" }
GreveGreve Deventer H - 5550.16_3286_Deventer wijdte H
€ 239,95
Greve Walker K - 3280.08_3335_Walker wijdte K
object(stdClass)#184 (46) { ["id"]=> string(4) "5331" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6200" ["serial_number"]=> string(0) "" ["article_number"]=> string(28) "3280.08_3335_Walker 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(45) "Greve Walker K - 3280.08_3335_Walker wijdte K" ["keyname"]=> string(8) "walker-k" ["label"]=> string(0) "" ["path"]=> string(15) "/heren/molieres" ["manufacturer_id"]=> string(4) "1998" ["manufacturer_name"]=> string(5) "Greve" ["manufacturer_keyname"]=> string(5) "greve" ["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" }
GreveGreve Walker K - 3280.08_3335_Walker wijdte K
€ 239,95
Greve Deventer K - 5570.01_3306_Deventer wijdte K
object(stdClass)#186 (46) { ["id"]=> string(4) "5346" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6208" ["serial_number"]=> string(0) "" ["article_number"]=> string(30) "5570.01_3306_Deventer 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(49) "Greve Deventer K - 5570.01_3306_Deventer wijdte K" ["keyname"]=> string(10) "deventer-k" ["label"]=> string(0) "" ["path"]=> string(22) "/heren/boots-ongevoerd" ["manufacturer_id"]=> string(4) "1998" ["manufacturer_name"]=> string(5) "Greve" ["manufacturer_keyname"]=> string(5) "greve" ["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" }
GreveGreve Deventer K - 5570.01_3306_Deventer wijdte K
€ 239,95