What's Hot

2bedroom for sale in nyayo highrise mbagathi way

This flat is located in Nyayo Highrise along Mbagathi way. The house is on the ground floor and it comprises of two bedrooms and a living room,with a kitchen and parking, It has tiles and in-built war...

Julia court - rental

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

2bedroom for sale in nyayo highrise mbagathi way

This flat is located in Nyayo Highrise along Mbagathi way. The house is on the ground floor and it comprises of two bedrooms and a living room,with a kitchen and parking,it within 5 minutes from T-mal...

Plot for sale

1/4 Acre Plot Of Land For Sale 200m Behind Thigio Shopping Center Along The Thogoto Mutarakwa Road. Already Developed Area. Electricity And Water Readily Available. Ideal For Residential Or Farming...

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

Luxury 3 bedroom apartment for sale loresho nairob

Selling 3 bedroom + Sq Apartment Loresho 14M ONO Location Within the great suburb of Loresho, there is this spectacular development of 12 blocks of apartment on a 5.5 acre sloppy land with landscap...

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

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