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": "17313", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada", "sort_urls": "bigwhiteskiresort7640porcupinerdbeaverdellbcv0h1a0canada", "address": "Big White Ski Resort", "city": "7640 Porcupine Rd", "state": "Beaverdell", "zipcode": "", "country": "BC V0H 1A0", "country_4_digits": "nada", "Phone": "(250) 859-6720", "name": "BIG WHITE-TREE TOPS TOWN HOME", "rating": "5", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJJ_80CAKffVMRH4STxrJZJOo", "feed_data": "\n\n OK\n \n BIG WHITE-TREE TOPS TOWN HOME\n Big White Ski Resort, 7640 Porcupine Road, Beaverdell\n point_of_interest\n establishment\n (250) 859-6720\n Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada\n \n Big White Ski Resort\n Big White Ski Resort\n point_of_interest\n establishment\n \n \n 7640\n 7640\n street_number\n \n \n Porcupine Road\n Porcupine Rd\n route\n \n \n Beaverdell\n Beaverdell\n locality\n political\n \n \n Kootenay Boundary\n Kootenay Boundary\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 V0H 1A0\n V0H 1A0\n postal_code\n \n \n \n 49.7254180\n -118.9277995\n \n \n \n 49.7241004\n -118.9291528\n \n \n 49.7267983\n -118.9264549\n \n \n \n 5.0\n https://maps.google.com/?cid=16871708728407327775\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJJ_80CAKffVMRH4STxrJZJOo\n +1 250-859-6720\n http://treetopsatbigwhite.com/\n \n \n \n Sacha Jones\n https://www.google.com/maps/contrib/106152642684210710215/reviews\n 5.0\n https://lh3.googleusercontent.com/a-/AD5-WClR6nJgpRibdBdqYvqdB4URijHE89oDUjBDx6TlCA=s128-c0x00000000-cc-rp-mo\n a year ago\n false\n \n -480\n <span class="extended-address">Big White Ski Resort</span>, <span class="street-address">7640 Porcupine Rd</span>, <span class="locality">Beaverdell</span>, <span class="region">BC</span> <span class="postal-code">V0H 1A0</span>, <span class="country-name">Canada</span>\n 1\n ChIJJ_80CAKffVMRH4STxrJZJOo\n \n 85X3P3GC+5V\n P3GC+5V Beaverdell, 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-01-23", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Big White Kootenay Boundary British Columbia V0H", "name_url": "big_whitetree_tops_town_home_big_white_ski_resort_7640_porcupine_rd_beaverdell_bc_v0h_1a0_canada", "city_state": "beaverdell7640porcupinerd", "streetphoto": "", "streetphoto_md5": "f4c4d7171b52a862a866a477fc5e01b1", "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": "220", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "7640porcupinerd", "country": "BC V0H 1A0", "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-7640porcupinerd-country-bcv0h1a0", "query": "SELECT * FROM `header_tags` where url='https://friendlylandlord.com/apartments-for-rent/city-7640porcupinerd-country-bcv0h1a0' 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": "bcv0h1a0", "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": "3.239.13.1", "data_review": "\n\t\t\t
\n\t\t\t\t\t

BIG WHITE-TREE TOPS TOWN HOME

\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

(250) 859 - 6720

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

Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada7640 Porcupine Rd, Beaverdell

