Jupiter Yacht Club

= 3950 AND mls.Sale_Price <= 2500000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '800202' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7',' 13') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7',' 13')) ">= 3950 AND mls.Sale_Price <= 2500000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '800202' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7',' 13') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7',' 13')) ORDER BY SortOrder,propertyType.PROP_TYPE_ORDER asc, SALE_PRICE Desc"> <table width="580" 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 width="277" valign="top" class="celltext"> <table width="260" 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=800202&BuildingID=0" 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('False');"> Disable 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"> </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> AllSalesRentalsWater 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%">4 Properties Found&nbsp; </td> </tr></table> </td> </tr> <tr><td colspan="2" class="celltext" height="28"> </td> </tr> </table> <!--div style="height:100%;overflow:auto; width:Admin_Page_Width + 25px;border:3px solid #e5e5e5;display:block;"--> <table width="580" 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> <a href="#viewmap"> <tr style="width:580px;"> <td valign="top" class="celltext" width="580"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr id="rowA1599093" onmouseover="mymouseover(0,'A1599093',this);" onmouseout="mymouseout(0,'A1599093',this);" onclick="myclick(0,this);" style="width:580px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="395"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$799,000</strong></td> <td colspan="4">400 S US Highway 1 #303 Jupiter, FL 33477</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 3 Beds </td> <td valign="bottom" style="width: 43%"> </td> </tr> <tr> <td style="width: 100px"> 3 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=A1599093&id=800202&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=A1599093&id=800202&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=A1599093&id=800202&language=&license=&source=miamimls&custId=0"><img src="../megatemplate/images/photoGallery.png" 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=Jupiter+Yacht+Club',this);self.status='Jupiter Yacht Cluby';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=A1599093&id=800202&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"> 2694 SF. </td> <td rowspan="2" align="center" valign="bottom"> &nbsp;</td> </tr> <tr> <td style="width: 100px">A1599093 </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> </a> </table></td></tr> <a href="#viewmap"> <tr style="width:580px;"> <td valign="top" class="celltext" width="580"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr id="rowR3222738" onmouseover="mymouseover(1,'R3222738',this);" onmouseout="mymouseout(1,'R3222738',this);" onclick="myclick(1,this);" style="width:580px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="395"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$7,500</strong></td> <td colspan="4">700 S Us Highway 1 # 206 Jupiter, FL 33477</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 3 Beds </td> <td valign="bottom" style="width: 43%"> </td> </tr> <tr> <td style="width: 100px"> 3 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=R3222738&id=800202&language=&license=&source=regional&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=R3222738&id=800202&language=&license=&source=regional&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=R3222738&id=800202&language=&license=&source=regional&custId=0"><img src="../megatemplate/images/photoGallery.png" 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=Jupiter+Yacht+Club',this);self.status='Jupiter Yacht Cluby';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=R3222738&id=800202&language=&license=&source=regional&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"> N/A SF. </td> <td rowspan="2" align="center" valign="bottom"> &nbsp;</td> </tr> <tr> <td style="width: 100px">R3222738 </td> <td style="width: 43%" class="pType"><b> Rental</b></td> <td valign="top" colspan="2" class="textBOLD"></td> </tr> </table> </td> </tr> </a> </table></td></tr> <a href="#viewmap"> <tr style="width:580px;"> <td valign="top" class="celltext" width="580"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr id="rowR3001985" onmouseover="mymouseover(2,'R3001985',this);" onmouseout="mymouseout(2,'R3001985',this);" onclick="myclick(2,this);" style="width:580px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="395"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$4,500</strong></td> <td colspan="4">700 S Us Highway 1 # 103 Jupiter, FL 33477</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 3 Beds </td> <td valign="bottom" style="width: 43%"> </td> </tr> <tr> <td style="width: 100px"> 3 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=R3001985&id=800202&language=&license=&source=regional&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=R3001985&id=800202&language=&license=&source=regional&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=R3001985&id=800202&language=&license=&source=regional&custId=0"><img src="../megatemplate/images/photoGallery.png" 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=Jupiter+Yacht+Club',this);self.status='Jupiter Yacht Cluby';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=R3001985&id=800202&language=&license=&source=regional&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"> N/A SF. </td> <td rowspan="2" align="center" valign="bottom"> &nbsp;</td> </tr> <tr> <td style="width: 100px">R3001985 </td> <td style="width: 43%" class="pType"><b> Rental</b></td> <td valign="top" colspan="2" class="textBOLD"></td> </tr> </table> </td> </tr> </a> </table></td></tr> <a href="#viewmap"> <tr style="width:580px;"> <td valign="top" class="celltext" width="580"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="text"> <tr id="rowR3006661" onmouseover="mymouseover(3,'R3006661',this);" onmouseout="mymouseout(3,'R3006661',this);" onclick="myclick(3,this);" style="width:580px;"> <td valign="top" class="celltext" > </td> <td valign="top" class="celltext" width="395"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text" ID="Table5"> <tr> <td valign="top" style="width: 100px"><strong>$4,300</strong></td> <td colspan="4">700 S Us Highway 1 # 102 Jupiter, FL 33477</td> </tr> <tr> <td height="30" valign="bottom" style="width: 100px"> 3 Beds </td> <td valign="bottom" style="width: 43%"> </td> </tr> <tr> <td style="width: 100px"> 3 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=R3006661&id=800202&language=&license=&source=regional&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=R3006661&id=800202&language=&license=&source=regional&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=R3006661&id=800202&language=&license=&source=regional&custId=0"><img src="../megatemplate/images/photoGallery.png" 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=Jupiter+Yacht+Club',this);self.status='Jupiter Yacht Cluby';return true;" onMouseOut="hideTooltip();self.status='';return true;" href="../megatemplate/mlsdetailsInv.asp?mls=R3006661&id=800202&language=&license=&source=regional&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"> N/A SF. </td> <td rowspan="2" align="center" valign="bottom"> &nbsp;</td> </tr> <tr> <td style="width: 100px">R3006661 </td> <td style="width: 43%" class="pType"><b> Rental</b></td> <td valign="top" colspan="2" class="textBOLD"></td> </tr> </table> </td> </tr> </a> </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%">4 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: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>&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="580"> <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>
Communities