Everytime, every single time I’ve tried to use Real Estate Websites for real-world stuff they come up short.

Searching, the basic function of the Real Estate Website, just doesn’t work.

I want to buy a house in a suburb. Not a unit, not a duplex, not an apartment.

So I search for houses, and blocks of land. And included in the result set is a semi-detached home. How the hell am I meant to bulldoze one of those? Is this ability to call a semi-detached house a free-standing house unique to only one website?

One site, Domain, doesn’t let you specify that you don’t want semis, so, of a fashion they can be excused. Except they’re missing a feature the other sites give you. So, Domain sucks.

The other two sites, RealEstateView and RealEstate.com.au both suck because they include properties I specifically told them to exclude. “Oh,” I hear you say, “it’s not their fault. The agent put in dud data.” This would be an excuse if the listing fees were a few bucks. But for hundreds of dollars, they can afford to have someone on minimum wage spend a few minutes sanity checking each listing, or they can have text matching algorithms running over the listing looking for words like “detached” and flagging that entry for review because “house” listings ought not include the word “detached”. For example. Or, heaven forbid, allow the users of the site to report misleading listings for subsequent correction. That would be nice. No more million dollar homes turning up in my sub-$600K search.

Part 1 of this (rather long) series of rants was sent to all three websites. None responded, other than with auto-responders. They all suck so much!

Oh God, Real Estate Websites Suck harder than an Electrolux. One little thing after another, they just suck. Today’s example: Search. Senario: I’ve decided to move closer to Daniel, so I want to live in a particular street in a particular suburb.

RealEstateView
I went to www.RealEstateView.com.au, and that worked, of a fashion. I searched for a keyword (the street name) for my desired suburb. No results. Which is fine, it’s a big place and a small street. But how to stay on top of the market – I know, get emailed when a new property turns up. Unfortunately, if there are no results you can’t get emailed in the future. If you get no hits, rather than being offered the chance to be told about this stuff when it comes up, you get told to search again. EBay deals with this problem just fine; you get to save the search and get emails if anything shows up. RealEstateView doesn’t.

I thought I’d outsmarted the website. I signed up for a search that did succeed, with an intention of editing it. I got the email, it said

If you did not request, or do not want, a membership in the
ViewALERT email system, please accept our apologies and
ignore this message. You will be able to de-activate your
membership by clicking the de-activation link on your first
ViewALERT email.

Great, so I can’t edit the search until the search finds something new. Garh!

Defeated, I moved on to:

RealEstate.com.au
Which failed horribly. I couldn’t even do a keyword search. Can’t limit my searches to a single street.

I could get it to email me alerts, with the same crude search terms as on their website (price, bedrooms, suburb). The confirmation email included my username and password. Great. Ten years we’ve been doing this shit, we’ve managed to figure out that’s not how confirmation emails ought to be done, you’re meant to email a link – click on it and it’s clear you’re a human. But no, here’s your details in cleartext. What dickheads.

Next:

Domain
Same problem.

I started The Project primarily so I could learn PHP. I’ve been using ASP (classic and .Net) for a while now, but wanted to try another web development language, preferably one that would be compatible with my dirt cheap web hosting. The way I envisaged it, it would be straight HTML/CSS, no fancy AJAX, using PHP and database lookups.

For development, I set up a Virtual PC with Win2K on it (quickest, best, easiest basic Windows version I had an unused licence for) and put IIS and PHP and MySQL on it. All reasonably easy. For database admin I put on PhpMyAdmin; it’s what runs on my web ISP, and is reasonably easy to use. For the IDE I looked around at Zend and some of the other paid tools, but decided to try DevPHP, a freeware thing, until I figured out if this project was going to fly.

It was all going well until I wanted to do some mod_rewrite fiddling with .htaccess. There are a few things around the place that purport to make mod_rewrite (or an approximation of it) work in IIS, but nothing seemed to do it well. In a fit of rage I ended up removing IIS and going the whole hog and installing Apache instead. It actually runs very well on Windows, and (after re-installing PHP and doing some config fiddling) matches my web ISP much better than any version of IIS could.

After using it for a bit, I also got a bit fed-up with PhpMyAdmin, which is particularly laborious for entering data. It’ll only do two records at a time, and semi-regularly seemed to ignore the second. Then I found the MySql GUI tools, which by comparison are an absolute Godsend. Why did nobody tell me about this before? (Actually it looks like I found a bit of it some time ago, but hadn’t used it properly until now.)

The coding has been coming along nicely, and the basic functionality is ready. I’ve got a couple more enhancements I’d like to do before it goes public.

So what is The Project? Not telling. But it’s aimed at non-geeks, going to be free for users, with Google Adsense to try and pull in some income (and get it indexed quickly). Maybe it’ll pay for itself, maybe not. But even if not, it’s already been successful as a way for me to learn some PHP.

Update 2007-04-19: The Project is now live.

Google for the Enterprise: Google Apps Premier edition is here. $50 / user account / year, providing Gmail, GTalk, GCalendar, GDocs & Spreadsheets, GPage with guaranteed uptimes, phone support and more storage and options.

