What's Hot

1/4 plot for sale in tuala opposite cooperative sa

The parcel of land is located at Tuala past Maasai Academy. it is ideal for residential development. It has a ready title deed and electricity & water available. Drive past Nazarene university. It...

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

St. ruby 2br apartments syokimau

Tastefully done are these 2br apartments in a gated community less than 1km from Mombasa road at syokimau Features an amenities -Lovely spacious dining and lounge -Spacious kitchen open...

Spacious 2 bedroom house to let

Spacious1 store 1 parking slotown gatehot showersecure environment...

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

Land for sale

Located 70 km from Nairobi along Magadi road at Oltepesi town. This 200 acre piece of land can be subdivided into portions of 5 acres.Prices are negotiable....

Land for sale

This is a 1/8 of an acre, they are 7 portions, located in kisamis town, ideal for residential development and it is located near the proposed Southern Bypass. Clean title deed available....

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