hello!
I already have some simple code written which has a url endpoint established for api calls to do blanket searches of properties for sale on zillow. we will have urls that will return a search on zillow with all properties to scrape (working off first page, and iterating through all - but no need to worry about this because it's all done on the api)
basically we end up with a ton of json/table in pandas which includes the properties as rows and associated details as fields/columns)
From there I need coding help with:
(i already have aws hosting that we can host the new DB/tables on)

1. pull properties from given zillow search URL
      ex) active/pending listings in zip code / map area

2. push all data in response to a db w/ only specific fields being copied/imported (not all 200+ columns provided through API) I have  list already

3. filter the search and only add to database if criteria is met (ie - listing status is NOT sold, listing calculated price per sq ft below $XXX), or doesn't contain phrases/words in listing description (ie - rehab, updated, remodeled)

3a. prevent duplicates, somehow only add new entries to the db if they didn't exist in the prior days searches

4. display (doesn't need to be fancy) the table legibly in a password protected page/end point in my website ( ie - elixir-residential.com/search)

5. make sure I know how to add / delete username / password pairs that have access

6. don't display properties unless the person who logs in  matches the elixirRep who is logged in to the page (elixirRepID would be simple?)

7. send a daily email that has two(or more) tables. 1 - First table would be showing new properties added that day. (w/ links for zillowURL to listings), and
2- second table for Key updates for important fields SUCH as very low listing price per sq ft, and aging listings ie) 10 days, 20 days and 30 days stale



Budget: $1,000
Posted On: May 08, 2023 01:41 UTC
Category: Full Stack Development
Skills:Python, SQL, HTML, Java, WordPress
Country: United States
click to apply