$sql=SELECT g.goods_id, g.goods_name, g.goods_name_long, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, g.z_price, g.goods_sn, mp.user_price, g.shop_price, g.z_price, g.goods_type, g.promote_price, c.sales_start_date, c.goods_in_parent, c.parent_subst, g.sales_start, g.sales_days_on, g.sales_days_off, g.is_promote, g.sales_percent, g.sales_price, g.sales_good, g.promote_start_date, g.promote_end_date, g.goods_brief, gg.name as goods_thumb, g.goods_number, g.goods_url, '' as ceo_goods_descr, '' as ceo_goods_label, g.short_description, g.complect_price, g.cat_id, if(g.goods_number > 0, 1, 0) as in_stock, if(g.sales_price>0, g.sales_price, IFNULL(mp.user_price, g.shop_price * '1')) as sort_price, g.hide_search FROM `alfadb`.`ecs_goods` AS g LEFT JOIN `alfadb`.`ecs_goods_img` AS gg on gg.goods_id = g.goods_id and gg.default_image = 1 LEFT JOIN `alfadb`.`ecs_category` AS c ON g.cat_id = c.cat_id LEFT JOIN `alfadb`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id in (2) OR g.goods_id IN ('') ) AND g.goods_id in (24,28,38,48,59,78,83,88,98,99,100,104,105,106,113,114,115,119,120,121,128,129,130,134,136,143,144,145,149,151,158,159,160,164,165,166,173,174,175,179,181,188,189,190,194,195,196,203,204,205,209,210,211,226,227,228,229,230,231,232,241,242,243,245,257,258,266,267,278,279,299,300,308,309,320,321,329,330,341,342,350,351,356,357,358,359,360,361,362,363,364,365,374,385,386,387,388,389,390,391,392,393,394,402,425,426,427,428,441,442,443,444,451,452,465,466,467,468,498,499,500,501,509,526,527,528,529,568,569,570,571,572,573,574,575,576,577,592,593,594,595,608,609,610,611,617,629,630,631,632,633,634,635,636,637,638,653,654,655,656,669,670,671,672,685,686,687,688,698,761,762,773,775,777,778,779,781,783,793,794,795,801,802,803,804,805,806,807,808,809,810,825,826,827,828,829,835,836,837,838,839,840,841,842,843,844,849,850,851,852,853,859,860,861,862,863,864,865,866,867,868,870,871,872,873,874,880,881,882,883,884,885,886,887,888,889,892,893,894,895,896,902,903,904,905,906,907,908,909,910,911,914,915,916,917,923,924,925,926,927,928,929,930,931,932,955,956,957,986,995,1002,1011,1014,1016,1025,1026,1027,2519,2541,2563,2596,2618,2640,5002,5226,5230,5246,5250,5323,5324,5357,5358,5397,5398,5417,5418,5441,5442,5465,5466,5509,5510,5529,5530,5556,5557,5586,5587,5609,5610,5645,5646,5692,5693,5912,5913,5988,5989,5997,6001,6005,6255,6256,6270,6271,6278,6359,6366,6373,6391,6397,6403,6441,6455,6479,6485,6487,6495,6501,7005,7009,7013,7020,7024,7025,7030,7031,7039,7040,7047,7074,7075,7080,7081,7086,7087,7093,9012,9023,9035,9036,9037,9050,9051,9052,9065,9066,9067,9080,9081,9082,9095,9096,9097,9114,9115,9116,9134,9135,9136,9150,9151,9152,9165,9166,9167,9174,9179,9184,9195,9196,9197,9210,9211,9212,9225,9226,9227,9240,9241,9242,15021,15022,15023,15024,15025,15035,15036,15039,15040,15041,15078,15079,15146,15148,15151,15153,15171,15172,15173,15174,15191,15192,15193,15194,16008,16010,16039,16042,16065,16067,16071,16073,16083,16084,16093,16094,16103,16104,16120,16122,16126,16128,16138,16139,16148,16149,16158,16159,17010,17018,17019,17028,17029,17038,17039,17045,18016,18026,18027,18034,18038,18041,18045,18048,18097,18100,19013,19014,19028,19029,19043,19044,19058,19059,19073,19074,19079,19093,19094,19108,19109,19123,19124,19138,19139,19153,19154,19159,19173,19174,19188,19189,19203,19204,19218,19219,19233,19234,19239,19246,19247,19256,19257,19266,19267,19276,19277,19289,19290,19291,37030,37031,37032,37033,37034,37035) ORDER BY in_stock desc, sort_price asc Серые двери со стеклом – купить недорого

Серые двери со стеклом

407
РаспродажаСкидки
В наличии
Фильтры
Показать ещё 48 из 359
1
2
3

Межкомнатные серые двери со стеклом в Москве и Санкт-Петербурге по цене от 4430 до 43600 рублей за полотно. В каталоге 407 товаров на выбор: по материалам, стилю, назначению, размерам, покрытию, конструкции и моделям. Купить двери можно в комплекте с коробкой, наличниками и фурнитурой недорого, а также заказать установку распашных, раздвижных и двустворчатых дверей. Оформить покупку можно в один клик онлайн, в наших магазинах или по телефону. Доставляем со склада до дома по Московской и Ленинградской областям. Гарантия на двери 3 года!

Свяжитесь с намиПоможем с выбором и рассчитаем заказ бесплатно
Выберите город с нашими салонами: