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

Melody gardens

Melody Gardens is an affordable and prestigious apartment , strategically located at the heart of Kilimani on a serene and quite environment.The development comprises of a 2,3 and 4 Bedrooms all en-su...

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

Olonyori apartment

Olonyori is a prestigious and serene 2 Bed Apartment strategically located in a prime and prestigious estate in Mlolongo Mombasa Road.It offers quality finishing and combines nature's traquility throu...

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

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

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