Call Now: (305) 588-2451

Brickell Ave

= 500000 AND mls.Sale_Price <= 20000000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '3209745' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7',' 19') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7',' 19')) ">= 500000 AND mls.Sale_Price <= 20000000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '3209745' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7',' 19') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7',' 19')) ORDER BY SortOrder,propertyType.PROP_TYPE_ORDER asc, SALE_PRICE Desc"> <table width="730" 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"> <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_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;">Brickell Ave</h1></td> </tr> </table> </td> <td align="center" valign="top" class="celltext"> <table width="410" 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 receive notification of all new listings';return true;" onMouseOut="self.status='';return true;" href="../megatemplate/SaveSearch.asp?Id=3209745&custId=0&SubdivisionID=30946" 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=3209745&custId=0&SubdivisionID=30946" 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="730"> <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>

featured Listings

Luxury Rentals
How Much is my Home Worth
Closing Costs
View Recent Sales
Mortgage Calculator

Real Estate News

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

Our Resources
Receive Email Alerts
Client Login
Bookmark This Site

Social Networks