Please try the following:
- Click the Refresh
button, or try again later.
- Open the
home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
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 ('9041','1006167') or mls.TLN_FIRM_ID IN('9041','1006167')) 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 REO = 1 AND region.regionTypeID IN ('3') AND city.regionTypeID IN ('3') AND propertyType.PROPERTY_TYPE_CODE = 'M' AND PHOTO_QUANTITY > 0 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = 'GAFFS' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('3') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('3')) AND mls.PROPERTY_STATE_ID = 'FL' ORDER BY SortOrder,propertyType.PROP_TYPE_ORDER asc, propertyType.PROP_TYPE_DESCRIPTION, SALE_PRICE DescDebug Email: 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 ('9041','1006167') or mls.TLN_FIRM_ID IN('9041','1006167')) 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 REO = 1 AND region.regionTypeID IN ('3') AND city.regionTypeID IN ('3') AND propertyType.PROPERTY_TYPE_CODE = 'M' AND PHOTO_QUANTITY > 0 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = 'GAFFS' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('3') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('3')) AND mls.PROPERTY_STATE_ID = 'FL' ORDER BY SortOrder,propertyType.PROP_TYPE_ORDER asc, propertyType.PROP_TYPE_DESCRIPTION, SALE_PRICE Desc
HTTP REFERER: COM Error Number: -2147217913 (0x80040E07) File Name: /megatemplate/include.asp Line Number: 1045
Brief Description: Conversion failed when converting the varchar value 'a ' to data type int.
http://www.resionline.com/megatemplate/mlsgrid.asp?id=GAFFS&PropertyType=M&PlusBeds=ON®ion=3&BankOwned=ON&map=false
Querystring ID: GAFFS
|