Vancouver West Apartments.
Vancouver East Apartments
West Vancouver Townhouses
East Vancouver Townhouses.
West Vancouver Houses
East Vancouver Houses
I received this wonderful email yesterday from a regular reader. Clearly there are some technically gifted individuals out there.
I'm a regular reader of your blog; haven't posted, but I really enjoy your writing. I'm writing to you on e-mail because I don't know how to post attachments to your blog.
Recently I wrote a program to grab all the current listings in the Vancouver area (City of Vancouver only so far) from the MLS site, including price, lot size, number of bedrooms, bathrooms, and house age. As of October 13, there were 3196 listings in the CoV.
I've attached a summary figure, which you're welcome to post on your blog, which shows the distribution of list prices (as of Oct 13, 07) by sub area. Its in the format of a box plot, which divides list prices in each MLS sub-area into quartiles, and shows the median list price. Outliers are also shown as open circles. The "whiskers"outside of each box show the distance to the closest outlier (defined as a point that is at least one and a half times the size of the full box away from the median).
With data on other attributes of each listing, I was also able to conduct a cross-sectional regression to determine "normalized" house prices in each area. Based on these regressions, I produced some estimates for several types of houses in both East and West Vancouver (i.e., a quality-corrected index):
For a 25 year old 3 bedroom house,
in Vancouver West - $1,373,455
in Vancouver East - $747,221
For a new 4 bedroom house,
in Vancouver West - $1,475,377
in Vancouver East - $849,142
For a 10 year old 2 bedroom apartment
in Vancouver West - $866,183
in Vancouver East - $239,049
...
Anyway, I've automated this, so should be able to produce a quality adjusted estimate of the change in list prices month on month. Thought I'd share it :)
I'm a regular reader of your blog; haven't posted, but I really enjoy your writing. I'm writing to you on e-mail because I don't know how to post attachments to your blog.
Recently I wrote a program to grab all the current listings in the Vancouver area (City of Vancouver only so far) from the MLS site, including price, lot size, number of bedrooms, bathrooms, and house age. As of October 13, there were 3196 listings in the CoV.
I've attached a summary figure, which you're welcome to post on your blog, which shows the distribution of list prices (as of Oct 13, 07) by sub area. Its in the format of a box plot, which divides list prices in each MLS sub-area into quartiles, and shows the median list price. Outliers are also shown as open circles. The "whiskers"outside of each box show the distance to the closest outlier (defined as a point that is at least one and a half times the size of the full box away from the median).
With data on other attributes of each listing, I was also able to conduct a cross-sectional regression to determine "normalized" house prices in each area. Based on these regressions, I produced some estimates for several types of houses in both East and West Vancouver (i.e., a quality-corrected index):
For a 25 year old 3 bedroom house,
in Vancouver West - $1,373,455
in Vancouver East - $747,221
For a new 4 bedroom house,
in Vancouver West - $1,475,377
in Vancouver East - $849,142
For a 10 year old 2 bedroom apartment
in Vancouver West - $866,183
in Vancouver East - $239,049
...
Anyway, I've automated this, so should be able to produce a quality adjusted estimate of the change in list prices month on month. Thought I'd share it :)
No comments:
Post a Comment