What's Hot

Ngong, matasia 3 bedroom house to let - ksh. 25,00

The house is 300 metres off Ngong-Kiserian road between Matasia and Kiserian It is near matatu stage i.e. very accessible even by public transport means. It is a spacious  3 bedrooms ma...

Ongata rongai plot for sale

Ongata Rongai plot ?Quick Sale Strategically located minutes to Rongai shopping centre, this plot is your perfect investment especially for redevelopment to accrue rental income. Features: ...

1/8 acre plot

1/8 acre plot with very good soil for agriculture or to build a home. Area  is developed and secure with AP police post nearby. Electricity on site....

4 bedrooom mansion for sale @ 15m

The Mansion sits on a 1/4 acre secured with a perimeter stone wall,tiled and with water and electricity....

4 bedrooms ( 2 ensuite ) maisonette for sale in ru

It is a newly built maisonette 4 bedrooms ( 2 ensuite) all bedroom with inbuilt wardrobes and master with walk in wardrobes Two balcony -sunken lounge -Guest cloakroom cabro pa...

Socian villas 3br plus dsq kileleshwa

Socian Villas 3br plus DSQ in Kileleshwa Socian villas is a latest addition to the remarkable development of Nairobi. A striking residential apartment complex of 3-bedroom apartments (with...

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 ...

available in Kenya

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

- 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 > 1435750299 ORDER BY rand() limit 0,4' at line 1
Related in Kenya