What's Hot

1 and 1/4 acre and 3 bedroom house

1 and 1/4 acre with 3 bedroom house, along Magadi road next to St.Patrick hills school. Excellent home...

11 acres kikambala creek with amazing view of ocea

This beautiful ocean front 11 Acre property for sale in Kikambala, 7kms ahead of Royal Reserve is full of privacy and no disturbance from town life. Located on a creek, it is ideal for apartments or a...

Kanamai beach front 6.42 acres prime property for

The above property is being advertised for sale through our company. All beach front sitting in a prime area, ideal for an apartment project. It shares the access road of Jumia Beach Resort and Royal ...

325 acres in eldoret, suitable for a housing proje

We at Tanesville hereby offer for sale a 325 Acre property divided into 2x100Acre and 125Acre of farmland. The land is very fertile and has excellent produce when farmed. The land is located in the po...

5 bedroom town houses to let

These are superbly done 5  bedroom all en suite town houses with spacious gardens in the up market....

Furnished apartments in garden estate nairobi

Fully Furnished Apartments in Garden Estate with wi-fi Internet, DSTV and beautiful gardens.Rates:1 Br - Kshs. 60,000/-2 Br - Kshs. 70.000/-2Br Executive - Kshs. 85,000/-...

Hotel job hiring !!! hotel job hiring !!!! job hir

HOTEL ATTENDANT / HOTEL CLEANER / HOUSE KEEPERS / DRIVER / CATERING / SECURITY / HOTEL WAITER/WAITRESS & OTHER WORKERS ARE WANTED URGENTLY IN THE USA. *WE WANT TO EMPLOY THE SERVICES OF A HOTEL A...

available in Kenya

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

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