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": "13499", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada", "sort_urls": "tudhopebuilding1colbornestworilliaonl3v7x5canada", "address": "Tudhope Building", "city": "1 Colborne St W", "state": "Orillia", "zipcode": "", "country": "ON L3V 7X5", "country_4_digits": "nada", "Phone": "(705) 323-9660", "name": "Heritage Place Apartments", "rating": "1", "types": "school,point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJdTloYTmpKk0RnlQMldSHWqs", "feed_data": "\n\n OK\n \n Heritage Place Apartments\n Tudhope Building, 1 Colborne Street West, Orillia\n school\n point_of_interest\n establishment\n (705) 323-9660\n Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada\n \n Tudhope Building\n Tudhope Building\n premise\n \n \n 1\n 1\n street_number\n \n \n Colborne Street West\n Colborne St W\n route\n \n \n Orillia\n Orillia\n locality\n political\n \n \n Simcoe County\n Simcoe 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 L3V 7X5\n L3V 7X5\n postal_code\n \n \n \n 44.6069804\n -79.4188011\n \n \n \n 44.6053228\n -79.4207346\n \n \n 44.6080208\n -79.4180366\n \n \n \n 1.0\n https://maps.google.com/?cid=12347330675493065886\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/school-71.png\n ChIJdTloYTmpKk0RnlQMldSHWqs\n +1 705-323-9660\n https://www.theheritageplace.com/\n \n \n there is no description of the apartment or prices?!?!\n Marcedees Dimytruk\n https://www.google.com/maps/contrib/101878365153529946947/reviews\n 1.0\n en\n https://lh3.googleusercontent.com/a-/ACNPEu93i3d50ZqALrzRHlbOTCYvx958vbxsFyLVMjJNmi4=s128-c0x00000000-cc-rp-mo-ba3\n 8 years ago\n en\n false\n \n -240\n <span class="extended-address">Tudhope Building</span>, <span class="street-address">1 Colborne St W</span>, <span class="locality">Orillia</span>, <span class="region">ON</span> <span class="postal-code">L3V 7X5</span>, <span class="country-name">Canada</span>\n 1\n ChIJdTloYTmpKk0RnlQMldSHWqs\n \n 87P2JH4J+QF\n JH4J+QF Orillia, ON, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/school_pinlet\n \n\n", "feed_data_done": "1", "Craw_Date": "0000-00-00", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Bayshore Village Simcoe Ontario L0K", "name_url": "heritage_place_apartments_tudhope_building_1_colborne_st_w_orillia_on_l3v_7x5_canada", "city_state": "orillia1colbornestw", "streetphoto": "", "streetphoto_md5": "8dfe206aa19189e8c85a87d456bb355d", "openhours": "1", "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": "207", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "1colbornestw", "country": "ON L3V 7X5", "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-1colbornestw-country-onl3v7x5", "query": "SELECT * FROM `header_tags` where url='https://friendlylandlord.com/apartments-for-rent/city-1colbornestw-country-onl3v7x5' 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": "onl3v7x5", "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": "54.81.157.133", "data_review": "\n\t\t\t
\n\t\t\t\t\t

Heritage Place Apartments

\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

(705) 323 - 9660

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

Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada1 Colborne St W, Orillia

