= 378000 AND SALE_PRICE <= 559000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = 'STRL01' 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')) ">= 378000 AND SALE_PRICE <= 559000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = 'STRL01' 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,propertyType.PROP_TYPE_ORDER asc,propertyType.PROP_TYPE_DESCRIPTION, SALE_PRICE Desc"> <table width="700" 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=STRL01&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=STRL01&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ñol</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=STRL01&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çais</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=STRL01&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=STRL01&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=STRL01&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ês</span></a></td><td width="56" class="text" align="center"><a href="../megatemplate/homesearch.asp?num=&id=STRL01&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="http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/02/A1750834.jpg" 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;">Oceanside Plaza</h1></td> </tr> </table> </td> <td align="center" valign="top" class="celltext"> <table width="380" 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"> <tr> <td class="text" valign="middle" width="7"><a onMouseOver="self.status='Click to Disable Map';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/CompareMLS.asp?Id=STRL01&BuildingID=72572" onClick="self.status='';return true;"> <img src="../megatemplate/images/bullet.gif" border="0"></a></td> <td class="text" valign="middle"> <a href="#" onclick="javascript:changeGoogle('True');"> Enable Map View</a></td> </tr> </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 compare all listings in building';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/CompareMLS.asp?Id=STRL01&BuildingID=72572" 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 compare all listings in building';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/CompareMLS.asp?Id=STRL01&BuildingID=72572" onClick="self.status='';return true;"> Compare all listings</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=STRL01&custId=0&BuildingID=72572" 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=STRL01&custId=0&BuildingID=72572" 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 colspan="2" class="celltext" id="viewmap" height="28"><a name="viewmap" style="position:relative"> </a> <table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td nowrap valign="top" class="text" align="left"><span id="AdvPropertyTypeLabel"> Filter by </span> AllSalesRentalsForeclosuresShort Sales Sort Price LowHigh</td> <td valign="top" class="text" align="right"> Properties Per Page 51015202550100</td> </td> </tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td valign="top" class="text" align="left" width="33%"> Page 1 of 1 </td> <td valign="top" class="text" align="center" width="34%"><b>1</b> </td> <td valign="top" class="text" align="right" width="33%">2 Properties Found </td> </tr></table> </td> </table> <!--div style="height:100%;overflow:auto; width:Admin_Page_Width + 25px;border:3px solid #e5e5e5;display:block;"--> <table width="700" cellpadding="2" cellspacing="0" height="10"> <tr> <td colspan="2" class="text" height="28"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:compareMLS();"><img src="../megatemplate/images/compareicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Compare Listings</span></a> </td> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:exportMLS();"><img src="../megatemplate/images/exportexcelicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Export To Excel</span></a> </td> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:saveMLS();"><img src="../megatemplate/images/saveicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Save Properties</span></a> </td> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:changeImage(false);"><img src="../megatemplate/images/hideimagesicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Hide Images</span></a> </td> </tr></table></td> </tr> <tr style="width:700px;"> <td valign="top" class="celltext" width="700"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr style="width:700px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="427"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$550,000</strong></td> <td colspan="4">5555 COLLINS AV #10J Miami Beach, FL 33140</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 2 Beds </td> <td valign="bottom" style="width: 43%"> <a onMouseOver="self.status='Click to map property';return true;" onMouseOut="self.status='';return true;" href="#" onClick="MM_openBrWindow('http://maps.google.com/maps?q=5555+COLLINS+AV+%2310J+Miami+Beach+FL++33140','Map','scrollbars=yes,resizable=yes,height=540');self.status='';return true;"><img src="../megatemplate/images/bullet_v2.gif" width="16" height="16" border="0" align="absmiddle"></a> <a onMouseOver="self.status='Click to map property';return true;" onMouseOut="self.status='';return true;" href="#" onClick="MM_openBrWindow('http://maps.google.com/maps?q=5555+COLLINS+AV+%2310J+Miami+Beach+FL++33140','Map','scrollbars=yes,resizable=yes,height=540');self.status='';return true;">Map Property</a> </td> </tr> <tr> <td style="width: 100px"> 2 Baths </td> <td style="width: 43%"> <a onClick="self.status='';return true;" onMouseOver="self.status='Details';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1750834&id=STRL01&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/bullet_v2.gif" width="16" height="16" border="0" align="absmiddle"></a> <a onClick="self.status='';return true;" onMouseOver="self.status='Details';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1750834&id=STRL01&language=&license=&source=miamimls&custId=0">Property Details</a> </td> </tr> <tr> <td style="width: 100px"> </td> <td rowspan="2" valign="middle" style="width: 43%"> <a onClick="self.status='';return true;" onMouseOver="showTooltip('../megatemplate/ToolTipHelp.asp?topic=photo',this);self.status='Photo Gallery';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1750834&id=STRL01&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/photoGallery.png" width="25" height="25" border="0" align="absmiddle"></a> <a onClick="self.status='';return true;" onMouseOver="showTooltip('../megatemplate/ToolTipHelp.asp?topic=Building&body=OCEANSIDE+PLAZA+CONDO',this);self.status='OCEANSIDE PLAZA CONDOy';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1750834&id=STRL01&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/buildings.png" width="25" height="25" border="0" align="absmiddle"></a> </td> </tr> <tr> <td style="width: 100px"> 1048 SF. </td> <td rowspan="2" align="center" valign="bottom"> </td> </tr> <tr> <td style="width: 100px">A1750834 </td> <td style="width: 43%" class="pType"><b> Condo / Town Home</b></td> <td valign="top" colspan="2" class="textBOLD"></td> </tr> </table> </td> </tr> </table></td></tr> <tr style="width:700px;"> <td valign="top" class="celltext" width="700"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr style="width:700px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="427"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$499,950</strong></td> <td colspan="4">5555 COLLINS AV #4F Miami Beach, FL 33140</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 2 Beds </td> <td valign="bottom" style="width: 43%"> <a onMouseOver="self.status='Click to map property';return true;" onMouseOut="self.status='';return true;" href="#" onClick="MM_openBrWindow('http://maps.google.com/maps?q=5555+COLLINS+AV+%234F+Miami+Beach+FL++33140','Map','scrollbars=yes,resizable=yes,height=540');self.status='';return true;"><img src="../megatemplate/images/bullet_v2.gif" width="16" height="16" border="0" align="absmiddle"></a> <a onMouseOver="self.status='Click to map property';return true;" onMouseOut="self.status='';return true;" href="#" onClick="MM_openBrWindow('http://maps.google.com/maps?q=5555+COLLINS+AV+%234F+Miami+Beach+FL++33140','Map','scrollbars=yes,resizable=yes,height=540');self.status='';return true;">Map Property</a> </td> </tr> <tr> <td style="width: 100px"> 2 Baths </td> <td style="width: 43%"> <a onClick="self.status='';return true;" onMouseOver="self.status='Details';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1788192&id=STRL01&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/bullet_v2.gif" width="16" height="16" border="0" align="absmiddle"></a> <a onClick="self.status='';return true;" onMouseOver="self.status='Details';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1788192&id=STRL01&language=&license=&source=miamimls&custId=0">Property Details</a> </td> </tr> <tr> <td style="width: 100px"> </td> <td rowspan="2" valign="middle" style="width: 43%"> <a onClick="self.status='';return true;" onMouseOver="showTooltip('../megatemplate/ToolTipHelp.asp?topic=photo',this);self.status='Photo Gallery';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1788192&id=STRL01&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/photoGallery.png" width="25" height="25" border="0" align="absmiddle"></a> <a onClick="self.status='';return true;" onMouseOver="showTooltip('../megatemplate/ToolTipHelp.asp?topic=Building&body=Oceanside+Plaza+Condo',this);self.status='Oceanside Plaza Condoy';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1788192&id=STRL01&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/buildings.png" width="25" height="25" border="0" align="absmiddle"></a> </td> </tr> <tr> <td style="width: 100px"> 1048 SF. </td> <td rowspan="2" align="center" valign="bottom"> </td> </tr> <tr> <td style="width: 100px">A1788192 </td> <td style="width: 43%" class="pType"><b> Condo / Town Home</b></td> <td valign="top" colspan="2" class="textBOLD"></td> </tr> </table> </td> </tr> </table></td></tr> <tr> <td colspan="2" class="celltext" height="28"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td valign="top" class="text" align="left" width="33%"> Page 1 of 1 </td> <td valign="top" class="text" align="center" width="34%"><b>1</b> </td> <td valign="top" class="text" align="right" width="33%">2 Properties Found </td> </tr></table></td> </tr> <tr> <td colspan="2" class="text" height="28"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:compareMLS();"><img src="../megatemplate/images/compareicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Compare Listings</span></a> </td> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:exportMLS();"><img src="../megatemplate/images/exportexcelicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Export To Excel</span></a> </td> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:saveMLS();"><img src="../megatemplate/images/saveicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Save Properties</span></a> </td> <td valign="top" class="text" align="center"> <a class="text" style="text-decoration: none" href="javascript:changeImage(false);"><img src="../megatemplate/images/hideimagesicon.png" border="0" class="pngfix"><span style="position:relative; bottom:5px;"> Hide Images</span></a> </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> </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="700"> <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>
4779 COLLINS AV #3301 BLUE DIAMOND
This direct oceanfront corner unit has breathtaking water views from every room....
