Dzięki! Jest to bardzo pomocne!

Inwestycyjna Łódź-Widzew, blisko zjazdu z A1

Działki Łódź, łódzkie, Polska
660 000 PLN brutto 536 585 PLN netto  
660 000 PLN brutto 536 585 PLN netto

Andrii

Profil
  • 0

Pochodzenie oferty

Region łódzkie
Miasto Łódź

Opis

Działka inwestycyjna, blisko zjazdu z A1, teren przemysłowo usługowy, powierzchnia 5500 m2, kształt zbliżony do kwadratu, cena do negocjacji. Pilne.

Zgłoś jako...
Drukuj

Podobne ogłoszenia

Działka, 40 557 m², Konstantynów Łódzki
5 400 000 zł

Działka, 40 557 m², Konstantynów Łódzki

40557 m2133zł/m2
Działka budowlana/inwestycyjna/przemysłowa
11 610 000 zł

Działka budowlana/inwestycyjna/przemysłowa

54000 m2215zł/m2
Działka inwestycyjna okolice M1 - 2,5 ha
7 649 100 zł

Działka inwestycyjna okolice M1 - 2,5 ha

25497 m2300zł/m2
  Database queries (Total queries: 81 - Total queries time: 0.044974327087402)  
0.0005500316619873 SELECT *
FROM (oc_t_preference)
0.00028705596923828 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0014801025390625 SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT JOIN oc_t_item_location l ON l.fk_i_item_id = i.pk_i_id
LEFT JOIN oc_t_item_stats s ON i.pk_i_id = s.fk_i_item_id
WHERE i.pk_i_id = '1125'
GROUP BY s.fk_i_item_id
0.00017619132995605 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '1125'
0.001352071762085 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (1125, '2025-09-03 18:05:54',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00064897537231445 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '33'
0.00052380561828613 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00026679039001465 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_name != ''
AND a.b_enabled = 1
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00025105476379395 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1125
0.0002739429473877 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0006859302520752 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE pk_i_id = '391081'
0.00032711029052734 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781818'
0.00043296813964844 SELECT *
FROM (oc_t_region)
WHERE s_name = 'łódzkie'
LIMIT 1
0.00042891502380371 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Łódź'
LIMIT 1
0.0002138614654541 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_slug = 'dzialki'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.0001370906829834 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Łódź'
LIMIT 1
0.00048995018005371 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.00013494491577148 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00013995170593262 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.0001378059387207 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00020813941955566 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00098609924316406 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 6
ORDER BY rand_ind asc
0.00015997886657715 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00037503242492676 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0011129379272461 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00017690658569336 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 238
AND s_plugin_name = 'custom_attributes'
0.00011014938354492 SELECT *
FROM (oc_t_item_custom_attr_groups)
JOIN oc_t_item_custom_attr_categories ON fk_i_group_id = pk_i_id
WHERE fk_i_category_id = 238
ORDER BY oc_t_item_custom_attr_groups.order ASC
0.00015616416931152 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00016403198242188 SELECT *
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id NOT IN ('3', '4', '5', '61', '120', '202', '8', '9', '10', '11', '12', '13', '21', '99', '14', '15', '17', '18', '20', '28', '29', '30', '31', '32', '33', '34', '35', '83', '84', '123', '125', '129', '184', '185', '186', '188', '192', '217', '219', '221', '222', '223', '36', '37', '38', '39', '41', '42', '43', '44', '45', '46', '47', '50', '51', '52', '53', '91', '98', '124', '130', '216', '218', '57', '58', '59', '60', '85', '121', '122', '147', '62', '63', '64', '65', '66', '67', '126', '70', '71', '78', '79', '80', '81', '82', '93', '94', '95', '97', '77', '86', '87', '89', '90', '159', '160', '161', '105', '107', '115', '131', '165', '109', '110', '112', '113', '114', '162', '206', '233', '116', '117', '118', '119', '195', '196', '197', '200', '128', '133', '134', '136', '137', '138', '139', '140', '141', '142', '143', '144', '151', '152', '153', '154', '155', '156', '157', '158', '163', '164', '235', '236', '237', '238', '171', '173', '174', '175', '203', '205', '224', '178', '181', '176', '187', '193', '194', '198', '199', '234', '207', '208', '209', '210', '211', '212', '213', '214', '215', '225', '226', '227', '228', '229', '230', '231')
ORDER BY i_order ASC
0.00014400482177734 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '22'
ORDER BY i_order ASC
0.00057601928710938 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '171'
LIMIT 1
0.00040102005004883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '173'
LIMIT 1
0.00030398368835449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '174'
LIMIT 1
0.00073599815368652 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '205'
LIMIT 1
0.00050616264343262 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '175'
LIMIT 1
0.0004580020904541 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '203'
LIMIT 1
0.00042104721069336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '224'
LIMIT 1
0.00023412704467773 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '31'
ORDER BY i_order ASC
0.0005488395690918 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '225'
LIMIT 1
0.00056791305541992 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '226'
LIMIT 1
0.0004889965057373 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '227'
LIMIT 1
0.00048995018005371 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '228'
LIMIT 1
0.00048303604125977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '229'
LIMIT 1
0.00046586990356445 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '230'
LIMIT 1
0.00046896934509277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '231'
LIMIT 1
0.0001838207244873 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '23'
ORDER BY i_order ASC
0.00066685676574707 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '178'
LIMIT 1
0.00053000450134277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1125
AND fk_i_field_id = '181'
LIMIT 1
0.0026979446411133 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2025-09-03 18:05:54') AND oc_t_item.pk_i_id < 1125
AND oc_t_item.fk_i_category_id IN (238)
AND ( oc_t_item_location.s_region LIKE 'łódzkie' )
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0020909309387207 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2025-09-03 18:05:54') AND oc_t_item.pk_i_id < 1125
AND oc_t_item.fk_i_category_id IN (238)
AND ( oc_t_item_location.s_region LIKE 'łódzkie' )
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00053501129150391 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '837'
0.00098991394042969 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '837'
AND s.fk_i_item_id = '837'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00043702125549316 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '674'
0.0010371208190918 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '674'
AND s.fk_i_item_id = '674'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00047802925109863 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '608'
0.00091886520385742 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '608'
AND s.fk_i_item_id = '608'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.0004880428314209 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 837
AND dt_expiration_date >= '2025-09-03 18:05:54'
0.00049090385437012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 837
0.0011880397796631 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=837
0.00051498413085938 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 674
AND dt_expiration_date >= '2025-09-03 18:05:54'
0.00051307678222656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 674
0.0010519027709961 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=674
0.00048995018005371 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 608
AND dt_expiration_date >= '2025-09-03 18:05:54'
0.00048303604125977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 608
0.00098085403442383 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=608
0.00021004676818848 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00089812278747559 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 2
ORDER BY rand_ind asc
0.00014710426330566 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00057315826416016 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0012638568878174 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00013303756713867 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00090599060058594 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 3
ORDER BY rand_ind asc
0.00015497207641602 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00042295455932617 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.001046895980835 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00013589859008789 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00081205368041992 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 4
ORDER BY rand_ind asc
0.00015091896057129 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00042414665222168 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0010299682617188 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00021696090698242 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC