Dublin hse+apt

Dublin all house and apartment

select pprsaledate,pprprice,price from ppr as p, myhomeunique as u, myhomederived as d where p.canonaddress = u.canonaddress and u.myhomeid = d.myhomeid and p.pprnotfull = false and (d.housetype = 0 or d.housetype = 1) and region like 'dublin%' order by pprsaledate

Month	Count	avg ask	median ask	avg sell	median sell
201101	25	355946	295000	318078	275000
201102	52	374597	327475	336659	300000
201103	106	360669	299475	327983	278625
201104	114	361983	335000	324107	297500
201105	140	348081	299975	306646	263500
201106	148	387667	299000	337260	270000
201107	176	403911	320000	349902	288250
201108	169	393303	339000	341571	285000
201109	202	365108	313750	322307	274500
201110	181	347598	289950	298070	240000
201111	200	344444	282500	296707	235000
201112	244	330886	268250	287497	228750
201201	163	353650	289950	305338	245000
201202	175	317644	270000	273758	225000
201203	186	329961	255000	284990	220000
201204	174	330251	246250	276928	220000
201205	218	330023	252500	285802	220000
201206	215	285354	249000	253461	220000
201207	235	351584	285000	315388	257500
201208	252	300673	262500	262532	227500
201209	241	311924	259500	291738	238500
201210	243	289238	250000	263470	225000
201211	285	292136	235000	276024	217000
201212	360	341291	275000	322454	250000
201301	120	331687	249950	309994	225000
201302	133	297854	240000	275522	220000
201303	168	303338	237000	283088	213424
201304	153	357608	270000	331729	257500
201305	144	346803	249975	319695	228000
201306	145	331826	265000	301908	229000
201307	144	323293	250000	294832	227750
201308	99	351582	269000	315252	250000
201309	75	344141	295000	315238	248000
201310	97	330918	260000	315561	250000
201311	135	358790	270000	347127	270000
201312	240	370948	295000	370344	288000
201401	101	324981	259000	317882	246000
201402	132	341447	295000	337028	290000
201403	121	360354	255000	356330	270000
201404	138	362715	299975	369028	300000
201405	98	351551	262500	373916	266000

10-Jun-2014 04:06:15 INFO: ...end