Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | SELECT ROW_NUMBER() OVER (
ORDER BY
list_price desc,
ml_number ASC
) + 0 AS RowNumber,
*
FROM (
SELECT DISTINCT COMPANY = (
CASE
WHEN (companyid = 'bay_staging')
THEN (1)
ELSE (2)
END
)
,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBAQ01')) THEN (1) ELSE (0) END
,IS_AGENT_LISTING = (
CASE
WHEN (
LEN('pwd12345jj') > 0
AND (
L.PUBLICID IN ('pwd12345jj')
OR
L.SECONDPUBLICID IN ('pwd12345jj')
)
) THEN (1)
ELSE (0)
END
),
0 AS Distance,
'f' AS iswatching,
l.image_path AS ImagePath,
l.url,
'' AS SortOrder,
'' AS AgentPublicID,
'' AS AgentImagePath,
'' AS AgentFirstName,
'' AS AgentMiddleName,
'' AS AgentLastName,
'' AS AgentPhone,
'' AS AgentCell,
'' AS AgentFax,
'' AS AgentEmail,
'' AS AgentWebsiteAddress,
'' AS AgentTeam,
'' AS AgentCertification,
'' AS AgentLicenseNumber,
'' AS AgentBioPath,
'' AS AgentHasBlog,
'' AS AgentURL,
'' AS SecondAgentPublicID,
'' AS SecondAgentImagePath,
'' AS SecondAgentFirstName,
'' AS SecondAgentMiddleName,
'' AS SecondAgentLastName,
'' AS SecondAgentPhone,
'' AS SecondAgentCell,
'' AS SecondAgentFax,
'' AS SecondAgentEmail,
'' AS SecondAgentWebsiteAddress,
'' AS SecondAgentTeam,
'' AS SecondAgentCertification,
'' AS SecondAgentLicenseNumber,
'' AS SecondAgentBioPath,
'' AS SecondAgentHasBlog,
'' AS SecondAgentURL,
'' AS OfficeID,
'' AS OfficeName,
'' AS OfficePhone,
'' AS OfficeAddress,
'' AS OfficeCity,
'' AS OfficeState,
'' AS OfficeZip,
'' AS OfficeDomain,
'' AS LogoPath,
'' AS DarkLogoPath,
'' AS LogoPathSmall,
'' AS leadpublicid,
'' AS AudioTour,
PropertyID.PropertyID,
'list_price' AS OrderBy,
'desc' AS OrderDirection,
l.MLSID,
l.listingid,
l.ListingType,
l.PropertyType,
l.PublicID AS LA_PublicID,
l.CompanyID,
l.StatusCode,
l.Area,
l.DisplayAddress,
l.DisplayRemarks,
l.DisplayCMA,
l.Lat,
ROUND(l.Lat,5,0) as latitude,
l.Lon,
ROUND(l.Lon,5,0) as longitude,
l.List_Price,
l.LO_Name,
l.LO_Phone,
l.LO_Email,
l.LA_Name,
l.LA_Phone,
l.LA_Email,
l.ML_Number,
l.PublicID,
l.SecondPublicID,
l.StreetAddress,
l.City,
l.State,
IIF (l.Zip_Code = '00000', '', l.Zip_Code) as Zip_Code,
l.County,
l.SchoolDistrict,
l.ElementarySchool,
l.JRHighSchool,
l.HighSchool,
DATEDIFF ( "D" , DATEFROMPARTS(left(l.AddDateTime,4), substring(l.AddDateTime,5, 2), substring(l.AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,
l.ReducedDateTime,
l.AddDateTime,
l.Prev_List_Price,
l.VirtualTourID,
l.Images,
l.SubType,
l.Optional_01,
l.Optional_02,
l.Optional_03,
l.Optional_04,
l.Optional_05,
l.Optional_06,
l.Optional_07,
l.Optional_08,
l.Optional_09,
l.Optional_10,
l.Optional_11,
l.Optional_12,
l.Optional_13,
l.Optional_14,
l.Optional_15,
l.Optional_16,
l.Optional_17,
l.Optional_18,
l.Optional_19,
l.Optional_20,
l.VideoTour,
l.SecondVideoTour,
l.MLS_Remarks,
l.Description,
l.MLS_StatusCode,
l.Orig_List_Price,
l.SalePrice,
l.ListingDateTime,
l.DateTime,
l.ClosingDateTime,
l.ContractDateTime,
l.DOM,
l.REO,
l.ShortSale,
l.LO_ID,
l.LA_ID,
l.BO_ID,
l.BA_ID,
l.BO_Name,
l.BA_Name,
l.image_list,
l.image_data,
l.custom_image_data,
l.DeleteFlag,
l.isprivate,
l.attribution,
'' AS OpenHouseSchedule,
'' AS BathsString,
l.Baths,
l.FullBaths,
l.HalfBaths,
l.ThreeQuarterBaths,
l.Beds,
l.Garage,
l.Style,
l.sq_foot,
l.Year_Built,
l.Pool,
l.Acreage,
l.Story,
l.Previews,
l.Featured,
l.CommunityName,
l.PropertyView,
l.Waterfront,
l.Golfcourse,
l.Basement,
l.Carport,
l.PatioSQ_Foot,
l.BuildingName,
l.UnitFloor,
l.HOA,
l.HoaDues,
l.Zoning,
l.sq_foot_Office,
l.Units,
l.AskingPricePersq_foot,
l.SalesTerms,
l.SaleType,
l.sq_foot_Vacant,
l.SuiteNumber,
l.SuiteFloor,
l.GrossBuildingArea,
l.GrossLeaseArea,
l.BuildingClass,
l.LegalDescription,
l.Occupancy,
l.TenantOccupancyBasis,
l.ConstructionStatus,
l.YearRenovated,
l.LeedCertification,
l.Buildings,
l.ParkingType,
l.ParkingSpaces,
l.PotentialRentalIncome,
l.NetOperatingIncome,
l.CapRate,
l.InternalRateOfReturn,
l.CashOnCash,
l.PotentialRentalIncomeRemarks,
l.NoiRemarks,
l.CapRateRemarks,
l.LoanBalance,
l.InterestRate,
l.AmortizationPeriod,
l.MaturityDate,
l.subarea,
l.propertystory,
l.propertystorystatus,
l.lastModificationDateTime,
l.lo_comp,
l.bo_comp,
l.lo_comp_display,
l.bo_comp_display,
l.secondpublicid as listingagentsecondpublicid,
l.publicid as listingagentpublicid,
A.officeid as listingagentofficeid,
l.isMarketStatisticsDisplay,
l.sourcemlsurl,
l.type
FROM Listings l WITH (NOLOCK)
LEFT JOIN Agents A WITH (NOLOCK)
ON A.PublicID = L.PublicID
AND A.[Status] = 'A'
LEFT JOIN PropertyID WITH (NOLOCK)
ON PropertyID.MLSID = l.mlsid
AND PropertyID.ML_Number = l.ML_Number
AND PropertyID.dbTable IN ('residential')
AND PropertyID.Status = 'A'
LEFT JOIN agents_teams TEAMS WITH (NOLOCK)
ON TEAMS.Status = 'A'
AND TEAMS.PublicID = l.publicid
WHERE
l.id in ( select cast(value as bigint) from openjson( '["222197"]' ) )
AND l.adddatetime <> ''
) dt
ORDER BY
list_price desc,
ml_number ASC |
|
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | column [ID] not found in query, columns are [ROWNUMBER,COMPANY,IS_OFFICE_LISTING,IS_AGENT_LISTING,DISTANCE,ISWATCHING,IMAGEPATH,URL,SORTORDER,AGENTPUBLICID,AGENTIMAGEPATH,AGENTFIRSTNAME,AGENTMIDDLENAME,AGENTLASTNAME,AGENTPHONE,AGENTCELL,AGENTFAX,AGENTEMAIL,AGENTWEBSITEADDRESS,AGENTTEAM,AGENTCERTIFICATION,AGENTLICENSENUMBER,AGENTBIOPATH,AGENTHASBLOG,AGENTURL,SECONDAGENTPUBLICID,SECONDAGENTIMAGEPATH,SECONDAGENTFIRSTNAME,SECONDAGENTMIDDLENAME,SECONDAGENTLASTNAME,SECONDAGENTPHONE,SECONDAGENTCELL,SECONDAGENTFAX,SECONDAGENTEMAIL,SECONDAGENTWEBSITEADDRESS,SECONDAGENTTEAM,SECONDAGENTCERTIFICATION,SECONDAGENTLICENSENUMBER,SECONDAGENTBIOPATH,SECONDAGENTHASBLOG,SECONDAGENTURL,OFFICEID,OFFICENAME,OFFICEPHONE,OFFICEADDRESS,OFFICECITY,OFFICESTATE,OFFICEZIP,OFFICEDOMAIN,LOGOPATH,DARKLOGOPATH,LOGOPATHSMALL,LEADPUBLICID,AUDIOTOUR,PROPERTYID,ORDERBY,ORDERDIRECTION,MLSID,LISTINGID,LISTINGTYPE,PROPERTYTYPE,LA_PUBLICID,COMPANYID,STATUSCODE,AREA,DISPLAYADDRESS,DISPLAYREMARKS,DISPLAYCMA,LAT,LATITUDE,LON,LONGITUDE,LIST_PRICE,LO_NAME,LO_PHONE,LO_EMAIL,LA_NAME,LA_PHONE,LA_EMAIL,ML_NUMBER,PUBLICID,SECONDPUBLICID,STREETADDRESS,CITY,STATE,ZIP_CODE,COUNTY,SCHOOLDISTRICT,ELEMENTARYSCHOOL,JRHIGHSCHOOL,HIGHSCHOOL,DAYSONSITE,REDUCEDDATETIME,ADDDATETIME,PREV_LIST_PRICE,VIRTUALTOURID,IMAGES,SUBTYPE,OPTIONAL_01,OPTIONAL_02,OPTIONAL_03,OPTIONAL_04,OPTIONAL_05,OPTIONAL_06,OPTIONAL_07,OPTIONAL_08,OPTIONAL_09,OPTIONAL_10,OPTIONAL_11,OPTIONAL_12,OPTIONAL_13,OPTIONAL_14,OPTIONAL_15,OPTIONAL_16,OPTIONAL_17,OPTIONAL_18,OPTIONAL_19,OPTIONAL_20,VIDEOTOUR,SECONDVIDEOTOUR,MLS_REMARKS,DESCRIPTION,MLS_STATUSCODE,ORIG_LIST_PRICE,SALEPRICE,LISTINGDATETIME,DATETIME,CLOSINGDATETIME,CONTRACTDATETIME,DOM,REO,SHORTSALE,LO_ID,LA_ID,BO_ID,BA_ID,BO_NAME,BA_NAME,IMAGE_LIST,IMAGE_DATA,CUSTOM_IMAGE_DATA,DELETEFLAG,ISPRIVATE,ATTRIBUTION,OPENHOUSESCHEDULE,BATHSSTRING,BATHS,FULLBATHS,HALFBATHS,THREEQUARTERBATHS,BEDS,GARAGE,STYLE,SQ_FOOT,YEAR_BUILT,POOL,ACREAGE,STORY,PREVIEWS,FEATURED,COMMUNITYNAME,PROPERTYVIEW,WATERFRONT,GOLFCOURSE,BASEMENT,CARPORT,PATIOSQ_FOOT,BUILDINGNAME,UNITFLOOR,HOA,HOADUES,ZONING,SQ_FOOT_OFFICE,UNITS,ASKINGPRICEPERSQ_FOOT,SALESTERMS,SALETYPE,SQ_FOOT_VACANT,SUITENUMBER,SUITEFLOOR,GROSSBUILDINGAREA,GROSSLEASEAREA,BUILDINGCLASS,LEGALDESCRIPTION,OCCUPANCY,TENANTOCCUPANCYBASIS,CONSTRUCTIONSTATUS,YEARRENOVATED,LEEDCERTIFICATION,BUILDINGS,PARKINGTYPE,PARKINGSPACES,POTENTIALRENTALINCOME,NETOPERATINGINCOME,CAPRATE,INTERNALRATEOFRETURN,CASHONCASH,POTENTIALRENTALINCOMEREMARKS,NOIREMARKS,CAPRATEREMARKS,LOANBALANCE,INTERESTRATE,AMORTIZATIONPERIOD,MATURITYDATE,SUBAREA,PROPERTYSTORY,PROPERTYSTORYSTATUS,LASTMODIFICATIONDATETIME,LO_COMP,BO_COMP,LO_COMP_DISPLAY,BO_COMP_DISPLAY,LISTINGAGENTSECONDPUBLICID,LISTINGAGENTPUBLICID,LISTINGAGENTOFFICEID,ISMARKETSTATISTICSDISPLAY,SOURCEMLSURL,TYPE] |
|
| NativeErrorCode | |
| queryError | | string | SELECT ROW_NUMBER() OVER (
ORDER BY
list_price desc,
ml_number ASC
) + 0 AS RowNumber,
*
FROM (
SELECT DISTINCT COMPANY = (
CASE
WHEN (companyid = 'bay_staging')
THEN (1)
ELSE (2)
END
)
,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBAQ01')) THEN (1) ELSE (0) END
,IS_AGENT_LISTING = (
CASE
WHEN (
LEN('pwd12345jj') > 0
AND (
L.PUBLICID IN ('pwd12345jj')
OR
L.SECONDPUBLICID IN ('pwd12345jj')
)
) THEN (1)
ELSE (0)
END
),
0 AS Distance,
'f' AS iswatching,
l.image_path AS ImagePath,
l.url,
'' AS SortOrder,
'' AS AgentPublicID,
'' AS AgentImagePath,
'' AS AgentFirstName,
'' AS AgentMiddleName,
'' AS AgentLastName,
'' AS AgentPhone,
'' AS AgentCell,
'' AS AgentFax,
'' AS AgentEmail,
'' AS AgentWebsiteAddress,
'' AS AgentTeam,
'' AS AgentCertification,
'' AS AgentLicenseNumber,
'' AS AgentBioPath,
'' AS AgentHasBlog,
'' AS AgentURL,
'' AS SecondAgentPublicID,
'' AS SecondAgentImagePath,
'' AS SecondAgentFirstName,
'' AS SecondAgentMiddleName,
'' AS SecondAgentLastName,
'' AS SecondAgentPhone,
'' AS SecondAgentCell,
'' AS SecondAgentFax,
'' AS SecondAgentEmail,
'' AS SecondAgentWebsiteAddress,
'' AS SecondAgentTeam,
'' AS SecondAgentCertification,
'' AS SecondAgentLicenseNumber,
'' AS SecondAgentBioPath,
'' AS SecondAgentHasBlog,
'' AS SecondAgentURL,
'' AS OfficeID,
'' AS OfficeName,
'' AS OfficePhone,
'' AS OfficeAddress,
'' AS OfficeCity,
'' AS OfficeState,
'' AS OfficeZip,
'' AS OfficeDomain,
'' AS LogoPath,
'' AS DarkLogoPath,
'' AS LogoPathSmall,
'' AS leadpublicid,
'' AS AudioTour,
PropertyID.PropertyID,
'list_price' AS OrderBy,
'desc' AS OrderDirection,
l.MLSID,
l.listingid,
l.ListingType,
l.PropertyType,
l.PublicID AS LA_PublicID,
l.CompanyID,
l.StatusCode,
l.Area,
l.DisplayAddress,
l.DisplayRemarks,
l.DisplayCMA,
l.Lat,
ROUND(l.Lat,5,0) as latitude,
l.Lon,
ROUND(l.Lon,5,0) as longitude,
l.List_Price,
l.LO_Name,
l.LO_Phone,
l.LO_Email,
l.LA_Name,
l.LA_Phone,
l.LA_Email,
l.ML_Number,
l.PublicID,
l.SecondPublicID,
l.StreetAddress,
l.City,
l.State,
IIF (l.Zip_Code = '00000', '', l.Zip_Code) as Zip_Code,
l.County,
l.SchoolDistrict,
l.ElementarySchool,
l.JRHighSchool,
l.HighSchool,
DATEDIFF ( "D" , DATEFROMPARTS(left(l.AddDateTime,4), substring(l.AddDateTime,5, 2), substring(l.AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,
l.ReducedDateTime,
l.AddDateTime,
l.Prev_List_Price,
l.VirtualTourID,
l.Images,
l.SubType,
l.Optional_01,
l.Optional_02,
l.Optional_03,
l.Optional_04,
l.Optional_05,
l.Optional_06,
l.Optional_07,
l.Optional_08,
l.Optional_09,
l.Optional_10,
l.Optional_11,
l.Optional_12,
l.Optional_13,
l.Optional_14,
l.Optional_15,
l.Optional_16,
l.Optional_17,
l.Optional_18,
l.Optional_19,
l.Optional_20,
l.VideoTour,
l.SecondVideoTour,
l.MLS_Remarks,
l.Description,
l.MLS_StatusCode,
l.Orig_List_Price,
l.SalePrice,
l.ListingDateTime,
l.DateTime,
l.ClosingDateTime,
l.ContractDateTime,
l.DOM,
l.REO,
l.ShortSale,
l.LO_ID,
l.LA_ID,
l.BO_ID,
l.BA_ID,
l.BO_Name,
l.BA_Name,
l.image_list,
l.image_data,
l.custom_image_data,
l.DeleteFlag,
l.isprivate,
l.attribution,
'' AS OpenHouseSchedule,
'' AS BathsString,
l.Baths,
l.FullBaths,
l.HalfBaths,
l.ThreeQuarterBaths,
l.Beds,
l.Garage,
l.Style,
l.sq_foot,
l.Year_Built,
l.Pool,
l.Acreage,
l.Story,
l.Previews,
l.Featured,
l.CommunityName,
l.PropertyView,
l.Waterfront,
l.Golfcourse,
l.Basement,
l.Carport,
l.PatioSQ_Foot,
l.BuildingName,
l.UnitFloor,
l.HOA,
l.HoaDues,
l.Zoning,
l.sq_foot_Office,
l.Units,
l.AskingPricePersq_foot,
l.SalesTerms,
l.SaleType,
l.sq_foot_Vacant,
l.SuiteNumber,
l.SuiteFloor,
l.GrossBuildingArea,
l.GrossLeaseArea,
l.BuildingClass,
l.LegalDescription,
l.Occupancy,
l.TenantOccupancyBasis,
l.ConstructionStatus,
l.YearRenovated,
l.LeedCertification,
l.Buildings,
l.ParkingType,
l.ParkingSpaces,
l.PotentialRentalIncome,
l.NetOperatingIncome,
l.CapRate,
l.InternalRateOfReturn,
l.CashOnCash,
l.PotentialRentalIncomeRemarks,
l.NoiRemarks,
l.CapRateRemarks,
l.LoanBalance,
l.InterestRate,
l.AmortizationPeriod,
l.MaturityDate,
l.subarea,
l.propertystory,
l.propertystorystatus,
l.lastModificationDateTime,
l.lo_comp,
l.bo_comp,
l.lo_comp_display,
l.bo_comp_display,
l.secondpublicid as listingagentsecondpublicid,
l.publicid as listingagentpublicid,
A.officeid as listingagentofficeid,
l.isMarketStatisticsDisplay,
l.sourcemlsurl,
l.type
FROM Listings l WITH (NOLOCK)
LEFT JOIN Agents A WITH (NOLOCK)
ON A.PublicID = L.PublicID
AND A.[Status] = 'A'
LEFT JOIN PropertyID WITH (NOLOCK)
ON PropertyID.MLSID = l.mlsid
AND PropertyID.ML_Number = l.ML_Number
AND PropertyID.dbTable IN ('residential')
AND PropertyID.Status = 'A'
LEFT JOIN agents_teams TEAMS WITH (NOLOCK)
ON TEAMS.Status = 'A'
AND TEAMS.PublicID = l.publicid
WHERE
l.id in ( select cast(value as bigint) from openjson( '["222197"]' ) )
AND l.adddatetime <> ''
) dt
ORDER BY
list_price desc,
ml_number ASC |
|
| Sql | | string | SELECT ROW_NUMBER() OVER (
ORDER BY
list_price desc,
ml_number ASC
) + 0 AS RowNumber,
*
FROM (
SELECT DISTINCT COMPANY = (
CASE
WHEN (companyid = 'bay_staging')
THEN (1)
ELSE (2)
END
)
,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBAQ01')) THEN (1) ELSE (0) END
,IS_AGENT_LISTING = (
CASE
WHEN (
LEN('pwd12345jj') > 0
AND (
L.PUBLICID IN ('pwd12345jj')
OR
L.SECONDPUBLICID IN ('pwd12345jj')
)
) THEN (1)
ELSE (0)
END
),
0 AS Distance,
'f' AS iswatching,
l.image_path AS ImagePath,
l.url,
'' AS SortOrder,
'' AS AgentPublicID,
'' AS AgentImagePath,
'' AS AgentFirstName,
'' AS AgentMiddleName,
'' AS AgentLastName,
'' AS AgentPhone,
'' AS AgentCell,
'' AS AgentFax,
'' AS AgentEmail,
'' AS AgentWebsiteAddress,
'' AS AgentTeam,
'' AS AgentCertification,
'' AS AgentLicenseNumber,
'' AS AgentBioPath,
'' AS AgentHasBlog,
'' AS AgentURL,
'' AS SecondAgentPublicID,
'' AS SecondAgentImagePath,
'' AS SecondAgentFirstName,
'' AS SecondAgentMiddleName,
'' AS SecondAgentLastName,
'' AS SecondAgentPhone,
'' AS SecondAgentCell,
'' AS SecondAgentFax,
'' AS SecondAgentEmail,
'' AS SecondAgentWebsiteAddress,
'' AS SecondAgentTeam,
'' AS SecondAgentCertification,
'' AS SecondAgentLicenseNumber,
'' AS SecondAgentBioPath,
'' AS SecondAgentHasBlog,
'' AS SecondAgentURL,
'' AS OfficeID,
'' AS OfficeName,
'' AS OfficePhone,
'' AS OfficeAddress,
'' AS OfficeCity,
'' AS OfficeState,
'' AS OfficeZip,
'' AS OfficeDomain,
'' AS LogoPath,
'' AS DarkLogoPath,
'' AS LogoPathSmall,
'' AS leadpublicid,
'' AS AudioTour,
PropertyID.PropertyID,
'list_price' AS OrderBy,
'desc' AS OrderDirection,
l.MLSID,
l.listingid,
l.ListingType,
l.PropertyType,
l.PublicID AS LA_PublicID,
l.CompanyID,
l.StatusCode,
l.Area,
l.DisplayAddress,
l.DisplayRemarks,
l.DisplayCMA,
l.Lat,
ROUND(l.Lat,5,0) as latitude,
l.Lon,
ROUND(l.Lon,5,0) as longitude,
l.List_Price,
l.LO_Name,
l.LO_Phone,
l.LO_Email,
l.LA_Name,
l.LA_Phone,
l.LA_Email,
l.ML_Number,
l.PublicID,
l.SecondPublicID,
l.StreetAddress,
l.City,
l.State,
IIF (l.Zip_Code = '00000', '', l.Zip_Code) as Zip_Code,
l.County,
l.SchoolDistrict,
l.ElementarySchool,
l.JRHighSchool,
l.HighSchool,
DATEDIFF ( "D" , DATEFROMPARTS(left(l.AddDateTime,4), substring(l.AddDateTime,5, 2), substring(l.AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,
l.ReducedDateTime,
l.AddDateTime,
l.Prev_List_Price,
l.VirtualTourID,
l.Images,
l.SubType,
l.Optional_01,
l.Optional_02,
l.Optional_03,
l.Optional_04,
l.Optional_05,
l.Optional_06,
l.Optional_07,
l.Optional_08,
l.Optional_09,
l.Optional_10,
l.Optional_11,
l.Optional_12,
l.Optional_13,
l.Optional_14,
l.Optional_15,
l.Optional_16,
l.Optional_17,
l.Optional_18,
l.Optional_19,
l.Optional_20,
l.VideoTour,
l.SecondVideoTour,
l.MLS_Remarks,
l.Description,
l.MLS_StatusCode,
l.Orig_List_Price,
l.SalePrice,
l.ListingDateTime,
l.DateTime,
l.ClosingDateTime,
l.ContractDateTime,
l.DOM,
l.REO,
l.ShortSale,
l.LO_ID,
l.LA_ID,
l.BO_ID,
l.BA_ID,
l.BO_Name,
l.BA_Name,
l.image_list,
l.image_data,
l.custom_image_data,
l.DeleteFlag,
l.isprivate,
l.attribution,
'' AS OpenHouseSchedule,
'' AS BathsString,
l.Baths,
l.FullBaths,
l.HalfBaths,
l.ThreeQuarterBaths,
l.Beds,
l.Garage,
l.Style,
l.sq_foot,
l.Year_Built,
l.Pool,
l.Acreage,
l.Story,
l.Previews,
l.Featured,
l.CommunityName,
l.PropertyView,
l.Waterfront,
l.Golfcourse,
l.Basement,
l.Carport,
l.PatioSQ_Foot,
l.BuildingName,
l.UnitFloor,
l.HOA,
l.HoaDues,
l.Zoning,
l.sq_foot_Office,
l.Units,
l.AskingPricePersq_foot,
l.SalesTerms,
l.SaleType,
l.sq_foot_Vacant,
l.SuiteNumber,
l.SuiteFloor,
l.GrossBuildingArea,
l.GrossLeaseArea,
l.BuildingClass,
l.LegalDescription,
l.Occupancy,
l.TenantOccupancyBasis,
l.ConstructionStatus,
l.YearRenovated,
l.LeedCertification,
l.Buildings,
l.ParkingType,
l.ParkingSpaces,
l.PotentialRentalIncome,
l.NetOperatingIncome,
l.CapRate,
l.InternalRateOfReturn,
l.CashOnCash,
l.PotentialRentalIncomeRemarks,
l.NoiRemarks,
l.CapRateRemarks,
l.LoanBalance,
l.InterestRate,
l.AmortizationPeriod,
l.MaturityDate,
l.subarea,
l.propertystory,
l.propertystorystatus,
l.lastModificationDateTime,
l.lo_comp,
l.bo_comp,
l.lo_comp_display,
l.bo_comp_display,
l.secondpublicid as listingagentsecondpublicid,
l.publicid as listingagentpublicid,
A.officeid as listingagentofficeid,
l.isMarketStatisticsDisplay,
l.sourcemlsurl,
l.type
FROM Listings l WITH (NOLOCK)
LEFT JOIN Agents A WITH (NOLOCK)
ON A.PublicID = L.PublicID
AND A.[Status] = 'A'
LEFT JOIN PropertyID WITH (NOLOCK)
ON PropertyID.MLSID = l.mlsid
AND PropertyID.ML_Number = l.ML_Number
AND PropertyID.dbTable IN ('residential')
AND PropertyID.Status = 'A'
LEFT JOIN agents_teams TEAMS WITH (NOLOCK)
ON TEAMS.Status = 'A'
AND TEAMS.PublicID = l.publicid
WHERE
l.id in ( select cast(value as bigint) from openjson( '["222197"]' ) )
AND l.adddatetime <> ''
) dt
ORDER BY
list_price desc,
ml_number ASC |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: column [ID] not found in query, columns are [ROWNUMBER,COMPANY,IS_OFFICE_LISTING,IS_AGENT_LISTING,DISTANCE,ISWATCHING,IMAGEPATH,URL,SORTORDER,AGENTPUBLICID,AGENTIMAGEPATH,AGENTFIRSTNAME,AGENTMIDDLENAME,AGENTLASTNAME,AGENTPHONE,AGENTCELL,AGENTFAX,AGENTEMAIL,AGENTWEBSITEADDRESS,AGENTTEAM,AGENTCERTIFICATION,AGENTLICENSENUMBER,AGENTBIOPATH,AGENTHASBLOG,AGENTURL,SECONDAGENTPUBLICID,SECONDAGENTIMAGEPATH,SECONDAGENTFIRSTNAME,SECONDAGENTMIDDLENAME,SECONDAGENTLASTNAME,SECONDAGENTPHONE,SECONDAGENTCELL,SECONDAGENTFAX,SECONDAGENTEMAIL,SECONDAGENTWEBSITEADDRESS,SECONDAGENTTEAM,SECONDAGENTCERTIFICATION,SECONDAGENTLICENSENUMBER,SECONDAGENTBIOPATH,SECONDAGENTHASBLOG,SECONDAGENTURL,OFFICEID,OFFICENAME,OFFICEPHONE,OFFICEADDRESS,OFFICECITY,OFFICESTATE,OFFICEZIP,OFFICEDOMAIN,LOGOPATH,DARKLOGOPATH,LOGOPATHSMALL,LEADPUBLICID,AUDIOTOUR,PROPERTYID,ORDERBY,ORDERDIRECTION,MLSID,LISTINGID,LISTINGTYPE,PROPERTYTYPE,LA_PUBLICID,COMPANYID,STATUSCODE,AREA,DISPLAYADDRESS,DISPLAYREMARKS,DISPLAYCMA,LAT,LATITUDE,LON,LONGITUDE,LIST_PRICE,LO_NAME,LO_PHONE,LO_EMAIL,LA_NAME,LA_PHONE,LA_EMAIL,ML_NUMBER,PUBLICID,SECONDPUBLICID,STREETADDRESS,CITY,STATE,ZIP_CODE,COUNTY,SCHOOLDISTRICT,ELEMENTARYSCHOOL,JRHIGHSCHOOL,HIGHSCHOOL,DAYSONSITE,REDUCEDDATETIME,ADDDATETIME,PREV_LIST_PRICE,VIRTUALTOURID,IMAGES,SUBTYPE,OPTIONAL_01,OPTIONAL_02,OPTIONAL_03,OPTIONAL_04,OPTIONAL_05,OPTIONAL_06,OPTIONAL_07,OPTIONAL_08,OPTIONAL_09,OPTIONAL_10,OPTIONAL_11,OPTIONAL_12,OPTIONAL_13,OPTIONAL_14,OPTIONAL_15,OPTIONAL_16,OPTIONAL_17,OPTIONAL_18,OPTIONAL_19,OPTIONAL_20,VIDEOTOUR,SECONDVIDEOTOUR,MLS_REMARKS,DESCRIPTION,MLS_STATUSCODE,ORIG_LIST_PRICE,SALEPRICE,LISTINGDATETIME,DATETIME,CLOSINGDATETIME,CONTRACTDATETIME,DOM,REO,SHORTSALE,LO_ID,LA_ID,BO_ID,BA_ID,BO_NAME,BA_NAME,IMAGE_LIST,IMAGE_DATA,CUSTOM_IMAGE_DATA,DELETEFLAG,ISPRIVATE,ATTRIBUTION,OPENHOUSESCHEDULE,BATHSSTRING,BATHS,FULLBATHS,HALFBATHS,THREEQUARTERBATHS,BEDS,GARAGE,STYLE,SQ_FOOT,YEAR_BUILT,POOL,ACREAGE,STORY,PREVIEWS,FEATURED,COMMUNITYNAME,PROPERTYVIEW,WATERFRONT,GOLFCOURSE,BASEMENT,CARPORT,PATIOSQ_FOOT,BUILDINGNAME,UNITFLOOR,HOA,HOADUES,ZONING,SQ_FOOT_OFFICE,UNITS,ASKINGPRICEPERSQ_FOOT,SALESTERMS,SALETYPE,SQ_FOOT_VACANT,SUITENUMBER,SUITEFLOOR,GROSSBUILDINGAREA,GROSSLEASEAREA,BUILDINGCLASS,LEGALDESCRIPTION,OCCUPANCY,TENANTOCCUPANCYBASIS,CONSTRUCTIONSTATUS,YEARRENOVATED,LEEDCERTIFICATION,BUILDINGS,PARKINGTYPE,PARKINGSPACES,POTENTIALRENTALINCOME,NETOPERATINGINCOME,CAPRATE,INTERNALRATEOFRETURN,CASHONCASH,POTENTIALRENTALINCOMEREMARKS,NOIREMARKS,CAPRATEREMARKS,LOANBALANCE,INTERESTRATE,AMORTIZATIONPERIOD,MATURITYDATE,SUBAREA,PROPERTYSTORY,PROPERTYSTORYSTATUS,LASTMODIFICATIONDATETIME,LO_COMP,BO_COMP,LO_COMP_DISPLAY,BO_COMP_DISPLAY,LISTINGAGENTSECONDPUBLICID,LISTINGAGENTPUBLICID,LISTINGAGENTOFFICEID,ISMARKETSTATISTICSDISPLAY,SOURCEMLSURL,TYPE]
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1140)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2048)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278)
at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1568)
at components.listing_layout_cfc$cf.udfCall_000007(/components/listing_layout.cfc:600)
at components.listing_layout_cfc$cf.udfCall(/components/listing_layout.cfc:596)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:665)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947)
at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)
at components.listing_cfc$cf.udfCall(/components/listing.cfc:194)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:665)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947)
at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)
at app._listing_cfm$cf.call(/app/_listing.cfm:27)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1026)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)
at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at templates.homepage._06.layouts._site_cfm$cf.call(/templates/homepage/06/layouts/_site.cfm:216)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1026)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:47)
at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:28)
at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
at application_cfc$cf.udfCall(/application.cfc:305)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.ModernAppListener.onRequest(ModernAppListener.java:107)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2479)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2450)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:383)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1734)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1335)
at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:645)
at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:621)
at java.base/sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:129)
at java.base/sun.nio.ch.Invoker$2.run(Invoker.java:221)
at java.base/sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:113)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:1583)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 598: <div class="iq_listing_slider_v2"><br>
599: <br>
<b>600: <div id="iq_listing_carousel" class="carousel slide" data-bs-interval="false" data-mlnumber="#arguments.rsListings.ml_number#" data-id="#arguments.rsListings.id#" data-mlsid="#arguments.rsListings.mlsid#" data-zip_code="#arguments.rsListings.zip_code#"></b><br>
601: <br>
602: <div class="bay_listing_card_love"><br>
|
| | codePrintPlain | | string | 598: <div class="iq_listing_slider_v2">
599:
600: <div id="iq_listing_carousel" class="carousel slide" data-bs-interval="false" data-mlnumber="#arguments.rsListings.ml_number#" data-id="#arguments.rsListings.id#" data-mlsid="#arguments.rsListings.mlsid#" data-zip_code="#arguments.rsListings.zip_code#">
601:
602: <div class="bay_listing_card_love">
|
| | column | | | id | | | line | | | Raw_Trace | | string | components.listing_layout_cfc$cf.udfCall_000007(/components/listing_layout.cfc:600) |
| | template | | string | C:\backatyou\code\sites\components\listing_layout.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 594: <cfset local.secondYoutubeVideoId = listfirst(local.secondYoutubeVideoId,"&")><br>
595: </cfif><br>
<b>596: </cfif></b><br>
597: <br>
598: <div class="iq_listing_slider_v2"><br>
|
| | codePrintPlain | | string | 594: <cfset local.secondYoutubeVideoId = listfirst(local.secondYoutubeVideoId,"&")>
595: </cfif>
596: </cfif>
597:
598: <div class="iq_listing_slider_v2">
|
| | column | | | id | | | line | | | Raw_Trace | | string | components.listing_layout_cfc$cf.udfCall(/components/listing_layout.cfc:596) |
| | template | | string | C:\backatyou\code\sites\components\listing_layout.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 192: <cfinvokeargument name="rsListings" value="#retListing.query#"><br>
193: <cfinvokeargument name="view_from" value="#arguments.view_from#"><br>
<b>194: </cfinvoke></b><br>
195: <cfelse><br>
196: <cfinvoke component="listing_layout" method="NoRecords" returnvariable="LOCAL.retLayout"><br>
|
| | codePrintPlain | | string | 192: <cfinvokeargument name="rsListings" value="#retListing.query#">
193: <cfinvokeargument name="view_from" value="#arguments.view_from#">
194: </cfinvoke>
195: <cfelse>
196: <cfinvoke component="listing_layout" method="NoRecords" returnvariable="LOCAL.retLayout">
|
| | column | | | id | | | line | | | Raw_Trace | | string | components.listing_cfc$cf.udfCall(/components/listing.cfc:194) |
| | template | | string | C:\backatyou\code\sites\components\listing.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 25: <!--- updated the showdeleted flag based on the mls setting of the listing ---><br>
26: <cfinvokeargument name="showdeleted" value="#local.mlsmarketlistingflg#"><br>
<b>27: </cfinvoke></b><br>
28: <br>
29: <!--- this is the a missing or removed MLSID ---><br>
|
| | codePrintPlain | | string | 25: <!--- updated the showdeleted flag based on the mls setting of the listing --->
26: <cfinvokeargument name="showdeleted" value="#local.mlsmarketlistingflg#">
27: </cfinvoke>
28:
29: <!--- this is the a missing or removed MLSID --->
|
| | column | | | id | | | line | | | Raw_Trace | | string | app._listing_cfm$cf.call(/app/_listing.cfm:27) |
| | template | | string | C:\backatyou\code\sites\app\_listing.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 80: <br>
81: <cftry><br>
<b>82: <cfinclude template="/app/_#local.PageName#.cfm" /></b><br>
83: <br>
84: <cfcatch><br>
|
| | codePrintPlain | | string | 80:
81: <cftry>
82: <cfinclude template="/app/_#local.PageName#.cfm" />
83:
84: <cfcatch>
|
| | column | | | id | | | line | | | Raw_Trace | | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82) |
| | template | | string | C:\backatyou\code\sites\lib\iq.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 214: <br>
215: <div class="#listFindNoCase("listings,search-listings,rentals,house-value,neighborhood-guide", request.page) ? 'container-fluid' : 'container'#"><br>
<b>216: #request.iqlib.RenderPage()#</b><br>
217: </div><br>
218: </div><br>
|
| | codePrintPlain | | string | 214:
215: <div class="#listFindNoCase("listings,search-listings,rentals,house-value,neighborhood-guide", request.page) ? 'container-fluid' : 'container'#">
216: #request.iqlib.RenderPage()#
217: </div>
218: </div>
|
| | column | | | id | | | line | | | Raw_Trace | | string | templates.homepage._06.layouts._site_cfm$cf.call(/templates/homepage/06/layouts/_site.cfm:216) |
| | template | | string | C:\backatyou\code\sites\templates\homepage\06\layouts\_site.cfm |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 45: <cfelse><br>
46: <cftry><br>
<b>47: <cfinclude template="#request.domain.homepagetemplatepath#/layouts/_#local.Layout#.cfm" /></b><br>
48: <br>
49: <cfset local.remote_addr = (StructKeyExists(GetHttpRequestData().headers, "x-ha-xff") ? ListFirst(GetHttpRequestData().headers["x-ha-xff"], ":") : (StructKeyExists(GetHttpRequestData().headers, "x-forwarded-for") ? ListFirst(GetHttpRequestData().headers["x-forwarded-for"], ":") : CGI.REMOTE_ADDR))><br>
|
| | codePrintPlain | | string | 45: <cfelse>
46: <cftry>
47: <cfinclude template="#request.domain.homepagetemplatepath#/layouts/_#local.Layout#.cfm" />
48:
49: <cfset local.remote_addr = (StructKeyExists(GetHttpRequestData().headers, "x-ha-xff") ? ListFirst(GetHttpRequestData().headers["x-ha-xff"], ":") : (StructKeyExists(GetHttpRequestData().headers, "x-forwarded-for") ? ListFirst(GetHttpRequestData().headers["x-forwarded-for"], ":") : CGI.REMOTE_ADDR))>
|
| | column | | | id | | | line | | | Raw_Trace | | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:47) |
| | template | | string | C:\backatyou\code\sites\lib\iq.cfc |
| | type | |
| | 8 | | Struct | | codePrintHTML | | string | 26: </cfif><br>
27: <cfscript><br>
<b>28: doLayout();</b><br>
29: </cfscript><br>
30: </cfif><br>
|
| | codePrintPlain | | string | 26: </cfif>
27: <cfscript>
28: doLayout();
29: </cfscript>
30: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:28) |
| | template | | string | C:\backatyou\code\sites\lib\iq.cfc |
| | type | |
| | 9 | | Struct | | codePrintHTML | | string | 303: <br>
304: <cfsavecontent variable="template_layout"><br>
<b>305: <cfoutput>#request.iqlib.RenderContent()#</cfoutput></b><br>
306: </cfsavecontent><br>
307: <br>
|
| | codePrintPlain | | string | 303:
304: <cfsavecontent variable="template_layout">
305: <cfoutput>#request.iqlib.RenderContent()#</cfoutput>
306: </cfsavecontent>
307:
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/application.cfc:305) |
| | template | | string | C:\backatyou\code\sites\application.cfc |
| | type | |
|
|
| type | |
| where | |
Listings courtesy of Stellar MLS as distributed by MLS GRID.Based on information submitted to the MLS GRID as of All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com. “The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.