API tools faq
paste
Advertisement
Guest User

Dublin 3-bed, 3-bed semi, 4-bed

a guest
Jun 9th, 2014
516
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.76 KB | None | 0 0
raw download clone embed print report
  1. Dublin 3-bed house
  2.  
  3. select pprsaledate,pprprice,price from HOUSEADDRMATCH where numbeds=3 and region like 'dublin%' order by pprsaledate
  4.  
  5. Month Count avg ask median ask avg sell median sell
  6. 201101 17 283158 265000 243055 225000
  7. 201102 29 313094 295000 286437 270000
  8. 201103 53 298040 280000 266433 256500
  9. 201104 49 320017 310000 280724 280000
  10. 201105 82 311520 277500 275274 250000
  11. 201106 78 317696 272475 280060 252500
  12. 201107 85 310664 295000 275006 248750
  13. 201108 77 316151 295000 278317 250000
  14. 201109 88 300349 292500 259020 247750
  15. 201110 97 285450 270000 243797 230000
  16. 201111 91 312670 250000 267317 207500
  17. 201112 122 271386 245000 234419 210000
  18. 201201 76 267178 259975 226650 212250
  19. 201202 79 247092 225000 209247 185500
  20. 201203 94 256180 225000 221324 200500
  21. 201204 95 281968 244950 241663 215000
  22. 201205 106 251788 230000 217531 196500
  23. 201206 114 240074 230000 215355 208500
  24. 201207 106 284243 252500 259325 236500
  25. 201208 103 263441 249950 235960 217000
  26. 201209 127 273941 250000 252179 220000
  27. 201210 129 248186 230000 223671 209000
  28. 201211 119 246212 215000 226890 200000
  29. 201212 164 274438 249950 258662 236000
  30. 201301 49 283688 230000 264795 210000
  31. 201302 57 251228 225000 234352 195000
  32. 201303 68 240377 214500 223093 185000
  33. 201304 58 270606 237475 253431 235000
  34. 201305 69 256294 219950 240426 212000
  35. 201306 73 260189 205000 233808 190000
  36. 201307 56 243424 225000 228704 195500
  37. 201308 42 255185 232500 231284 219975
  38. 201309 23 256278 225000 235430 220000
  39. 201310 42 248796 212000 236272 205000
  40. 201311 56 283651 259000 275823 247500
  41. 201312 112 313928 275000 312120 278250
  42. 201401 36 264709 219475 264128 221750
  43. 201402 64 310582 295000 316443 301500
  44. 201403 48 282907 250000 286848 252000
  45. 201404 63 276872 249950 280685 251000
  46. 201405 51 267902 225000 289937 243000
  47.  
  48. Dublin 3-bed semi-D
  49.  
  50. select pprsaledate,pprprice,price from HOUSEADDRMATCH where numbeds=3 and region like 'dublin%' and housetypestr='Semi Detached House' order by pprsaledate
  51.  
  52. Month Count avg ask median ask avg sell median sell
  53. 201101 7 281978 259950 256357 225000
  54. 201102 10 349490 310000 322335 284500
  55. 201103 24 305139 289475 275312 269000
  56. 201104 27 355074 345000 317944 315000
  57. 201105 43 310390 285000 276686 251000
  58. 201106 37 326186 295000 283986 270000
  59. 201107 40 305320 299500 268451 263000
  60. 201108 44 325847 295000 291443 251500
  61. 201109 48 294655 299000 256062 263750
  62. 201110 42 307303 295000 262575 245000
  63. 201111 38 316494 287000 270217 230000
  64. 201112 63 274103 260000 240507 220000
  65. 201201 39 299891 299000 253305 243000
  66. 201202 26 284915 245000 242230 204000
  67. 201203 46 275656 244000 244370 215000
  68. 201204 42 293220 259975 261608 233500
  69. 201205 60 265421 249475 229781 215000
  70. 201206 52 259655 252475 234192 226250
  71. 201207 54 289403 279500 265212 258500
  72. 201208 47 270080 265000 245988 232500
  73. 201209 53 253590 237500 232886 210000
  74. 201210 64 268895 254500 248030 228500
  75. 201211 53 273497 259000 251688 220000
  76. 201212 86 283701 255000 269290 241000
  77. 201301 26 262686 244475 251557 227500
  78. 201302 25 291658 239500 273084 211000
  79. 201303 23 247476 230000 227217 210000
  80. 201304 31 294443 250000 280064 262500
  81. 201305 31 286703 249000 270838 226000
  82. 201306 24 292095 254500 263666 238500
  83. 201307 31 258348 240000 241129 225000
  84. 201308 13 282457 269000 275500 280000
  85. 201309 6 273825 267000 233333 227500
  86. 201310 15 266796 240000 257200 233500
  87. 201311 27 289437 263000 274018 245000
  88. 201312 52 289687 269000 289298 261000
  89. 201401 15 242123 224950 254500 238000
  90. 201402 33 335107 300000 337004 314000
  91. 201403 23 289556 255000 294826 272000
  92. 201404 25 294490 250000 302228 262000
  93. 201405 18 356877 352475 391027 393500
  94.  
  95. Dublin 4-bed house
  96.  
  97. select pprsaledate,pprprice,price from HOUSEADDRMATCH where numbeds=4 and region like 'dublin%' order by pprsaledate
  98.  
  99. Month Count avg ask median ask avg sell median sell
  100. 201001 1 285000 285000 357000 357000
  101. 201003 1 329000 329000 343500 343500
  102. 201004 3 878316 389950 714649 350000
  103. 201005 3 339650 289000 326333 290000
  104. 201006 1 1100000 1100000 1500000 1500000
  105. 201007 3 236650 245000 205000 230000
  106. 201008 1 310000 310000 294670 294670
  107. 201009 1 299000 299000 246000 246000
  108. 201010 2 287000 287000 265000 265000
  109. 201011 1 475000 475000 410000 410000
  110. 201012 4 414987 402500 407500 405000
  111. 201101 5 509990 499950 492400 500000
  112. 201102 11 504313 422500 454463 398000
  113. 201103 27 528288 494950 489462 458000
  114. 201104 32 480607 469500 420334 410000
  115. 201105 27 463074 460000 407111 410000
  116. 201106 28 558810 550000 495857 501000
  117. 201107 43 593832 495000 498649 455000
  118. 201108 58 515928 495000 446756 443000
  119. 201109 53 523582 475000 461411 412500
  120. 201110 41 508703 449000 430892 400000
  121. 201111 58 473394 447500 414350 409000
  122. 201112 61 451489 395000 407942 367500
  123. 201201 38 468178 427500 407446 369000
  124. 201202 48 448868 374975 388736 335000
  125. 201203 52 494421 399500 429947 370000
  126. 201204 35 382308 365000 335157 310000
  127. 201205 55 461615 430000 404310 400000
  128. 201206 45 433397 405000 384950 378000
  129. 201207 61 446014 365000 410001 351211
  130. 201208 65 395530 375000 356544 350000
  131. 201209 45 420438 395000 393554 365000
  132. 201210 52 422189 387500 395923 357750
  133. 201211 61 419218 375000 394330 362500
  134. 201212 88 447746 399000 415534 401000
  135. 201301 26 454536 449500 435638 481250
  136. 201302 30 434958 362475 395083 332500
  137. 201303 40 439360 395000 406087 390000
  138. 201304 42 507057 425000 448998 406000
  139. 201305 26 451190 435000 437538 418250
  140. 201306 34 447541 408500 415330 376375
  141. 201307 35 448854 399000 412585 365000
  142. 201308 25 624120 479000 552140 443000
  143. 201309 19 430200 350000 395000 367500
  144. 201310 20 416370 395000 396700 391500
  145. 201311 32 511982 440000 509925 443500
  146. 201312 48 466516 430000 460625 410000
  147. 201401 29 437368 395000 423502 392000
  148. 201402 25 502558 460000 478853 484000
  149. 201403 27 608424 485000 558740 440000
  150. 201404 37 471186 395000 470159 403000
  151. 201405 15 576000 495000 580769 515000
  152.  
  153. 10-Jun-2014 04:06:15 INFO: ...end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!