La Vista Bay

La Vista Bay sitting atop 1 million square meters along the stunning Mediterranean, La Vista Bay - North Coast boasts a picturesque 1 Km white sandy beachfront. Only 22 Km from Hacienda, La Vista Bay - North Coast brings together the best of the Mediterranean and the best of the previous six La Vista Projects to the North Coast. With 5 rows of luxurious and excusive villas and chalets arranged in a step formation descending toward the beautiful seashore, every home enjoys its own unique grand view of the idyllic Mediterranean. La Vista Bay offers its’ residents several pools to choose from, a clubhouse, a hotel, restaurants, and a supermarket. La Vista North Coast also offers its’ residents scenic lagoons inspired by fantasies and fairy-tales, and rich, vibrant green landscaping.
select * from Mls where ID in (80597,102766,102668,102638,102611,102340,102339,102187,102188,99063,99033,97711,97613,97828,90777,90798,63743,61682,82793,82794,82825,63401,80414,78709,69588,67792,67791,66390,46909,57477,56311,54025,53246,53144,52985,53145,53146,53147,53149,53150,52303,46918,45180,100351,102488,42512,66089,90614,102269,95218,102131,102009,54824,102043,101665,101161,84219,64362,102823,102829,102828,102830,102831,102835,102836,102804,102805,102806,102808,102810,102774,102764,102765,102720,102410,102494,102493,102495,102496,102497,101823,102393,102408,102394,102395,102396,102397,102398,100288,102399,102400,102367,102366,102365,102343,102225,102228,102229,102189,102133,102134,102099,102122,102100,102102,102096,102104,102078,100371,95916,102014,102007,102002,41470,101849,101845,101850,101852,101793,101794,101527,101684,101528,101626,101666,101667,101669,71921,80104,84939,101353,101343,101300,101302,101303,100269,101235,101026,101233,101224,101210,101185,101159,101157,101155,101186,101153,101129,101138,101130,101131,101132,101142,101133,101143,101146,101134,101148,101149,101150,101106,101078,97331,101053,101054,101055,100995,100996,100997,100999,101000,100978,101001,101002,101003,97766,101004,101006,101007,100939,100941,100942,100943,100944,100946,100947,100948,100949,100950,100951,100952,100953,100954,100887,100888,100889,100890,100891,100892,100893) ORDER BY FIELD(ID, 80597,102766,102668,102638,102611,102340,102339,102187,102188,99063,99033,97711,97613,97828,90777,90798,63743,61682,82793,82794,82825,63401,80414,78709,69588,67792,67791,66390,46909,57477,56311,54025,53246,53144,52985,53145,53146,53147,53149,53150,52303,46918,45180,100351,102488,42512,66089,90614,102269,95218,102131,102009,54824,102043,101665,101161,84219,64362,102823,102829,102828,102830,102831,102835,102836,102804,102805,102806,102808,102810,102774,102764,102765,102720,102410,102494,102493,102495,102496,102497,101823,102393,102408,102394,102395,102396,102397,102398,100288,102399,102400,102367,102366,102365,102343,102225,102228,102229,102189,102133,102134,102099,102122,102100,102102,102096,102104,102078,100371,95916,102014,102007,102002,41470,101849,101845,101850,101852,101793,101794,101527,101684,101528,101626,101666,101667,101669,71921,80104,84939,101353,101343,101300,101302,101303,100269,101235,101026,101233,101224,101210,101185,101159,101157,101155,101186,101153,101129,101138,101130,101131,101132,101142,101133,101143,101146,101134,101148,101149,101150,101106,101078,97331,101053,101054,101055,100995,100996,100997,100999,101000,100978,101001,101002,101003,97766,101004,101006,101007,100939,100941,100942,100943,100944,100946,100947,100948,100949,100950,100951,100952,100953,100954,100887,100888,100889,100890,100891,100892,100893) LIMIT 0,20
Can't find record in 'Mls'