I've just heard today about DealPlumber.com - it seems a good example of smart aggregation in a number of different ways, perhaps one of the things you're looking for.
You know, I really really wanted that to be a site to get a plumber - some sort of locality vs auction market for plumbers who have a spare couple of hours between bigger jobs type thing. You never need a plumber until you need one...