What's Hot

valley brook gardens - 4 br massionettes in athi

Valley Brook Gardens is a housing concept that comprises ten 4 Bedroom Massionettes all en-suite in Athi River. The beautiful homes are in a convenient location off Mombasa road, approximately 30 minu...

10 bedroom residential property for sale - athi r

The Homes are 3Km off Mombasa Road at Athi River. Spectacular double storey home, with main accommodation comprising 10 bedrooms (most ensuite), sitting room, dining room, large kitchen, study and oth...

Spacious 2 bedroom house to let

Spacious1 store 1 parking slotown gatehot showersecure environment...

Plot for sale

40x80 Plot for sale. Access to water and electricity in Mavoko...

Serviced plot 60x80

Plots on gated community 40metres off kangundo road at KBC Ruai. Piped water and Electricity already connected on each plot. (Developed area) Price 490k Call 0771909325...

2.5 acres land for sale in athi river

The land is near the upcoming safaricom mall.The roads are undergoing grading.The plots are all fenced and the titles are all ready.Price is Ksh 14 million per acre.For More info go to http://www.vall...

House for sale in kitengela

It is three bedroom bungalow master ensuite Located in Muigai Estate, Kitengela Controlled location Ready title deed Price - Ksh. 8.5 million...

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