| VENDORERRORCODE |
1054 |
| SQLSTATE |
42S22 |
| SQL |
SELECT BATHS, Bath34Size as tQBath, BathsPartial as hbath, BedRoomMasterDimensions as mbrsize,
Bedroom2Size as bdrm2size, Bedroom3Size as bdrm3size, Bedrooms as bdrms,
DenSize as DEN_SIZE, DiningRoomSize as ddin, FamilyRoomSize as dfam, SqFtTotal as sqft_n,
ListingID as MLS_Number, KitchenSize as dkit,
ListPrice as LIST_PRICE, LotSizeArea AS acres, LivingRoomSize as liv_siz, Zoning,
DateChange as MOD_DATE_TIME, DatePhoto as P_MOD_DATE_TIME, PublicRemarks as remark,
TotalRooms as n_rms,
SchoolDistrict as school, SchoolElementary as sch_elem, JuniorHighSchool as sch_jr, SchoolHigh as sch_high,
SeasonalYN AS SEASONAL, StateOrProvince as STATE, ListingStatus AS STATUS, TaxAmount as taxes_n, TaxYear as tax_yr,
OfficialTown as town, YearBuilt as yr_blt,
PropertyType AS prop_fmt,
ListingAgentID, ListingFirmID,
PhotoCount as photos, WaterBodyName as wtrname, WaterFrontage as wtr_fdtg,
StreetNameIDX as street_name, StreetNumberIDX as street_no, AuctioneerLicNo as auctioneer_lic,
VirtualTourURL as virt_url, PostalCode as zip,
HeatingAndCooling, HeatFuel,
Amenities, Style,
'' as agtname,
'' as offname
FROM residentialproperty_unsold mls
WHERE ListingID = (param 1) |
| DATASOURCE |
retsv2_homefinder_ds |
|