What's Hot

Gudka houses for sale

Gudka houses for sale are located 200 meters from migosi car wash stage. the houses have Maximum security since there is always a security guard during the day and at night. currently we have 12 uni...

250 acres prime land chemelil kisumu

This Chemelil land for sale is a prime land recommended for organizations, institution, farming, industrial development, manufacturing companies etc Features: 250acres in size. 200 meters off t...

Guest house for sale in kilimani, nairobi

The property has got 3 floors within which has got 34 units of self contained fully furnished rooms, a conference hall, a restaurant and four offices and a stand by generator. It is being sold as it i...

Plot in nyalunya for sale

Plot in Nyalunya for sale is located only 100 meters from Nyalunya secondary school and only half a kilometer from the Nairobi-Kisumu main road The land price is 950,000/- (Negotiable) The land ...

Riat land for sale

Very ideal land is up for sale, Riat land for sale is in Riat and only 100 meters off the main kakamega road. The land is 1/2 acres and goes for only Ksh.6.5M (Neg) and a free hold parcel. Slightly ...

Manyatta plot for sale

0.04 Ha plot in manyatta Right along tarmac road towards miracle bridge. This manyatta plot for sale is located just 120 meters from k?oyango market. Fully secure with water,  electricity and ...

0.0232ha nubian land for sale

Nubian land for sale is just along the new kondele bypass which separates manyatta and nubian, it?s approximately 5 minutes drive from the CBD. it is a nice parcel of land in Nubian estate Kisumu ...

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