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

Hurlingham 1bedroom own compound to let

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

Ideal bedsitter to rent in ngara near figtree

Bedsitter to rent in ngara fig tree near market very neat and  spacious and all fitted with Wardrobes, Kitchenette, Toilet, Bathroom, A Gate, Small compound. For more info call Victor on 07109816...

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

A lovely maisonette on sale

A four bedroom master ensuite with a balcony house within a nice community with several amenities such as schools,kindergartens,churches etc.the house is surrounded by a gated perimeter wall and has a...

Stunning sparkling 1br ext/sq in hulringham near y

Gated spaciously and newly built one bedroom extension recently finished located at hulringham near yaya center, The sq/ext has a spacious bedroom, living room, kitchen, toilet and bathroomContact; 07...

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