====== select *, MATCH (EnItem) AGAINST ('studio furnished for kawthar hurghada red' IN BOOLEAN MODE) AS Relevance from Mls where ID>0 and PropertyFor like '%Sale%' and MATCH (EnItem) AGAINST ('studio furnished for kawthar hurghada red' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 60,20 =============
SE 6351
Beds
3
Bathrooms
3
Area
235 M2
Floor No.
3
NA 2007
Beds
6
Bathrooms
7
Plot Area
1000 M2
Building Area
500 M2
PL 3338
Beds
3
Bathrooms
3
Plot Area
307 M2
Building Area
190 M2
Street Width
15
SE 25419
Beds
3
Bathrooms
3
Area
100 M2
Type
Chalet
Floor No.
3
SE 25855
Beds
3
Bathrooms
3
Plot Area
586 M2
Building Area
167 M2
SE 25872
Beds
3
Bathrooms
3
Area
143 M2
Floor No.
2
EBP 761
Beds
2
Bathrooms
2
Area
90 M2
Type
Chalet
EBP 12318
Beds
2
Bathrooms
2
Area
110 M2
Floor No.
Ground Floor
GB 1578
Beds
2
Bathrooms
1
Area
125 M2
Type
Chalet
Floor No.
1
BY 23452
Beds
2
Bathrooms
1
Area
120 M2
Type
Chalet
MA 19423
Beds
6
Bathrooms
6
Plot Area
1300 M2
Building Area
600 M2
Street Width
25
NA 11415
Plot Area
500 M2
Building Area
266 M2
TV 3077
Beds
4
Bathrooms
4
Area
300 M2
Floor No.
2
MA 12092
Beds
2
Bathrooms
2
Area
95 M2
Type
Chalet
Floor No.
Ground Floor
GB 22925
SE 24807
Beds
2
Bathrooms
2
Area
110 M2
Type
Chalet
Floor No.
6
GB 35897
Beds
5
Bathrooms
5
Area
250 M2
Type
Chalet
Floor No.
1
EBP 7709
Beds
3
Bathrooms
3
Plot Area
250 M2
Building Area
180 M2
Street Width
25
EBP 20298
Beds
1
Bathrooms
2
Area
64 M2
Floor No.
1
NH 1255
Beds
1
Bathrooms
2
Area
102 M2
Floor No.
Ground Floor
EGYPT
UAE