What's Hot

7 bedroom maisonette at kasarani off thika superhi

Carefully tucked in the lavish Kasarani area off Thika Superhighway, only 10minutes drive to Nairobi CBD stands this magnificent maisonette on own compound! Features and amenities This house c...

New 3 bedroom apartment for rent

3 bedroom unfurnished apartment, master ensuite, secure with ample parking and water, fitted wardrobes and adequate kitchen,available immediately....

Prime plot for sale

this is a 3 acre land situated in a well developed area ( syokimau ) 400 mtrs off mombasa rd opp kenya civil aviation authority and 800 km from nairobi town...

3 brm bungalow for sale

3 bedroomed Bungalow.40*80 very prime areaKiambu TownHave underground room 12ft*9ftOld town KiambuNewly constructed Hse 98% finished....

Office/salon space to let

spacious office/salon space to let can also be used as a chemist or boutique 0724323293...

Karen- 29 acres for sale

KAREN- OLOLUA RIDGE- 29 ACRES FOR SALE- KSH. 45M P.A...

Office/salon space to let

spacious office/salon space to let can also be used as a chemist or boutique 0724323293...

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