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": "15402", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "L3S0E1, 39 New Delhi Dr, Markham, ON, Canada", "sort_urls": "l3s0e139newdelhidrmarkhamoncanada", "address": "L3S0E1", "city": "39 New Delhi Dr", "state": "Markham", "zipcode": "", "country": "ON", "country_4_digits": "nada", "Phone": "(905) 669-0222", "name": "GEM 2 Condos", "rating": "0", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJ4UU9igfX1IkRw7vwmCDCLac", "feed_data": "\n\n OK\n \n GEM 2 Condos\n L3S0E1, 39 New Delhi Drive, Markham\n point_of_interest\n establishment\n (905) 669-0222\n L3S0E1, 39 New Delhi Dr, Markham, ON L3S 0B6, Canada\n \n 39\n 39\n street_number\n \n \n New Delhi Drive\n New Delhi Dr\n route\n \n \n Markham\n Markham\n locality\n political\n \n \n Regional Municipality of York\n Regional Municipality of York\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 L3S 0B6\n L3S 0B6\n postal_code\n \n \n \n 43.8511980\n -79.2529164\n \n \n \n 43.8498717\n -79.2541675\n \n \n 43.8525697\n -79.2514696\n \n \n \n 5.0\n https://maps.google.com/?cid=12046498023546600387\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJ4UU9igfX1IkRw7vwmCDCLac\n +1 905-669-0222\n \n \n \n John Doe\n https://www.google.com/maps/contrib/118008528511616232655/reviews\n 5.0\n https://lh3.googleusercontent.com/a/AGNmyxbJL07IlFFecAbM2xWECj5Ka04fQaxURGj-nwik=s128-c0x00000000-cc-rp-mo\n a month ago\n false\n \n -300\n L3S0E1, <span class="street-address">39 New Delhi Dr</span>, <span class="locality">Markham</span>, <span class="region">ON</span> <span class="postal-code">L3S 0B6</span>, <span class="country-name">Canada</span>\n 1\n ChIJ4UU9igfX1IkRw7vwmCDCLac\n \n 87M2VP2W+FR\n VP2W+FR Markham, 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-02-25", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Belford Durham Ontario L0H", "name_url": "gem_2_condos_l3s0e1_39_new_delhi_dr_markham_on_canada", "city_state": "markham39newdelhidr", "streetphoto": "", "streetphoto_md5": "771b705f2941c0b998ae51afbf6dd973", "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": "86", "width": "640", "width_done": "2", "transfer_done": "0" } ], "page": 1, "city": "39newdelhidr", "country": "ON", "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-39newdelhidr-country-on", "query": "SELECT * FROM `header_tags` where url='https://friendlylandlord.com/apartments-for-rent/city-39newdelhidr-country-on' 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": "on", "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": "44.222.125.114", "data_review": "\n\t\t\t
\n\t\t\t\t\t

GEM 2 Condos

\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

(905) 669 - 0222

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

L3S0E1, 39 New Delhi Dr, Markham, ON, Canada39 New Delhi Dr, Markham

