What's Hot

Three bedroom house for sale in kiserian

The house is located behind St. Patrick School, Kiserian It is a three bedroom bungalow master ensuite On eighth acre plot Spacious Unique design Ready clean title deed...

3 bedroom bungalow in a gated community for sale i

The house is in a gated community of 9 houses. It is 3 bedrooms two ensuite. On eighth acre plot, own compound, fence and gate. Perimeter wall Landscaped gardens and parkings Spacious rooms Exce...

House for sale in kitengela opposite epz

The house is three bedroom all ensuite On eighth acre plot Perimeter stone wall Price ? Ksh. 8 million...

Hurlingham 1bedroom own compound to let

hurlingham 1bedroom own compound very clean no agent please...

4 bedroom bungalow on one acre land available for

The house is located along Ngong ? Kiserian road It  is a 4 bedroom bungalow master ensuite on one acre land Mature  lawns/ gardens Mature natural fence Trees along the fence Freehold t...

Half acre plots available for sale in kiserian

The plots are located along Kahara road near St. Patrick School. They measure half acre Each has ready clean freehold title deed Red soil Developed neighbourhood...

A block of flats for sale in ngong with a total mo

It is located in Ngong It has 16 units of 2 bedroom each with total monthly rent of Ksh. 240,000 Built on quarter acre Has got space for further expansion Selling for Ksh. 28 million...

available in Kenya

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

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