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": "32796", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada", "sort_urls": "sunshinecoast5907cowriestsecheltbcv0n3a7canada", "address": "Sunshine Coast", "city": "5907 Cowrie St", "state": "Sechelt", "zipcode": "", "country": "BC V0N 3A7", "country_4_digits": "nada", "Phone": "(604) 741-5481", "name": "Panorama Ridge", "rating": "0", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJdQk1KXs6hlQR1x1NFq0wth4", "feed_data": "\n\n OK\n \n Panorama Ridge\n Sunshine Coast, 5907 Cowrie Street, Sechelt\n point_of_interest\n establishment\n (604) 741-5481\n Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada\n \n Sunshine Coast\n Sunshine Coast\n point_of_interest\n establishment\n \n \n 5907\n 5907\n street_number\n \n \n Cowrie Street\n Cowrie St\n route\n \n \n Sechelt\n Sechelt\n locality\n political\n \n \n Sechelt\n Sechelt\n administrative_area_level_3\n political\n \n \n Sunshine Coast Regional District\n Sunshine Coast Regional District\n administrative_area_level_2\n political\n \n \n British Columbia\n BC\n administrative_area_level_1\n political\n \n \n Canada\n CA\n country\n political\n \n \n V0N 3A7\n V0N 3A7\n postal_code\n \n \n \n 49.4718364\n -123.7689438\n \n \n \n 49.4707426\n -123.7702926\n \n \n 49.4734405\n -123.7675947\n \n \n \n https://maps.google.com/?cid=2213009786860805591\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJdQk1KXs6hlQR1x1NFq0wth4\n +1 604-741-5481\n -480\n <span class="extended-address">Sunshine Coast</span>, <span class="street-address">5907 Cowrie St</span>, <span class="locality">Sechelt</span>, <span class="region">BC</span> <span class="postal-code">V0N 3A7</span>, <span class="country-name">Canada</span>\n ChIJdQk1KXs6hlQR1x1NFq0wth4\n \n 84XRF6CJ+PC\n F6CJ+PC Sechelt, BC, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/generic_pinlet\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 Davis Bay Sunshine Coast British Columbia V0N", "name_url": "panorama_ridge_sunshine_coast_5907_cowrie_st_sechelt_bc_v0n_3a7_canada", "city_state": "sechelt5907cowriest", "streetphoto": "", "streetphoto_md5": "242cbbe832df395e6d4bbe22337439e2", "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": "112", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "5907cowriest", "country": "BC V0N 3A7", "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-5907cowriest-country-bcv0n3a7", "query": "SELECT * FROM `header_tags` where url='https://friendlylandlord.com/apartments-for-rent/city-5907cowriest-country-bcv0n3a7' 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": "bcv0n3a7", "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.208.135.174", "data_review": "\n\t\t\t
\n\t\t\t\t\t

Panorama Ridge

\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

(604) 741 - 5481

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

Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada5907 Cowrie St, Sechelt

