What's Hot

Syokimau masionatte

This is a 4 Bed master en-suite masionatte  strategically located in a prime and prestigious locality  in Syokimau behind Gateway Mall.In its own compound this masionatte provide the securit...

Gitanga rd townhouse

Gitanga Road Townhouse is a gated community comprising of five townhouses in a serene, and spacious environment.It is providing a  spectacular 5 Bed bed in a posy and affordable budget.Features5 ...

Homeland riara

Homeland Riara is a spectacular and tastefully built development  comprising of four bedrooms and DSQ all en-suite.It is  modeled and developed around your needs at the heart of Lavington, b...

Lifestyle terraces

Lifestyle Terraces is a spectacular 2  and 3 Bed Apartment strategically located along Mombasa road, behind the Gateway Mall.Lifestyle Terraces is an affordable apartment  at only Ksh 4.8 M&...

Dg oasis

DG Oasis is a spectacular development comprising a a 3 Bed modern  state of art apartment with an en-suite DSQ.DG Oasis provides an executive lovely home to be at in a serene environment. This de...

Graceland masionatte

Graceland Athi-River Masioneate is a spectacular development comprising of 3 Bedrooms with a Dsq all en-suite.The masionatte is strategically located along Mombasa Road in Athi-river, 25 minutes from ...

Delight furnished apartment

Delight Apartment is a spacious and executive furnished 3 Bed apartment and DSQ strategically located in a serene and prestigious locality in Kilimani.Features3 Bed Master En-suiteFully FurnishedSpaci...

available in Kenya

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

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