What's Hot

2 bedroom apartments for sale in ngong

The units are located in Ngong about 1km from Ngong town opposite Ngong PCEA parish next to an pcomin Ngong Tuskys mall, it is about 100 mtrs from tarmac. They are a total of 32 units with 50% sold ou...

Ruiru 5br stand-alone maisonette

Strategically and conveniently located minutes to the Kenyatta University Ruiru campus stands this magnificent family home just for you! Features include: -Very spacious sitting area and dinning area ...

Oletepesi grdens

1. Oletepesi gardens;1/8 acre@850001/4 acre@170001/2 acre@340001 acre@ 680000 Located along magadi road, after Oletepesi town and 300m from the tarmac; The highlights of this project are schools...

4 and 5 bedroom townhouse tolet

4 ansd 5 bedroom  apartments available tolet.5 bedroom has 2 SQ while 4 bedroom has 1SQ.All bed are Ensuite.Club house .swimming pool.Bore hole and city council water....

4 and 5 bedroom townhouse tolet

4 ansd 5 bedroom  apartments available tolet.5 bedroom has 2 SQ while 4 bedroom has 1SQ.All bed are Ensuite.Club house .swimming pool.Bore hole and city council water....

Ngong, matasiah: 3 bedroom house for sale - ksh. 5

The house  Ngong-Kiserian Road It is 3 bedrooms master ensuite On eighth acre plot Developed neighbourhood Steady water suppy Ready clean freehold title deed Price -...

Newly built 3 bedroom bungalows in a gated communi

The houses are in a gated community of 9 houses. They are 3 bedrooms master ensuite. Each on eighth acre plot, own compound, fence and gate. Perimeter wall Landscaped gardens and p...

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