<table width="410" cellpadding="3" cellspacing="5"> <tr> <td align="left" valign="middle" width="360"> <h1 style="color: 000000; font: 13pt/15pt verdana"> The page cannot be displayed</h1> </td> </tr> <tr> <td width="400" colspan="2"> <font style="color: 000000; font: 8pt/11pt verdana">There is a problem with the page you are trying to reach and it cannot be displayed.</font> </td> </tr> <tr> <td width="400" colspan="2"> <font style="color: 000000; font: 8pt/11pt verdana"> <hr color="#C0C0C0" noshade> <p>Please try the following:</p> <ul> <li id="instructionsText1">Click the <a href="javascript:location.reload()">Refresh</a> button, or try again later.<br /> </li> <li>Open the home page, and then look for links to the information you want. </li> </ul> <h2 style="font: 8pt/11pt verdana; color: 000000"> HTTP 500.100 - Internal Server Error - ASP error<br /> Internet Information Services</h2> <p> Technical Information (for support personnel)</p> Session("Debug"): SELECT mls.SUBDIVISION, mls.Longitude, mls.Latitude, mls.STREET_NAME, mls.STREET_NUMBER, mls.STREET_TYPE, mls.STREET_DIRECTION, mls.ZIP_CODE, mls.PHOTO_IND, mls.PHOTO_QUANTITY, mls.PHOTO_URL, mls.MLS_OFFICE_NAME, mls.MLS_ID, mls.MLS_LISTING_ID, mls.ADDRESS, city.CITY, mls.PROPERTY_STATE_ID, mls.ZIP_CODE, mls.BEDROOMS, mls.BATHS_FULL, mls.BATHS_HALF, propertyType.PROP_TYPE_DESCRIPTION, mls.SALE_PRICE, mls.PROPERTY_TYPE_CODE, mls.MLS_AGENT_ID, mls.BUILDING_SQUARE_FOOTAGE, mls.ACRES, mls.TOTAL_UNITS, mls.TOTAL_BUILDINGS, mls.TOTAL_LOTS, mls.YEAR_BUILT, mls.VIRTUAL_TOUR, propertyType.PROP_TYPE_ORDER, mls.TLN_REALTOR_ID, SortOrder=case when (mls.MLS_OFFICE_ID IN ('FINRO8') or mls.TLN_FIRM_ID IN('FINRO8')) then 0 else 1 end,region.regionTypeID FROM mls (NOLOCK) LEFT OUTER JOIN city ON mls.CITY_ID = city.CITY_ID INNER JOIN propertyType ON mls.PROPERTY_TYPE_CODE = propertyType.PROPERTY_TYPE_CODE INNER JOIN region ON mls.MLS_ID = region.regionTable WHERE ( ((mls.CITY_ID = '000016') AND (LTRIM(RTRIM(ISNULL(mls.STREET_NUMBER,''))) + ' ' + LTRIM(RTRIM(ISNULL(mls.STREET_DIRECTION,''))) + ' ' + LTRIM(RTRIM(ISNULL(mls.STREET_NAME,''))) IN ('TRUMP INT SONESTA','TRUMP INT'L BEACH RESORT','TRUMP INT'L SONESTA','TRUMP INT'L SONESTA BEACH','TRUMP INTERNATIONAL','TRUMP INTERNATIONAL BEACH','TRUMP INTL SONESTA','TRUMP INTNATL SONESTA BEA','TRUMP SONESTA','TRUMP SONESTA INTERNATION','TRUMPI INTL SONESTA'))) OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'BEACH%RESORT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'SONESTA%BEACH%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTERNATIONAL%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTERNATIONAL%BEACH%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTL%SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTNATL%SONESTA%BEA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%SONESTA%INTERNATION%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMPI%INTL%SONESTA%') ) AND mls.PROPERTY_TYPE_CODE IN ('H','M','T','R') AND mls.PROPERTY_TYPE_CODE IN ('S','M','D','R','C','V','B') AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '3095756' 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 DescDebug Email: <br />Session Debug: SELECT mls.SUBDIVISION, mls.Longitude, mls.Latitude, mls.STREET_NAME, mls.STREET_NUMBER, mls.STREET_TYPE, mls.STREET_DIRECTION, mls.ZIP_CODE, mls.PHOTO_IND, mls.PHOTO_QUANTITY, mls.PHOTO_URL, mls.MLS_OFFICE_NAME, mls.MLS_ID, mls.MLS_LISTING_ID, mls.ADDRESS, city.CITY, mls.PROPERTY_STATE_ID, mls.ZIP_CODE, mls.BEDROOMS, mls.BATHS_FULL, mls.BATHS_HALF, propertyType.PROP_TYPE_DESCRIPTION, mls.SALE_PRICE, mls.PROPERTY_TYPE_CODE, mls.MLS_AGENT_ID, mls.BUILDING_SQUARE_FOOTAGE, mls.ACRES, mls.TOTAL_UNITS, mls.TOTAL_BUILDINGS, mls.TOTAL_LOTS, mls.YEAR_BUILT, mls.VIRTUAL_TOUR, propertyType.PROP_TYPE_ORDER, mls.TLN_REALTOR_ID, SortOrder=case when (mls.MLS_OFFICE_ID IN ('FINRO8') or mls.TLN_FIRM_ID IN('FINRO8')) then 0 else 1 end,region.regionTypeID FROM mls (NOLOCK) LEFT OUTER JOIN city ON mls.CITY_ID = city.CITY_ID INNER JOIN propertyType ON mls.PROPERTY_TYPE_CODE = propertyType.PROPERTY_TYPE_CODE INNER JOIN region ON mls.MLS_ID = region.regionTable WHERE ( ((mls.CITY_ID = '000016') AND (LTRIM(RTRIM(ISNULL(mls.STREET_NUMBER,''))) + ' ' + LTRIM(RTRIM(ISNULL(mls.STREET_DIRECTION,''))) + ' ' + LTRIM(RTRIM(ISNULL(mls.STREET_NAME,''))) IN ('TRUMP INT SONESTA','TRUMP INT'L BEACH RESORT','TRUMP INT'L SONESTA','TRUMP INT'L SONESTA BEACH','TRUMP INTERNATIONAL','TRUMP INTERNATIONAL BEACH','TRUMP INTL SONESTA','TRUMP INTNATL SONESTA BEA','TRUMP SONESTA','TRUMP SONESTA INTERNATION','TRUMPI INTL SONESTA'))) OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'BEACH%RESORT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INT%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'SONESTA%BEACH%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTERNATIONAL%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTERNATIONAL%BEACH%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTL%SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%INTNATL%SONESTA%BEA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%SONESTA%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMP%SONESTA%INTERNATION%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE 'TRUMPI%INTL%SONESTA%') ) AND mls.PROPERTY_TYPE_CODE IN ('H','M','T','R') AND mls.PROPERTY_TYPE_CODE IN ('S','M','D','R','C','V','B') AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '3095756' 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<br /><br />HTTP REFERER: <br />COM Error Number: -2147217900 (0x80040E14)<br />File Name: /megatemplate/include.asp<br />Line Number: 1115<br /><br />Brief Description: Incorrect syntax near 'L'.<br /><br /><a href="http://www.resionline.com/megatemplate/mlsgrid.asp?id=3095756&buildingid=81902&UserUseGoogleMap=false">http://www.resionline.com/megatemplate/mlsgrid.asp?id=3095756&buildingid=81902&UserUseGoogleMap=false</a><br /><br />Querystring ID: 3095756<br /> <hr color="#C0C0C0" noshade> </font> </td> </tr> </table>


English Spanish French German Italian Portugues
Interior Design
Concierge
New York Investment Opportunities


Add us on Facebook!
Follow us on Twitter!
Watch us on Youtube!
One Vision on Linkedin
Miami Events
Resource Center


Updated: Tuesday, May 21, 2013

Four Tips for Homeowners Facin...
Consumers can minimize the fear and paralysis associated with foreclosure by arming themselves ...

Real Estate Marketing Strategi...
How would you know if you subconsciously suffer from knowing what you should be doing, but aren...

Here We Go: Building Booming a...
Build it and they will come. The new housing industry is growing stronger and helping boost the...

Copyright ©2013Realty Times®.
All Rights Reserved