Reapit API response a property twice

[hoangnguyentci]

Describe the bug
Reapit API response a property twice

To Reproduce
Steps to reproduce:

Call API: https://platform.reapit.cloud/properties/?id=BLV241297
Property ID BLV241297 appear twice in the response and the count is wrong:

"pageNumber": 1,
    "pageSize": 25,
    "pageCount": 2,
    "totalPageCount": 1,
    "totalCount": 1,
    "_links": {
        "self": {
            "href": "/properties/?PageNumber=1&PageSize=25&id=BLV241297"
        },
        "first": {
            "href": "/properties/?PageNumber=1&PageSize=25&id=BLV241297"
        }
    }

prop_id_BLV241297.json

Expected behaviour
Property ID BLV241297 should appear once in the response

Screenshots

Device (please complete the following information for web issues):

• Device: [e.g. iPhone6, PC, Mac]
• OS: [e.g. iOS8.1]
• Browser [e.g. Chrome, Safari]
• Version [e.g. 22]

Additional context
Customer agent_name":"Romans" and client_code:"ROM"

[github-actions]

Thank you for taking the time to report a bug. We prioritise bugs depending on the severity and implications, so please ensure that you have provided as much information as possible. If you haven’t already, it really helps us to investigate the bug you have reported if you provide ‘Steps to Replicate’ and any associated screenshots.
Please ensure any personal information from the production database is obscured when submitting screenshots.
This issue will be reviewed in our weekly refinement sessions and assigned to a specific project board. We may also update the ticket to request additional information, if required.
For more information on our processes, please click here

[AshDeeming]

Migrated: PBI-5852

[AshDeeming]

Developer note/update; There are 11 properties for this customer which have superfluous records in the 'matinfo' table, most of which pre-date the ability to update this information via API and likely reflect a defect in CRM