Favicons: Good article on making a good favicon.

One commenter left a useful link to the PNG2ICO command-line tool. This online tool also looks handy.

RIP: Robert Adler, the man who invented the TV remote control (despite not watching much TV himself, apparently).

A major web site of my acquaintance just got a makeover.

I’m not going to deny it was due for a revamp. Or that (eventually, when it’s all working) the new functionality will be worthwhile.

But apart from the list of data errors (which is as long as your arm), and the functionality they should be providing in this day and age but aren’t, they’ve also changed every single page address, apart from the home page, and so they’re writing to people who link to them to ask them to change hyperlinks.

I’m really trying not to lose my temper and say to them:

“Well WTF did you let your programmers change your URLs in the first place?”

and

“WTF don’t you get your programmers to set up page forwarding so all the old links work?”

I mean really… it’s like changing all the internal phone numbers and telling everybody to ring the switchboard.

Oh, I should mention that this is a public transport information site, with timetables… they have partially-numeric URLs that bear no resemblance to the route numbers.

Web sites must be accessible, under pain of having your ass sued off.

So no more Flash only websites, or implementing everything as images.

In Australia, footy-tipping (be it for NRL or AFL) is very popular. And every Thursday, the leading footytips web site footytips.com.au sends out a reminder notice, which goes something like “We notice you have not entered your tips for this week!”

It’s an attempt in human load balancing. Footy-tipping is, almost by definition, an activity reserved for Fridays. Discussions around the photocopier/water-cooler/kitchenette invariably take place about the fitness of each team in the competition, the players, the injuries, the stats. Close examination of the Friday morning newspapers reveals more information on how people should tip.

All of which means that for sites like footytips.com.au, they need a lot of server capacity on Fridays, when everyone enters their tips, on Mondays, when people look at the results, and for the other five days of the week they’re quiet.

In a way I can understand them wanting to encourage tips entry earlier than Fridays… but it goes against the whole culture of it. Nobody wants to enter their tips on Thursdays. And we all want to look at the results on Mondays. No amount of nagging people to do otherwise is going to work.

Maybe they can find some other application which is really busy from Tuesday to Thursday, and on the weekend, and share their infrastructure?

The Herald-Sun (and most of the News Ltd properties) vastly improved their web site a week or two ago. But they’re obviously having a few issues this morning…

Ah, I see they’ve fixed it already.

Got a well-known brand? Why bother with consistency? Instead, change its name and/or web address for advertising purposes!

It’s not Yahoo Australia … it’s Yahoo!7

Just when you thought you’d got used to ticketmaster7.com, it’s changed back to ticketmaster.com.au

It’s not bigbrother.com.au, it’s bigbrother.3mobile.com.au

It’s not gmail.com, it’s gmail.google.com (just in case you forget what the G stands for)

Within domains it can be a mess too. Microsoft’s site always makes sure the default pages don’t end in / but instead in whatever their latest web server technology is. It used to be /default.asp, then /default.aspx, now it’s /default.mspx. It must be a nightmare of forwarding, to make sure anybody who has bookmarked in the past still gets to where they want. Go to www.microsoft.com/ie now, and it flickers past about 4 old addresses to get where it’s going.

Once upon a time, www.microsoft.com/windows/ie/default.aspx was the IE page. That one just produces an error now. Idiots.

• My old rant about URL design

Databases have long been part and parcel of web development, but it seems that some of the big 2.0 sites have a few things to say on databases. Some love them, others hate them, and all are dealing with really big databases.

Second Life (database has grown and grown and split), Bloglines and memeorandum.com (lovers of flatfiles), Flickr (almost a Tb of data – and we’re ignoring images here), NASA, Craigslist (dealing with masses of data), O’Reilly (doing interesting data mining / transformation), Google (not much gets said here), Findory and Amazon (Findory try to keep it all in RAM), finally MySQL repsonds saying “Flat files suck”

The mob I work for, eVision, are looking for an extra person, so they put an ad on Seek for the position.

Seek’s URLs are broken. The only way to get a URL that you can link to or send to somebody is to use their own “Email this job to a friend” feature and send it to yourself. That way you get a sensible, working URL, such as:

http://www.seek.com.au/showjob.asp?jobid=6946759

rather than the broken one you get by copying it off the browser (even after clicking through the above), which is something like:

http://www.seek.com.au/users/apply/index.ascx?Sequence=82&PageNumber=1&ChannelID=1&SiteID=1&JobId=6946759&Keywords=

which goes to an error page that complains that your browser doesn’t take cookies (even if your browser does take cookies).

Dick Smith Electronics’ otherwise excellent web site suffers from a similar problem.

Jakob Nielsen’s article URL as UI remains as relevant — and as unfollowed — as ever.

Sitepoint tries to figure out how well the Web2.0 works for blind people.

Basically, no US gov website, and none that loves blind people, will be able to implement a AJAX-only site – a noscript verson will have to be available. And this stems from the fact that it’s too hard to make the various screenreaders act in a standard way in response to changes to the document. Which sounds to me to be a perfect problem for World Wide Web Consortium standardisation.