What's Hot

7 bedroom ensuite for sale, mukuyu, next to maguna

7 bedroom ensuite build (each with a toilet and a bathroom) built on 800mt sq. Mukuyu, Muranga a few meters from Magunandu supermarket on 0.36 acres...

3 bedroom bungalow on sale

ceramic tiles 3 bedroomed master ensuite, 45 min to cbd, secure place opposite casa mia ruai estate in built warddrobes & kitchen cabinets in its own compound on a 1/8 acre land...

3bedroom for sale in matasia-ngong.

This house sits on an 1/8 of an acre. It is located in Matasia about 300mtrs from Ngong-Kiserian road, a very secure and serene environment. It is near shopping centres n not far from tuskys super...

Quick sale!!!! 1/8 acres in kajiado

This piece of land is located 2km from Kajiado tow and 800 from the tarmac.All social amenities are located nearby.Ideal for commercial development which can tap potential businesses from the tarmac.A...

3 bedroom bungalow on sale

ceramic tiles 3 bedroomed master ensuite, 45 min to cbd, secure place opposite casa mia ruai estate in built warddrobes & kitchen cabinets in its own compound on a 1/8 acre land...

Au-pair/ house keepers / nanny / driver & hotel a

AU-PAIR/ HOUSE KEEPERS / NANNY / DRIVER & HOTEL ATTENDANT ARE WANTED URGENTLY. *WE WANT TO EMPLOY THE SERVICES OF AN AUPAIR /BABYSITTER/TEACHER/ GARDENER/SECURITY/NURSING/CAREGIVER/NANNY/DRIVER/HO...

Serenity in nature

5 Bedroom all ensuite house with a 2 bedroom guest house on ? acre property, off Kuwinda Road, Karen. It sits next to the wetland where you can see lots of birds and enjoy amazing sunsets (weather per...

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