The property market is witnessing the largest drop in housing prices in 12 years in June while mortgage rates still soar.