APARTMENT REVIEWS AND RATINGS IN { "title": "ErrorException", "type": "ErrorException", "code": 500, "message": "Undefined variable: city_tag", "file": "/home/friendlylandlord/friendlylandlord/app/Views/sort/index.php", "line": 524, "trace": [ { "file": "/home/friendlylandlord/friendlylandlord/app/Views/sort/index.php", "line": 524, "function": "errorHandler", "class": "CodeIgniter\\Debug\\Exceptions", "type": "->", "args": [ 8, "Undefined variable: city_tag", "/home/friendlylandlord/friendlylandlord/app/Views/sort/index.php", 524, { "view": "sort/index", "options": [], "saveData": true, "fileExt": "", "realPath": "sort/index.php", "session_user": null, "properties": [ { "id": "142", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada", "sort_urls": "lambtonhall1421westernrdlondononn6g4w4canada", "address": "Lambton Hall", "city": "1421 Western Rd", "state": "London", "zipcode": "", "country": "ON N6G 4W4", "country_4_digits": "nada", "Phone": "(519) 661-2111", "name": "Lambton Hall", "rating": "3", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJ9VmP4z7uLogRbmDlIehD3QE", "feed_data": "\n\n OK\n \n Lambton Hall\n Lambton Hall, 1421 Western Road, London\n point_of_interest\n establishment\n (519) 661-2111\n Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada\n \n Lambton Hall\n Lambton Hall\n premise\n \n \n 1421\n 1421\n street_number\n \n \n Western Road\n Western Rd\n route\n \n \n Medway\n Medway\n neighborhood\n political\n \n \n London\n London\n locality\n political\n \n \n Middlesex County\n Middlesex County\n administrative_area_level_2\n political\n \n \n Ontario\n ON\n administrative_area_level_1\n political\n \n \n Canada\n CA\n country\n political\n \n \n N6G 4W4\n N6G 4W4\n postal_code\n \n \n \n 43.0134931\n -81.2774997\n \n \n \n 43.0120756\n -81.2788523\n \n \n 43.0147736\n -81.2761543\n \n \n \n 3.6\n https://maps.google.com/?cid=134338228171137134\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJ9VmP4z7uLogRbmDlIehD3QE\n +1 519-661-2111\n https://residence.uwo.ca/buildings/firstyear_buildings/lambton_hall\n \n \n great student resident for student who want to live close to campus. 10 min walk for resident to social science, this place is close to campus and provide a good amount of transportation. Student who live here can also apply for a spot at the bayfield lot. Which is beside to the resident. Overall this is a good place for student who are not financially restricted and want a place that is close to campus.\n ken “404” c\n https://www.google.com/maps/contrib/104722236969906050528/reviews\n 4.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WCme-ZwTcQstFZpFkMYul9N4loohYz3XX7g8fhikzf0=s128-c0x00000000-cc-rp-mo-ba6\n 3 years ago\n en\n false\n \n \n \n The security officers are so rude and I think they have some racial issues. Please think twice before you get harassed by one of them.\n zacanada zak\n https://www.google.com/maps/contrib/108834921211138900212/reviews\n 1.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WClxjVTI7V1yuh-FE7eUhH4j6osDXl8kwIjpS-EX=s128-c0x00000000-cc-rp-mo-ba3\n 3 years ago\n en\n false\n \n \n \n Great student residence at an affordable price.\n Jordan Fung\n https://www.google.com/maps/contrib/113926602490396500410/reviews\n 4.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WCnoyEwT5Hs4vzmeHa4p7_dFmGPV42Gx3OOWn8MWOQ=s128-c0x00000000-cc-rp-mo-ba3\n 2 years ago\n en\n false\n \n \n \n \n Brad Lee\n https://www.google.com/maps/contrib/103538965610042813221/reviews\n 4.0\n https://lh3.googleusercontent.com/a-/AD5-WCkcYXOfjbd0XdmRXxeekK8nVmUkAE3_Ab9VJObi-A=s128-c0x00000000-cc-rp-mo\n 4 years ago\n false\n \n \n \n \n Andrei Popescu\n https://www.google.com/maps/contrib/102065284626986092788/reviews\n 5.0\n https://lh3.googleusercontent.com/a-/AD5-WCmAi-yLUkqQ47DXavrhQ7LGrj6hxKazWcsT1HiI=s128-c0x00000000-cc-rp-mo\n 3 years ago\n false\n \n -300\n \n ARywPAIi4jJ19tfLfKoj_J_V6w0rHQ4rqHglFkujksCRf7Psfg2oFE182tCgNpMgG7llBv09tMZrrgyIgpsyZkwfwGUPXZa6jMPvImS-mDFrcE_zJPRdvNakl16D8u-dJhsznnOqimGxlYGNlJ4VWw0cMfcOoaJe5EzaRUl5mu-f1xTiVUTC\n 1800\n 4000\n <a href="https://maps.google.com/maps/contrib/114325546348900893837">Ribal Aridi</a>\n \n \n ARywPAJkO4g8LBhLfzrefW1FLTbKN-uRVmURsZQzgmz7HoI5ObWRq9zm1kjTzQHLj8Unp58Gjhbg4BJkzzFfc4MfX8lDgHzfb9BkiwtBvnxX50RftEk8bhhu4Nz4tjQe5C_KKlGfLu7yMAOqIGJT4MGiMfTljnImPKee7p7QjDb8kxQcdngG\n 3456\n 4608\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAKzCC_1_NSoFMiHDPRW5IVzztAQ_PAusuV590ezR_bTw5MniCIcpiHCjnKFq_5Ox5E5RvH6TFXo2fClLMnmvuVpTGDiJqiAqMqA4DCxePACgOoFRyNGU0Lu4NNJTFulgOhPGSbTa9SwvmKc7wOCmadP7IHAdmnCOCFN00h2x561BpKK\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPALMIh_vionnhoglZ1TlvIud4FCFBpVV4T8IlKd06H61UnIFkTFn0Audw2BUwFvR9Lvznq17xY0W1dcM1wv3NS-OZ7DyjL790hDIprTdbTJIarIo_YSa5yQOKFVJY43hVR79GEm0HZXvZt8tEFMLaB4ZMFaC22ig4V_Wzb7btzjiLEc6\n 3456\n 4608\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAJ36pDPXW8Da7SF83stLuDZ8gKnmgo1aVQK3CLnCYKrYq0b0vcDP3uIICkdtZHgh5iSFadyVBLkqJ1gtD5ZSqrAWqT_MZ5rBDV7YxT_WNNXVS1SVyLcXvlGxOXyI8T-lYabv4I3jzGWf8rwLC7kqbTqiQqKipCydenA5CuPaEkkna7D\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAJgrkuABSfOdQhmIAK_06NCygKPtfEDBqUQ1Mryhabsb9TIVccvmLzotWMq5zgf3w-7TQWgNuZfbsotG36jGtBtElboky7M1kojKcP3x5BMvQzktJe6M4zygNrhnMWq8erRvOVfupjT0rHZzJ71KfQuAxkrIbf1sZoUZn9wg9Ts1XsK\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n <span class="extended-address">Lambton Hall</span>, <span class="street-address">1421 Western Rd</span>, <span class="locality">London</span>, <span class="region">ON</span> <span class="postal-code">N6G 4W4</span>, <span class="country-name">Canada</span>\n 5\n ChIJ9VmP4z7uLogRbmDlIehD3QE\n \n 86MW2P7F+92\n 2P7F+92 London, ON, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/generic_pinlet\n true\n \n\n", "feed_data_done": "1", "Craw_Date": "2023-01-20", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Aberfeldy Lambton Ontario N0N", "name_url": "lambton_hall_lambton_hall_1421_western_rd_london_on_n6g_4w4_canada", "city_state": "london1421westernrd", "streetphoto": "", "streetphoto_md5": "a43abba08fad81852c6c7277516d2813", "openhours": "0", "Open_hours_monday": "", "Closed_hours_monday": "", "Open_hours_tuesday": "", "Closed_hours_tuesday": "", "Open_hours_wednesday": "", "Closed_hours_wednesday": "", "Open_hours_thursday": "", "Closed_hours_thursday": "", "Open_hours_friday": "", "Closed_hours_friday": "", "Open_hours_saturday": "", "Closed_hours_saturday": "", "Open_hours_sunday": "", "Closed_hours_sunday": "", "H_Monday": "", "H_Tuesday": "", "H_Wednesday": "", "H_Thursday": "", "H_Friday": "", "H_Saturday": "", "H_Sunday": "", "H_done": "1", "hits": "233", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "1421westernrd", "country": "ON N6G 4W4", "offset": 25, "menus": [], "total_count": "1", "servername": "localhost", "username": "friendlylandlord_user", "password": "8x.$Ug&(~)m0", "dbname": "friendlylandlord_database", "conn": { "affected_rows": null, "client_info": null, "client_version": null, "connect_errno": null, "connect_error": null, "errno": null, "error": null, "error_list": null, "field_count": null, "host_info": null, "info": null, "insert_id": null, "server_info": null, "server_version": null, "sqlstate": null, "protocol_version": null, "thread_id": null, "warning_count": null }, "url": "https://friendlylandlord.com/apartments-for-rent/city-1421westernrd-country-onn6g4w4", "query": "SELECT * FROM `header_tags` where url='https://friendlylandlord.com/apartments-for-rent/city-1421westernrd-country-onn6g4w4' limit 1", "result": { "current_field": null, "field_count": null, "lengths": null, "num_rows": null, "type": null }, "row": null, "db": { "DBDriver": "MySQLi", "deleteHack": true, "escapeChar": "`", "mysqli": { "affected_rows": null, "client_info": null, "client_version": null, "connect_errno": null, "connect_error": null, "errno": null, "error": null, "error_list": null, "field_count": null, "host_info": null, "info": null, "insert_id": null, "server_info": null, "server_version": null, "sqlstate": null, "protocol_version": null, "thread_id": null, "warning_count": null }, "connID": { "affected_rows": null, "client_info": null, "client_version": null, "connect_errno": null, "connect_error": null, "errno": null, "error": null, "error_list": null, "field_count": null, "host_info": null, "info": null, "insert_id": null, "server_info": null, "server_version": null, "sqlstate": null, "protocol_version": null, "thread_id": null, "warning_count": null }, "resultID": { "current_field": null, "field_count": null, "lengths": null, "num_rows": null, "type": null }, "protectIdentifiers": true, "likeEscapeStr": " ESCAPE '%s' ", "likeEscapeChar": "!", "dataCache": [], "transEnabled": true, "transStrict": true }, "main_country": "onn6g4w4", "message_images_arr": { "A": "https://friendlylandlord.com/images/users/a.png", "B": "https://friendlylandlord.com/images/users/b.png", "C": "https://friendlylandlord.com/images/users/c.png", "D": "https://friendlylandlord.com/images/users/d.png", "E": "https://friendlylandlord.com/images/users/e.png", "F": "https://friendlylandlord.com/images/users/f.png", "G": "https://friendlylandlord.com/images/users/g.png", "H": "https://friendlylandlord.com/images/users/h.png", "I": "https://friendlylandlord.com/images/users/i.png", "J": "https://friendlylandlord.com/images/users/j.png", "K": "https://friendlylandlord.com/images/users/k.png", "L": "https://friendlylandlord.com/images/users/l.png", "M": "https://friendlylandlord.com/images/users/m.png", "N": "https://friendlylandlord.com/images/users/n.png", "O": "https://friendlylandlord.com/images/users/o.png", "P": "https://friendlylandlord.com/images/users/p.png", "Q": "https://friendlylandlord.com/images/users/q.png", "R": "https://friendlylandlord.com/images/users/r.png", "S": "https://friendlylandlord.com/images/users/s.png", "T": "https://friendlylandlord.com/images/users/t.png", "U": "https://friendlylandlord.com/images/users/u.png", "V": "https://friendlylandlord.com/images/users/v.png", "W": "https://friendlylandlord.com/images/users/w.png", "X": "https://friendlylandlord.com/images/users/x.png", "Y": "https://friendlylandlord.com/images/users/y.png", "Z": "https://friendlylandlord.com/images/users/z.png" }, "ip_address": "18.234.202.202", "data_review": "\n\t\t\t
\n\t\t\t\t\t

Lambton Hall

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t

(519) 661 - 2111

\n\t\t\t\t\t\t
\n

Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada1421 Western Rd, London

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t
", "city_seo": "1421WESTERNRD", "state_seo": "LONDON", "state": "London", "property": { "id": "142", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada", "sort_urls": "lambtonhall1421westernrdlondononn6g4w4canada", "address": "Lambton Hall", "city": "1421 Western Rd", "state": "London", "zipcode": "", "country": "ON N6G 4W4", "country_4_digits": "nada", "Phone": "(519) 661-2111", "name": "Lambton Hall", "rating": "3", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJ9VmP4z7uLogRbmDlIehD3QE", "feed_data": "\n\n OK\n \n Lambton Hall\n Lambton Hall, 1421 Western Road, London\n point_of_interest\n establishment\n (519) 661-2111\n Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada\n \n Lambton Hall\n Lambton Hall\n premise\n \n \n 1421\n 1421\n street_number\n \n \n Western Road\n Western Rd\n route\n \n \n Medway\n Medway\n neighborhood\n political\n \n \n London\n London\n locality\n political\n \n \n Middlesex County\n Middlesex County\n administrative_area_level_2\n political\n \n \n Ontario\n ON\n administrative_area_level_1\n political\n \n \n Canada\n CA\n country\n political\n \n \n N6G 4W4\n N6G 4W4\n postal_code\n \n \n \n 43.0134931\n -81.2774997\n \n \n \n 43.0120756\n -81.2788523\n \n \n 43.0147736\n -81.2761543\n \n \n \n 3.6\n https://maps.google.com/?cid=134338228171137134\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJ9VmP4z7uLogRbmDlIehD3QE\n +1 519-661-2111\n https://residence.uwo.ca/buildings/firstyear_buildings/lambton_hall\n \n \n great student resident for student who want to live close to campus. 10 min walk for resident to social science, this place is close to campus and provide a good amount of transportation. Student who live here can also apply for a spot at the bayfield lot. Which is beside to the resident. Overall this is a good place for student who are not financially restricted and want a place that is close to campus.\n ken “404” c\n https://www.google.com/maps/contrib/104722236969906050528/reviews\n 4.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WCme-ZwTcQstFZpFkMYul9N4loohYz3XX7g8fhikzf0=s128-c0x00000000-cc-rp-mo-ba6\n 3 years ago\n en\n false\n \n \n \n The security officers are so rude and I think they have some racial issues. Please think twice before you get harassed by one of them.\n zacanada zak\n https://www.google.com/maps/contrib/108834921211138900212/reviews\n 1.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WClxjVTI7V1yuh-FE7eUhH4j6osDXl8kwIjpS-EX=s128-c0x00000000-cc-rp-mo-ba3\n 3 years ago\n en\n false\n \n \n \n Great student residence at an affordable price.\n Jordan Fung\n https://www.google.com/maps/contrib/113926602490396500410/reviews\n 4.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WCnoyEwT5Hs4vzmeHa4p7_dFmGPV42Gx3OOWn8MWOQ=s128-c0x00000000-cc-rp-mo-ba3\n 2 years ago\n en\n false\n \n \n \n \n Brad Lee\n https://www.google.com/maps/contrib/103538965610042813221/reviews\n 4.0\n https://lh3.googleusercontent.com/a-/AD5-WCkcYXOfjbd0XdmRXxeekK8nVmUkAE3_Ab9VJObi-A=s128-c0x00000000-cc-rp-mo\n 4 years ago\n false\n \n \n \n \n Andrei Popescu\n https://www.google.com/maps/contrib/102065284626986092788/reviews\n 5.0\n https://lh3.googleusercontent.com/a-/AD5-WCmAi-yLUkqQ47DXavrhQ7LGrj6hxKazWcsT1HiI=s128-c0x00000000-cc-rp-mo\n 3 years ago\n false\n \n -300\n \n ARywPAIi4jJ19tfLfKoj_J_V6w0rHQ4rqHglFkujksCRf7Psfg2oFE182tCgNpMgG7llBv09tMZrrgyIgpsyZkwfwGUPXZa6jMPvImS-mDFrcE_zJPRdvNakl16D8u-dJhsznnOqimGxlYGNlJ4VWw0cMfcOoaJe5EzaRUl5mu-f1xTiVUTC\n 1800\n 4000\n <a href="https://maps.google.com/maps/contrib/114325546348900893837">Ribal Aridi</a>\n \n \n ARywPAJkO4g8LBhLfzrefW1FLTbKN-uRVmURsZQzgmz7HoI5ObWRq9zm1kjTzQHLj8Unp58Gjhbg4BJkzzFfc4MfX8lDgHzfb9BkiwtBvnxX50RftEk8bhhu4Nz4tjQe5C_KKlGfLu7yMAOqIGJT4MGiMfTljnImPKee7p7QjDb8kxQcdngG\n 3456\n 4608\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAKzCC_1_NSoFMiHDPRW5IVzztAQ_PAusuV590ezR_bTw5MniCIcpiHCjnKFq_5Ox5E5RvH6TFXo2fClLMnmvuVpTGDiJqiAqMqA4DCxePACgOoFRyNGU0Lu4NNJTFulgOhPGSbTa9SwvmKc7wOCmadP7IHAdmnCOCFN00h2x561BpKK\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPALMIh_vionnhoglZ1TlvIud4FCFBpVV4T8IlKd06H61UnIFkTFn0Audw2BUwFvR9Lvznq17xY0W1dcM1wv3NS-OZ7DyjL790hDIprTdbTJIarIo_YSa5yQOKFVJY43hVR79GEm0HZXvZt8tEFMLaB4ZMFaC22ig4V_Wzb7btzjiLEc6\n 3456\n 4608\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAJ36pDPXW8Da7SF83stLuDZ8gKnmgo1aVQK3CLnCYKrYq0b0vcDP3uIICkdtZHgh5iSFadyVBLkqJ1gtD5ZSqrAWqT_MZ5rBDV7YxT_WNNXVS1SVyLcXvlGxOXyI8T-lYabv4I3jzGWf8rwLC7kqbTqiQqKipCydenA5CuPaEkkna7D\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAJgrkuABSfOdQhmIAK_06NCygKPtfEDBqUQ1Mryhabsb9TIVccvmLzotWMq5zgf3w-7TQWgNuZfbsotG36jGtBtElboky7M1kojKcP3x5BMvQzktJe6M4zygNrhnMWq8erRvOVfupjT0rHZzJ71KfQuAxkrIbf1sZoUZn9wg9Ts1XsK\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n <span class="extended-address">Lambton Hall</span>, <span class="street-address">1421 Western Rd</span>, <span class="locality">London</span>, <span class="region">ON</span> <span class="postal-code">N6G 4W4</span>, <span class="country-name">Canada</span>\n 5\n ChIJ9VmP4z7uLogRbmDlIehD3QE\n \n 86MW2P7F+92\n 2P7F+92 London, ON, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/generic_pinlet\n true\n \n\n", "feed_data_done": "1", "Craw_Date": "2023-01-20", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Aberfeldy Lambton Ontario N0N", "name_url": "lambton_hall_lambton_hall_1421_western_rd_london_on_n6g_4w4_canada", "city_state": "london1421westernrd", "streetphoto": "", "streetphoto_md5": "a43abba08fad81852c6c7277516d2813", "openhours": "0", "Open_hours_monday": "", "Closed_hours_monday": "", "Open_hours_tuesday": "", "Closed_hours_tuesday": "", "Open_hours_wednesday": "", "Closed_hours_wednesday": "", "Open_hours_thursday": "", "Closed_hours_thursday": "", "Open_hours_friday": "", "Closed_hours_friday": "", "Open_hours_saturday": "", "Closed_hours_saturday": "", "Open_hours_sunday": "", "Closed_hours_sunday": "", "H_Monday": "", "H_Tuesday": "", "H_Wednesday": "", "H_Thursday": "", "H_Friday": "", "H_Saturday": "", "H_Sunday": "", "H_done": "1", "hits": "233", "width": "640", "width_done": "2", "transfer_done": "1" }, "property_id": "142", "place_id": "ChIJ9VmP4z7uLogRbmDlIehD3QE", "business_name": "Lambton Hall", "name_url": "lambton_hall_lambton_hall_1421_western_rd_london_on_n6g_4w4_canada", "business_name_url": "lambton-hall", "address": "Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada", "city_display": "1421 Western Rd", "City_link": "1421westernrd", "country_link": "onn6g4w4", "zip": "", "zipcode_link": "", "city_state_zip": ", 1421westernrd, London ", "pictures": "", "Open_hours_monday": "", "Open_hours_tuesday": "", "Open_hours_wednesday": "", "Open_hours_thursday": "", "Open_hours_friday": "", "Open_hours_saturday": "", "Open_hours_sunday": "", "Closed_hours_monday": "", "Closed_hours_tuesday": "", "Closed_hours_wednesday": "", "Closed_hours_thursday": "", "Closed_hours_friday": "", "Closed_hours_saturday": "", "Closed_hours_sunday": "", "streetphoto": "", "picture_urls": [], "image_gallery": "", "Phone_apt": "5196612111", "Phone": "Hieu5196612111Nguyen", "Phone_First": "Hieu519", "Phone_Last": "2111Nguyen", "Phone_Mid": "661", "Final_phone": "(519) 661 - 2111", "phone_show": "(519) 661 - 2111", "query1": "SELECT review_text_ai, review_time, review_text, review_author_name, review_rating, tmp.avg_rating, `path` FROM data_review left join (SELECT place_id as id, AVG(review_rating) as avg_rating FROM data_review WHERE place_id ='ChIJ9VmP4z7uLogRbmDlIehD3QE' and review_public='1' GROUP BY place_id) tmp on tmp.id=data_review.place_id WHERE data_review.place_id ='ChIJ9VmP4z7uLogRbmDlIehD3QE' and review_public='1' order by data_review.charactercount DESC LIMIT 1", "row1": null, "review_time": 0, "review_author_name": "", "review_text": "", "show_star_2": "", "review_profile_photo_url": "", "avg_rating": 0, "show_star": "", "monday_str": "", "tuesday_str": "", "wednesday_str": "", "thursday_str": "", "friday_str": "", "saturday_str": "", "sunday_str": "" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/View/View.php", "line": 246, "args": [ "/home/friendlylandlord/friendlylandlord/app/Views/sort/index.php" ], "function": "include" }, { "file": "/home/friendlylandlord/friendlylandlord/system/Common.php", "line": 1119, "function": "render", "class": "CodeIgniter\\View\\View", "type": "->", "args": [ "sort/index", [], true ] }, { "file": "/home/friendlylandlord/friendlylandlord/app/Controllers/SortController.php", "line": 63, "function": "view", "args": [ "sort/index", { "session_user": null, "properties": [ { "id": "142", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada", "sort_urls": "lambtonhall1421westernrdlondononn6g4w4canada", "address": "Lambton Hall", "city": "1421 Western Rd", "state": "London", "zipcode": "", "country": "ON N6G 4W4", "country_4_digits": "nada", "Phone": "(519) 661-2111", "name": "Lambton Hall", "rating": "3", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJ9VmP4z7uLogRbmDlIehD3QE", "feed_data": "\n\n OK\n \n Lambton Hall\n Lambton Hall, 1421 Western Road, London\n point_of_interest\n establishment\n (519) 661-2111\n Lambton Hall, 1421 Western Rd, London, ON N6G 4W4, Canada\n \n Lambton Hall\n Lambton Hall\n premise\n \n \n 1421\n 1421\n street_number\n \n \n Western Road\n Western Rd\n route\n \n \n Medway\n Medway\n neighborhood\n political\n \n \n London\n London\n locality\n political\n \n \n Middlesex County\n Middlesex County\n administrative_area_level_2\n political\n \n \n Ontario\n ON\n administrative_area_level_1\n political\n \n \n Canada\n CA\n country\n political\n \n \n N6G 4W4\n N6G 4W4\n postal_code\n \n \n \n 43.0134931\n -81.2774997\n \n \n \n 43.0120756\n -81.2788523\n \n \n 43.0147736\n -81.2761543\n \n \n \n 3.6\n https://maps.google.com/?cid=134338228171137134\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJ9VmP4z7uLogRbmDlIehD3QE\n +1 519-661-2111\n https://residence.uwo.ca/buildings/firstyear_buildings/lambton_hall\n \n \n great student resident for student who want to live close to campus. 10 min walk for resident to social science, this place is close to campus and provide a good amount of transportation. Student who live here can also apply for a spot at the bayfield lot. Which is beside to the resident. Overall this is a good place for student who are not financially restricted and want a place that is close to campus.\n ken “404” c\n https://www.google.com/maps/contrib/104722236969906050528/reviews\n 4.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WCme-ZwTcQstFZpFkMYul9N4loohYz3XX7g8fhikzf0=s128-c0x00000000-cc-rp-mo-ba6\n 3 years ago\n en\n false\n \n \n \n The security officers are so rude and I think they have some racial issues. Please think twice before you get harassed by one of them.\n zacanada zak\n https://www.google.com/maps/contrib/108834921211138900212/reviews\n 1.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WClxjVTI7V1yuh-FE7eUhH4j6osDXl8kwIjpS-EX=s128-c0x00000000-cc-rp-mo-ba3\n 3 years ago\n en\n false\n \n \n \n Great student residence at an affordable price.\n Jordan Fung\n https://www.google.com/maps/contrib/113926602490396500410/reviews\n 4.0\n en\n https://lh3.googleusercontent.com/a-/AD5-WCnoyEwT5Hs4vzmeHa4p7_dFmGPV42Gx3OOWn8MWOQ=s128-c0x00000000-cc-rp-mo-ba3\n 2 years ago\n en\n false\n \n \n \n \n Brad Lee\n https://www.google.com/maps/contrib/103538965610042813221/reviews\n 4.0\n https://lh3.googleusercontent.com/a-/AD5-WCkcYXOfjbd0XdmRXxeekK8nVmUkAE3_Ab9VJObi-A=s128-c0x00000000-cc-rp-mo\n 4 years ago\n false\n \n \n \n \n Andrei Popescu\n https://www.google.com/maps/contrib/102065284626986092788/reviews\n 5.0\n https://lh3.googleusercontent.com/a-/AD5-WCmAi-yLUkqQ47DXavrhQ7LGrj6hxKazWcsT1HiI=s128-c0x00000000-cc-rp-mo\n 3 years ago\n false\n \n -300\n \n ARywPAIi4jJ19tfLfKoj_J_V6w0rHQ4rqHglFkujksCRf7Psfg2oFE182tCgNpMgG7llBv09tMZrrgyIgpsyZkwfwGUPXZa6jMPvImS-mDFrcE_zJPRdvNakl16D8u-dJhsznnOqimGxlYGNlJ4VWw0cMfcOoaJe5EzaRUl5mu-f1xTiVUTC\n 1800\n 4000\n <a href="https://maps.google.com/maps/contrib/114325546348900893837">Ribal Aridi</a>\n \n \n ARywPAJkO4g8LBhLfzrefW1FLTbKN-uRVmURsZQzgmz7HoI5ObWRq9zm1kjTzQHLj8Unp58Gjhbg4BJkzzFfc4MfX8lDgHzfb9BkiwtBvnxX50RftEk8bhhu4Nz4tjQe5C_KKlGfLu7yMAOqIGJT4MGiMfTljnImPKee7p7QjDb8kxQcdngG\n 3456\n 4608\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAKzCC_1_NSoFMiHDPRW5IVzztAQ_PAusuV590ezR_bTw5MniCIcpiHCjnKFq_5Ox5E5RvH6TFXo2fClLMnmvuVpTGDiJqiAqMqA4DCxePACgOoFRyNGU0Lu4NNJTFulgOhPGSbTa9SwvmKc7wOCmadP7IHAdmnCOCFN00h2x561BpKK\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPALMIh_vionnhoglZ1TlvIud4FCFBpVV4T8IlKd06H61UnIFkTFn0Audw2BUwFvR9Lvznq17xY0W1dcM1wv3NS-OZ7DyjL790hDIprTdbTJIarIo_YSa5yQOKFVJY43hVR79GEm0HZXvZt8tEFMLaB4ZMFaC22ig4V_Wzb7btzjiLEc6\n 3456\n 4608\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAJ36pDPXW8Da7SF83stLuDZ8gKnmgo1aVQK3CLnCYKrYq0b0vcDP3uIICkdtZHgh5iSFadyVBLkqJ1gtD5ZSqrAWqT_MZ5rBDV7YxT_WNNXVS1SVyLcXvlGxOXyI8T-lYabv4I3jzGWf8rwLC7kqbTqiQqKipCydenA5CuPaEkkna7D\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n \n ARywPAJgrkuABSfOdQhmIAK_06NCygKPtfEDBqUQ1Mryhabsb9TIVccvmLzotWMq5zgf3w-7TQWgNuZfbsotG36jGtBtElboky7M1kojKcP3x5BMvQzktJe6M4zygNrhnMWq8erRvOVfupjT0rHZzJ71KfQuAxkrIbf1sZoUZn9wg9Ts1XsK\n 3024\n 4032\n <a href="https://maps.google.com/maps/contrib/104722236969906050528">ken “404” c</a>\n \n <span class="extended-address">Lambton Hall</span>, <span class="street-address">1421 Western Rd</span>, <span class="locality">London</span>, <span class="region">ON</span> <span class="postal-code">N6G 4W4</span>, <span class="country-name">Canada</span>\n 5\n ChIJ9VmP4z7uLogRbmDlIehD3QE\n \n 86MW2P7F+92\n 2P7F+92 London, ON, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/generic_pinlet\n true\n \n\n", "feed_data_done": "1", "Craw_Date": "2023-01-20", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Aberfeldy Lambton Ontario N0N", "name_url": "lambton_hall_lambton_hall_1421_western_rd_london_on_n6g_4w4_canada", "city_state": "london1421westernrd", "streetphoto": "", "streetphoto_md5": "a43abba08fad81852c6c7277516d2813", "openhours": "0", "Open_hours_monday": "", "Closed_hours_monday": "", "Open_hours_tuesday": "", "Closed_hours_tuesday": "", "Open_hours_wednesday": "", "Closed_hours_wednesday": "", "Open_hours_thursday": "", "Closed_hours_thursday": "", "Open_hours_friday": "", "Closed_hours_friday": "", "Open_hours_saturday": "", "Closed_hours_saturday": "", "Open_hours_sunday": "", "Closed_hours_sunday": "", "H_Monday": "", "H_Tuesday": "", "H_Wednesday": "", "H_Thursday": "", "H_Friday": "", "H_Saturday": "", "H_Sunday": "", "H_done": "1", "hits": "233", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "1421westernrd", "country": "onn6g4w4", "offset": 25, "menus": [], "total_count": "1" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 918, "function": "index", "class": "App\\Controllers\\SortController", "type": "->", "args": [ "1421westernrd", "onn6g4w4", 1 ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 404, "function": "runController", "class": "CodeIgniter\\CodeIgniter", "type": "->", "args": [ { "session": {} } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 312, "function": "handleRequest", "class": "CodeIgniter\\CodeIgniter", "type": "->", "args": [ null, { "handler": "file", "backupHandler": "dummy", "storePath": "/home/friendlylandlord/friendlylandlord/writable/cache/", "cacheQueryString": false, "prefix": "", "memcached": { "host": "127.0.0.1", "port": 11211, "weight": 1, "raw": false }, "redis": { "host": "127.0.0.1", "password": null, "port": 6379, "timeout": 0, "database": 0 }, "validHandlers": { "dummy": "CodeIgniter\\Cache\\Handlers\\DummyHandler", "file": "CodeIgniter\\Cache\\Handlers\\FileHandler", "memcached": "CodeIgniter\\Cache\\Handlers\\MemcachedHandler", "predis": "CodeIgniter\\Cache\\Handlers\\PredisHandler", "redis": "CodeIgniter\\Cache\\Handlers\\RedisHandler", "wincache": "CodeIgniter\\Cache\\Handlers\\WincacheHandler" } }, false ] }, { "file": "/home/friendlylandlord/public_html/index.php", "line": 45, "function": "run", "class": "CodeIgniter\\CodeIgniter", "type": "->", "args": [] } ] }