array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29173218/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173218&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173218/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173218&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23632
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23634
+post_id: "470178"
+post_author: 1
+"ListingKey": "29173218"
+"ListingId": "X12611662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T15:30:28Z"
+"RFModificationTimestamp": "2025-12-09T15:34:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G3"
+"UnparsedAddress": "30A AMOS AVENUE, Waterloo, Ontario N2L5G3"
+"Coordinates": array:2 [
0 => -80.5462165
1 => 43.4567849
]
+"Latitude": 43.4567849
+"Longitude": -80.5462165
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious three-bedroom semi-detached home in a prime Waterloo location. This well-maintained property features a finished basement with a separate entrance, perfect for additional living space or potential income. The modern white eat-in kitchen boasts contemporary finishes and a convenient walkout to an expansive private backyard, ideal for entertaining or relaxation. Located just minutes from uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Costco, and KW Hospital, this home offers the perfect combination of comfort and convenience. Three generous bedrooms provide ample space for families, professionals, or students. The large yard offers endless possibilities for outdoor enjoyment. Easy access to public transit, shopping, dining, and entertainment makes daily life effortless. Don't miss this opportunity to lease a beautiful home in one of Waterloo's most sought-after neighborhoods. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T04:34:48.132778+00:00"
+"Directions": "Cross Streets: Amos and Erb St W. ** Directions: Turn on Amos from Erb St W."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1884502"
+"ListOfficeKey": "50892"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T03:44:28Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T15:17:20Z"
+"Stories": "2.0"
+"StreetName": "Amos"
+"StreetNumber": "30A"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29173218/30a-amos-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2500
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2025-12-09T03:44:28.55Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362362902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/a63e74fa563c5eb139786bf93fcb22d9.webp"
"MediaSize" => 177531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-a63e74fa563c5eb139786bf93fcb22d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362362905"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/8ebb1d8ce26f9e6546c08faaf7d43d0d.webp"
"MediaSize" => 97867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-8ebb1d8ce26f9e6546c08faaf7d43d0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362362910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/a48f24ceb2f9d4ebc1b057a67cd66b34.webp"
"MediaSize" => 168618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-a48f24ceb2f9d4ebc1b057a67cd66b34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362362916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/a1495013848b61ac108f29fd31736299.webp"
"MediaSize" => 156713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-a1495013848b61ac108f29fd31736299.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362362920"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/b31d14024a726e074a6d832bceb31da2.webp"
"MediaSize" => 164849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-b31d14024a726e074a6d832bceb31da2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362362925"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/1a693945c464c565e4bbcda78a567673.webp"
"MediaSize" => 223454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-1a693945c464c565e4bbcda78a567673.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362362931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/172a8eaea547e9d6276a9705a0a1fbaa.webp"
"MediaSize" => 126800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-172a8eaea547e9d6276a9705a0a1fbaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362362937"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/8b89f2a899c7b66f9ccc5cd5795a76cf.webp"
"MediaSize" => 98594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-8b89f2a899c7b66f9ccc5cd5795a76cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362362945"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/91a84eb1df37f5da57b9f34fe6f540e3.webp"
"MediaSize" => 98283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-91a84eb1df37f5da57b9f34fe6f540e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362362954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/ce54f9f9a844f6ae4617705bae34d433.webp"
"MediaSize" => 174422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-ce54f9f9a844f6ae4617705bae34d433.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362362964"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/f9303267024f0578a9dc7b0d5d8c12cb.webp"
"MediaSize" => 115784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-f9303267024f0578a9dc7b0d5d8c12cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362362968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/1424155242d87822b121fafac063b6ed.webp"
"MediaSize" => 109822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-1424155242d87822b121fafac063b6ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362362976"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/bfb81edbbc2f28c1a8bdffc993de2589.webp"
"MediaSize" => 120520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-bfb81edbbc2f28c1a8bdffc993de2589.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362362982"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/98d8f28210f89e1df189807d92c7e523.webp"
"MediaSize" => 163651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-98d8f28210f89e1df189807d92c7e523.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362362989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/7a5e6903c2fc65f75c76e1259eb0b8cd.webp"
"MediaSize" => 137972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-7a5e6903c2fc65f75c76e1259eb0b8cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362363004"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/2553732f087e717d268ee27c02319e71.webp"
"MediaSize" => 119867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-2553732f087e717d268ee27c02319e71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362363012"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/ea8decbd053e3898a75405a3b9b02a5a.webp"
"MediaSize" => 109822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-ea8decbd053e3898a75405a3b9b02a5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362363021"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/4877056e0f2a0eccd013f0f0835a20c4.webp"
"MediaSize" => 106715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-4877056e0f2a0eccd013f0f0835a20c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362363030"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/389c18ecc977190e494b59455f09adac.webp"
"MediaSize" => 165954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-389c18ecc977190e494b59455f09adac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362363039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173218/17e1d56114b2071a03fa4b475e1a5efc.webp"
"MediaSize" => 120191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173218/thumbnail-17e1d56114b2071a03fa4b475e1a5efc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611662"
"ResourceRecordKey" => "29173218"
"ModificationTimestamp" => "2025-12-09T03:44:28.57Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "IGOR MILJANOVIC"
"MemberFirstName" => "IGOR"
"MemberLastName" => "MILJANOVIC"
"MemberMlsId" => "9538306"
"OriginatingSystemName" => 26
"MemberKey" => "1884502"
"ModificationTimestamp" => "2025-12-15T06:30:14Z"
"MemberStatus" => "Active"
"OfficeKey" => "50892"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberOfficePhone" => "416-832-5895"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2010-03-26T01:51:00Z"
"MemberNationalAssociationId" => "1208289"
"OfficeNationalAssociationId" => "1002610"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "HOMELIFE/MIRACLE REALTY LTD"
"OfficePhone" => "416-747-9777"
"OfficeMlsId" => "406000"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "50892"
"ModificationTimestamp" => "2024-10-13T04:32:20Z"
"OfficeAddress1" => "11A-5010 STEELES AVE. WEST"
"OfficeCity" => "TORONTO"
"OfficePostalCode" => "M9V5C6"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "416-747-7135"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1002610"
"FranchiseNationalAssociationId" => "1230687"
"OfficeBrokerNationalAssociationId" => "1051469"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173218')"
+"ID": "470178"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 50892/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50892&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50892/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50892&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25435
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25437
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OfficeEmail": null
+"OfficePhone": "416-747-9777"
+"OfficeMlsId": "406000"
+"ModificationTimestamp": "2024-10-13T04:32:20Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "50892"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "11A-5010 STEELES AVE. WEST"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "TORONTO"
+"OfficePostalCode": "M9V5C6"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1002610"
+"OriginalEntryTimestamp": null
+"OfficeFax": "416-747-7135"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "373643"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "50892"
"SocialMediaUrlOrId" => "http://www.homelifemiracle.com/"
"ModificationTimestamp" => "2024-10-13T03:24:00Z"
]
]
+"FranchiseNationalAssociationId": "1230687"
+"OfficeBrokerNationalAssociationId": "1051469"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('50892')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1884502/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1884502&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1884502/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1884502&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25440
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29173218" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25075
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173218/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173218&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173218/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173218&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25055
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173218 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5462165 43.4567849)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173218 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5462165 43.4567849)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173218 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5462165 43.4567849)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173218 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5462165 43.4567849)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25281
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "481614"
+post_author: 1
+"ListingKey": "29185163"
+"ListingId": "40793762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T19:35:37Z"
+"RFModificationTimestamp": "2025-12-13T22:55:31Z"
+"ListPrice": 685000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1192.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3C2"
+"UnparsedAddress": "67 NORTHMANOR Crescent, Kitchener, Ontario N2N3C2"
+"Coordinates": array:2 [
0 => -80.5497373
1 => 43.4391837
]
+"Latitude": 43.4391837
+"Longitude": -80.5497373
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this detached residence located in a desirable, family-friendly neighbourhood, offering exceptional potential for buyers looking to personalize or invest. Featuring an attached garage with interior access, the main level presents a functional layout with a kitchen and cozy breakfast nook just off the foyer, a spacious dining area, and a sunken living room highlighted by a fireplace and French glass doors. A main-floor powder room adds everyday convenience. The upper level accommodates three bedrooms, including a private primary suite with its own ensuite bath, along with two additional bedrooms and a four-piece bathroom. The finished basement provides valuable additional living space and flexibility. This home offers a solid foundation of generous proportions, and an excellent opportunity to add value and create a customized living space in a sought-after location. Ideally situated close to schools, parks, and a full range of amenities, this property presents a compelling opportunity for renovators, investors, or buyers with vision. Taxes estimated as per city’s website. Property is being sold under Power of Sale. Sold as is, where is. RSA (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T22:55:15.582708+00:00"
+"Directions": "University Ave W & Fischer Hallman Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2142382"
+"ListOfficeKey": "288562"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-13T19:29:37Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T19:29:37Z"
+"Stories": "2.0"
+"StreetName": "NORTHMANOR"
+"StreetNumber": "67"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4260"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1548504813"
"RoomType" => "Bedroom"
"ListingId" => "40793762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.17Z"
]
1 => array:11 [
"RoomKey" => "1548504814"
"RoomType" => "Bedroom"
"ListingId" => "40793762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.17Z"
]
2 => array:11 [
"RoomKey" => "1548504815"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.18Z"
]
3 => array:11 [
"RoomKey" => "1548504816"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.18Z"
]
4 => array:11 [
"RoomKey" => "1548504817"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.18Z"
]
5 => array:11 [
"RoomKey" => "1548504818"
"RoomType" => "Living room"
"ListingId" => "40793762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.19Z"
]
6 => array:11 [
"RoomKey" => "1548504819"
"RoomType" => "Dining room"
"ListingId" => "40793762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.2Z"
]
7 => array:11 [
"RoomKey" => "1548504820"
"RoomType" => "Breakfast"
"ListingId" => "40793762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "6'10'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.21Z"
]
8 => array:11 [
"RoomKey" => "1548504821"
"RoomType" => "Kitchen"
"ListingId" => "40793762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.21Z"
]
9 => array:11 [
"RoomKey" => "1548504822"
"RoomType" => "2pc Bathroom"
"ListingId" => "40793762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29185163"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 2'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-13T19:29:37.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29185163/67-northmanor-crescent-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1192
+"OriginalEntryTimestamp": "2025-12-13T19:29:36.95Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:31 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6367558894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/5c4d1df1b764e9c8459071ca7232c326.webp"
"MediaSize" => 148881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-5c4d1df1b764e9c8459071ca7232c326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6367558947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/95bdc6b50c390be4f91008210bc111b2.webp"
"MediaSize" => 96086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-95bdc6b50c390be4f91008210bc111b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6367558968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/59ea7a1a4bc1546c1d03916fe816b7f8.webp"
"MediaSize" => 137380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-59ea7a1a4bc1546c1d03916fe816b7f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6367559024"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/85279065d1e032e901741f4185595fc0.webp"
"MediaSize" => 145668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-85279065d1e032e901741f4185595fc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6367559095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/df3e0a83ecee6e71d63e02900945ea3b.webp"
"MediaSize" => 123844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-df3e0a83ecee6e71d63e02900945ea3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6367559150"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/2d9f1c1fd7d7fa0a94ca30b92a880d61.webp"
"MediaSize" => 52536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-2d9f1c1fd7d7fa0a94ca30b92a880d61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6367559199"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/c5153e879323ceb58f953377a1944fe6.webp"
"MediaSize" => 80476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-c5153e879323ceb58f953377a1944fe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6367559242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/a78e9c53ec0e2d16f5f1edb9925062eb.webp"
"MediaSize" => 93963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-a78e9c53ec0e2d16f5f1edb9925062eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6367559302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/9d4a4666752b52cd7c72de31a93049b1.webp"
"MediaSize" => 75334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-9d4a4666752b52cd7c72de31a93049b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6367559374"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/4ad3ba2a49038951894d2f9731436069.webp"
"MediaSize" => 106604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-4ad3ba2a49038951894d2f9731436069.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6367559390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/4a5cfdac9220d87604792a4b3a81b894.webp"
"MediaSize" => 59428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-4a5cfdac9220d87604792a4b3a81b894.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6367559487"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/b0c6062b667bfd74245c2966c7692e65.webp"
"MediaSize" => 104828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-b0c6062b667bfd74245c2966c7692e65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6367559537"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/14c1af8a66cf855ef3d90e7c508c00cf.webp"
"MediaSize" => 59726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-14c1af8a66cf855ef3d90e7c508c00cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6367559598"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/3372238b3f0447a81460e23225a9e351.webp"
"MediaSize" => 66311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-3372238b3f0447a81460e23225a9e351.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6367559684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/9a4928c70dd17e74247f68e142b7b3a8.webp"
"MediaSize" => 92746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-9a4928c70dd17e74247f68e142b7b3a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6367559749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/1fe9cf030f0dd30823ed3fb014bab303.webp"
"MediaSize" => 95167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-1fe9cf030f0dd30823ed3fb014bab303.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6367559782"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/55420a76e22167e6ca9cee92c2626210.webp"
"MediaSize" => 77598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-55420a76e22167e6ca9cee92c2626210.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6367559849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/3d0fc929a1c334ff8c1365b4e91c0dc1.webp"
"MediaSize" => 83251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-3d0fc929a1c334ff8c1365b4e91c0dc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6367559910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/b42ecdfab218cc48f517c8977554af30.webp"
"MediaSize" => 82895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-b42ecdfab218cc48f517c8977554af30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6367559967"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/dcb38e0457f9f0f7773e2e3f0bc572f4.webp"
"MediaSize" => 77762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-dcb38e0457f9f0f7773e2e3f0bc572f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6367560023"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/d8a904f633acc3afcbf9c3c60a52db39.webp"
"MediaSize" => 67583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-d8a904f633acc3afcbf9c3c60a52db39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6367560044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/b55c3e5652cf56b530b2e53625008b3b.webp"
"MediaSize" => 64801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-b55c3e5652cf56b530b2e53625008b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6367560115"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/542d1401b6c8ee4e7c1401123faeb242.webp"
"MediaSize" => 61476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-542d1401b6c8ee4e7c1401123faeb242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6367560186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/534947ae33598a9e41e8bf32b6f336a9.webp"
"MediaSize" => 43732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-534947ae33598a9e41e8bf32b6f336a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6367560233"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/4eee5e5daf8ba468f4fbe5db85b0eba6.webp"
"MediaSize" => 58099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-4eee5e5daf8ba468f4fbe5db85b0eba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6367560276"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/cb16fdfeffc28d8e89051f63f8368011.webp"
"MediaSize" => 78747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-cb16fdfeffc28d8e89051f63f8368011.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6367560300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/de3951dc567224a3a294ccf00fd2d207.webp"
"MediaSize" => 81276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-de3951dc567224a3a294ccf00fd2d207.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6367560345"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/1a311c02e5debb52fafba9b1b435ffbb.webp"
"MediaSize" => 80626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-1a311c02e5debb52fafba9b1b435ffbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6367560414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/dc853aaaf174b8009f4f131eac6a555d.webp"
"MediaSize" => 57666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-dc853aaaf174b8009f4f131eac6a555d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6367560477"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/c12720f232d8c6d74180131f3f88c58b.webp"
"MediaSize" => 57471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-c12720f232d8c6d74180131f3f88c58b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6367560519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185163/b0cf2045827d9c5d31ceaefdf2a973d0.webp"
"MediaSize" => 41632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185163/thumbnail-b0cf2045827d9c5d31ceaefdf2a973d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793762"
"ResourceRecordKey" => "29185163"
"ModificationTimestamp" => "2025-12-13T19:29:36.97Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Jessica Magill"
"MemberFirstName" => "Jessica"
"MemberLastName" => "Magill"
"MemberMlsId" => "WR61271"
"OriginatingSystemName" => 26
"MemberKey" => "2142382"
"ModificationTimestamp" => "2025-12-11T01:31:05Z"
"MemberStatus" => "Active"
"OfficeKey" => "288562"
"MemberAOR" => "Cornerstone"
"JobTitle" => "Salesperson"
"MemberFax" => "613-733-3435"
"MemberCity" => "MORRISTON"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-741-1145"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-08-10T17:20:00Z"
"MemberNationalAssociationId" => "1393989"
"OfficeNationalAssociationId" => "1369324"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "SOLID ROCK REALTY"
"OfficePhone" => "855-484-6042"
"OfficeMlsId" => "CA716"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288562"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "26 BADENOCH ST."
"OfficeCity" => "MORRISTON"
"OfficePostalCode" => "N0B2C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "613-733-3435"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:5 [ …5]
"OriginalEntryTimestamp" => "2020-09-14T19:25:00Z"
"OfficeNationalAssociationId" => "1369324"
"OfficeBrokerNationalAssociationId" => "1369330"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29185163')"
+"ID": "481614"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "477610"
+post_author: 1
+"ListingKey": "29183047"
+"ListingId": "40784095"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T18:30:28Z"
+"RFModificationTimestamp": "2025-12-12T20:13:37Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1034.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "223 ERB Street W Unit# 405, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.5362068
1 => 43.4591902
]
+"Latitude": 43.4591902
+"Longitude": -80.5362068
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Warm, welcoming, and easy to live in, this 2-bedroom, 2-bath condo at 223 Erb Street West offers the kind of lifestyle that makes condo living so appealing. The open-concept layout blends a well-appointed kitchen with granite counters, rich cabinetry, and a central island into a bright living and dining space that flows effortlessly onto a private balcony, perfect for morning coffee or winding down at the end of the day. Both bedrooms are generously sized, including a primary suite with its own ensuite, while thoughtful finishes and natural light create a calm, comfortable feel throughout. Beyond the suite, the building elevates everyday living with amenities that extend your space, including a fully equipped gym, party rooms for entertaining, and a rooftop patio where you can relax, socialize, or take in the surroundings. Set in one of Waterloo’s most convenient and walkable locations, you are steps from Uptown shops, cafes, restaurants, trails, and transit, making it easy to stay connected while enjoying the simplicity of condo living. This is a home that balances comfort, convenience, and community, right where you want to be. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "1111.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T20:13:15.309742+00:00"
+"Directions": "Intersection of Erb and Westmount"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564144"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-12T18:02:43Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T18:02:43Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4437.96"
+"VirtualTourURLUnbranded": "https://youriguide.com/vro49_405_223_erb_st_w_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1547968196"
"RoomType" => "5pc Bathroom"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
1 => array:11 [
"RoomKey" => "1547968197"
"RoomType" => "Primary Bedroom"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
2 => array:11 [
"RoomKey" => "1547968198"
"RoomType" => "Bedroom"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
3 => array:11 [
"RoomKey" => "1547968199"
"RoomType" => "Full bathroom"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
4 => array:11 [
"RoomKey" => "1547968200"
"RoomType" => "Laundry room"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
5 => array:11 [
"RoomKey" => "1547968201"
"RoomType" => "Living room"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
6 => array:11 [
"RoomKey" => "1547968202"
"RoomType" => "Eat in kitchen"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:02:43.22Z"
]
7 => array:11 [
"RoomKey" => "1547968203"
"RoomType" => "Foyer"
"ListingId" => "40784095"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29183047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
…2
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29183047/223-erb-street-w-unit-405-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1034
+"OriginalEntryTimestamp": "2025-12-12T18:02:43.18Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183047')"
+"ID": "477610"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24921
+post_id: "474317"
+post_author: 1
+"ListingKey": "29178457"
+"ListingId": "X12616732"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T22:05:16Z"
+"RFModificationTimestamp": "2025-12-10T22:34:27Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B7"
+"UnparsedAddress": "22 - 435 WINCHESTER DRIVE, Waterloo, Ontario N2T0B7"
+"Coordinates": array:2 [
0 => -80.561888
1 => 43.452439
]
+"Latitude": 43.452439
+"Longitude": -80.561888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "DISCOVER LIFE IN THE VILLAGE. A rare executive townhome with over 3,100 sqft. of beautifully finished living space, offering privacy and convenience in a quiet enclave ideal for retirees, or busy professionals. The home makes a strong first impression with its attached double garage and meticulous curb appeal. Inside, you're greeted by an open concept main floor with a bright kitchen featuring granite countertops and ample cabinetry, a welcoming dining area and a living room with a cozy gas fireplace. Large windows fill the space with natural light and provide clear views of McCrae Park. A convenient 2 piece bathroom completes this level. Upstairs, a versatile family room provides additional living space or a dedicated office. The primary bedroom includes a walk-in closet and a luxurious 5 piece ensuite. The second bedroom also features its own walk-in closet and a 4 piece ensuite. The laundry room completes the upper level. The fully finished basement offers a large recreation room and a full 4 piece bathroom. Outside, enjoy a private patio area with a gas BBQ hookup. Living in Beechwood means enjoying one of Waterloo's most desirable and peaceful neighbourhoods, with nearby amenities, top rated schools and quick access to Uptown Waterloo. Homes in The Village rarely come to market, so this is an opportunity not to be missed. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "617.18"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 4
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T22:34:05.078153+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road. ** Directions: Fischer-Hallman Road to Winchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
]
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-12-10T21:55:53Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T21:55:53Z"
+"Stories": "2.0"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8111.22"
+"VirtualTourURLUnbranded": "https://youriguide.com/435_winchester_dr_waterloo_on/"
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29178457/22-435-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"ZoningDescription": "G"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-10T21:55:53.48Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29178457')"
+"ID": "474317"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "473841"
+post_author: 1
+"ListingKey": "29177039"
+"ListingId": "X12615358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T16:35:40Z"
+"RFModificationTimestamp": "2025-12-10T19:41:31Z"
+"ListPrice": 1095000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2L9"
+"UnparsedAddress": "83 INWOOD CRESCENT, Kitchener, Ontario N2M2L9"
+"Coordinates": array:2 [
0 => -80.52736
1 => 43.4471868
]
+"Latitude": 43.4471868
+"Longitude": -80.52736
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your private retreat in one of Kitchener's most picturesque areas! Located in the Westmount neighborhood, this lovely home sits on a lush, shaded lot in a peaceful neighborhood with attached 2 car garage/workshop-offering space, serenity, and the charm of Westmount living. This 4-bedroom, 3-bath bungalow features a first-floor primary suite, a refreshed bath, painted vanity, and stylish new countertops. The main floor also includes a formal dining room, a cozy family room with a custom gas fireplace and south facing picture window complete with custom cushions as well as a separate all-season sun room. The kitchen has been beautifully updated with custom, ceiling-height cabinetry, quartz countertops, and ample storage complete with a pantry. It is designed with entertainment in mind! In the finished basement, you'll find two spacious bedrooms, a flex space, built-in sauna, and pool table. The unfinished storage room provides ample space and is already heated and cooled. Outdoors, enjoy the large, fully fenced backyard, perfect for gardening, pets, or play. The oversized garage can easily fit two vehicles and doubles as a workshop or project space. Carpet-fee floors throughout. Nearby a world-class golf course, shopping and dining, this is a wonderful opportunity to own a spacious, well-maintained home in one of Westmount's most desirable and scenic areas-don't miss it! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:41:16.078435+00:00"
+"Directions": "Cross Streets: Inwood Drive. ** Directions: Glasgow to Inwood Drive to Inwood Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138150"
+"ListOfficeKey": "282801"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sauna"
]
+"LotSizeDimensions": "62.7 x 130 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-10T16:29:11Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T16:29:11Z"
+"Stories": "1.0"
+"StreetName": "Inwood"
+"StreetNumber": "83"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6259.23"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29177039/83-inwood-crescent-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "RA2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 62.8
+"OriginalEntryTimestamp": "2025-12-10T16:29:11.68Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177039')"
+"ID": "473841"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "470664"
+post_author: 1
+"ListingKey": "29173617"
+"ListingId": "X12612020"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T15:25:41Z"
+"RFModificationTimestamp": "2025-12-09T16:59:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "1 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bedrooms available for lease in this beautiful and Cozy End-Unit Townhouse In Desirable Beechwood! List Price is price for each room, including utilities and internet, please contact for details. Main Floor Features A Large, Comfortable Living Space And Newer Kitchen Appliances. Student Welcome, landlord considers short term lease too. (id:62650)"
+"Basement": array:4 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T16:59:14.953589+00:00"
+"Directions": "Cross Streets: Keats Way And Fischer Hallman. ** Directions: Google Map."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091671"
+"ListOfficeKey": "289061"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2025-12-09T15:17:20Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T15:17:20Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29173617/1-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"TotalActualRent": 750
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-09T15:17:20.94Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:7 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173617')"
+"ID": "470664"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24974
+post_id: "470347"
+post_author: 1
+"ListingKey": "29173268"
+"ListingId": "40793031"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T17:50:07Z"
+"RFModificationTimestamp": "2025-12-09T17:51:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1040.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G3"
+"UnparsedAddress": "30 AMOS Avenue Unit# A, Waterloo, Ontario N2L5G3"
+"Coordinates": array:2 [
0 => -80.548616
1 => 43.45845
]
+"Latitude": 43.45845
+"Longitude": -80.548616
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious three-bedroom semi-detached home in a prime Waterloo location. This well-maintained property features a finished basement with a separate entrance, perfect for additional living space or potential income. The modern white eat-in kitchen boasts contemporary finishes and a convenient walkout to an expansive private backyard, ideal for entertaining or relaxation. Located just minutes from uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Costco, and KW Hospital, this home offers the perfect combination of comfort and convenience. Three generous bedrooms provide ample space for families, professionals, or students. The large yard offers endless possibilities for outdoor enjoyment. Easy access to public transit, shopping, dining, and entertainment makes daily life effortless. Don't miss this opportunity to lease a beautiful home in one of Waterloo's most sought-after neighborhoods. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Exterior Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-09T06:54:33.148121+00:00"
+"Directions": "KEATS WAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2111050"
+"ListOfficeKey": "284587"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-12-09T04:29:10Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T17:38:36Z"
+"Stories": "2.0"
+"StreetName": "AMOS"
+"StreetNumber": "30"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29173268/30-amos-avenue-unit-a-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1040
+"OriginalEntryTimestamp": "2025-12-09T04:29:10.3Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173268')"
+"ID": "470347"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+post_id: "465332"
+post_author: 1
+"ListingKey": "29166367"
+"ListingId": "40792612"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T18:30:17Z"
+"RFModificationTimestamp": "2025-12-05T19:03:01Z"
+"ListPrice": 1700000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.26
+"LivingArea": 3602.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5H7"
+"UnparsedAddress": "38 ACADEMY Crescent, Waterloo, Ontario N2L5H7"
+"Coordinates": array:2 [
0 => -80.5565336
1 => 43.4681032
]
+"Latitude": 43.4681032
+"Longitude": -80.5565336
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A masterpiece of design and craftsmanship, with over 3,600 sqft of living space, this executive home in Waterloo’s prestigious Old Beechwood neighbourhood has been completely transformed with over $550,000 in professional renovations. Each level has been meticulously designed, blending timeless elegance with state-of-the-art comfort. Kitchen and basement renovations by the Canadian Home and Renovations Team. Engineered hardwood, custom millwork, and leathered granite finishes anchor a space where luxury meets technology. With a Station Earth AV system, integrated Sonos sound, and smart networking throughout, you’ll know this isn’t a renovation—it’s a reinvention. Curb appeal is undeniable and a ¼-acre pie-shaped lot that widens to 128 feet at the rear. The main floor blends elegance and function, featuring a dedicated home office ideal for today’s flexible lifestyle. The open-concept kitchen/living areas impress with a leathered granite island, quartz backsplash, built-in beverage station, Thermador appliances, and a matching granite fireplace. Sunlit living spaces open to a sprawling deck with pergola dining, outdoor gas fireplace, and BBQ hookup—an effortless flow from indoor comfort to outdoor retreat. Upstairs, 4 bedrooms include spa-inspired bathrooms with heated floors, while the primary suite offers a gas fireplace, ensuite, and integrated Sonos sound. The lower level redefines recreation: a soundproofed theatre with blackout blinds/HD projection, full glass-walled gym, spa bath with sauna/double shower, custom bar with dishwasher/fridge, and den/music lounge with fireplace. Dual laundry areas on the main and lower levels add ultimate convenience. A new furnace, A/C, and tankless water heater (2022) add everyday efficiency to the elegance. Located close to Beechwood trails, Conestoga Mall, St. Jacobs Market, universities, tech hubs, and Uptown Waterloo’s dining and shopping, it offers rare privacy, prestige, and perfection—all in one address. (id:62650)"
+"Appliances": array:1 [
0 => "Wet Bar"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T19:02:53.456364+00:00"
+"Directions": "Old Post Road to Academy Cres"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1565503"
+"ListOfficeKey": "283852"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wet bar"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.26"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T18:00:45Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T18:00:44Z"
+"Stories": "2.0"
+"StreetName": "ACADEMY"
+"StreetNumber": "38"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "8316.05"
+"VirtualTourURLUnbranded": "https://youtu.be/Jvhlx6z7HEQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166367/38-academy-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1565504"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 2414
+"BelowGradeFinishedArea": 1188
+"OriginalEntryTimestamp": "2025-12-05T18:00:44.52Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166367')"
+"ID": "465332"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24910
+post_id: "465049"
+post_author: 1
+"ListingKey": "29165300"
+"ListingId": "40792481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T14:15:40Z"
+"RFModificationTimestamp": "2025-12-05T17:34:52Z"
+"ListPrice": 639900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1814.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6N6"
+"UnparsedAddress": "255 KEATS Way Unit# 701, Waterloo, Ontario N2L6N6"
+"Coordinates": array:2 [
0 => -80.5433895
1 => 43.4620641
]
+"Latitude": 43.4620641
+"Longitude": -80.5433895
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "KEATSWAY ON THE PARK! Welcome to this spacious 1,800 sq. ft. 2 bedroom plus den, 2 bathroom condo situated in desirable neighbourhood within walking distance to University of Waterloo & Laurier! Carpet free with newer vinyl plank flooring throughout. Open concept living/dining/family rooms with sliding door walk-out to large open balcony with panoramic views. Split bedroom floor plan. Spacious primary bedroom with full ensuite and walk-in closet. In-suite laundry and storage room plus storage locker. Two owned parking spots – one underground and one surface! Amenities include exercise room and guest suite. Enjoy a care-free condo lifestyle in a great location near public transit, shops, restaurants & Waterloo park! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "1001"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T17:34:42.943766+00:00"
+"Directions": "Erb Street W. to University Avenue W. to Keats Way"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564177"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-05T14:11:03Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T14:11:03Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "255"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "5585"
+"VirtualTourURLUnbranded": "https://youriguide.com/701_255_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29165300/255-keats-way-unit-701-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1564615"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76831"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Guest Suite"
]
+"ZoningDescription": "RMU 40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1814
+"OriginalEntryTimestamp": "2025-12-05T14:08:54.88Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165300')"
+"ID": "465049"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24980
+post_id: "464895"
+post_author: 1
+"ListingKey": "29165567"
+"ListingId": "40792386"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T16:15:23Z"
+"RFModificationTimestamp": "2025-12-05T16:18:18Z"
+"ListPrice": 559900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1514.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2R7"
+"UnparsedAddress": "284 WESTCOURT Place, Waterloo, Ontario N2L2R7"
+"Coordinates": array:2 [
0 => -80.5409897
1 => 43.4620131
]
+"Latitude": 43.4620131
+"Longitude": -80.5409897
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 284 Westcourt Place, a renovated townhome offering modern finishes, thoughtful upgrades, and unbeatable proximity to both universities and everyday amenities. This move-in-ready home features 4 spacious bedrooms and 3 full bathrooms, including a convenient 3-piece primary ensuite, a 4-piece bathroom on the upper level, and an additional 3-piece bathroom in the finished basement. The extensive 2021 renovation includes all-new plumbing, insulated exterior walls, and the roof was reinsulated., providing comfort, efficiency, and peace of mind for years to come. The open-concept main floor showcases a bright living and dining area, a well-designed kitchen with ample storage and stainless steel appliances. The patio area backs onto a park-like setting, offering natural views and added privacy. The fully finished basement includes extra living space, a full bath, and a sump pump for additional protection. One assigned parking space is included with this property. Located within walking distance to shopping, restaurants, and major bus routes—this home is ideal for families, professionals, or investors seeking a well-upgraded property in an unbeatable location! Low condo fees and a well run condo corporation for peace of mind makes this an excellent choice for investors and parents who want a place for your students attending one of the universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "214"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T16:18:12.781185+00:00"
+"Directions": "Westmount/Father David Bauer Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-05T15:39:17Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T16:03:20Z"
+"Stories": "2.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "284"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3617"
+"VirtualTourURLUnbranded": "https://youriguide.com/284_westcourt_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29165567/284-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1084
+"BelowGradeFinishedArea": 430
+"OriginalEntryTimestamp": "2025-12-05T15:39:17.55Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:25 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165567')"
+"ID": "464895"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 116
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]