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": "7556", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada", "sort_urls": "29invernessdrivewoodlawnrdandinvernessdrguelphonn1e3m1canada", "address": "29 Inverness Drive", "city": "Woodlawn Rd. and Inverness Dr.", "state": "Guelph", "zipcode": "", "country": "ON N1E 3M1", "country_4_digits": "nada", "Phone": "(519) 546-6952", "name": "Inverness Apartments", "rating": "5", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJMeTvfG-aK4gRa4frlfjVXyo", "feed_data": "\n\n OK\n \n Inverness Apartments\n 29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph\n point_of_interest\n establishment\n (519) 546-6952\n 29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada\n \n Guelph\n Guelph\n locality\n political\n \n \n Waverley\n Waverley\n neighborhood\n political\n \n \n Wellington County\n Wellington 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 N1E 3M1\n N1E 3M1\n postal_code\n \n \n \n 43.5760498\n -80.2627716\n \n \n \n 43.5746125\n -80.2639959\n \n \n 43.5773105\n -80.2612980\n \n \n \n 5.0\n https://maps.google.com/?cid=3053394336024332139\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJMeTvfG-aK4gRa4frlfjVXyo\n +1 519-546-6952\n http://www.williamsandmcdaniel.com/\n \n \n I have lived at the Inverness Apartments in Guelph for over 6 years. The building is constantly being upgraded and is very well maintained both inside and out. Lorrie, our building manager is very approachable for issues or concerns. maintenance issues, however trivial, are dealt with immediately. This is a small 30 unit building with residents that are quiet, pleasant and respectful. i am very happy with my choice to call the Inverness Apts., my home.\n Shirley Macfarlane\n https://www.google.com/maps/contrib/109641150428988514332/reviews\n 5.0\n en\n https://lh3.googleusercontent.com/a/ALm5wu2EDhl7nF03QWY9uFdg2uVl7YsgY3xVbs_W0_Vv=s128-c0x00000000-cc-rp-mo\n 3 years ago\n en\n false\n \n \n \n We've lived here for a few years now and LOVE it. The building is very well maintained and the management is very hands on. Lorrie the building manager is very friendly and very responsive to inquiries. William's and McDaniel and the management have been very accommodating for my husbands disability, and have changed a few things to make it easier for him to get in and out of the building. Can't say enough nice things about the building atmosphere and the management.\n Blaire Henry\n https://www.google.com/maps/contrib/109085310187807708199/reviews\n 5.0\n en\n https://lh3.googleusercontent.com/a/ALm5wu3H3IWhuGz9LVd9gf9MWJkqBjEp3eXyd4yKidSU=s128-c0x00000000-cc-rp-mo\n 3 years ago\n en\n false\n \n -240\n \n AcYSjRjNcKpS7c0YYCulTXNLqn_wYcGLe6Zqft9_4wjkJJKOQPbIftq9zsAUy6QlGKTkXbaegmdNri7jD6kLhQBOkyiE5NFkLE1EPC5uy4AMGPBeXQNbKB-Bnav8EkOZ44tz4Sb-xQvkIkymRJexNg8KLY-67-rXktlL2NJP-wzr-qCE23sG\n 897\n 662\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRg6ZEZbmAmgziHXZ3mNC5XlIgzgK92OAYiUUmMwBYlY1iJ4Fbn2m6D2et801aASK7GDQqJCy7qlZ37X3o7q48kD6AMIWyLll81DPWQ1ilrK1vqkCBlx8PiuV_xrDOUVpqp6sh0xizLxe9flxlxgdNdIYkfQLuxjAjQmy_3oDvXCatNF\n 854\n 670\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRjTKifkNhSExS0tYZ4gMl1ZRL1YlymoL_oHRHZaaK8A9k9S3Bhq_k8c0NnBBrZx5yLg2Ff6ni-_hHCrFhzlvZ0iCT-E4jwa8qodS_sAEZnhPhjlHYjvk7FPmGKK0KbVJt2jx1_7ZVZ7SAS3uXywJjPZ4qMWn7VA3nelLuYZyhmtItEe\n 445\n 579\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRhML2cOaeWaNfhz2ZP00YAqaLq7AuJvvw2FxAfyvoeOCLE1-GR-5fhdf2UfZcsFH32bZyT-pBDyZUgHWGFzoz1l5Ma5unHngUhFNnSm3LD4JPp6bkfgKnAumPOU8jvv4GtgVroDzQEwM4ftX2Q0VMfBbm9QREpykQ1IBsefd-LSeBsF\n 446\n 441\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRjDZl4y8M3AbO1bR2io1qgFmux1gINCAQiPCvHI2UPX3NyKC3W23_-aWJUPFBdR52S8y94r4LkQRj42uiVbZ4oPgzrJusfeFyi3upXe4trbpGHYg-KBdTJZ0kTjFPVyP8AqZSEH8PsvsShBh9-Bk14alh8CbrGOewQV1ldDqQwsavxN\n 898\n 668\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRiM2tP4YUedCYj35KRK_5MRAFWhgjo7lntflnuKouU0gk973mO02qowssesTJcJpeEaDyqW3qostNHj7SqwxP04mssLatNrdMCOD9Axd2lodftCXAHawvK-u4-vqkhsQI_MPt0GFeq3qeHyLyF3MNkioD0otkdpDVYzidfzYHYpLw3a\n 898\n 673\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n 29 Inverness Drive, <span class="street-address">Woodlawn Rd. and Inverness Dr.</span>, <span class="locality">Guelph</span>, <span class="region">ON</span> <span class="postal-code">N1E 3M1</span>, <span class="country-name">Canada</span>\n 2\n ChIJMeTvfG-aK4gRa4frlfjVXyo\n \n 86MXHPGP+CV\n HPGP+CV Guelph, ON, 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": "0000-00-00", "review_time": "1674099003", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Ariss Wellington Ontario N0B", "name_url": "inverness_apartments_29_inverness_drive_woodlawn_rd_and_inverness_dr_guelph_on_n1e_3m1_canada", "city_state": "guelphwoodlawnrdandinvernessdr", "streetphoto": "", "streetphoto_md5": "", "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": "217", "width": "0", "width_done": "1", "transfer_done": "0" } ], "page": 1, "city": "Woodlawnrdandinvernessdr", "country": "ON N1E 3M1", "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-woodlawnrdandinvernessdr-country-onn1e3m1", "query": "SELECT * FROM `header_tags` where url='https://friendlylandlord.com/apartments-for-rent/city-woodlawnrdandinvernessdr-country-onn1e3m1' 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": "onn1e3m1", "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": "35.171.22.220", "data_review": "\n\t\t\t
\n\t\t\t\t\t