\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": "1COLBORNESTW", "state_seo": "ORILLIA", "state": "Orillia", "property": { "id": "13499", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada", "sort_urls": "tudhopebuilding1colbornestworilliaonl3v7x5canada", "address": "Tudhope Building", "city": "1 Colborne St W", "state": "Orillia", "zipcode": "", "country": "ON L3V 7X5", "country_4_digits": "nada", "Phone": "(705) 323-9660", "name": "Heritage Place Apartments", "rating": "1", "types": "school,point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJdTloYTmpKk0RnlQMldSHWqs", "feed_data": "\n\n OK\n \n Heritage Place Apartments\n Tudhope Building, 1 Colborne Street West, Orillia\n school\n point_of_interest\n establishment\n (705) 323-9660\n Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada\n \n Tudhope Building\n Tudhope Building\n premise\n \n \n 1\n 1\n street_number\n \n \n Colborne Street West\n Colborne St W\n route\n \n \n Orillia\n Orillia\n locality\n political\n \n \n Simcoe County\n Simcoe 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 L3V 7X5\n L3V 7X5\n postal_code\n \n \n \n 44.6069804\n -79.4188011\n \n \n \n 44.6053228\n -79.4207346\n \n \n 44.6080208\n -79.4180366\n \n \n \n 1.0\n https://maps.google.com/?cid=12347330675493065886\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/school-71.png\n ChIJdTloYTmpKk0RnlQMldSHWqs\n +1 705-323-9660\n https://www.theheritageplace.com/\n \n \n there is no description of the apartment or prices?!?!\n Marcedees Dimytruk\n https://www.google.com/maps/contrib/101878365153529946947/reviews\n 1.0\n en\n https://lh3.googleusercontent.com/a-/ACNPEu93i3d50ZqALrzRHlbOTCYvx958vbxsFyLVMjJNmi4=s128-c0x00000000-cc-rp-mo-ba3\n 8 years ago\n en\n false\n \n -240\n <span class="extended-address">Tudhope Building</span>, <span class="street-address">1 Colborne St W</span>, <span class="locality">Orillia</span>, <span class="region">ON</span> <span class="postal-code">L3V 7X5</span>, <span class="country-name">Canada</span>\n 1\n ChIJdTloYTmpKk0RnlQMldSHWqs\n \n 87P2JH4J+QF\n JH4J+QF Orillia, ON, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/school_pinlet\n \n\n", "feed_data_done": "1", "Craw_Date": "0000-00-00", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Bayshore Village Simcoe Ontario L0K", "name_url": "heritage_place_apartments_tudhope_building_1_colborne_st_w_orillia_on_l3v_7x5_canada", "city_state": "orillia1colbornestw", "streetphoto": "", "streetphoto_md5": "8dfe206aa19189e8c85a87d456bb355d", "openhours": "1", "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": "207", "width": "640", "width_done": "2", "transfer_done": "1" }, "property_id": "13499", "place_id": "ChIJdTloYTmpKk0RnlQMldSHWqs", "business_name": "Heritage Place Apartments", "name_url": "heritage_place_apartments_tudhope_building_1_colborne_st_w_orillia_on_l3v_7x5_canada", "business_name_url": "heritage-place-apartments", "address": "Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada", "city_display": "1 Colborne St W", "City_link": "1colbornestw", "country_link": "onl3v7x5", "zip": "", "zipcode_link": "", "city_state_zip": ", 1colbornestw, Orillia ", "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": "7053239660", "Phone": "Hieu7053239660Nguyen", "Phone_First": "Hieu705", "Phone_Last": "9660Nguyen", "Phone_Mid": "323", "Final_phone": "(705) 323 - 9660", "phone_show": "(705) 323 - 9660", "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 ='ChIJdTloYTmpKk0RnlQMldSHWqs' and review_public='1' GROUP BY place_id) tmp on tmp.id=data_review.place_id WHERE data_review.place_id ='ChIJdTloYTmpKk0RnlQMldSHWqs' 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": "13499", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada", "sort_urls": "tudhopebuilding1colbornestworilliaonl3v7x5canada", "address": "Tudhope Building", "city": "1 Colborne St W", "state": "Orillia", "zipcode": "", "country": "ON L3V 7X5", "country_4_digits": "nada", "Phone": "(705) 323-9660", "name": "Heritage Place Apartments", "rating": "1", "types": "school,point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJdTloYTmpKk0RnlQMldSHWqs", "feed_data": "\n\n OK\n \n Heritage Place Apartments\n Tudhope Building, 1 Colborne Street West, Orillia\n school\n point_of_interest\n establishment\n (705) 323-9660\n Tudhope Building, 1 Colborne St W, Orillia, ON L3V 7X5, Canada\n \n Tudhope Building\n Tudhope Building\n premise\n \n \n 1\n 1\n street_number\n \n \n Colborne Street West\n Colborne St W\n route\n \n \n Orillia\n Orillia\n locality\n political\n \n \n Simcoe County\n Simcoe 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 L3V 7X5\n L3V 7X5\n postal_code\n \n \n \n 44.6069804\n -79.4188011\n \n \n \n 44.6053228\n -79.4207346\n \n \n 44.6080208\n -79.4180366\n \n \n \n 1.0\n https://maps.google.com/?cid=12347330675493065886\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/school-71.png\n ChIJdTloYTmpKk0RnlQMldSHWqs\n +1 705-323-9660\n https://www.theheritageplace.com/\n \n \n there is no description of the apartment or prices?!?!\n Marcedees Dimytruk\n https://www.google.com/maps/contrib/101878365153529946947/reviews\n 1.0\n en\n https://lh3.googleusercontent.com/a-/ACNPEu93i3d50ZqALrzRHlbOTCYvx958vbxsFyLVMjJNmi4=s128-c0x00000000-cc-rp-mo-ba3\n 8 years ago\n en\n false\n \n -240\n <span class="extended-address">Tudhope Building</span>, <span class="street-address">1 Colborne St W</span>, <span class="locality">Orillia</span>, <span class="region">ON</span> <span class="postal-code">L3V 7X5</span>, <span class="country-name">Canada</span>\n 1\n ChIJdTloYTmpKk0RnlQMldSHWqs\n \n 87P2JH4J+QF\n JH4J+QF Orillia, ON, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/school_pinlet\n \n\n", "feed_data_done": "1", "Craw_Date": "0000-00-00", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Bayshore Village Simcoe Ontario L0K", "name_url": "heritage_place_apartments_tudhope_building_1_colborne_st_w_orillia_on_l3v_7x5_canada", "city_state": "orillia1colbornestw", "streetphoto": "", "streetphoto_md5": "8dfe206aa19189e8c85a87d456bb355d", "openhours": "1", "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": "207", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "1colbornestw", "country": "onl3v7x5", "offset": 25, "menus": [], "total_count": "1" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 918, "function": "index", "class": "App\\Controllers\\SortController", "type": "->", "args": [ "1colbornestw", "onl3v7x5", 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": [] } ] }