Apartments on the map

user warning: Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'arenda_apartment.location.latitude' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.language AS node_language, node_data_field_flat_number_rooms.field_flat_number_rooms_value AS node_data_field_flat_number_rooms_field_flat_number_rooms_value, node.type AS node_type, node.vid AS node_vid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, location.latitude AS gmap_lat, location.longitude AS gmap_lon, node.type AS gmap_node_type FROM node node LEFT JOIN content_type_flatarenda node_data_field_flat_number_rooms ON node.vid = node_data_field_flat_number_rooms.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid WHERE (node.status = 1) AND (node.type in ('flatarenda')) AND (node.language in ('en')) GROUP BY nid in /var/www/arenda/data/www/apartment.kharkov.ua/modules/views/includes/view.inc on line 799.

Объекты не найдены

One-room apartment on Botanicheskii Sad Number of rooms: 1-rooms Nice 1-room apartment for daily rent in Kharkov. Cable TV, Wi-fi, air conditioning, sliding-door wardrobe, convirtable sofa, phone, shower cabin,...	One-room apartment in the center Number of rooms: 1-rooms Stylish and cozy 1-room apartment situated in the heart of the city, with original design, not far from the metro station "Sovetskaya". The apartment...	Two-room apartment on Maidan Konstitutsii Number of rooms: 2-rooms Stylish 2-room apartment in the centre of Kharkov near the metro station Maidan Konstitutsii. King-size bed, convertible coach, TV, DVD, shower...	One-room apartment on 23 Avgusta Number of rooms: 1-rooms Apartment for daily rent in the center of Kharkov. Modern renovation, fully equipped with modern household appliances. Several min. by foot from...
Five-room apartment Number of rooms: 4 or more rooms 5-room apartment in the heart of Kharkiv for daily lease.1 min. by foot from metro station Istoricheskiy muzey. A great deal of historical places,...	Three-room apartment, m. st. Istoricheskiy muzey Number of rooms: 3-rooms 3-room apartment in the heart of Kharkiv for daily lease. 1 min. by foot from metro station Istoricheskiy muzey/Sovetskaya. A great deal of...	Two-room apartment, m. st. Istoricheskiy muzey Number of rooms: 2-rooms 2k apartment in the center of Kharkov. Modern furniture and appliances. The bedroom has a double bed, wardrobe, views over the city. Living room...	Rudneva avenue, 25 (downtown hotel №4) Number of rooms: 1-rooms Cozy studio is equipped with modern electric appliances and is furnished according to the latest fashion trends. Comfortable accommodation for 2...