Inverness Apartments

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t
(5/5)
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t

(519) 546 - 6952

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

29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, CanadaWoodlawn Rd. and Inverness Dr., Guelph

\n\t\t\t\t\t
\n\t\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

Shirley Macfarlane

(5/5)
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t

\n\t\t\t\t\t\t\t2022-09-25T09:32:17Z
I have been residing at the Inverness Apartments in Guelph for more than 6 years now and I am content with my decision This 30unit building is kept up to date with upgrades and is wellmaintained both inside and outside Lorrie our building manager is very accessible when it comes to concerns or issues that may arise no matter how small they are they get taken
\n\t\t\t\t\t\t\t2022-09-25T09:32:17Z
I have been residing at the Inverness Apartments in Guelph for more than 6 years now and I am content with my decision This 30unit building is kept up to date with upgrades and is wellmaintained both inside and outside Lorrie our building manager is very accessible when it comes to concerns or issues that may arise no matter how small they are they get taken care of right away Furthermore all the residents here are quiet pleasant and respectful people which makes it an even better place to live in
\n\t\t\t\t\t\t\tmore ...\n\t\t\t\t\t\t\thide ...\n\t\t\t\t\t\t

\n\t\t\t\t
\n\t\t\t
", "city_seo": "WOODLAWNRDANDINVERNESSDR", "state_seo": "GUELPH", "state": "Guelph", "property": { "id": "7556", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada", "sort_urls": "29invernessdrivewoodlawnrdandinvernessdrguelphonn1e3m1canada", "address": "29 Inverness Drive", "city": "Woodlawn Rd. and Inverness Dr.", "state": "Guelph", "zipcode": "", "country": "ON N1E 3M1", "country_4_digits": "nada", "Phone": "(519) 546-6952", "name": "Inverness Apartments", "rating": "5", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJMeTvfG-aK4gRa4frlfjVXyo", "feed_data": "\n\n OK\n \n Inverness Apartments\n 29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph\n point_of_interest\n establishment\n (519) 546-6952\n 29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada\n \n Guelph\n Guelph\n locality\n political\n \n \n Waverley\n Waverley\n neighborhood\n political\n \n \n Wellington County\n Wellington 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 N1E 3M1\n N1E 3M1\n postal_code\n \n \n \n 43.5760498\n -80.2627716\n \n \n \n 43.5746125\n -80.2639959\n \n \n 43.5773105\n -80.2612980\n \n \n \n 5.0\n https://maps.google.com/?cid=3053394336024332139\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJMeTvfG-aK4gRa4frlfjVXyo\n +1 519-546-6952\n http://www.williamsandmcdaniel.com/\n \n \n I have lived at the Inverness Apartments in Guelph for over 6 years. The building is constantly being upgraded and is very well maintained both inside and out. Lorrie, our building manager is very approachable for issues or concerns. maintenance issues, however trivial, are dealt with immediately. This is a small 30 unit building with residents that are quiet, pleasant and respectful. i am very happy with my choice to call the Inverness Apts., my home.\n Shirley Macfarlane\n https://www.google.com/maps/contrib/109641150428988514332/reviews\n 5.0\n en\n https://lh3.googleusercontent.com/a/ALm5wu2EDhl7nF03QWY9uFdg2uVl7YsgY3xVbs_W0_Vv=s128-c0x00000000-cc-rp-mo\n 3 years ago\n en\n false\n \n \n \n We've lived here for a few years now and LOVE it. The building is very well maintained and the management is very hands on. Lorrie the building manager is very friendly and very responsive to inquiries. William's and McDaniel and the management have been very accommodating for my husbands disability, and have changed a few things to make it easier for him to get in and out of the building. Can't say enough nice things about the building atmosphere and the management.\n Blaire Henry\n https://www.google.com/maps/contrib/109085310187807708199/reviews\n 5.0\n en\n https://lh3.googleusercontent.com/a/ALm5wu3H3IWhuGz9LVd9gf9MWJkqBjEp3eXyd4yKidSU=s128-c0x00000000-cc-rp-mo\n 3 years ago\n en\n false\n \n -240\n \n AcYSjRjNcKpS7c0YYCulTXNLqn_wYcGLe6Zqft9_4wjkJJKOQPbIftq9zsAUy6QlGKTkXbaegmdNri7jD6kLhQBOkyiE5NFkLE1EPC5uy4AMGPBeXQNbKB-Bnav8EkOZ44tz4Sb-xQvkIkymRJexNg8KLY-67-rXktlL2NJP-wzr-qCE23sG\n 897\n 662\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRg6ZEZbmAmgziHXZ3mNC5XlIgzgK92OAYiUUmMwBYlY1iJ4Fbn2m6D2et801aASK7GDQqJCy7qlZ37X3o7q48kD6AMIWyLll81DPWQ1ilrK1vqkCBlx8PiuV_xrDOUVpqp6sh0xizLxe9flxlxgdNdIYkfQLuxjAjQmy_3oDvXCatNF\n 854\n 670\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRjTKifkNhSExS0tYZ4gMl1ZRL1YlymoL_oHRHZaaK8A9k9S3Bhq_k8c0NnBBrZx5yLg2Ff6ni-_hHCrFhzlvZ0iCT-E4jwa8qodS_sAEZnhPhjlHYjvk7FPmGKK0KbVJt2jx1_7ZVZ7SAS3uXywJjPZ4qMWn7VA3nelLuYZyhmtItEe\n 445\n 579\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRhML2cOaeWaNfhz2ZP00YAqaLq7AuJvvw2FxAfyvoeOCLE1-GR-5fhdf2UfZcsFH32bZyT-pBDyZUgHWGFzoz1l5Ma5unHngUhFNnSm3LD4JPp6bkfgKnAumPOU8jvv4GtgVroDzQEwM4ftX2Q0VMfBbm9QREpykQ1IBsefd-LSeBsF\n 446\n 441\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRjDZl4y8M3AbO1bR2io1qgFmux1gINCAQiPCvHI2UPX3NyKC3W23_-aWJUPFBdR52S8y94r4LkQRj42uiVbZ4oPgzrJusfeFyi3upXe4trbpGHYg-KBdTJZ0kTjFPVyP8AqZSEH8PsvsShBh9-Bk14alh8CbrGOewQV1ldDqQwsavxN\n 898\n 668\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRiM2tP4YUedCYj35KRK_5MRAFWhgjo7lntflnuKouU0gk973mO02qowssesTJcJpeEaDyqW3qostNHj7SqwxP04mssLatNrdMCOD9Axd2lodftCXAHawvK-u4-vqkhsQI_MPt0GFeq3qeHyLyF3MNkioD0otkdpDVYzidfzYHYpLw3a\n 898\n 673\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n 29 Inverness Drive, <span class="street-address">Woodlawn Rd. and Inverness Dr.</span>, <span class="locality">Guelph</span>, <span class="region">ON</span> <span class="postal-code">N1E 3M1</span>, <span class="country-name">Canada</span>\n 2\n ChIJMeTvfG-aK4gRa4frlfjVXyo\n \n 86MXHPGP+CV\n HPGP+CV Guelph, ON, 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": "0000-00-00", "review_time": "1674099003", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Ariss Wellington Ontario N0B", "name_url": "inverness_apartments_29_inverness_drive_woodlawn_rd_and_inverness_dr_guelph_on_n1e_3m1_canada", "city_state": "guelphwoodlawnrdandinvernessdr", "streetphoto": "", "streetphoto_md5": "", "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": "217", "width": "0", "width_done": "1", "transfer_done": "0" }, "property_id": "7556", "place_id": "ChIJMeTvfG-aK4gRa4frlfjVXyo", "business_name": "Inverness Apartments", "name_url": "inverness_apartments_29_inverness_drive_woodlawn_rd_and_inverness_dr_guelph_on_n1e_3m1_canada", "business_name_url": "inverness-apartments", "address": "29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada", "city_display": "Woodlawn Rd. and Inverness Dr.", "City_link": "woodlawnrdandinvernessdr", "country_link": "onn1e3m1", "zip": "", "zipcode_link": "", "city_state_zip": ", woodlawnrdandinvernessdr, Guelph ", "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": "5195466952", "Phone": "Hieu5195466952Nguyen", "Phone_First": "Hieu519", "Phone_Last": "6952Nguyen", "Phone_Mid": "546", "Final_phone": "(519) 546 - 6952", "phone_show": "(519) 546 - 6952", "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 ='ChIJMeTvfG-aK4gRa4frlfjVXyo' and review_public='1' GROUP BY place_id) tmp on tmp.id=data_review.place_id WHERE data_review.place_id ='ChIJMeTvfG-aK4gRa4frlfjVXyo' and review_public='1' order by data_review.charactercount DESC LIMIT 1", "row1": { "review_text_ai": "I have been residing at the Inverness Apartments in Guelph for more than 6 years now and I am content with my decision. This 30-unit building is kept up to date with upgrades and is well-maintained both inside and outside. Lorrie, our building manager, is very accessible when it comes to concerns or issues that may arise; no matter how small they are, they get taken care of right away. Furthermore, all the residents here are quiet, pleasant and respectful people which makes it an even better place to live in.", "review_time": "1674099003", "review_text": "I have lived at the Inverness Apartments in Guelph for over 6 years. The building is constantly being upgraded and is very well maintained both inside and out. Lorrie, our building manager is very approachable for issues or concerns. maintenance issues, however trivial, are dealt with immediately. This is a small 30 unit building with residents that are quiet, pleasant and respectful. i am very happy with my choice to call the Inverness Apts., my home.", "review_author_name": "Shirley Macfarlane", "review_rating": "5.0", "avg_rating": "5", "path": "users/aaad6921e65b214003eac2e477f933ea.jpg" }, "review_time": "2022-09-25T09:32:17Z", "review_author_name": "Shirley Macfarlane", "review_text": "2022-09-25T09:32:17Z
I have been residing at the Inverness Apartments in Guelph for more than 6 years now and I am content with my decision This 30unit building is kept up to date with upgrades and is wellmaintained both inside and outside Lorrie our building manager is very accessible when it comes to concerns or issues that may arise no matter how small they are they get taken care of right away Furthermore all the residents here are quiet pleasant and respectful people which makes it an even better place to live in", "show_star_2": "

