Office (305) 433-2818
eFax (786) 228-0879
Brasil: +55 (21) 4042 1368
Argentina: 54 (11) 5258 2199
Romania: +40 (21) 539 8233
Contact Us

<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.MLS_AREA,ISNULL(mls.SUBDIVISION,mls.COMMUNITY_NAME) AS 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.BEDROOMS, mls.BATHS_FULL, mls.BATHS_HALF, propertyType.PROP_TYPE_DESCRIPTION, mls.SALE_PRICE, mls.PROPERTY_TYPE_CODE, mls.MLS_AGENT_ID, mls.REMARKS, mls.STATUS_CODE, mls.SOLD_DATE, mls.LAST_MLS_UPDATE_DATE, 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_AGENT_ID IN ('3026334')) then 0 else 1 end,region.regionTypeID FROM mls 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 AND region.regionTypeID IN (SELECT regionTypeID FROM regionUsers where userName = '3026334') WHERE ( mls.CITY_ID in ('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','18001 COLLINS','18001 COLLINS AV','18001 COLLINS AVE')) OR (( isnull(mls.subdivision,mls.community_name) like 'Trump%International%Sonesta%Condo%Hotel%')) 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%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE '18001%COLLINS%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE '18001%COLLINS%AV%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE '18001%COLLINS%AVE%') ) AND mls.PROPERTY_TYPE_CODE IN ('H','M','T','R') AND mls.PROPERTY_TYPE_CODE IN ('S','M','D','R','C','V') AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES WHERE USER_NAME = '3026334' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND STATUS_CODE = 'A' AND Not city.regionTypeID Is Null AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN (SELECT regionTypeID FROM regionUsers where userName = '3026334')) ORDER BY SortOrder,propertyType.PROP_TYPE_ORDER asc,propertyType.PROP_TYPE_DESCRIPTION, SALE_PRICE DescDebug Email: <br />Session Debug: SELECT mls.MLS_AREA,ISNULL(mls.SUBDIVISION,mls.COMMUNITY_NAME) AS 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.BEDROOMS, mls.BATHS_FULL, mls.BATHS_HALF, propertyType.PROP_TYPE_DESCRIPTION, mls.SALE_PRICE, mls.PROPERTY_TYPE_CODE, mls.MLS_AGENT_ID, mls.REMARKS, mls.STATUS_CODE, mls.SOLD_DATE, mls.LAST_MLS_UPDATE_DATE, 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_AGENT_ID IN ('3026334')) then 0 else 1 end,region.regionTypeID FROM mls 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 AND region.regionTypeID IN (SELECT regionTypeID FROM regionUsers where userName = '3026334') WHERE ( mls.CITY_ID in ('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','18001 COLLINS','18001 COLLINS AV','18001 COLLINS AVE')) OR (( isnull(mls.subdivision,mls.community_name) like 'Trump%International%Sonesta%Condo%Hotel%')) 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%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE '18001%COLLINS%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE '18001%COLLINS%AV%') OR (LTRIM(RTRIM(ISNULL(mls.ADDRESS,''))) LIKE '18001%COLLINS%AVE%') ) AND mls.PROPERTY_TYPE_CODE IN ('H','M','T','R') AND mls.PROPERTY_TYPE_CODE IN ('S','M','D','R','C','V') AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES WHERE USER_NAME = '3026334' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND STATUS_CODE = 'A' AND Not city.regionTypeID Is Null AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN (SELECT regionTypeID FROM regionUsers where userName = '3026334')) 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: 1586<br /><br />Brief Description: Incorrect syntax near 'L'.<br /><br /><a href="http://www.resionline.com/megatemplate/mlsgrid.asp?id=3026334&buildingid=100352&UserUseGoogleMap=false">http://www.resionline.com/megatemplate/mlsgrid.asp?id=3026334&buildingid=100352&UserUseGoogleMap=false</a><br /><br />Querystring ID: 3026334<br /> <hr color="#C0C0C0" noshade> </font> </td> </tr> </table>

International Buyers
Penthouses
Luxury Rentals
Miami Tourist Guide
Resources
Sign up for our Newsletter
Client Login

Updated: Friday, June 23, 2017

Relaxing Designs For Your Lake...
According to Wallace J. Nichols, in his book "Blue Mind," our brains are hardwired to react ...

How Green Can You Go? Eco-frie...
Its hard to ignore the influence of big oil in Texas. Thirty-five miles to the Southwest of ...

The Top-Three Considerations W...
If yoursquo;re considering starting a home-based business, youre in good company. According ...

Copyright ©2017Realty Times®. All Rights Reserved