= 850000 AND SALE_PRICE <= 1300000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '3116846' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7')) ">= 850000 AND SALE_PRICE <= 1300000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '3116846' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7')) ORDER BY SortOrder,SALE_PRICE Desc"> <table width="720" cellpadding="1" cellspacing="2" height="10"> <tr> <td colspan="2" class="celltext" align="right" height="25" valign="middle"> <a onClick="self.status='';return true;" onMouseOver="self.status='Return to the previous page';return true;" onMouseOut="self.status='';return true;" href="javascript:window.history.back();">< Back</a> </td> </tr> <tr> <td colspan="2" align="center"> <table border="0" cellpadding="3" cellspacing="0" ID="Table2"> <tr> <td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=" onclick="changeLang('');return false;"><img src="../megatemplate/images/english.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> English</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=esp" onclick="changeLang('esp');return false;"><img src="../megatemplate/images/Espanol.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> Espa&ntilde;ol</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=fre" onclick="changeLang('fre');return false;"><img src="../megatemplate/images/Francais.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> Fran&ccedil;ais</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=ger" onclick="changeLang('ger');return false;"><img src="../megatemplate/images/Deutsch.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> Deutsch</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=ita" onclick="changeLang('ita');return false;"><img src="../megatemplate/images/Italiano.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> Italiano</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=por" onclick="changeLang('por');return false;"><img src="../megatemplate/images/Portugues.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> Portugu&ecirc;s</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=3116846&language=rus" onclick="changeLang('rus');return false;"><img src="../megatemplate/images/russian.png" border="0" class="pngfix"><br><span class="text" style="text-decoration: none; Padding-top: 10px;"> Russian</span></a></td> </tr> </table> </td> </tr> <tr> <td colspan="2"> <table width="100%" border="0" cellpadding="1" cellspacing="2"> <tr> <td valign="top" class="celltext" width="300"> <table border="0" cellspacing="0" cellpadding="3"> <tr> <td><img src="../megatemplate/images/nophoto/nophoto_condo_big.gif" onerror="javascript:this.src='../megatemplate/images/nophoto/nophoto.gif'" width="300" bordercolor="#999999"></td> </tr> <tr> <td align="center"><h1 class="title" style="margin:0px;">Millennium</h1></td> </tr> </table> </td> <td align="center" valign="top" class="celltext"> <table width="400" border="0" cellpadding="3" cellspacing="0" class="text"> <tr> <td valign="top" class="textBOLD" align="center" width="100%"> <table width="100%" border="0" cellspacing="0" cellpadding="3"> </table> </td> </tr> <tr> <td valign="top" class="textBOLD" align="center" width="100%"> <table width="100%" border="0" cellspacing="0" cellpadding="3" ID="Table1"> <tr> <td class="text" valign="middle" width="7"><a onMouseOver="self.status='Click to map building';return true;" onMouseOut="self.status='';return true;" href="#" onClick="MM_openBrWindow('http://maps.google.com/maps?q=18671%2BCollins%2BAv+Sunny+Isles+Beach+FL+33160','GoogleMaps','scrollbars=yes,resizable=yes,height=540');self.status='';return true;"> <img src="../megatemplate/images/bullet.gif" border="0"></a></td> <td class="text" valign="middle"><a onMouseOver="self.status='Click to map building';return true;" onMouseOut="self.status='';return true;" href="#" onClick="MM_openBrWindow('http://maps.google.com/maps?q=18671%2BCollins%2BAv+Sunny+Isles+Beach+FL+33160','GoogleMaps','scrollbars=yes,resizable=yes,height=540');self.status='';return true;"> Map Property</a></td> </tr> <tr> <td class="text" valign="middle" width="7"><a onMouseOver="self.status='Click to receive notification of all new listings';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/SaveSearch.asp?Id=3116846&custId=0&BuildingID=73561" onClick="self.status='';return true;"> <img src="../megatemplate/images/bullet.gif" border="0"></a></td> <td class="text" valign="middle"><a onMouseOver="self.status='Click to receive notification of all new listings';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/SaveSearch.asp?Id=3116846&custId=0&BuildingID=73561" onClick="self.status='';return true;"> Receive Email Notification of new listings</a></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td height="1" colspan="2" class="celltext" valign="top"> <table border="0" align="center" cellpadding="6" cellspacing="0"> <tr> <td class="title" align="center">There are no listings available at this time.<br>Please check back soon.</td> </tr> </table> </td> </tr> <tr> <td colspan="2" class="celltext" align="right" height="25" valign="middle"> <a onClick="self.status='';return true;" onMouseOver="self.status='Return to search page';return true;" onMouseOut="self.status='';return true;" href="javascript:window.history.back();">< Back</a>&nbsp; </td> </tr> <tr> <td colspan="2" class="celltext"> <table width="100%" border="0" cellpadding="6" cellspacing="0"> <tr> <td class="text"></td> </tr> </table> </td> </tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="720"> <tr> <td height="1" valign="top" class="celltext" align="center"> <a href="http://www.resionline.com" target="_blank"><img src="../megatemplate/images/resilogo.png" alt="Real Estate Web Design" width="96" height="39" border="0"></a></td> </tr> </table>

 

New York Properties

 

English
Core Values

 

Facebook Youtube Follow Us on Twitter TypePad
Press ReleasesVisit us on Facebook!
Find Out What your Home is Worth
Resource Center
Client Login
Today's News
Get Email Alerts
Bookmark This Site