retail for sale in a very prime
====== select * from Mls where EnItem like '%retail for sale in a very prime%' group by CompanyCode ORDER BY UpdateStamp DESC =============
NA 11190
Store Type
Street Commercial Store
Area
1200 M2
Floor No.
Ground Floor
Street Width
1200
====== select *, MATCH (EnItem) AGAINST ('retail for in a very prime' IN BOOLEAN MODE) AS Relevance from Mls where ID>0 and PropertyFor like '%Sale%' and MATCH (EnItem) AGAINST ('retail for in a very prime' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 0,20 =============
NA 3989
Store Type
Street Commercial Store
Area
80 M2
Floor No.
Ground Floor
NA 3988
Store Type
Mall Commercial Store
Area
240 M2
Floor No.
Ground Floor
NA 11771
Store Type
Mall Commercial Store
Area
1200 M2
Floor No.
Ground Floor
NA 11979
Area
400 M2
Floor No.
Ground Floor
NA 11978
Area
300 M2
Floor No.
Ground Floor
NA 11954
Store Type
Street Commercial Store
Area
365 M2
NA 10359
Store Type
Street Commercial Store
Area
200 M2
NA 11909
Store Type
Street Commercial Store
Area
140 M2
NA 11701
![retail for sale or rent in very prime location in Heliopolis]()
Store Type
Street Commercial Store
Area
28 M2
NA 11190
Store Type
Street Commercial Store
Area
1200 M2
Floor No.
Ground Floor
Street Width
1200
NA 10120
Store Type
Mall Commercial Store
Area
108 M2
Floor No.
Ground Floor
NA 10117
Store Type
Mall Commercial Store
Area
94 M2
Floor No.
Ground Floor
NA 3379
Room(s)
8
Bathrooms
3
Area
200 M2
Floor No.
Ground Floor
NA 3368
Store Type
Mall Commercial Store
Area
140 M2
Floor No.
1
NA 2561
Store Type
Mall Commercial Store
Area
309 M2
NA 2562
Store Type
Mall Commercial Store
Area
108 M2
NA 2560
BB 5122
Store Type
Mall Commercial Store
Area
72 M2
Floor No.
Ground Floor
BB 5131
Store Type
Mall Commercial Store
Area
79 M2
Floor No.
Ground Floor
BB 5133
Store Type
Mall Commercial Store
Area
79 M2
Floor No.
Ground Floor
EGYPT
UAE