query:
SELECT AccessibilityFeatures, AdditionalParcelsDescription, AdditionalParcelsYN, Appliances, ArchitecturalStyle, AssociationAmenities, AssociationFee, AssociationFeeFrequency, AssociationFeeIncludes, AttachedGarageYN, BathroomsFull, BathroomsHalf, BedroomsTotal, BodyType, BuildingAreaTotal, CarportSpaces, CarportYN, City, CloseDate, ClosePrice, CommunityFeatures, ConstructionMaterials, Cooling, CountyOrParish, CumulativeDaysOnMarket, DaysOnMarket, DirectionFaces, Disclosures, Electric, ElementarySchool, ExteriorFeatures, Fencing, FireplaceFeatures, FireplaceYN, Flooring, FoundationDetails, GarageSpaces, GarageYN, GreenBuildingVerificationType, GreenEnergyEfficient, GreenIndoorAirQuality, GreenWaterConservation, Heating, HighSchool, InteriorFeatures, InternetAddressDisplayYN, Latitude, LaundryFeatures, LeaseTerm, Levels, ListingContractDate, ListingId, ListingKey, ListingKeyNumeric, ListingTerms, ListOfficeKey, ListOfficeMlsId, ListOfficeName, ListOfficePhone, ListPrice, LivingArea, Longitude, LotFeatures, LotSizeAcres, LotSizeDimensions, LotSizeSquareFeet, Media, MiddleOrJuniorSchool, MlsStatus, Model, NewConstructionYN, NumberOfBuildings, OriginalListPrice, OtherStructures, ParcelNumber, ParkingFeatures, PatioAndPorchFeatures, PetsAllowed, PhotosCount, PoolFeatures, PoolPrivateYN, PostalCode, PriceChangeTimestamp, PropertySubType, PropertyType, PublicRemarks, PublicSurveyRange, PublicSurveySection, PublicSurveyTownship, RoadFrontageType, Roof, SecurityFeatures, SeniorCommunityYN, Sewer, SpaFeatures, StateOrProvince, STELLAR_AdditionalRooms, STELLAR_AdditionalWaterInformation, STELLAR_AdjoiningProperty, STELLAR_AmenitiesAdditionalFees, STELLAR_AssociationFeeRequirement, STELLAR_CeilingHeight, STELLAR_CeilingType, STELLAR_ComTransactionType, STELLAR_CondoFees, STELLAR_CondoFeesTerm, STELLAR_ConvertedResidenceYN, STELLAR_CurrentAdjacentUse, STELLAR_DoorHeight, STELLAR_DoorWidth, STELLAR_Easements, STELLAR_ExistLseTenantYN, STELLAR_FloodZoneCode, STELLAR_FloodZoneDate, STELLAR_FloodZonePanel, STELLAR_FreezerSpaceYN, STELLAR_GarageDimensions, STELLAR_GarageDoorHeight, STELLAR_GreenLandscaping, STELLAR_HomesteadYN, STELLAR_LeasableArea, STELLAR_MaxPetWeight, STELLAR_MontlyMaintAmtAdditionToHOA, STELLAR_NetOperatingIncomeType, STELLAR_NumberOfPets, STELLAR_NumofBays, STELLAR_NumofBaysDockHigh, STELLAR_NumofBaysGradeLevel, STELLAR_NumofOffices, STELLAR_PetRestrictions, STELLAR_PetSize, STELLAR_SpaceType, STELLAR_StatePropertyUseCode, STELLAR_CountyLandUseCode, STELLAR_TotalAcreage, STELLAR_WarehouseSpaceTotal, STELLAR_WaterAccess, STELLAR_WaterAccessYN, STELLAR_WaterExtras, STELLAR_WaterfrontFeetTotal, STELLAR_WaterViewYN, STELLAR_WaterView, StoriesTotal, StreetAdditionalInfo, StreetDirPrefix, StreetDirSuffix, StreetName, StreetNumber, StreetNumberNumeric, StreetSuffix, StreetSuffixModifier, SubdivisionName, STELLAR_SubdivisionSectionNumber, STELLAR_SWSubdivCommunityName, STELLAR_WarehouseSpaceHeated, TaxLegalDescription, TaxOtherAnnualAssessmentAmount, UnparsedAddress, Utilities, View, VirtualTourURLUnbranded, WaterBodyName, WaterfrontFeatures, WaterfrontYN, WaterSource, WindowFeatures, YearBuilt, Zoning, ZoningDescription, DATE_FORMAT(ListingContractDate, '%Y') as ListYear, DATE_FORMAT(CloseDate, '%M %e, %Y') as CloseDate, DATE_FORMAT(PriceChangeTimestamp, '%M %e, %Y') as PriceChangeTimestamp , MediaURL FROM Listings LEFT JOIN PhotoURLs ON Listings.ListingKey = PhotoURLs.ResourceRecordKey WHERE Listings.ListingId = 'D6146614'

END query
line 101 listingdetails template Details | Testing testing
Nancy J. Weber, Realtor, Keller Williams Island Life Real Estate
Copyright © 2005-2026 Nancy J. Weber. All rights reserved.
Designed by Tropical Web Works • Log in