Limekiln Rd is actually quite long. Comparing the Terenure end and the Greenhills end, one seems quite far from the city centre, the other is quite close, relatively speaking.
As others have said, for the location you will not beat Limekiln in terms of value. Half a kilometre down the road will cost you another €200k. Relatively speaking it is very close to the city centre - you'd cycle in around 15/20 minutes, and you could walk all the way in, in an hour or less.
Had a look at one there myself back in March;
Absolutely massive south facing rear Garden. House itself needed gutting, but the amount of potential there was enormous. In the end we didn't even bother offering because it's in the catchment area for St. Paul's, and schools are one of our main factors.
The €475k one
mentioned above showed what could be done with these houses - their asking was way too high, but at the same time it's a stunning property.