= 1450000 AND mls.Sale_Price <= 4100000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '0596187' 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')) ">= 1450000 AND mls.Sale_Price <= 4100000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '0596187' 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, SALE_PRICE Desc"> <table width="740" 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=0596187&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=0596187&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=0596187&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=0596187&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=0596187&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=0596187&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> </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/80/A1578860.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;">Hammock Oaks</h1></td> </tr> </table> </td> <td align="center" valign="top" class="celltext"> <table width="420" 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 compare all listings in community';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/CompareMLS.asp?Id=0596187&SubdivisionID=4229" 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 community';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/CompareMLS.asp?Id=0596187&SubdivisionID=4229" onClick="self.status='';return true;"> Compare all 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">&nbsp;</a> <table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td nowrap valign="top" class="text" align="left"><span id="AdvPropertyTypeLabel">&nbsp;Filter by </span> AllSalesRentalsForeclosuresShort SalesWater FrontPool &nbsp;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%"> &nbsp;Page 1 of 1 </td> <td valign="top" class="text" align="center" width="34%"><b>1</b>&nbsp;</td> <td valign="top" class="text" align="right" width="33%">1 Properties Found&nbsp; </td> </tr></table> </td> </table> <!--div style="height:100%;overflow:auto; width:Admin_Page_Width + 25px;border:3px solid #e5e5e5;display:block;"--> <table width="740" cellpadding="1" cellspacing="2" 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: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:740px;"> <td valign="top" class="celltext" width="740"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr style="width:740px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="467"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$2,225,000</strong></td> <td colspan="4">490 ROVINO AV Coral Gables, FL 33156</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 5 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=490+ROVINO+AV+Coral+Gables+FL++33156','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=490+ROVINO+AV+Coral+Gables+FL++33156','Map','scrollbars=yes,resizable=yes,height=540');self.status='';return true;">Map Property</a> </td> </tr> <tr> <td style="width: 100px"> 6 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=A1578860&id=0596187&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=A1578860&id=0596187&language=&license=&source=miamimls&custId=0">Property Details</a> </td> </tr> <tr> <td style="width: 100px"> 1 Half Baths </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=A1578860&id=0596187&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/photoGallery.png" width="25" height="25" border="0" align="absmiddle"></a>&nbsp;&nbsp;<a onMouseOver="showTooltip('../megatemplate/ToolTipHelp.asp?topic=virtual',this);self.status='Virtual Tour';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="javascript:;" onClick="MM_openBrWindow('http://www.obeo.com/u.aspx?ID=698096','virtualtour','scrollbars=yes,resizable=yes');self.status='';return true;"><img src="../megatemplate/images/virtualTour.gif" width="25" height="25" border="0" align="absmiddle"></a>&nbsp;&nbsp;<a onClick="self.status='';return true;" onMouseOver="showTooltip('../megatemplate/ToolTipHelp.asp?topic=Building&body=HAMMOCK+OAKS+HARBOR+SEC+2',this);self.status='HAMMOCK OAKS HARBOR SEC 2y';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1578860&id=0596187&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/buildings.png" width="25" height="25" border="0" align="absmiddle"></a>&nbsp;&nbsp; </td> </tr> <tr> <td style="width: 100px"> 5857 SF. </td> <td rowspan="2" align="center" valign="bottom"> &nbsp;</td> </tr> <tr> <td style="width: 100px">A1578860 </td> <td style="width: 43%" class="pType"><b> Single Family</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%"> &nbsp;Page 1 of 1 </td> <td valign="top" class="text" align="center" width="34%"><b>1</b>&nbsp;</td> <td valign="top" class="text" align="right" width="33%">1 Properties Found&nbsp; </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: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>&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="740"> <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>
Updated: Wednesday, February 22, 2012

Incentives for Going Green...
Are you thinking green this Spring“ Not only can energy efficient windows, doors and skyl...

Ask the HOA Expert...
Our governing documents describe allowable signs as either for sale or for rent. Since no other...

Pressure Proofing Your Busines...
We are all under the gun every day in real estate sales. Most of us get up every morning unempl...

Copyright ©2012Realty Times®. All Rights Reserved

International Properties
Busqueda de Propiedades
Resource Center
Client Login
Receive Email Alerts
Bookmark This Site