Header Banner

====== select * from Mls where DistrictID=3278 and PropertyFor='Sale' and CategoryID=3 group by CompanyCode ORDER BY UpdateStamp DESC =============
NA 6300 FeaturedBuilding for sale in Smart Village
EGP 110,000,000

Smart Village, Buildings in smart village, Cairo Alexandria Desert Road

Buildings For Sale in Smart Village

Total Surface Area
6368 M2
 

====== select * from Mls where RecycleBin=0 and Active=1 and RegionID>=0 and PropertyFor like '%sale%' and CityID in (92) and PropertyFor like '%sale%' and DistrictID in (3278) and PropertyFor like '%sale%' and CategoryID in (3) order by UpdateStamp DESC LIMIT 0,20 =============
NA 6300 Building for sale in Smart Village
EGP 110,000,000

Smart Village, Buildings in smart village, Cairo Alexandria Desert Road

Buildings For Sale in Smart Village

Total Surface Area
6368 M2