= 50000 AND mls.Sale_Price <= 50000 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')) ">= 50000 AND mls.Sale_Price <= 50000 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="../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;">Grand Bay</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"> </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="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