Neva Crystall's Neva Sky Villi is a one of the best residential sims I have visited in Second Life. In fact, some parts are breathtaking. The village consists of square blocks which are linked together by bridges, boatways, and canals. At first, the square grid can seem overwhelming, but after you get used to the concept of the design, it all makes very good sense. The mesh detailing results in a very high level of realism. The village looks great in autumn colors, and is highly recommended for a visit.
I assume that places are available for rental here, or that a waiting list might be maintained, but be aware that this could be a German-speaking sim - I am not sure.