\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": "5907COWRIEST", "state_seo": "SECHELT", "state": "Sechelt", "property": { "id": "32796", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada", "sort_urls": "sunshinecoast5907cowriestsecheltbcv0n3a7canada", "address": "Sunshine Coast", "city": "5907 Cowrie St", "state": "Sechelt", "zipcode": "", "country": "BC V0N 3A7", "country_4_digits": "nada", "Phone": "(604) 741-5481", "name": "Panorama Ridge", "rating": "0", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJdQk1KXs6hlQR1x1NFq0wth4", "feed_data": "\n\n OK\n \n Panorama Ridge\n Sunshine Coast, 5907 Cowrie Street, Sechelt\n point_of_interest\n establishment\n (604) 741-5481\n Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada\n \n Sunshine Coast\n Sunshine Coast\n point_of_interest\n establishment\n \n \n 5907\n 5907\n street_number\n \n \n Cowrie Street\n Cowrie St\n route\n \n \n Sechelt\n Sechelt\n locality\n political\n \n \n Sechelt\n Sechelt\n administrative_area_level_3\n political\n \n \n Sunshine Coast Regional District\n Sunshine Coast Regional District\n administrative_area_level_2\n political\n \n \n British Columbia\n BC\n administrative_area_level_1\n political\n \n \n Canada\n CA\n country\n political\n \n \n V0N 3A7\n V0N 3A7\n postal_code\n \n \n \n 49.4718364\n -123.7689438\n \n \n \n 49.4707426\n -123.7702926\n \n \n 49.4734405\n -123.7675947\n \n \n \n https://maps.google.com/?cid=2213009786860805591\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJdQk1KXs6hlQR1x1NFq0wth4\n +1 604-741-5481\n -480\n <span class="extended-address">Sunshine Coast</span>, <span class="street-address">5907 Cowrie St</span>, <span class="locality">Sechelt</span>, <span class="region">BC</span> <span class="postal-code">V0N 3A7</span>, <span class="country-name">Canada</span>\n ChIJdQk1KXs6hlQR1x1NFq0wth4\n \n 84XRF6CJ+PC\n F6CJ+PC Sechelt, BC, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/generic_pinlet\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 Davis Bay Sunshine Coast British Columbia V0N", "name_url": "panorama_ridge_sunshine_coast_5907_cowrie_st_sechelt_bc_v0n_3a7_canada", "city_state": "sechelt5907cowriest", "streetphoto": "", "streetphoto_md5": "242cbbe832df395e6d4bbe22337439e2", "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": "112", "width": "640", "width_done": "2", "transfer_done": "1" }, "property_id": "32796", "place_id": "ChIJdQk1KXs6hlQR1x1NFq0wth4", "business_name": "Panorama Ridge", "name_url": "panorama_ridge_sunshine_coast_5907_cowrie_st_sechelt_bc_v0n_3a7_canada", "business_name_url": "panorama-ridge", "address": "Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada", "city_display": "5907 Cowrie St", "City_link": "5907cowriest", "country_link": "bcv0n3a7", "zip": "", "zipcode_link": "", "city_state_zip": ", 5907cowriest, Sechelt ", "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": "6047415481", "Phone": "Hieu6047415481Nguyen", "Phone_First": "Hieu604", "Phone_Last": "5481Nguyen", "Phone_Mid": "741", "Final_phone": "(604) 741 - 5481", "phone_show": "(604) 741 - 5481", "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 ='ChIJdQk1KXs6hlQR1x1NFq0wth4' and review_public='1' GROUP BY place_id) tmp on tmp.id=data_review.place_id WHERE data_review.place_id ='ChIJdQk1KXs6hlQR1x1NFq0wth4' 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": "32796", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada", "sort_urls": "sunshinecoast5907cowriestsecheltbcv0n3a7canada", "address": "Sunshine Coast", "city": "5907 Cowrie St", "state": "Sechelt", "zipcode": "", "country": "BC V0N 3A7", "country_4_digits": "nada", "Phone": "(604) 741-5481", "name": "Panorama Ridge", "rating": "0", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJdQk1KXs6hlQR1x1NFq0wth4", "feed_data": "\n\n OK\n \n Panorama Ridge\n Sunshine Coast, 5907 Cowrie Street, Sechelt\n point_of_interest\n establishment\n (604) 741-5481\n Sunshine Coast, 5907 Cowrie St, Sechelt, BC V0N 3A7, Canada\n \n Sunshine Coast\n Sunshine Coast\n point_of_interest\n establishment\n \n \n 5907\n 5907\n street_number\n \n \n Cowrie Street\n Cowrie St\n route\n \n \n Sechelt\n Sechelt\n locality\n political\n \n \n Sechelt\n Sechelt\n administrative_area_level_3\n political\n \n \n Sunshine Coast Regional District\n Sunshine Coast Regional District\n administrative_area_level_2\n political\n \n \n British Columbia\n BC\n administrative_area_level_1\n political\n \n \n Canada\n CA\n country\n political\n \n \n V0N 3A7\n V0N 3A7\n postal_code\n \n \n \n 49.4718364\n -123.7689438\n \n \n \n 49.4707426\n -123.7702926\n \n \n 49.4734405\n -123.7675947\n \n \n \n https://maps.google.com/?cid=2213009786860805591\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJdQk1KXs6hlQR1x1NFq0wth4\n +1 604-741-5481\n -480\n <span class="extended-address">Sunshine Coast</span>, <span class="street-address">5907 Cowrie St</span>, <span class="locality">Sechelt</span>, <span class="region">BC</span> <span class="postal-code">V0N 3A7</span>, <span class="country-name">Canada</span>\n ChIJdQk1KXs6hlQR1x1NFq0wth4\n \n 84XRF6CJ+PC\n F6CJ+PC Sechelt, BC, Canada\n \n #7B9EB0\n OPERATIONAL\n https://maps.gstatic.com/mapfiles/place_api/icons/v2/generic_pinlet\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 Davis Bay Sunshine Coast British Columbia V0N", "name_url": "panorama_ridge_sunshine_coast_5907_cowrie_st_sechelt_bc_v0n_3a7_canada", "city_state": "sechelt5907cowriest", "streetphoto": "", "streetphoto_md5": "242cbbe832df395e6d4bbe22337439e2", "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": "112", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "5907cowriest", "country": "bcv0n3a7", "offset": 25, "menus": [], "total_count": "1" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 918, "function": "index", "class": "App\\Controllers\\SortController", "type": "->", "args": [ "5907cowriest", "bcv0n3a7", 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": [] } ] }