\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": "7640PORCUPINERD", "state_seo": "BEAVERDELL", "state": "Beaverdell", "property": { "id": "17313", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada", "sort_urls": "bigwhiteskiresort7640porcupinerdbeaverdellbcv0h1a0canada", "address": "Big White Ski Resort", "city": "7640 Porcupine Rd", "state": "Beaverdell", "zipcode": "", "country": "BC V0H 1A0", "country_4_digits": "nada", "Phone": "(250) 859-6720", "name": "BIG WHITE-TREE TOPS TOWN HOME", "rating": "5", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJJ_80CAKffVMRH4STxrJZJOo", "feed_data": "\n\n OK\n \n BIG WHITE-TREE TOPS TOWN HOME\n Big White Ski Resort, 7640 Porcupine Road, Beaverdell\n point_of_interest\n establishment\n (250) 859-6720\n Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada\n \n Big White Ski Resort\n Big White Ski Resort\n point_of_interest\n establishment\n \n \n 7640\n 7640\n street_number\n \n \n Porcupine Road\n Porcupine Rd\n route\n \n \n Beaverdell\n Beaverdell\n locality\n political\n \n \n Kootenay Boundary\n Kootenay Boundary\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 V0H 1A0\n V0H 1A0\n postal_code\n \n \n \n 49.7254180\n -118.9277995\n \n \n \n 49.7241004\n -118.9291528\n \n \n 49.7267983\n -118.9264549\n \n \n \n 5.0\n https://maps.google.com/?cid=16871708728407327775\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJJ_80CAKffVMRH4STxrJZJOo\n +1 250-859-6720\n http://treetopsatbigwhite.com/\n \n \n \n Sacha Jones\n https://www.google.com/maps/contrib/106152642684210710215/reviews\n 5.0\n https://lh3.googleusercontent.com/a-/AD5-WClR6nJgpRibdBdqYvqdB4URijHE89oDUjBDx6TlCA=s128-c0x00000000-cc-rp-mo\n a year ago\n false\n \n -480\n <span class="extended-address">Big White Ski Resort</span>, <span class="street-address">7640 Porcupine Rd</span>, <span class="locality">Beaverdell</span>, <span class="region">BC</span> <span class="postal-code">V0H 1A0</span>, <span class="country-name">Canada</span>\n 1\n ChIJJ_80CAKffVMRH4STxrJZJOo\n \n 85X3P3GC+5V\n P3GC+5V Beaverdell, 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-01-23", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Big White Kootenay Boundary British Columbia V0H", "name_url": "big_whitetree_tops_town_home_big_white_ski_resort_7640_porcupine_rd_beaverdell_bc_v0h_1a0_canada", "city_state": "beaverdell7640porcupinerd", "streetphoto": "", "streetphoto_md5": "f4c4d7171b52a862a866a477fc5e01b1", "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": "220", "width": "640", "width_done": "2", "transfer_done": "1" }, "property_id": "17313", "place_id": "ChIJJ_80CAKffVMRH4STxrJZJOo", "business_name": "BIG WHITE-TREE TOPS TOWN HOME", "name_url": "big_whitetree_tops_town_home_big_white_ski_resort_7640_porcupine_rd_beaverdell_bc_v0h_1a0_canada", "business_name_url": "big-whitetree-tops-town-home", "address": "Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada", "city_display": "7640 Porcupine Rd", "City_link": "7640porcupinerd", "country_link": "bcv0h1a0", "zip": "", "zipcode_link": "", "city_state_zip": ", 7640porcupinerd, Beaverdell ", "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": "2508596720", "Phone": "Hieu2508596720Nguyen", "Phone_First": "Hieu250", "Phone_Last": "6720Nguyen", "Phone_Mid": "859", "Final_phone": "(250) 859 - 6720", "phone_show": "(250) 859 - 6720", "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 ='ChIJJ_80CAKffVMRH4STxrJZJOo' and review_public='1' GROUP BY place_id) tmp on tmp.id=data_review.place_id WHERE data_review.place_id ='ChIJJ_80CAKffVMRH4STxrJZJOo' 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": "17313", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada", "sort_urls": "bigwhiteskiresort7640porcupinerdbeaverdellbcv0h1a0canada", "address": "Big White Ski Resort", "city": "7640 Porcupine Rd", "state": "Beaverdell", "zipcode": "", "country": "BC V0H 1A0", "country_4_digits": "nada", "Phone": "(250) 859-6720", "name": "BIG WHITE-TREE TOPS TOWN HOME", "rating": "5", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJJ_80CAKffVMRH4STxrJZJOo", "feed_data": "\n\n OK\n \n BIG WHITE-TREE TOPS TOWN HOME\n Big White Ski Resort, 7640 Porcupine Road, Beaverdell\n point_of_interest\n establishment\n (250) 859-6720\n Big White Ski Resort, 7640 Porcupine Rd, Beaverdell, BC V0H 1A0, Canada\n \n Big White Ski Resort\n Big White Ski Resort\n point_of_interest\n establishment\n \n \n 7640\n 7640\n street_number\n \n \n Porcupine Road\n Porcupine Rd\n route\n \n \n Beaverdell\n Beaverdell\n locality\n political\n \n \n Kootenay Boundary\n Kootenay Boundary\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 V0H 1A0\n V0H 1A0\n postal_code\n \n \n \n 49.7254180\n -118.9277995\n \n \n \n 49.7241004\n -118.9291528\n \n \n 49.7267983\n -118.9264549\n \n \n \n 5.0\n https://maps.google.com/?cid=16871708728407327775\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJJ_80CAKffVMRH4STxrJZJOo\n +1 250-859-6720\n http://treetopsatbigwhite.com/\n \n \n \n Sacha Jones\n https://www.google.com/maps/contrib/106152642684210710215/reviews\n 5.0\n https://lh3.googleusercontent.com/a-/AD5-WClR6nJgpRibdBdqYvqdB4URijHE89oDUjBDx6TlCA=s128-c0x00000000-cc-rp-mo\n a year ago\n false\n \n -480\n <span class="extended-address">Big White Ski Resort</span>, <span class="street-address">7640 Porcupine Rd</span>, <span class="locality">Beaverdell</span>, <span class="region">BC</span> <span class="postal-code">V0H 1A0</span>, <span class="country-name">Canada</span>\n 1\n ChIJJ_80CAKffVMRH4STxrJZJOo\n \n 85X3P3GC+5V\n P3GC+5V Beaverdell, 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-01-23", "review_time": "0", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Big White Kootenay Boundary British Columbia V0H", "name_url": "big_whitetree_tops_town_home_big_white_ski_resort_7640_porcupine_rd_beaverdell_bc_v0h_1a0_canada", "city_state": "beaverdell7640porcupinerd", "streetphoto": "", "streetphoto_md5": "f4c4d7171b52a862a866a477fc5e01b1", "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": "220", "width": "640", "width_done": "2", "transfer_done": "1" } ], "page": 1, "city": "7640porcupinerd", "country": "bcv0h1a0", "offset": 25, "menus": [], "total_count": "1" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 918, "function": "index", "class": "App\\Controllers\\SortController", "type": "->", "args": [ "7640porcupinerd", "bcv0h1a0", 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": [] } ] }