What's Hot

Kitengela prime acres next to kampala internationa

These plots are located at Kisaju area a few meters from the Nairobi-Namanga tarmac road . Behind Millenium Hotel and adjacent to Kampala International University.This is a most desirable area due to ...

Real estate

We are Seller Agents Specializing in Residential Property: Residential Bungalows, Residential Apartment, Land for Sale, Industrial Land, Maisonettes, Commercial Land, Furnished Apartment Special...

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

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

3 brm bungalow for sale

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

Karen- 29 acres for sale

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

available in Kenya

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

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