What's Hot

Nyari central, nairobi - 6 bedrooms(all ensuite) a

This stunning Ambassadorial Mansion is unlike any other property on the market - the design features and finishes put these properties miles ahead of the rest, in a class of their own. Key Featu...

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

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

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

available in Kenya

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

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