villa 550 for rent lake view compound
====== select * from Mls where EnItem like '%villa 550 for rent lake view compound%' group by CompanyCode ORDER BY UpdateStamp DESC =============
====== select *, MATCH (EnItem) AGAINST ('villa 550 for lake view compound' IN BOOLEAN MODE) AS Relevance from Mls where ID>0 and PropertyFor like '%Rent%' and MATCH (EnItem) AGAINST ('villa 550 for lake view compound' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 0,20 =============
EBP 18755
Beds
5
Bathrooms
4
Plot Area
1300 M2
Building Area
600 M2
Street Width
30
EBP 18276
Beds
4
Bathrooms
4
Plot Area
600 M2
Building Area
800 M2
Street Width
50
EBP 18793
Beds
5
Bathrooms
5
Plot Area
650 M2
Building Area
580 M2
Street Width
30
EBP 27537
Beds
4
Bathrooms
5
Plot Area
450 M2
Building Area
550 M2
Street Width
10
EBP 27624
Beds
4
Bathrooms
5
Plot Area
450 M2
Building Area
550 M2
Street Width
10
EBP 5776
Beds
3
Bathrooms
4
Plot Area
750 M2
Building Area
450 M2
Street Width
15
EBP 2634
Beds
4
Bathrooms
4
Plot Area
650 M2
Building Area
420 M2
Street Width
10
EBP 1714
Beds
4
Bathrooms
6
Plot Area
870 M2
Building Area
670 M2
Street Width
25
EBP 158
MA 13822
EBP 34210
Beds
3
Bathrooms
4
Area
315 M2
Floor No.
Ground Floor
EBP 2651
Beds
4
Bathrooms
4
Plot Area
620 M2
Building Area
570 M2
Street Width
10
EBP 3
Beds
4
Bathrooms
5
Plot Area
800 M2
Building Area
650 M2
GB 25124
Beds
7
Bathrooms
8
Plot Area
1394 M2
Building Area
709 M2
MA 13532
Beds
5
Bathrooms
6
Plot Area
600 M2
EBP 18431
Beds
5
Bathrooms
5
Plot Area
1010 M2
Building Area
750 M2
Street Width
10
BY 23173
Beds
4
Bathrooms
4
Plot Area
600 M2
Building Area
300 M2
BY 23060
Beds
5
Bathrooms
3
Plot Area
300 M2
Building Area
250 M2
MA 13475
Beds
5
Bathrooms
6
Plot Area
400 M2
EBP 966
Beds
4
Bathrooms
5
Plot Area
650 M2
Building Area
500 M2
Street Width
12
EGYPT
UAE