What's Hot

3 bedrooms apartment for sale at dagoretti corner,

The apartment in a block located at Dagoretti corner off Naivasha road near Nakumatt Junction and Riara school It is three bedrooms master ensuite Newly built Steady water supply from piped city co...

Kitengela opposite epz 4 bedroomsall ensuite bunga

It is a newly built 4 bedrooms bungalow All the 4 bedrooms are ensuite. Ceramic tiling on entire floor Spacious Kitchen with double sink, worktop, high and low level cabinets Perimter wall. Loca...

Loresho 4 bedrooms maisonette to let

four bedroom house to let along waiyaki way few minutes drive from westlands Master ensuit with Jacuzi Ample Parking In a gated community with Security Renting at Ksh 90,000 Per Month...

Ruiru eighth acre residential plot for sale ksh. 1

The plot is located inside Ukombozi Green Gardens Estate off Ruiru - Githunguri road. It measures Eighth of an acre(50 by 100 feet). Red soil. Clean title deed....

Kitengela , milmani area: three bedroom house for

The house is located in Kitengela, Milimani area 200 metres from Namanga road It is a three bedrooms bungalow Master bedroom Price - Ksh. 5.4 million...

Dagoretti plot for sale

We have approximate 1/4 acre plot 100m from the mainroad and within Ruthimitu/gachui shopping centre. Selling price kshs. 4,700,000 neg. the title is freehold and the plot is vacant at moment....

Kitengela eighth acre plots for sale ksh. 450,000

They are 70 plots measuring eighth acre (50 by 100 feet) each. Located 10km behind Kitengela centre. All the plots have ready title deeds. Few remaining...

available in Kenya

Guest | | views | ref: PU29358 Contact Seller
Property TypeTransaction TypePrice (Kshs)
RegionLocationRoad
UpdatedViewsRef. No.
PU29358

- Description

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and prop_renewdate > 1414635199 ORDER BY rand() limit 0,4' at line 1
Related in Kenya