SELECT *,LOWER(Address) AS Address,FORMAT(ListPrice,0) AS Price,FORMAT(TotFloorAreaGrandTotal,0) AS FloorArea,ListFirm1Name, IFNULL(PublicRemarks,PublicRemarks2) AS PublicRemarks, COALESCE(NULLIF(UnitNumber,''),'Not Available') AS UnitNumber, COALESCE(NULLIF(Amenities,''),'Not Available') AS Amenities, COALESCE(NULLIF(SiteInfluences,''),'Not Available') AS SiteInfluences,CONCAT_WS(' / ',ForTaxYear,Concat('$',FORMAT(GrossTaxes,0))) AS Tax,IF(LotSzSqFt !=0,FORMAT(LotSzSqFt,0),'Not Available') AS LotSzSqFt,COALESCE(NULLIF(Concat('$',FORMAT(StrataMaintFee,0)),''),'Not Available') AS StrataMaintFee,Status,FORMAT(SoldPrice,0) AS SoldPrice FROM brc_property WHERE sysid='262970442'