I would like 5-year median price trend data (monthly) extracted for all suburbs across Australia (houses and unit/apartment) contained on www.realestate.com.au. In the dataset I also want you to include the property market insight statistics provided on www.realestate.com.au (i.e. # houses available in the past month, # sold in the past 12 months, # days median time on market, # interested buyers and rental yield (both for houses and unit/apartment). In addition to this I want you to include the owner / renter split that is provided on domain.com.au. I need the data provided in an excel spreadsheet in a neatly formatted way.
Examples of the websites are below:
www.realestate.com.au/nsw/bondi-2026/
www.domain.com.au/suburb-profile/bondi-nsw-2026
Please provide me with the code so I can update this spreadsheet dynamically in the future from my end.