What's Hot

Impressively done 3 bedroom houses in a gated comm

The houses are in a gated community of 8 houses They are uniformly done 3 bedroom bungalows master ensuite Each on own full eighth acre plot, own gates, separating fences and individual titl...

Beautiful mansion

4 bedrooms all ensuit..large living room...dining area...spacious modern kitchen.. a dsq...guest quaters attached to the house..backyard landscaped...front compound cabro paved...ample parking fo...

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

...

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

available in Kenya

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

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