Match listings based on similar addresses and property data

[gabeklavans]

Some brokers list properties with slightly different addresses when they are in actuality the same exact property.

Rough pseudo code idea of how to match:

if new address is a substring of existing address:
    if beds match and baths match and prices match and availabilities match:
        they are actually the same, add this new address's link to the existing address

the first step of determining the address are similar enough could be tricky

additional consideration

some brokers put less information in the address. if this matching algo were implemented, we'd want to take the address that has more information. this could be as simple as updating the address column with whichever address has more characters when a match is found