Header Banner

Studio For Sale in La Hacienda


====== select * from Mls where DistrictID=4308 and PropertyFor='Sale' and CategoryID=2 group by CompanyCode ORDER BY UpdateStamp DESC =============
SE 25381 FeaturedLa Hacienda ras sedr ground floor chalet with gardn 6 years installme
EGP 950,000

La Hacienda, Ras Sudr

Studio For Sale in La Hacienda

Beds
2
Bathrooms
2
Area
91 M2
Floor No.
Ground Floor
 

====== select * from Mls where RecycleBin=0 and Active=1 and RegionID>=0 and PropertyFor like '%sale%' and CityID in (138) and PropertyFor like '%sale%' and DistrictID in (4308) and PropertyFor like '%sale%' and CategoryID in (2) order by UpdateStamp DESC LIMIT 0,20 =============
SE 25381 La Hacienda ras sedr ground floor chalet with gardn 6 years installme
EGP 950,000

La Hacienda, Ras Sudr

Studio For Sale in La Hacienda

Beds
2
Bathrooms
2
Area
91 M2
Floor No.
Ground Floor