Data Updated through 8/27/2006 and Automation Complete.
Data is updated through 8/27/2006.
Also, I finished the automation of the weekly update of sold homes. Lucky thing too, considering I’ll be at Burning Man through the 5th.
« July 2006 | Main | September 2006 »
August 26, 2006
August 20, 2006
Data Updated through 8/20/2006 and News!
Data is updated through August 20th, 2006.
I have exciting news! I passed the real estate sales person exam. I’m through the hard part of getting a real estate license. It’s pretty exciting. Hopefully, I’ll have access to the MLS soon, and before you know it there’ll be more useful data on the website.
August 15, 2006
Data Updated through 8/13/2006
Sorry for the delay on getting the data updated this week. I took the Real Estate Exam this Monday morning and I’ve been studying for it like crazy. I think I did okay, and hopefully pretty soon I’ll have access to the MLS and be able to offer better information and statistics about the houses that I have listed on the site.
As a result of the studying I didn’t make sure the new data got up on Sunday. But it’s up now!
August 09, 2006
Search Tips are Born
Today I put up the Search Tips page. The content is a little rough, but it does provide some search tips. Also, the main page now has questions marks which link into the Search Tips page and describes certain functionality and uses for the area they clicked from. I hope you like it.
Eventually I will add some images and make it more obvious what I’m talking about.
New Design! Engine Changes!
There’s a new layout that’s been pushed up.
I think it looks much better and it will include search tips and some words about the purpose of this website.
I’ve been working on this design for a while. It’s definitely been fun, though I have to tell you that sometimes it can be pretty hard to get everything just exactly as you want it. I know my CSS pretty well, but I not the super expert that might be required to solve the minor issues that I couldn’t get to work exactly perfectly. And wouldn’t you know it, but the problems were both non-compliance by IE. When are they going to follow the standards?
Why do they get away with this?
I hope you enjoy the new design. I know I do. I think it looks much better than the almost ugly old version.
Also, I changed the way the searching works. Before, the AJAX call was grabbing the results from a PHP page that would first go and count the number of records that were possible to be returned, and then it would hit the database again to get the actual records that were going to be returned to the front end. So, two queries that weren’t running asynchronous. Now they are two different AJAX calls and it runs faster. I find it interesting that sometimes the count query doesn’t beat the record set results query, and as a result the notation of how many pages could possibly be returned isn’t listed. But usually it is. There's something really interesting to me about the fact that sometimes it doesn’t return first and sometimes it does. I like slight randomness in programming. Alot.
Also, I built the ability to page through the record results. So, instead of just knowing that you’re not seeing all the results for a particular query, now you can actually flip through the pages, if you wanted. I’m curious to see how many people actually will do that.
You did know that I store the queries that people search on? I don’t recall if I posted that before. I haven’t had a chance to look at that data yet. But I’m excited to look at it and see where and what folks are searching on.
Below find the first version of BayAreaSoldHomes. Stored here for posterity’s sake.
Wow. That image sure looks crappy.
Here's the image if you want to look at the full sized one.