JOB Description: You will need experience in either MS Excel or Google Sheets beyond the usual. The goal is to match “My list” of properties with “Recently Sold” list within .25 miles of addresses on “My List”. The “My List” will contain addresses without property details such as bedroom, bathroom, square foot, lot size, year built. Your script will need to pull that information from realtor.com or Zillow.com or similar (we’re open to your suggestions) Next, your script will need to measure out distances from each address on “recently sold” against each address on “My List” and only post results on an outcome sheet if the parameters are met. The initial parameters I can think of: Parameters that I can change as I wish. 1. Within _____ miles of my addresses (.25 miles can be the default) 2. Within _____% of square feet (add checkbox “ignore” if I want to skip this step) 3. Within _____% of lot size (add checkbox “ignore” if I want to skip this step) 4. Match type ? – Y/N (Detached (SFR) vs Condo)
The output sheet should make it easy for me to see which property from “recently sold” list is say within .25 miles of any of my addresses from “My list”. It can be a one to many relationship, meaning one address from recently sold can have several properties within .25 miles.