Jump to content
House Price Crash Forum

ASBEAR

Members
  • Content Count

    68
  • Joined

  • Last visited

About ASBEAR

  • Rank
    HPC Poster

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. This is very close to where I live. It is actaully horrible place to live as the bar on the ground floor is always packed with drunken loud lads and they scream laugh smoke all evening/night long. Selling the flat must be a huge scam IMHO.
  2. Great news!! We may be able to see a negative annual change % in 2 to 3 months!
  3. No I don't. The number for the last months are not matching anyway. the total recode count is 215032 in the file. That's significantly lower than what it should be. It should be around 350000. Probably the land registery's data is not reliable source for this kind of analysis.
  4. I imported the 2017 data set from the link to my local DB and ran some quick queries with no location filter. https://www.gov.uk/government/news/april-2017-price-paid-data Downloaded the data set in "Yearly file: 2017" section in the following link. https://www.gov.uk/government/statistical-data-sets/price-paid-data-downloads The transaction for April look incredibly low, probably it's because the data for recent months are filled months after? I am not completely sure about it. The general query looks like this: select to_char(deed_date, 'YYYY-MM') as month, round(avg(price_paid),2) as avg_price, count(*) as transaction from sold_prices where property_type='D' group by 1 order by month; I may be able to run the queries later today if you want the data for any specific location. Detached month | avg_price | transaction ---------+-----------+------------- 2017-01 | 401349.09 | 13592 2017-02 | 392968.34 | 13556 2017-03 | 394783.04 | 13760 2017-04 | 417157.10 | 5232 (4 rows) Semi Detached month | avg_price | transaction ---------+-----------+------------- 2017-01 | 246650.81 | 16190 2017-02 | 241539.58 | 16398 2017-03 | 244499.75 | 17763 2017-04 | 248079.05 | 6101 (4 rows) Terrassed month | avg_price | transaction ---------+-----------+------------- 2017-01 | 233406.91 | 17710 2017-02 | 228484.84 | 17944 2017-03 | 224308.96 | 19537 2017-04 | 237340.87 | 6670 (4 rows) Flat month | avg_price | transaction ---------+-----------+------------- 2017-01 | 293365.02 | 11592 2017-02 | 292891.27 | 11558 2017-03 | 273240.36 | 11100 2017-04 | 308446.53 | 3254 (4 rows) Office (?), property_type='O' month | avg_price | transaction ---------+------------+------------- 2017-01 | 922368.07 | 4008 2017-02 | 942865.89 | 3631 2017-03 | 1028779.93 | 4147 2017-04 | 873061.05 | 1289 (4 rows) New build month | avg_price | transaction ---------+-----------+------------- 2017-01 | 336457.11 | 4098 2017-02 | 374470.36 | 3450 2017-03 | 322135.91 | 1884 2017-04 | 231411.05 | 184 (4 rows) Existing property month | avg_price | transaction ---------+-----------+------------- 2017-01 | 327165.26 | 58994 2017-02 | 316995.11 | 59637 2017-03 | 323642.21 | 64423 2017-04 | 329382.03 | 22362 (4 rows)
  5. This report is really smelly. I feel it is massively tailored. For instance, 'average time to sell means' nothing when only good properties are being sold, because recently I saw massive amount of properties have been re-listed by new or even the same EA after being not sold for many months. Of course the 'date listed' are all reset. Evil. 'Average stock per agent' is really not useful when it includes 'sold STC' without any indicator. How many of that are sold STC and how many are not. I didn't want to believe Rightmove is biasing the market report but now I am more than certain they are.
  6. 8% this year. Btw anyone knows how to check if I have been paying more tax than I had to? I have been a full time employee for the last 8 years, and now wondering if I could get back any money. Do I need to hire an accountant for it? Is there any no win no fee solution?
  7. Dunno why mine looks different. What's the options you gave for that?
  8. I've just created one for you. You can create the chart here http://hpc.soboru.co.uk/
  9. It looks flat but it has actually fallen considering the inflation. But I want to see REAL fall soon!
  10. I've updated http://hpc.soboru.co.uk/ to grab the new Land Registry data. London's annual change is just about to back to 2011. Sales volume has been already as low as 2011. Sold price is falling. I can't wait to see the next month's graph.
  11. Just checked the last sold price and it was 20% cheaper last year. WTF.
  12. Never seen this price in this area for at least 2 years. Usually above 370k for houses even in much lower quality. http://www.rightmove.co.uk/s6p/58722841
  13. London is falling, while other area arent. AFAIK this data is based on the initial asking price? I just heard but not sure. http://www.home.co.uk/asking_price_index/HAPIndex_MAY17.pdf
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.