New technology to crack down on house-flipping

By | March 10, 2017

Just read an article on cracking down house flipping in NZ, it says “New Zealand’s real estate watchdog is ramping up its crackdown on house-flipping by investing in new technology which allows it to track when properties have been quickly re-sold for huge profits.”

So what’s the new technology is about? You would have thought there is a database table with a simple SQL query like this:

select * from sales_record r1 left join sales_record r2 on r1.title_no = r2.title_no and r1.id < r2.id where datediff(r2.sales_date, r1.sales_date) < 30;

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.