Apartament Warszawa – Mokotów Woronicza Rozmiar: 120m2 Czynsz za miesiąc 7200 PLN Przestronny apartament 120 m na górnym Mokotowie przy ul. Woronicza z piękną panoramą miasta. Mieszkanie znajduje się w spokojnej, zielonej okolicy na 8 piętrze. Roztacza się z trzech stron Warszawy: wewnętrznego parku z placem zabaw i centrum Warszawy po drugiej stronie. Mieszkanie podzielone jest
3 200 zł/mc. Warszawa, Powiśle, mazowieckie. Mieszkanie Warszawa Powiśle, ul. Zajęcza. Do wynajęcia jednopokojowe mieszkanie w jednej z najmodniejszych dzielnic, czyli Warszawskie Powiśle.Mieszkanie znajduje się na 2 piętrze w nowoczesnym, kameral. 35 m 2. 1 pokój. +103 pkt. Nr ref. gratka-660970.
873 000 zł. Dodane 2023.11.18. mieszkanie na sprzedaż. 4 pokoje⭐100 m2⭐Balkon⭐Garaż⭐Legionowo. Do sprzedaży cichy, jasny z bardzo wysokim standardem, nowoczesny apartament wśród zieleni w Legionowie blisko Warszawy na ogrodzonym i spokojnym osiedlu Rezydencja. ️ Lokalizacja: Legionowo, ul. Słowackiego ️ Metraż: 100 m2 ️
Zobacz 144 ogłoszeń o mieszkania na sprzedaż w Kabaty, Ursynów, Warszawa, mazowieckie. Sprawdź na Otodom.pl! 2 330 000 zł 17 120 zł/m
. SELECT * FROM (oc_t_preference) REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING') SELECT * FROM (oc_t_locale) WHERE b_enabled = 1 ORDER BY s_name ASC SELECT l.*, i.*, SUM( AS i_num_views FROM (oc_t_item i) LEFT JOIN oc_t_item_location l ON = LEFT JOIN oc_t_item_stats s ON = WHERE = '962' GROUP BY SELECT * FROM (oc_t_item_description) WHERE fk_i_item_id = '962' INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (962, '2022-07-31 04:39:53',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1 SELECT * FROM (oc_t_user) WHERE pk_i_id = '38' SELECT * FROM (oc_t_user_description) WHERE fk_i_user_id = '38' SELECT * FROM ((SELECT a.*, b.*, 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 = LEFT JOIN oc_t_category_stats as c ON = WHERE != '' AND = 1 ORDER BY locale_order DESC) dummytable) GROUP BY pk_i_id ORDER BY i_position ASC SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 962 SELECT pk_c_code, s_name, s_description, b_enabled FROM (oc_t_currency) WHERE pk_c_code = 'PLN' 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 = '367478' SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug FROM (oc_t_region) WHERE pk_i_id = '781807' SELECT * FROM (oc_t_region) WHERE s_name = 'mazowieckie' LIMIT 1 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 = 'Warszawa' LIMIT 1 SELECT * FROM ((SELECT a.*, b.*, 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 = LEFT JOIN oc_t_category_stats as c ON = WHERE = 'mieszkania' AND != '' ORDER BY locale_order DESC) dummytable) GROUP BY pk_i_id ORDER BY i_position ASC 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 = 'Warszawa' LIMIT 1 SELECT * FROM (oc_t_user) WHERE pk_i_id = 38 SELECT * FROM (oc_t_user_description) WHERE fk_i_user_id = '38' SELECT * FROM (oc_t_user) WHERE pk_i_id = 38 SELECT * FROM (oc_t_user_description) WHERE fk_i_user_id = '38' SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_6' SELECT as "b_group_id", as "b_group_name", b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE = AND = 6 ORDER BY rand_ind asc SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_6' SELECT * FROM (oc_t_banner) WHERE b_id = '6' UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6 SELECT COUNT(*) AS numrows FROM (oc_t_plugin_category) WHERE fk_i_category_id = 236 AND s_plugin_name = 'custom_attributes' 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 = 236 ORDER BY ASC SELECT fk_i_field_id FROM (oc_t_item_custom_attr_meta) 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 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 = '26' ORDER BY i_order ASC 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 = '1' ORDER BY i_order ASC SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '120' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '5' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '3' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '61' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '4' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '202' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '120' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '5' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '3' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '61' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '4' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '202' LIMIT 1 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 = '4' ORDER BY i_order ASC SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '32' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '31' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '28' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '33' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '186' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '34' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '29' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '30' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '125' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '223' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '219' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '188' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '83' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '129' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '84' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '192' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '185' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '221' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '222' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '184' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '35' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '123' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '217' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '32' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '31' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '28' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '33' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '186' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '34' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '29' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '30' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '125' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '223' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '219' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '188' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '83' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '129' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '84' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '192' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '185' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '221' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '222' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '184' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '35' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '123' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '217' LIMIT 1 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 = '6' ORDER BY i_order ASC SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '85' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '121' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '122' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '147' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '57' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '58' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '59' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '60' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '85' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '121' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '122' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '147' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '57' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '58' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '59' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '60' LIMIT 1 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 = '14' ORDER BY i_order ASC SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '116' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '117' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '118' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '119' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '195' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '196' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '197' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '200' LIMIT 1 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 = '3' ORDER BY i_order ASC SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '14' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '15' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '17' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '18' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '20' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '14' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '15' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '17' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '18' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '20' LIMIT 1 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 = '10' ORDER BY s_label ASC SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '77' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '159' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '87' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '86' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '90' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '161' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '89' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '160' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '77' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '159' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '87' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '86' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '90' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '161' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '89' LIMIT 1 SELECT s_value FROM (oc_t_item_custom_attr_values) WHERE fk_i_item_id = 962 AND fk_i_field_id = '160' LIMIT 1 SELECT oc_t_item.*, as s_user_name, FROM (oc_t_item) LEFT JOIN oc_t_item_location ON = LEFT JOIN oc_t_item_car_attr ON = WHERE = 1 AND = 1 AND = 0 AND ( = 1 || >= '2022-07-31 04:39:53') AND = '2022-07-31 04:39:53') AND = '2022-07-31 04:39:53') AND != 962 AND IN (236) ORDER BY dt_pub_date DESC LIMIT 0, 9 SELECT FROM (oc_t_item) LEFT JOIN oc_t_item_location ON = LEFT JOIN oc_t_item_car_attr ON = WHERE = 1 AND = 1 AND = 0 AND ( = 1 || >= '2022-07-31 04:39:53') AND != 962 AND IN (236) ORDER BY dt_pub_date DESC LIMIT 900000 SELECT * FROM (oc_t_item_description) WHERE = '1170' SELECT oc_t_item_location.*, 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 = '1170' AND = '1170' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1169' SELECT oc_t_item_location.*, 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 = '1169' AND = '1169' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1168' SELECT oc_t_item_location.*, 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 = '1168' AND = '1168' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1167' SELECT oc_t_item_location.*, 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 = '1167' AND = '1167' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1166' SELECT oc_t_item_location.*, 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 = '1166' AND = '1166' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1165' SELECT oc_t_item_location.*, 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 = '1165' AND = '1165' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1164' SELECT oc_t_item_location.*, 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 = '1164' AND = '1164' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1163' SELECT oc_t_item_location.*, 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 = '1163' AND = '1163' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_item_description) WHERE = '1162' SELECT oc_t_item_location.*, 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 = '1162' AND = '1162' AND = '236' GROUP BY fk_i_item_id SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1170 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1170 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1169 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1169 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1168 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1168 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1167 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1167 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1166 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1166 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1165 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1165 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1164 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1164 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1163 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1163 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 1162 AND dt_expiration_date >= '2022-07-31 04:39:53' SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 1162 SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON AND WHERE SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_2' SELECT as "b_group_id", as "b_group_name", b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE = AND = 2 ORDER BY rand_ind asc SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_2' SELECT * FROM (oc_t_banner) WHERE b_id = '2' UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2 SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_3' SELECT as "b_group_id", as "b_group_name", b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE = AND = 3 ORDER BY rand_ind asc SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_3' SELECT * FROM (oc_t_banner) WHERE b_id = '3' UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3 SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_4' SELECT as "b_group_id", as "b_group_name", b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE = AND = 4 ORDER BY rand_ind asc SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_4' SELECT * FROM (oc_t_banner) WHERE b_id = '4' UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4 SELECT * FROM (oc_t_pages) WHERE b_indelible = 0 AND b_link = 1 ORDER BY i_order ASC
Mieszkanie 120,0m2, 6 pokoi Warszawa, Mokotów, Belwederska 2 950 000 zł 24 583,33 zł/m2 PARKING miejsce parkingowe Opis oferty Sprzedam apartament który na obecną chwilę zaaranżowany jest pod biuro. Kameralna inwestycja z 2009 roku w otulinie pięknego Parku Morskie Oko. Lokal znajduję się w nowoczesnym budynku na ulicy Belwederskiej. - 120m2 - wysoki standard inwestycji - łazienka - zamknięta kuchnia - 6 oddzielnych pomieszczeń z których dwa można powiększyć przez usunięcie szklanych ścian np. pod OPEN SPACE. - klimatyzacja - balkon - istnieje możliwość zrobienia recepcji - duże panoramiczne okna Do mieszkania przynależy miejsce postojowe, jest możliwość korzystania z miejsc na terenie inwestycji. Serdecznie zapraszam do prezentacji nieruchomości w dogodnym dla Państwa terminie. Numer oferty: PEMS-136919Osoba odpowiedzialna zawodowo: Patryk Poręba Statystyki ogłoszenia: Lokalizacja Warszawa, Mokotów, Belwederska Podobne nieruchomości WYRÓŻNIONE OBEJRZANE WYRÓŻNIONE OBEJRZANE WYRÓŻNIONE OBEJRZANE WYRÓŻNIONE OBEJRZANE
Wybierz jedną z opcji Na Sprzedaż(1 351) Do Wynajęcia(247) ┕Niezależnie ┕Warszawa(1 374) ┕Gdańsk(113) ┕Kobyłka(13) ┕Marki(11) ┕Międzyzdroje(10) ┕Kostrzyn(9) ┕Warszawa Śródmieście(8) ┕Jabłonna(6) ┕Legionowo(6) ┕Sopot(5) Typ Nieruchomości Niezależnie Mieszkanie(1 394) Dom(39) Lokal(24) Dom Wolnostojący(6) Biuro(5) Działka(4) Bliźniak(1) Magazyn(1) ✚ Zobacz więcej... Ostatnia aktualizacja Tydzień temu 15 dni temu Miesiąc temu Cena: zł Zmień 0 zł - 200 000 zł 200 000 zł - 400 000 zł 400 000 zł - 600 000 zł 600 000 zł - 800 000 zł 800 000 zł - 1 000 000 zł 1 000 000 zł - 1 600 000 zł 1 600 000 zł - 2 200 000 zł 2 200 000 zł - 2 800 000 zł 2 800 000 zł - 3 400 000 zł 3 400 000 zł - 4 000 000 zł 4 000 000 zł +✚ Zobacz więcej... Pokoje 1+ pokoi 2+ pokoi 3+ pokoi 4+ pokoi Powierzchnia: m² Zmień 0 - 15 m² 15 - 30 m² 30 - 45 m² 45 - 60 m² 60 - 75 m² 75 - 120 m² 120 - 165 m² 165 - 210 m² 210 - 255 m² 255 - 300 m² 300+ m²✚ Zobacz więcej... Łazienki 1+ łazienki 2+ łazienki 3+ łazienki 4+ łazienki Zobacz 30 nieruchomości na mapie >
Znaleziono 702 oferty w 39 inwestycjach w tym 82 oferty promocyjneŚrednia cena nieruchomości w tej lokalizacji 13 524 zł/m²Zobacz na mapieOsiedle Hemara - etap IIPROFIT DevelopmentMieszkanie Brzeziny, Białołęka, Warszawaul. Mariana HemaraOddanie: gotoweMetraż: 40-70 m2Mieszkań: 24Pokoje: 2-3Ogrody Włochy etap IIIOgrody Invest Sp. z Nowe Włochy, Włochy, Warszawaul. Pola KarolińskieOddanie: gotoweMetraż: 30-53 m2Mieszkań: 17Pokoje: 1-2Modern SpaceRobyg Stare Włochy, Włochy, Warszawaul. Budki SzczęśliwickieOddanie: gotoweMetraż: 90 m2Mieszkań: 1Pokoje: 4MOXO HOUSEGH DevelopmentMieszkanie Wierzbno, Mokotów, Warszawaul. GoszczyńskiegoOddanie: gotoweMetraż: 72-141 m2Mieszkań: 3Pokoje: 3-4Wille WrzosFelix DevelopmentMieszkanie Stare Włochy, Włochy, WarszawaOddanie: gotoweMetraż: 101-189 m2Mieszkań: 9Pokoje: 4-5WiktoriaPolnord Błonia Wilanowskie, Wilanów, Warszawaul. Herbu JaninaOddanie: gotoweMetraż: 74-88 m2Mieszkań: 10Pokoje: 3-4Wilanowska PointWarsaw LuxuryMieszkanie Stegny, Mokotów, WarszawaOddanie: gotoweMetraż: 51-77 m2Mieszkań: 6Pokoje: 2-3Villa Merkury IIICity Villa sp. z Górce, Bemowo, Warszawaul. NarwikOddanie: gotoweMetraż: 48 m2Mieszkań: 1Pokoje: 2Ruczaj ParkAR Group Powsinek, Wilanów, WarszawaOddanie: gotoweMetraż: 52-147 m2Mieszkań: 20Pokoje: 2-4Hotel PolonezaArche Osiedle Wyczółki, Ursynów, WarszawaOddanie: gotoweMetraż: 19-57 m2Mieszkań: 216Pokoje: 1Osiedle WilnoDom Development Elsnerów, Targówek, WarszawaOddanie: gotoweMetraż: 37-86 m2Mieszkań: 70Pokoje: 1-4Villa ImielinArche Stary Imielin, Ursynów, WarszawaOddanie: gotoweMetraż: 156-217 m2Mieszkań: 4Pokoje: 5-7Kwitnące BielanyUnimax DevelopmentMieszkanie Chomiczówka, Bielany, WarszawaOddanie: gotoweMetraż: 56-59 m2Mieszkań: 4Pokoje: 3WiolettaPolnord Błonia Wilanowskie, Wilanów, Warszawaul. Herbu JaninaOddanie: gotoweMetraż: 75-88 m2Mieszkań: 6Pokoje: 3-4Blu ResidenceAlbero InvestMieszkanie Siekierki, Mokotów, WarszawaOddanie: gotoweMetraż: 39-165 m2Mieszkań: 12Pokoje: 2-4Natolin ParkYuniversal DevelopmentMieszkanie Natolin, Ursynów, Warszawaul. Kazimierza Sotta "Sokoła"Oddanie: gotoweMetraż: 111 m2Mieszkań: 1Pokoje: 4Nova BluszczańskaSGI Sp. z Siekierki, Mokotów, Warszawaul. BluszczańskaOddanie: gotoweMetraż: 33-73 m2Mieszkań: 4Pokoje: 1-3Fleminga ResidenceTPPI SAMieszkanie Henryków, Białołęka, Warszawaul. Aleksandra FlemingaOddanie: gotoweMetraż: 52-67 m2Mieszkań: 3Pokoje: 2-3Apartamenty przy lesieUnimax DevelopmentMieszkanie Marysin Wawerski, Wawer, WarszawaOddanie: gotoweMetraż: 79-99 m2Mieszkań: 3Pokoje: 4Zobacz 3 dostępne mieszkania i domyPrzejdź do następnej stronyZobacz jeszcze 15 inwestycji Poprzednia12Następna Wiadomości na temat Warszawy:Informacje o WarszawieW Warszawie dostępne są 12 072 oferty nowych mieszkań i domów znajdujących się w 268 inwestycjach w Warszawie mają w sprzedaży nowe mieszkania o powierzchniach od 19 do 265 m2, w tym lokale:1-pokojowe (1 616 mieszkań).2-pokojowe (4 440 mieszkań).3-pokojowe (3 855 mieszkań).4-pokojowe (1 529 mieszkań).5-pokojowe (188 mieszkań).6-pokojowe (16 mieszkań).7-pokojowe (4 mieszkania).9-pokojowe (1 mieszkanie).Wśród inwestycji deweloperskich w Warszawie dostępne są oferty sprzedaży nowych domów o powierzchniach od 57 do 344 nowe mieszkanie dostępne w sprzedaży w Warszawie kosztuje 75 088 zł, natomiast najtańszy nowy dom kupimy za 510 000 ostatnim czasie w 17 nieruchomościach zostały obniżone ceny. Aktualnie obowiązują 42 oferty promocyjne. Dostępnych jest także 13 mieszkań w ofercie last minute. oraz 3 oferty w przedsprzedaży. W najbliższym czasie w 7 inwestycjach mieszkaniowych odbędą się dni LokalizacjeMieszkania Błonie (142 oferty)Mieszkania Brwinów (57 ofert)Mieszkania Ciechanów (42 oferty)Mieszkania Góra Kalwaria (124 oferty)Mieszkania Grodzisk Mazowiecki (7 ofert)Mieszkania Legionowo (10 ofert)Mieszkania Łomianki (48 ofert)Miejsca w pobliżuMieszkania Bemowo (482 oferty)Mieszkania Białołęka (2432 oferty)Mieszkania Bielany (338 ofert)Mieszkania Mokotów (1310 ofert)Mieszkania Ochota (1080 ofert)Mieszkania Praga-Północ (690 ofert)Mieszkania Praga-Południe (1005 ofert)Mieszkania Rembertów (91 ofert)Mieszkania Targówek (939 ofert)Mieszkania Ursus (1237 ofert)Mieszkania Ursynów (1310 ofert)Mieszkania Wawer (142 oferty)Mieszkania Wesoła (59 ofert)Mieszkania Wilanów (283 oferty)Mieszkania Włochy (1611 ofert)Mieszkania Wola (1155 ofert)Mieszkania Żoliborz (3 oferty)Oferty w WarszawieMieszkania 1-pokojowe (1616 ofert)Mieszkania 2-pokojowe (4440 ofert)Mieszkania 3-pokojowe (3855 ofert)Mieszkania 4-pokojowe (1529 ofert)Mieszkania 5-pokojowe i więcej (209 ofert)Twoja przeglądarka nie jest obsługiwanaNowa odsłona RynkuPierwotnego została stworzona w oparciu o najnowsze technologie zapewniające szybsze działanie serwisu i maksymalne bezpieczeństwo. Niestety, Twoja aktualna przeglądarka nie wspiera tych pobranie najnowszej wersji jednej z poniższych wyszukiwarek:
mieszkanie 120 m warszawa