Shirley Macfarlane

(5/5)
", "review_profile_photo_url": "users/aaad6921e65b214003eac2e477f933ea.jpg", "avg_rating": 5, "review_text_ai": "I have been residing at the Inverness Apartments in Guelph for more than 6 years now and I am content with my decision. This 30-unit building is kept up to date with upgrades and is well-maintained both inside and outside. Lorrie, our building manager, is very accessible when it comes to concerns or issues that may arise; no matter how small they are, they get taken care of right away. Furthermore, all the residents here are quiet, pleasant and respectful people which makes it an even better place to live in.", "review_rating": "5.0", "review_star": "
(5/5)
", "i": 6, "show_star": "
(5/5)
", "monday_str": "", "tuesday_str": "", "wednesday_str": "", "thursday_str": "", "friday_str": "", "saturday_str": "", "sunday_str": "", "review_text_220": "2022-09-25T09:32:17Z
I have been residing at the Inverness Apartments in Guelph for more than 6 years now and I am content with my decision This 30unit building is kept up to date with upgrades and is wellmaintained both inside and outside Lorrie our building manager is very accessible when it comes to concerns or issues that may arise no matter how small they are they get taken" } ] }, { "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": "7556", "business_status": "OPERATIONAL", "Apartments": "1", "formatted_address": "29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada", "sort_urls": "29invernessdrivewoodlawnrdandinvernessdrguelphonn1e3m1canada", "address": "29 Inverness Drive", "city": "Woodlawn Rd. and Inverness Dr.", "state": "Guelph", "zipcode": "", "country": "ON N1E 3M1", "country_4_digits": "nada", "Phone": "(519) 546-6952", "name": "Inverness Apartments", "rating": "5", "types": "point_of_interest,establishment", "total_user_ratings": "", "place_id": "ChIJMeTvfG-aK4gRa4frlfjVXyo", "feed_data": "\n\n OK\n \n Inverness Apartments\n 29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph\n point_of_interest\n establishment\n (519) 546-6952\n 29 Inverness Drive, Woodlawn Rd. and Inverness Dr., Guelph, ON N1E 3M1, Canada\n \n Guelph\n Guelph\n locality\n political\n \n \n Waverley\n Waverley\n neighborhood\n political\n \n \n Wellington County\n Wellington 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 N1E 3M1\n N1E 3M1\n postal_code\n \n \n \n 43.5760498\n -80.2627716\n \n \n \n 43.5746125\n -80.2639959\n \n \n 43.5773105\n -80.2612980\n \n \n \n 5.0\n https://maps.google.com/?cid=3053394336024332139\n https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/generic_business-71.png\n ChIJMeTvfG-aK4gRa4frlfjVXyo\n +1 519-546-6952\n http://www.williamsandmcdaniel.com/\n \n \n I have lived at the Inverness Apartments in Guelph for over 6 years. The building is constantly being upgraded and is very well maintained both inside and out. Lorrie, our building manager is very approachable for issues or concerns. maintenance issues, however trivial, are dealt with immediately. This is a small 30 unit building with residents that are quiet, pleasant and respectful. i am very happy with my choice to call the Inverness Apts., my home.\n Shirley Macfarlane\n https://www.google.com/maps/contrib/109641150428988514332/reviews\n 5.0\n en\n https://lh3.googleusercontent.com/a/ALm5wu2EDhl7nF03QWY9uFdg2uVl7YsgY3xVbs_W0_Vv=s128-c0x00000000-cc-rp-mo\n 3 years ago\n en\n false\n \n \n \n We've lived here for a few years now and LOVE it. The building is very well maintained and the management is very hands on. Lorrie the building manager is very friendly and very responsive to inquiries. William's and McDaniel and the management have been very accommodating for my husbands disability, and have changed a few things to make it easier for him to get in and out of the building. Can't say enough nice things about the building atmosphere and the management.\n Blaire Henry\n https://www.google.com/maps/contrib/109085310187807708199/reviews\n 5.0\n en\n https://lh3.googleusercontent.com/a/ALm5wu3H3IWhuGz9LVd9gf9MWJkqBjEp3eXyd4yKidSU=s128-c0x00000000-cc-rp-mo\n 3 years ago\n en\n false\n \n -240\n \n AcYSjRjNcKpS7c0YYCulTXNLqn_wYcGLe6Zqft9_4wjkJJKOQPbIftq9zsAUy6QlGKTkXbaegmdNri7jD6kLhQBOkyiE5NFkLE1EPC5uy4AMGPBeXQNbKB-Bnav8EkOZ44tz4Sb-xQvkIkymRJexNg8KLY-67-rXktlL2NJP-wzr-qCE23sG\n 897\n 662\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRg6ZEZbmAmgziHXZ3mNC5XlIgzgK92OAYiUUmMwBYlY1iJ4Fbn2m6D2et801aASK7GDQqJCy7qlZ37X3o7q48kD6AMIWyLll81DPWQ1ilrK1vqkCBlx8PiuV_xrDOUVpqp6sh0xizLxe9flxlxgdNdIYkfQLuxjAjQmy_3oDvXCatNF\n 854\n 670\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRjTKifkNhSExS0tYZ4gMl1ZRL1YlymoL_oHRHZaaK8A9k9S3Bhq_k8c0NnBBrZx5yLg2Ff6ni-_hHCrFhzlvZ0iCT-E4jwa8qodS_sAEZnhPhjlHYjvk7FPmGKK0KbVJt2jx1_7ZVZ7SAS3uXywJjPZ4qMWn7VA3nelLuYZyhmtItEe\n 445\n 579\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRhML2cOaeWaNfhz2ZP00YAqaLq7AuJvvw2FxAfyvoeOCLE1-GR-5fhdf2UfZcsFH32bZyT-pBDyZUgHWGFzoz1l5Ma5unHngUhFNnSm3LD4JPp6bkfgKnAumPOU8jvv4GtgVroDzQEwM4ftX2Q0VMfBbm9QREpykQ1IBsefd-LSeBsF\n 446\n 441\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRjDZl4y8M3AbO1bR2io1qgFmux1gINCAQiPCvHI2UPX3NyKC3W23_-aWJUPFBdR52S8y94r4LkQRj42uiVbZ4oPgzrJusfeFyi3upXe4trbpGHYg-KBdTJZ0kTjFPVyP8AqZSEH8PsvsShBh9-Bk14alh8CbrGOewQV1ldDqQwsavxN\n 898\n 668\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n \n AcYSjRiM2tP4YUedCYj35KRK_5MRAFWhgjo7lntflnuKouU0gk973mO02qowssesTJcJpeEaDyqW3qostNHj7SqwxP04mssLatNrdMCOD9Axd2lodftCXAHawvK-u4-vqkhsQI_MPt0GFeq3qeHyLyF3MNkioD0otkdpDVYzidfzYHYpLw3a\n 898\n 673\n <a href="https://maps.google.com/maps/contrib/110986298116430256219">Inverness Apartments</a>\n \n 29 Inverness Drive, <span class="street-address">Woodlawn Rd. and Inverness Dr.</span>, <span class="locality">Guelph</span>, <span class="region">ON</span> <span class="postal-code">N1E 3M1</span>, <span class="country-name">Canada</span>\n 2\n ChIJMeTvfG-aK4gRa4frlfjVXyo\n \n 86MXHPGP+CV\n HPGP+CV Guelph, ON, 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": "0000-00-00", "review_time": "1674099003", "update_phone_images": "1", "pictures": "", "transfer_to_data_review": "1", "Keywords": "apartments in Ariss Wellington Ontario N0B", "name_url": "inverness_apartments_29_inverness_drive_woodlawn_rd_and_inverness_dr_guelph_on_n1e_3m1_canada", "city_state": "guelphwoodlawnrdandinvernessdr", "streetphoto": "", "streetphoto_md5": "", "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": "217", "width": "0", "width_done": "1", "transfer_done": "0" } ], "page": 1, "city": "woodlawnrdandinvernessdr", "country": "onn1e3m1", "offset": 25, "menus": [], "total_count": "1" } ] }, { "file": "/home/friendlylandlord/friendlylandlord/system/CodeIgniter.php", "line": 918, "function": "index", "class": "App\\Controllers\\SortController", "type": "->", "args": [ "woodlawnrdandinvernessdr", "onn1e3m1", 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": [] } ] }