\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": "39NEWDELHIDR", "state_seo": "MARKHAM", "state": "Markham", "property": { "id": "15402", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "L3S0E1, 39 New Delhi Dr, Markham, ON, Canada", "sort_urls": "l3s0e139newdelhidrmarkhamoncanada", "address": "L3S0E1", "city": "39 New Delhi Dr", "state": "Markham", "zipcode": "", "country": "ON", "country_4_digits": "nada", "Phone": "(905) 669-0222", "name": "GEM 2 Condos", "rating": "0", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJ4UU9igfX1IkRw7vwmCDCLac", "feed_data": "\n\n OK\n \n GEM 2 Condos\n L3S0E1, 39 New Delhi Drive, Markham\n point_of_interest\n establishment\n (905) 669-0222\n L3S0E1, 39 New Delhi Dr, Markham, ON L3S 0B6, Canada\n \n 39\n 39\n street_number\n \n \n New Delhi Drive\n New Delhi Dr\n route\n \n \n Markham\n Markham\n locality\n political\n \n \n Regional Municipality of York\n Regional Municipality of York\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 L3S 0B6\n L3S 0B6\n postal_code\n \n \n \n 43.8511980\n -79.2529164\n \n \n \n 43.8498717\n -79.2541675\n \n \n 43.8525697\n -79.2514696\n \n \n \n 5.0\n https://maps.google.com/?cid=12046498023546600387\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJ4UU9igfX1IkRw7vwmCDCLac\n +1 905-669-0222\n \n \n \n John Doe\n https://www.google.com/maps/contrib/118008528511616232655/reviews\n 5.0\n https://lh3.googleusercontent.com/a/AGNmyxbJL07IlFFecAbM2xWECj5Ka04fQaxURGj-nwik=s128-c0x00000000-cc-rp-mo\n a month ago\n false\n \n -300\n L3S0E1, <span class="street-address">39 New Delhi Dr</span>, <span class="locality">Markham</span>, <span class="region">ON</span> <span class="postal-code">L3S 0B6</span>, <span class="country-name">Canada</span>\n 1\n ChIJ4UU9igfX1IkRw7vwmCDCLac\n \n 87M2VP2W+FR\n VP2W+FR Markham, 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-02-25", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Belford Durham Ontario L0H", "name_url": "gem_2_condos_l3s0e1_39_new_delhi_dr_markham_on_canada", "city_state": "markham39newdelhidr", "streetphoto": "", "streetphoto_md5": "771b705f2941c0b998ae51afbf6dd973", "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": "86", "width": "640", "width_done": "2", "transfer_done": "0" }, "property_id": "15402", "place_id": "ChIJ4UU9igfX1IkRw7vwmCDCLac", "business_name": "GEM 2 Condos", "name_url": "gem_2_condos_l3s0e1_39_new_delhi_dr_markham_on_canada", "business_name_url": "gem-2-condos", "address": "L3S0E1, 39 New Delhi Dr, Markham, ON, Canada", "city_display": "39 New Delhi Dr", "City_link": "39newdelhidr", "country_link": "on", "zip": "", "zipcode_link": "", "city_state_zip": ", 39newdelhidr, Markham ", "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": "9056690222", "Phone": "Hieu9056690222Nguyen", "Phone_First": "Hieu905", "Phone_Last": "0222Nguyen", "Phone_Mid": "669", "Final_phone": "(905) 669 - 0222", "phone_show": "(905) 669 - 0222", "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 ='ChIJ4UU9igfX1IkRw7vwmCDCLac' and review_public='1' GROUP BY place_id) tmp on tmp.id=data_review.place_id WHERE data_review.place_id ='ChIJ4UU9igfX1IkRw7vwmCDCLac' 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": "15402", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "L3S0E1, 39 New Delhi Dr, Markham, ON, Canada", "sort_urls": "l3s0e139newdelhidrmarkhamoncanada", "address": "L3S0E1", "city": "39 New Delhi Dr", "state": "Markham", "zipcode": "", "country": "ON", "country_4_digits": "nada", "Phone": "(905) 669-0222", "name": "GEM 2 Condos", "rating": "0", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJ4UU9igfX1IkRw7vwmCDCLac", "feed_data": "\n\n OK\n \n GEM 2 Condos\n L3S0E1, 39 New Delhi Drive, Markham\n point_of_interest\n establishment\n (905) 669-0222\n L3S0E1, 39 New Delhi Dr, Markham, ON L3S 0B6, Canada\n \n 39\n 39\n street_number\n \n \n New Delhi Drive\n New Delhi Dr\n route\n \n \n Markham\n Markham\n locality\n political\n \n \n Regional Municipality of York\n Regional Municipality of York\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 L3S 0B6\n L3S 0B6\n postal_code\n \n \n \n 43.8511980\n -79.2529164\n \n \n \n 43.8498717\n -79.2541675\n \n \n 43.8525697\n -79.2514696\n \n \n \n 5.0\n https://maps.google.com/?cid=12046498023546600387\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJ4UU9igfX1IkRw7vwmCDCLac\n +1 905-669-0222\n \n \n \n John Doe\n https://www.google.com/maps/contrib/118008528511616232655/reviews\n 5.0\n https://lh3.googleusercontent.com/a/AGNmyxbJL07IlFFecAbM2xWECj5Ka04fQaxURGj-nwik=s128-c0x00000000-cc-rp-mo\n a month ago\n false\n \n -300\n L3S0E1, <span class="street-address">39 New Delhi Dr</span>, <span class="locality">Markham</span>, <span class="region">ON</span> <span class="postal-code">L3S 0B6</span>, <span class="country-name">Canada</span>\n 1\n ChIJ4UU9igfX1IkRw7vwmCDCLac\n \n 87M2VP2W+FR\n VP2W+FR Markham, 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-02-25", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Belford Durham Ontario L0H", "name_url": "gem_2_condos_l3s0e1_39_new_delhi_dr_markham_on_canada", "city_state": "markham39newdelhidr", "streetphoto": "", "streetphoto_md5": "771b705f2941c0b998ae51afbf6dd973", "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": "86", "width": "640", "width_done": "2", "transfer_done": "0" } ], "page": 1, "city": "39newdelhidr", "country": "on", "offset": 25, "menus": [], "total_count": "1" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 918, "function": "index", "class": "App\\Controllers\\SortController", "type": "->", "args": [ "39newdelhidr", "on", 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": [] } ] }