This Knol written by Will Johnson, wjhonson@aol.com, as an example of how to use Trulia URL's to generate lists of for-sale and sold properties in various locations.
Real Estate For Sale in Snohomish County, Washington
Focusing on Zip Code 98201
- 98201 (Everett, Washington)
- All properties, Single-family homes, Condos, Townhouses, Lot or Land, Multi-Family
- (This is a city area, having no mobile homes in this zip code.)
[Edit]
Trulia also has a way of viewing Recently Sold homes, but when I tried it for these zip codes I didn't see anything, even though I know there are recently sold homes. I suspect that in order for that to work, they need a partner in that area, willing to provide them with the data, and probably not all areas have such partners yet. However for an example of the Recently Sold homes link look at this one for the 95003 zip code. The URL, for which they get a high mark, is very simple, just http://www.trulia.com/sold/95003_zip/
Domania however, which I thought was a dead site, does show recent sales for 98201, but they don't allow deep-linking so I can't show you! You have to go there, enter the zip and then *guess* at a street address in that zip. (Stupid, stupid.)
On the other hand, a new site I've just found called Zillow is showing recent sales for Everett, WA. And appears to be relatively up-to-date and complete. They can also do it by Zip code, this search is for 98201. Now if you have a site that is hard to use, Domania, competing with a site which is easy to use Zillow, who is going to win out? Yes....
The URLs however for their properties for-sale aren't as simple :
- http://www.trulia.com/for_sale/98201_zip/price;a_sort/
- http://www.trulia.com/for_sale/98201_zip/SINGLE-FAMILY_HOME_type/price;a_sort/
- http://www.trulia.com/for_sale/98201_zip/CONDO_type/price;a_sort/
- http://www.trulia.com/for_sale/98201_zip/TOWNHOUSE_type/price;a_sort/
- http://www.trulia.com/for_sale/98201_zip/LOT%7CLAND_type/price;a_sort/
- http://www.trulia.com/for_sale/98201_zip/MULTI-FAMILY_type/price;a_sort/
[Edit]
As a computer programmer myself, I can say that you really do not need to say "zip" or "type" in the above. It's redundant. No one is going to mistake "Multi-Family" for a zip code for example. Also is it really necessary to capitalize those types? And finally, wouldn't a simple code like "Multi-Family"=3 be a lot easier? OK anyway, it's better than other sites I've tried which don't even allow deep-linking.
The Snohomish County Assessor / Treasurer Parcel Inquiry system is at this link, where you can see what the current taxes are, verify the square footage, see past transactions, etc. That website is quite buggy and I wish they'd fix it, but at least it's better than nothing. The map will often not move when you want it to move, not zoom up or down when you tell it to, and sometimes inexplicably takes you to somewhere to which you didn't tell it to go. Sometimes I would like to look at a map of sales in an area, but don't know an exact address for that area. It doesn't appear that you can select an area by zip code, so you just have to make a guess and then move the map around once it appears. Once it does pop up, on the side there are toggle boxes for recent sales, and also toggles to show street address instead of parcel number.
In the table below I'm going to start charting how the prices are changing over time, hopefully I can keep this update at least once a week. For each property type below, the table shows the number of those properties currently for sale, and then the median price for that type of property.
[Edit]
On 29 Jan 10, we see a few interesting changes. The total inventory dropped by over ten percent, while the median prices also dropped. In a normal market, what this would mean, is that people are buying the mid-to-upper price houses faster, pulling them off the market, and overlooking the lower priced ones. Meanwhile, those holding the lower priced units, may be dropping their prices a bit as well. In a very soft market, however, this could mean that those people holding the upper priced houses, are delisting them without selling, while those holding the lower priced ones are not.
All Properties | Single-family homes | Condos | Cheapest Condo | ||||
Date | No. | Median | No. | Median | No. | Median | |
27 Dec 09 | 272 | $224.6 | 182 | $220 | 26 | $199 | |
13 Jan 10 | 277 | $222 | 192 | $215 | 28 | $229 | |
29 Jan 10 | 247 | $207 | 140 | $205 | 29 | $189 | |
08 Feb 10 | 256 | $219 | 182 | $211 | 21 | $204 | $80 |
10 Sep 10 | 353 | $212 | 205 | $209 | 34 | $166 | $105 |
15 Dec 10 | 325 | $189 | 174 | $198 | 29 | $149 | $100 |
25 Jan 11 | 332 | $187 | 200 | $188 | 29 | $164 | $60 |
15 Feb 11 | 347 | $168 | 219 | $170 | 37 | $143 | $60 |
18 Mar 11 | 339 | $167 | 210 | $168 | 35 | $137 | $60 |
[Edit]
I need a new chart for "cheapest" I think. The cheapest Condo in 98201 as of 1 Mar 2010 is 1304 Chestnut St #8 now reduced to only $80,000. That is dirt cheap, especially when you consider that you could most likely rent it (800 ft, 2 bed) for about $800 to $900 per month. That's a positive cash-flow even with no money down. I'm sure they are losing money on that if they bought it within the past six years. This condo is now (June 2010) marked Sale Pending.
The cheapest condo as of 1 Jun 2010 is 2609 W Marine View Dr #4, Everett WA which is now only $80,000 for a 2 bed, 900 ft. You could rent that for about $800 to $900. The mortgage is only going to be maybe $450 with no money down.
The cheapest condo as of 10 Sep 2010 is an auction foreclosure on Grand Avenue which is now only $105,000 for 697 ft. which would seem to mean that the cheapest units are being snapped up. The best cheap deal however is 2902 13th St #5D, Everett WA which is $110 for a 1028 ft 2 bedroom. That could rent for about $900 a month and the mortgage is only going to be maybe $450 with 20% down. Easy cash-flow. Oops, it's been reduced to only $105 now.
Update 18 Mar 2011, I don't know what's going on at that Highland Avenue complex but it's weird. Maybe they are having financial problems, but three condos are in there for dirt dirt cheap and not selling. As you can see, the whole condo market isn't being dragged down by them, so there's something particular that is wrong with them, I just don't know what it is.