What's Hot

Julia court - rental

2 - bedroom Flat available , master ensuite- 30,000 pm...

Joska kbc ( komarock ): 50 x 100 plots for sale

The plots are located 7 km from Kangundo rd access road at st nimrod just before komarock shrine center. The land is near Ngwata catholic church.The land is very fertile can alo be used for farming cu...

Matuu: 50 x 100 prime plots for sale

The land is located 2km from Matuu town and 100m from Thika - Garissa highway Viewing: Wednesdays and Sartudays Pyment: In full or 90 days instalments Call Jack 0720712426 ( No Agent )...

Juja farm: 3.25 acres of land for sale

This ideal land is located 15km from Thika super highway and 1 km from the upcoming great northern bypass. The land is near Athi shopping center. Due to its proximity to Thika super highway and bypass...

Thika ngoingwa: 50 x 100 prime plots for sale

Two prime plots for sale in Ngoingwa Thika one of the fastest developing high end estate in Thika . one plot is located 1 km fro the super highway and 100m from the tarmac the plot is near Unique supe...

A six bedrooms town house on 1/2acre

A six bedrooms town house on 1/2acre  with a study, family/TV rooms, table tennis room, servants quarter for two, garage for two big cars and the rent is kshs. 300,000 per month....

Ongata rongai: 50 x 100 prime plots for sale

The prime plots are located 6km from Rongai past Nazareen university and near the upcoming korean universityReady titlePrice 965,000 ( Paid in full or 90 days instalmentsCall Jack 0720712426( No broke...

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