What's Hot

2 bed apartment in syokimau

Tastefully done are these 2br apartments in a gated community less than 1km from Mombasa road at syokimau Features an amenities -Lovely spacious dining and lounge -Spacious kitchen opening ...

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

3 bedroom apartment in killeleshwa

This is a magnificent and  spacious  newly built 3 bedroom apartment all en-suite with panoramic views near kasuku centre in kileleshwa. Features;Spacious Lounge and dinning rooms,Modern kit...

Office space and shop to let

Magharibi Place offers contemporary office space within a new mixed use complexIt is strategically located along Langata road off Mai mahiu road and opposite Tmall.This commercial complex is easily ac...

3 bedroom apartment in kilimani

Strategically located in the leafy suburbs of the prestigious Lavington stand these luxurious apartments in a quiet neighborhood just behind valley arcade Features and Amenities: -Very large lounge an...

Kileleshwa 0.5 acrea

This is a 0.5 acre prime plot for sale in a prestigious and serene location at the heart of Kileleshwa. It is in a strategic located neighboring; Kenton International School, Kileleshwa Primary School...

4 bedroom stand alone in loresho

This is a magnificent 4 Bedroom stand alone house strategically located in the prime and prestigious Loresho locality occupying 0.5 acre land.Features4 Spacious Bedrooms all en-suiteLarge loungeDinnin...

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